DATA INSIGHT TRAINING
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog

A Complete Introduction to Excel Power Pivot

16/12/2019

0 Comments

 
The fourth video in my "Complete Introduction to" series focuses on Excel Power Pivot.  Power Pivot is another incredibly powerful feature within Excel.  It was first introduced to Excel in 2010 as an add-in, which was freely available to all Excel 2010 users.  In Excel 2013 Microsoft integrated Power Pivot into Excel, but sadly created separate licencing for the product so now you require a Pro Plus license to access it.
Why is Power Pivot so important to Excel users?  Because it is a powerful data analysis tool that does not have a number of the restrictions that Excel does and eliminates the need to use complicated formulas like VLookUp and HLookUp.  It can store millions of records of data, easily create relationships between different tables of data and introduces the DAX formula language, which is broadly based on the Excel formulas we already know.  Once data is loaded into Power Pivot, you can use Pivot Tables and Charts to analyze the data, just as you would using standard Excel.  When you start using DAX (Data Analysis eXpressions) in PowerPivot, you will quickly see the similarities it shares with standard Excel formulas.

​In the video I create some simple calculations to show the concept of a calculated column and how to add a measure to the Power Pivot data model.  Measures are calculated in the context of the Pivot Table or Pivot Chart and this allows the creation of powerful business intelligence calculations within Excel.  In addition to the standard Excel formulas, DAX adds a wide range of new formulas to enhance your data analysis capabilities.  One example is the distinct count function which counts the number of unique entries in a field, something that would be very helpful in Excel!
​Relationships are another powerful capability in Power Pivot.  You will see in the video how quick and easy it is to create the relationship between two Human Resource tables, and once there is a relationship between the two tables, it is easy to create Pivot Tables using fields from both tables
Power Pivot Relationship
Power Pivot Relationship
Power Pivot is another amazing Excel technology that will drastically improve your data analysis skills and also the speed to understand your data, without the steep learning curve associated with learning other data analysis programs.
0 Comments



Leave a Reply.

    Categories

    All
    Business Data Analysis
    Complete Introduction To
    Coronavirus
    Data Skills
    DAX
    Excel Dashboards
    Excel Formulas
    Gartner Report
    Inspiration & Motivation
    Pivot Tables
    Power BI
    Power BI Desktop
    Power BI Query Editor
    Power BI Services
    Power Map
    Power Pivot
    Power Query
    Power View
    Tables & Reports

    Archives

    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

Privacy Policy
Copyright datainsighttraining.com
info@datainsighttraining.com
+44 330 223 5910
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog