Introduction to Power Pivot Training

Key Points

  • Power Pivot is a self-service BI solution
  • It is a FREE add-in to Excel 2010 and in-built functionality in Excel 2016
  • 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 Query and Power BI

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. CMBI's Power Pivot training will turn Excel gurus into advanced data analysis gurus!

About CMBI

Leverage your Excel knowledge

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 maintaining multiple spreadsheets full of complex formulas.

Using Power Pivot analysts can quickly automate routine reporting and analysis using functionality that is free and readily available in Excel.


Course Details

CMBI's "Introduction to Power Pivot" training course will quickly get analysts, accountants and business professionals up to speed with this great tool. The content is a mixture of technical knowledge transfer as well as practical advice on how you can get the best out of Power Pivot for your organisation.


Duration: 1 day

Cost: $1,440 + GST per training session hosted at your venue

Number of Attendees: to ensure each person gets the required level of support during the workshop we recommend a maximum of 6 attendees.

Prerequisites: To get the most out of this course, we recommend that attendees to this course are proficient in Excel, and familiar with the more advanced Excel concepts such as PivotTables and functions such as SUM, IIF and VLOOKUP.

If you are not sure if this is the right course for you, just email us and we'll be happy to advise.


Course Outline

CMBI's "Introduction to Power Pivot" training course covers the following topics:

Introduction to Power Pivot

  • What is Power Pivot, and when to use it?
  • Overview of the Power Pivot interface
  • Importing data into Power Pivot

  • Importing data using a variety of methods, including Excel, flat files, databases and webpages
  • Manipulating your data in Power Pivot

  • Changing data types
  • Adding custom columns
  • Joining data together from different sources
  • Creating simple calculations
  • Creating more complex calculations using DAX formulas
  • Adding date/time analysis with DAX time intelligence
  • Presenting your data

  • Creating a PivotTable report
  • Adding slicers to your report
  • Refreshing the data in the model
  • 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


    Why Choose CMBI?

    Why should you choose CMBI for your next training solution?

    • Trainers with hands-on, real world experience
    • Real datasets from an array of education, financial services and government sources
    • Small groups for one-to-one mentoring
    • Instructional videos to take away for future reference
    • Options to tailor the training session to your organisation

    Click here for more training benefits CMBI can offer you and your organisation.


    Contact Us

    For more information or to book a training course, contact Julie McGowan via our contact page.


    See Also