Power Pivot - 10 Easy Steps for Beginners
4.8 (12 ratings)
45 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Power Pivot - 10 Easy Steps for Beginners to your Wishlist.

# Power Pivot - 10 Easy Steps for Beginners

Learn how to build DAX functions in PowerPivot with Excel 2016. Reinforce and embed with practice exercises/solutions
4.8 (12 ratings)
45 students enrolled
Created by Gilly Dow
Last updated 2/2017
English
Current price: \$10 Original price: \$30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
• 6 hours on-demand video
• 1 Supplemental Resource
• Full lifetime access
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Import data into the Power Pivot Data Model using Excel 2016
• Import and edit data from Microsoft Access and Microsoft Excel
• Build Relationships between Data Tables
• Create Hierarchies for end-user filtering convenience
• Shape the Data Model with Calculated Columns & Measures
• Create DAX Expressions: SUM, RELATED, RELATEDTABLE, COUNT, DISTINCTCOUNT, MONTH, DATE, CALCULATE, ALL
• Build custom DAX Expressions to drop into any pivot
• Create Dashboard worthy reports with Slicers and Presentation tips
• Download the step-by-step user guide with practice exercises and solutions
• Import existing Excel data and Link Excel data into the Data Model
• Create Calculated Columns and Measures in the Data Model
• Create Measures in Excel
• Create Calculated Columns with RELATED() & RELATEDTABLE() DAX Functions
• Create Measures using the COUNT() & DISTINCTCOUNT DAX Functions
• Create Measures using the CALCULATE() DAX Function to modify the Filter Context of Pivot Tables
• Create static values for Ratio creation with CALCULATE() & ALL() DAX Functions
• Create a Date Table (Calendar) in Excel and Relate to the Data Model for Time Intelligence functionality
View Curriculum
Requirements
• Students will have an understanding of Excel Pivot Tables
• It's helpful to have a basic understanding of relational database concepts
• Please ensure you have the Power Pivot Add-in installed and the Power Pivot Menu visible in the main Excel window
Description

Power Pivot – it’s now 2 words, not one – dispenses with the cost of Business Intelligence and Data Analysis consultants and hands over the power to YOU  the end user.

Gone are the days of waiting for IT to provide the data you need to manipulate and report on only to find what’s been provided isn’t what you asked for…

Import the data directly into Excel – "hey, this isn’t new...", I hear you cry, "...we’ve always been able to do that!"

BUT, Power Pivot laughs in the face of the 1M row threshold in Excel worksheets.

Power Pivot brings new capabilities that enables manipulation of hundreds of millions of rows of data.

Creating relationships between tables of data negates the need for VLOOKUP. Reducing the time it takes to shape your data -  is one of the major benefits of this awesome tool.

Data Analysis, Business Intelligence and Insights emerge with Measures.

These portable calculations are created with Power Pivot’s Data Analysis Expressions (DAX) formula language and can be dropped into ANY pivot table – yes, that’s right – they can be dropped into ANY pivot table.

Well constructed DAX measures, simplify the reporting process and transform the typical end user into super-hero status that will propel you with a new skill-set that is in very short supply and very high demand.

There is no programming involved with DAX - your Excel formulas experience has set you up nicely for the next step in your Excel journey.

Once you get a handle on DAX, there's no going back - you'll be creating all your pivots in Power Pivot - you really don't have to a have millions of rows of data to enjoy the benefits of Power Pivot and DAX

What you will learn in this course:

• Import data into the Power Pivot Data Model using Excel 2016
• Import and edit data from Microsoft Access and Microsoft Excel
• Build Relationships between Data Tables
• Create Hierarchies for end-user filtering convenience
• Shape the Data Model with Calculated Columns & Measures
• Build custom DAX Expressions to drop into any pivot
• Create Dashboard worthy reports with Slicers and Presentation tips
• Import existing Excel data and Link Excel data into the Data Model
• Create Calculated Columns and Measures in the Data Model
• Create Measures in Excel
• Create Calculated Columns with RELATED() & RELATEDTABLE() DAX Functions
• Create Measures using the COUNT() & DISTINCTCOUNT DAX Functions
• Create Measures using the CALCULATE() DAX Function to modify the Filter Context of Pivot Tables
• Create static values for Ratio creation with CALCULATE() & ALL() DAX Functions
• Create a Date Table (Calendar) in Excel and Relate to the Data Model for Time Intelligence functionality

Will the path of satisfaction simply unfold before you? Not exactly! There’ll be exercises to guide you, practice tasks to accomplish. Because, no matter what secret method others covet, there’s no magic wand. Journeying to the top requires effort and expertise.

BUT YOU HAVE THE VISION TO SEE THE WAY AND THE STRENGTH TO FORGE AHEAD

With careful, considered application of thought, plus a drizzle of creativity, the new ingredients you bake in 2017 can see you rise higher than ever

Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your Excel skills. I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences. If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.

Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.

Who is the target audience?
• For all Excel enthusiasts who consolidate or manipulate data repetively
• For all those who want to be at the forefront of the Big Data, Business Intelligence concept
• For all those who want to adapt a report in seconds when stakeholders objectives change
• Students may have an understanding of Power Pivot but want to consolidate their knowledge with practical examples and practice exercises
• For all those who want super-hero status amongst their colleagues
Curriculum For This Course
46 Lectures
06:10:26
+
Introduction to Course
1 Lecture 05:47
Preview 05:47
+
Group Work 1 Creating the Data Model
5 Lectures 47:22
Preview 12:03

Removing and Filtering Fields WHEN Importing Data
13:46

Preview 08:59

Practice Ex1 Editing the Data Source
08:27

Group Work 1 - Importing External Data into the Power Pivot Data Model Window
5 questions

Group Work 1 Recap of Objectives
04:07
+
Group Work 2 Creating Pivot Tables & Relationships
4 Lectures 30:47
Adding a Pivot Table From the Data Model
12:03

Hiding Tables AND/OR Fields From the Pivot Table Field List
07:12

Practice Ex2 Pivot Tables & Relationships
08:25

Preview 03:07

Group Work 2 - Creating Pivot Tables & Relationships
5 questions
+
Group Work 3 Adding Excel Data to the Data Model
4 Lectures 26:45
Group Work 3 Linking Excel Tables to the Data Model
11:03

Group Work 3 Importing an Excel File into the Data Model
04:34

Practice Ex3 Linked Tables
08:00

Group Work 3 Recap of Objectives
03:08

Group Work 3 Adding Excel Data to the Data Model
5 questions
+
Group Work 4 Creating a Hierarchy
3 Lectures 15:21
Group Work 4 Creating a Hierarchy
10:57

Practice Ex4 Creating a Hierarchy
02:46

Group Work 4 Recap of Objectives
01:38

Hierarchies are created in the Pivot Table Field List

Group Work 4 Creating a Hierarchy
3 questions
+
Group Work 5 Calculated Columns & Measures
5 Lectures 40:17
Group Work 5 Creating Calculated Columns in the Data Model
07:34

Group Work 5 Creating Measures in the Data Model
08:51

Group Work 5 Displaying Measure in Pivot Tables
06:20

Practice Ex5 Calculated Columns & Measures
08:03

Group Work 5 Recap of Objectives
09:29

Group Work 5 Calculated Columns & Measures
5 questions
+
Group Work 6 Measures in Excel
3 Lectures 26:33
Group Work 6 Adding Measures in Excel
15:25

Practice Ex6 Measures in Excel
08:08

Group Work 6 Recap of Objectives
03:00

Group Work 6 Measures in Excel
5 questions
+
Group Work 7 RELATED() & RELATEDTABLE()
5 Lectures 40:07
Group Work 7 RELATED()
07:42

Group Work 7 RELATED() Part 2
06:09

Group Work 7 RelatedTable
09:22

Practice Ex7 RELATED() & RELATEDTABLE()
12:44

GW 7 Recap of Objectives
04:10

Group Work 7 RELATED() & RELATEDTABLE()
5 questions
+
Group Work 8 COUNT() & DISTINCTCOUNT()
5 Lectures 36:02
Group Work 8 Aggregator Function COUNT()
07:32

Group Work 8 DISTINCTCOUNT()
07:49

Group Work 8 Date Fields in Calculated Columns
10:10

Practice Ex8 COUNT() DISTINCTCOUNT() & DATE Fields
08:28

Group Work 8 Recap of Objectives
02:03

Group Work 8 COUNT() & DISTINCTCOUNT()
5 questions
+
Group Work 9 CALCULATE()
6 Lectures 56:47
Group Work 9 CALCULATE() Part 1
11:10

Group Work 9 CALCULATE() with AND OR
12:49

Group Work 9 CALCULATE() with Comparison Operators
06:09

Group Work 9 CALCULATE() with DATE () & MONTH()
10:38

Practice Ex9 CALCULATE() Month() DATE()
12:14

Group Work 9 Recap of Objectives
03:47

Group Work 9 CALCULATE() Month() DATE()
10 questions
2 More Sections
About the Instructor
 4.8 Average rating 12 Reviews 46 Students 2 Courses
IT Training Consultant, founder gdteach.co.uk

Gilly Dow is an MS Office Master, a Certified Microsoft Excel Expert and Training Consultant with 20 years experience working for the US Military, NHS and multiple private sector companies. Gilly have trained thousands of students from IT Security, MS Office, SAP and Clinical Healthcare applications. GD Teach has been founded especially for Udemy to reach out to a wider audience and deliver practical, step-by-step, quality training that makes a difference to you and your job satisfaction.