CMBI's "Introduction to Power Pivot" training introduces you to some of the most powerful data analysis capabilities within the Excel environment.
Leverage your Excel knowledge
If you or your team are spreadsheet gurus then nothing short of full spreadsheet functionality will do. Power Pivot is an end user data integration and analysis tool that can be used to automate even the most complex reports and analytics whilst remaining completely within the Excel environment.
Using Power Pivot, users can quickly automate routine reporting and analysis because they are already familiar with the spreadsheet tool and data. They can continue to use the spreadsheet to create the layout and presentation but the content will now update automatically when the underlying source acquires new data.
How it works
We come to you or host remotelysaving you travel time |
Interactive workshopgiving you valuable hands-on experience with personalised support |
||
One day course from 9am-5pmTeam can't spare a full day? 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 with Power Pivot through a series of practical exercises. At the end of the session you will know how to use Power Pivot to simplify your existing Excel spreadsheets, as well as be able to design flexible and scalable data models for your future reporting requirements.
Topics Covered
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 and scalable data model for your reporting solution using relationships |
||
Using DAX to create calculated columns & measuresLearn how to use DAX, Power BI's powerful formula language to add new columns and measures to your reporting and analytics |
Time intelligenceCreate time intelligence analytics to gain instant insight into year-to-date and prior period performance |
||
Creating a Dashboard in ExcelLearn techniques for creating professional-looking and interactive reports in Excel |
Introduction to Power BI DesktopLearn how to import your Excel data model into Microsoft's Power BI Desktop application, to make use of the 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 BI. 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.