English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 2h41m | 926 MB
Create relationships between tables & use DAX calculations
Power Pivot has been described as the most important new feature in Excel in 20 years. Power Pivot has been developed by Microsoft to help companies analyze and understand the growing quantities of data that are created on a daily basis.
Power Pivot will improve your time to create reports, develop data analysis and gain insight into your your data by at least 80%.
- Create relationships between tables of data without Vlookups
- Create powerful Key Metric and Key Performance Indicator calculations
- Manage and work with data models of millions of records of data
- Create powerful new dashboards and reports
Power Pivot is a free Add-in for Excel 2010 and is called the Data Model in Excel 2013 that provides capabilities to handle large quantities of data. PowerPivot is a columnar database that is capable of storing and manipulating hundreds of millions rows of data. PowerPivot brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. PowerPivot has been referred to as the most important feature for Excel in 20 years.
Power Pivot makes it easy to setup relationships between tables of data in the same way as databases and therefore does not require the use of Excel functions such as Vlookup. PowerPivot therefore decreases the time substantially to analyse and gain new insight from business and marketing data.
Power Pivot allows the rapid development of powerful PivotTables and PivotCharts in Excel utilising the latest Slicer technology to easily analyse and view data from multiple different perspectives. PowerPivot also adds a new Data Analysis Expressions (DAX) formula language that provides new and powerful calculations and insight to the business user.
Table of Contents
01 – Overview of the Power Pivot Course
02 – Activating Power Pivot in Excel
03 – Loading Data into Power Pivot
04 – Browse Filter and Sort Power Pivot Data
05 – Home Menu Options
06 – The AutoSum Function in Power Pivot
07 – Design Menu Options
08 – The Advanced Menu Option
09 – Power Pivot Menu in Excel
10 – Creating Pivot Tables
11 – Changing the Method of Aggregation
12 – Pivot Table Calculations
13 – Pivot Table Filters and Slicers
14 – Pivot Table and Pivot Chart
15 – Creating Hierarchies
16 – Create Relationships to Master Data
17 – Create Pivot Tables with Table Relationships
18 – Create Calculated Columns in DAX
19 – Date Functions in Power Pivot
20 – Using the Sort By Option
21 – Create a Date Table
22 – Text and Logical Calculated Fields
23 – Creating Related Calculated Formulas
24 – Power Pivot Calculated Fields
25 – The Calculate Formula
26 – Date Mesure Examples
27 – Creating Named Sets
28 – Creating KPIs
Resolve the captcha to access the links!