Do you want to create automated spreadsheets that can keep up with ever-increasing data volumes and changing reporting requirements?
In this comprehensive 2-day course, you will learn how Power Pivot, Power Query and the next generation of Excel tools can help you automate routine data analysis and create professional reports in Excel in just minutes!
- Automate reporting
- Fast track data integration
- Discover new insights
- Super boost your productivity
How it works
|
We come to you or host remotelysaving you travel time |
|
Interactive workshopgiving you valuable hands-on experience with personalised support |
|
Two day course from 9am-5pmTeam can't spare two full days? Ask us about splitting the course across multiple sessions. |
|
Training Materials providedso you can recap after the session. See full details below |
|
$1,999 + GST per team per dayEach day of training includes optional Q&A, plus supporting course guide. |
|
Want more info?Contact us today |
How can Power Pivot help me?
With Power Pivot you can:
- Create faster, more efficient spreadsheets
- Reduce report preparation time
- Reduce workbook complexity and reliance on VBAs and macros
- Provide greater insight to stakeholders
During the training workshop you will gain valuable hands-on experience that will revolutionise the way you currently work with data. At the end of the session you will know how to use Power Pivot to build automated and maintainable data analytics and reporting solutions end-to-end, all within the familiar Excel environment.
Topics Covered
Day 1 Sessions |
|||
|
Introduction to Power BI for ExcelLearn about the different components of Power BI, and how they can help you improve your Excel spreadsheets |
|
Loading data with Power QueryUnderstand the different ways of getting data into Excel, and learn how to use Power Query to load, transform and cleanse your data |
|
Introduction to Power PivotLearn how Power Pivot can help you create reports that add real business value in Excel |
|
Building a data model with RelationshipsUnderstand how to create a flexible data model for your reporting solution using relationships |
|
Using DAX to create calculated columns & measuresLearn how to use DAX, Power Pivot's powerful formula language to add new columns and measures to your reporting and analytics |
|
Creating a Dashboard in ExcelLearn techniques for creating professional-looking and interactive reports in Excel |
Day 2 Sessions |
|||
|
Integrating data with Power QueryDelve deeper into the capabilities of Power Query to learn how to group, append and merge datasets. Not a VLOOKUP in sight! |
|
Transforming data with UnpivotLearn how to transform data displayed in columns into rows at the click of a button in Power Query |
|
Using DAX to create complex measuresContinue exploring DAX functions such as CALCULATE() and ALL() to add more complex measures to your reporting and analytics |
|
Time intelligenceCreate time intelligence analytics to gain instant insight into year-to-date and prior period performance in your organisation |
|
|
Creating ParametersLearn how to parameterise your queries to create a flexible and scalable reporting solution that protects against change. |
|
Introduction to Power BI DesktopLearn how to import your Excel data model into Microsoft's Power BI Desktop application, to make use of its extensive visualisation library |
Want more info?
Download a detailed course overview
Delivery Method
Each workshop is presented as a series of practical exercises, that give attendees hands-on experience of all aspects of Power Query and Power Pivot. All our training exercises are supported by detailed course materials for reference during and after the training day.
CMBI can present this training session either in-person onsite, or host it live remotely, using industry-leading video conferencing software. Learn more about Remote Training here.
Materials and support
Our course materials support learning and re-enforcement well beyond the workshop.
Each session includes an associated set of support materials to help attendees complete the tasks on the day, as well as provide support after course completion:
- Supporting course notes PDF document (approx 90 pages, printed on request)
- Complete Excel models for all exercises
- Datasets for all examples
- Optional Q&A time at the end of the session for anyone interested in asking specific questions
More Training Options
Don't see what you're looking for? CMBI offer a variety of training to suit all levels of experience:
See CMBI's training page for details of all courses we offer.