DAX 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.46 (1599 reviews)
Udemy
platform
English
language
Other
category
instructor
DAX Power Pivot - 10 Easy Steps for Beginners
5,574
students
6.5 hours
content
Mar 2019
last update
$79.99
regular price

What you will 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 including: 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

Why take this course?

If your goal is to enter the world of BI, Data Mining and or Data Analysis you have to take this course. All of these environments and roles demand the skills you are about to learn

Microsoft PowerPivot is an add on for Excel that provides Business Intelligence functionality and reporting within the familiar environment of Excel.

This capability enables manipulation of hundreds of millions of rows of data with the capacity to provide business insights and shorter decision making cycles laughing in the face of the million row threshold of regular Excel

Here's what others had to say about the course:

"This instructor is unbelievable. Not only were the course materials plentiful, but her instruction was full of enthusiasm and encouragement. The format was perfect for me. I never felt like I was being left behind. I'll take any course by Gilly Dow, if it's not completely relevant to something I'm working with at the moment. This course was really amazing."

- Mickey Thorpe


"I purchased your two courses as a review to brush up on my skills Dax Power Pivot 10 Easy Steps for beginners Dax Power Pivot Time intelligence 10 easy steps Both wonderfully explained with very good demonstrated examples. Great refresher courses. You really have a gift for teaching. I took PowerPivot Pro a couple of years back and I find your walk through and demonstrations of the Dax measures so much clearer and to the point. It has been a fun enjoyable refresher for me. This is great course for everyone getting started in PowerPivot Thanks well done."

- Stephen Davanzo


"Thank you so much for making DAX so simple and efficient. This is perfect for everyone would like to start their journey in DAX."

- Ravi Vijay


"she is too good . I would  like to do other courses  even if they are not available on Udemy. Request Udemy to get all her works small or big on the site. Every slide I see my learning and understanding increases by leaps and bounds. I simply love this instructor and my highest regards for her way of explaining the things."

- Vinay Kumra

"Great course, good testing, good exercises, easy to follow lessons. I'm about 60% complete and the further I go the better it gets. Love the practice exercises and how the instructor goes through the answers in video detail about how the solution was arrived at...great teaching techniques all around. And then, there is the 70+ page guide that is integrated into the lesson plan, makes following the videos and working independently on the practice sessions easy as everything is organized to just follow along and learn by doing. So, watch, listen read do, test, feedback, move to next lesson. Right pace, right tone, right encouragement. Excellent course! Looking forward to the advanced. Marty"

- Martin Rini


"I really loved this course because it gave a nice (IMHO) overview for a beginning DAX / Power Pivot course. The Instructor was very very good. She took time to walk-through each step. If she keeps that approach in the upcoming Intermediate and Advanced courses, they will be winners. (She even gave some "top-tips" for regular Excel which jogged my memory banks anyway.) I am eagerly looking forward to the release dates her subsequent courses."

- Walt Lierman


What You'll Learn

To start with the course focuses on importing data into Power Pivot to create the Data Model. You will learn about calculated columns and other DAX related concepts that will show you how to “shape” the data.

Next, you will create relationships between tables of data negating the need for VLOOKUP. Reducing the time it takes to “shape” your data -  is one of the major benefits of this awesome tool.

With the data model in place, next you delve into the world of DAX measures. These are Data Analysis EXpressions functions that build the formulas to provide the business insights that decision makers and stakeholders dream of.

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

Throughout the course we work together building the data model and measures. At the end of each step you have an opportunity to practice creating your own measures to help you consolidate, embed and reinforce everything you have learned. I provide a solutions video lecture before moving on to ensure you’re on track and ready to move on.

I provide all the files you need to follow along and a fully supporting, screen-shot enriched 78 pg. user guide pdf packed with all the steps and practice exercises with solutions.

Power Pivot is the perfect tool for those working in finance, statistics, project, business and market analysis or any data reporting role who have a need to create and produce Business Intelligence style dashboard reports.

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. 

Reviews

Fabrizio
November 6, 2023
I find this course very interesting and well done even at the beginning. Everything is explained clearly and at the right pace to be able to follow the author.
Richard
July 31, 2023
Generally very good, but occasionally the practice exercises are unclear - example when asked to create % Profit measure (page 41), it does not state what you are being asked to calculate.
Ken
July 25, 2023
I thoroughly enjoyed the course on using DAX functions in Power Pivot. Gilly is an excellent instructor who possesses vast knowledge; her teaching style is easy to understand. The exercises provided a practical, hands-on learning experience.
Carol
October 6, 2022
I have already used what I've learned to help my team with a large project, saving time and making the customer happy!
Michael
September 12, 2022
Ms. Dow provided an exceptional training experience. Multiple tips on how to do things, many examples and exercises, and excellent presentation tips.
Doug
July 30, 2022
Absolutely fantastic introduction to DAX and PowerPivot. The pace of the course was perfect for me and I am looking forward to Gilly's next class on DAX. Thank you for offering this wonderful course.
Ashley
June 28, 2022
Accidently took the intermediate course before the beginner course so this definitely helped me get a better understanding of what I learn dover there which I appreciate
Bob
May 17, 2022
Yes it was a very good course to start from scratch, i.e. Pivot Table experience but no idea what you can do with Power Pivot
Jessica
May 10, 2022
I loved the contents of this course and find it easy to follow. The only complaint I have is I find Gilly's voice a bit low. I am used to wearing a headset all day long and I've done a lot of courses on Udemy, but I find that every time I do this course, I have to increase my headset volume a lot to be able to clearly hear what Gilly is saying. It's not major, maybe others don't have this issue.
Ali
March 16, 2022
I've purchased many tutorials, but this one is the most educational of all I've purchased. Also, the documentation is very comprehensive. Everything is going great for now.
Talha
March 5, 2022
Great speed and detail. Answers questions that I have when going through the process. Quite smooth and informative!
Bartlomiej
February 22, 2022
Was looking to get more familiar with DAX as I jumped from Excel to Power BI. Got what I was looking for and learned a lot about Power Pivot functionality as well - great content and will benefit me for sure.
Shane
February 11, 2022
Great intro to Power Pivot and full of tricks and tips. I had to adjust the video speed to x1.25 and sometimes even x1.5 but that's just personal preference and I understand everyone absorbs at different rates.
Adam
November 25, 2021
All good so far. Very good explanations and accompanying notes blend well with the self directed aspects of the course.
Eric
March 17, 2021
Merci beaucoup Mme Dow pour ce cours fantastique. Vous avez véritablement l'art de nous faire croire que nous ne sommes pas seuls à suivre votre cours.

Charts

Price

DAX Power Pivot - 10 Easy Steps for Beginners - Price chart

Rating

DAX Power Pivot - 10 Easy Steps for Beginners - Ratings chart

Enrollment distribution

DAX Power Pivot - 10 Easy Steps for Beginners - Distribution chart
980248
udemy ID
10/10/2016
course created date
4/4/2020
course indexed date
Bot
course submited by