Power Pivot trainer
CMBI's Colin McGowan will be your facilitator and has been using Power Pivot and related tools since their initial release dates. Colin has over 15 years of BI, DW, and analytics experience in various sectors including banking, insurance, government, retail, and pharmaceuticals.
Introduction to Power Pivot course structure
CMBI's Power Pivot training is performed at your workplace. We can use sample data but we can also use your data and take the opportunity to tackle real reporting and analysis challenges.
Introducing Power BI
- Planning a Power BI project
- Retrieving and integrating data with Power Query
- Modelling your data with Power Pivot
- DAX calculations
- Visualising your data with Power View
Power BI report development
- Power BI Desktop
- Excel and Power BI
- Practical considerations for report automation
- Advanced analysis with other Excel tools
*Conditions of offer
- The training is performed at your office which must be in the Sydney region
- The offer is for 1 day of onsite Power Pivot instruction
- You can choose to use your data or sample data from the AdventureWorks database
- We can follow the standard course structure or build the model you want interactively (NOTE: this is most effective for 1 on 1 training sessions)
About CMBI
CMBI designs and develops business intelligence and analytics solutions for clients in Sydney and regional NSW. CMBI technology expertise includes Power BI, Power Pivot, Excel, SQL Server, Analysis Services, SharePoint BI, and Tableau