Ultimate Excel Course #13 - Introduction to the Data Model and PowerPivot | Alan Murray | Skillshare

# Ultimate Excel Course #13 - Introduction to the Data Model and PowerPivot

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
7 Lessons (45m)

7:03

7:46

5:51

1:12

4:38

7:37
• ### 7. Introduction to DAX - Measures

10:29
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

126

Students

--

Projects

This class is #13 in a series called the Ultimate Excel Course.

In this class you will be introduced to the Data Model and PowerPivot in Excel. This is an extremely powerful area of modern Excel.

This class is for people who work with large volumes of data and need to perform powerful analysis.

This is a huge area of Excel so this class serves as an introduction and insight into this feature. It will enable you to understand what it is and how it may benefit you.

In the class we import some data from a csv file into the data model using Power Query. This file contains over 100,000 rows of data. We then create relationships from it to 3 other tables.

Then we create a PivotTable from multiple tables of data in the model. Next we look at enabling the PowerPivot add-in and demonstrate some basic examples of DAX formulas.

The Excel files used during the class are provided so that you can follow along. You can then take on the project exercises to test your skills in action.

Please post any questions in the discussion area and I will get back to you.

Grab a coffee, enrol and let's do this.

Please note that this is class #13 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #6 - Validating and Protecting Excel Data

Class #7 - Advanced Formulas for Analysing Data

Class #12 - Get & Transform Data with Power Query

Class #13 - Introduction to the Data Model and PowerPivot

#### Alan Murray

IT Trainer, Coffee Lover and Lifelong learner

Teacher

Hello, my name is Alan Murray and I have been training and consulting in Excel now for over 20 years. I have had the pleasure in helping individuals and businesses from all around the world improve their Excel skills.

I set up Computergaga about 10 years ago to help spread the latest Excel tips and to engage with other Excel experts and learners. It has grown beyond my expectations and I hope to get the chance to speak with many of you soon.

I have a real passion for Excel and I hope that it comes across in my classes. I believe that it helps if you enjoy what you are learning.

I currently live in Ipswich, on the east coast of England. I have two beautiful children. So they take up most of my time away from Excel. If I'm not with t... See full profile

## Class Ratings

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

# Your creative journey starts here.

• Supportive online creative community
• Learn offline with Skillshare’s app

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects