Introduction to Power Pivot course - $1500 for up to 4 participants

Key Points

  • Power Pivot and Power BI are self-service BI tools from Microsoft
  • Power BI desktop is FREE
  • Power Pivot, Power Query, and Power View are free add-ins to Microsoft Excel (2010-2013)
  • CMBI provides training for all aspects of Power BI including data aquisition, data integration, modelling, DAX calculations, and designing visualisations and reports

Kick start your self-service BI with a one day onsite introduction to Power Pivot and Power BI from CMBI for a total cost of $1,500+GST for up to 4 participants*

About CMBI

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

See Also