Power Pivot Training

Key Points

  • Power Pivot is a self-service BI solution
  • It is a FREE add-in to Excel 2010
  • Power Pivot is often used to automate routine reporting
  • Power Pivot avoids the need to use VBA, macros, and VLOOKUPs for complex reports
  • CMBI provides training on Power Pivot, Power Quuery and Power BI

CMBI's Power Pivot training will turn Excel gurus into advanced data analysis gurus.

About CMBI

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 reporting 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.

Power Pivot training services

CMBI's Colin McGowan has been using Power Pivot since its release and has helped organisations build Power Pivot models for an array of business challenges. Power Pivot will be a new approach for those used to the traditional methods of Excel data manipulation. Gone are complex macros that can be difficult to maintain. Gone are the need for hundreds of VLOOKUPs and multiple copies of complex formulae.

Colin's Power Pivot mentoring program will quickly get you up to speed with this great tool. The content is a mixture of technical knowledge transfer as well as practical advice on making the best of the tool. The training is most effective if it is conducted at your site using your data and real world reporting and analysis problems.

Power Pivot course structure

CMBI's Power Pivot mentoring is performed at your workplace. We can use sample data but Colin strongly recommends we use your data and take the opportunity to tackle real reporting and analysis challenges.

Introducing Power Pivot

  • Planning a Power Pivot project
  • Retrieving and integrating data with Power Query
  • Date/time analysis with DAX time intelligence
  • Introduction to DAX formulas

Power Pivot report automation

  • Techniques for report automation
  • Pivot Table, Power View and dashboard design
  • Practical considerations for report automation
  • Advanced analysis with other Excel tools

Power Pivot for the enterprise

  • Publishing Power Pivot reports and dashboards
  • Power Pivot and SharePoint 2010
  • PowerView
  • Upsizing to Analysis Services Tabular
  • Self service BI with Power BI

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