PowerPivot with DAX - Basic to Advance (13 Hours)

Focused View

ajay parmar

13:01:41

0 View

1 - Get PowerPivot ready.mp4

10:15

2 - How to bring data into PowerPivot and other basic things about its window.mp4

19:34

3 - Import external data in PowerPivot.mp4

16:33

4 - Create Calculated Column and Measures.mp4

48:20

5 - DAX introduction.mp4

47:16

6 - ITERATOR Functions SUMX COUNTX etc.mp4

39:15

7 - CALCULATE Dax.mp4

18:28

8 - ALL DAX.mp4

16:52

9 - ALL Dax Continues.mp4

35:30

10 - ALL Except DAX.mp4

10:44

11 - ALL Selected DAX.mp4

15:38

12 - QUIZ 1.mp4

42:08

13 - QUIZ 2.mp4

12:38

14 - How Measures work in PowerPivot.mp4

16:23

15 - Related DAX.mp4

38:21

16 - Many to Many RelationShip begins.mp4

19:23

17 - Many to Many RelationShip.mp4

07:02

18 - Project.mp4

25:41

19 - Use IF fx Calculated Column and Measure.mp4

43:23

20 - More discussion on IF DAX.mp4

07:50

21 - SWITCH Dax.mp4

16:19

22 - TOPN Dax Very important.mp4

30:03

23 - Question for you Books revenue.mp4

04:55

24 - How to sort months in a pivot.mp4

02:46

25 - HASONEVALUE Dax.mp4

13:12

26 - HASONEVALUE with Subtotal.mp4

14:29

27 - Summarize Dax My favorite So useful.mp4

39:07

28 - Summarize dax PowerPivot Subtotal Issue.mp4

45:30

29 - VALUES Dax.mp4

18:05

30 - VALUES Dax Continues.mp4

15:43

31 - Implicit and Explicit.mp4

17:41

32 - Date Time functions.mp4

26:53

33 - FirstDate LastDate.mp4

07:24

34 - Start of an Year End of Month.mp4

03:54

35 - Closing Balance.mp4

06:42

36 - Date Add.mp4

14:56

37 - Date Between.mp4

12:48

Files.zip

Description

Complete Data Analysis and making pivot reports

What You'll Learn?

Students will learn PowerPivot and the role of DAX in it.
You will learn why PowerPivot is important for your career and how it has an edge over normal excel pivot.
How to create Reports using PowerPivot.
Implicit and Explicit Dax - Pls check curriculum for complete DAX details. We are discussing everything here

Who is this for?

This course is for Data , Research analysts and MIS people who work day and night on data and create reports

Those who want to add extra wings to their excel normal pivots - Definitely this course is for you

PowerPivot and DAX are the skills highly in demand in our industry. Booster for your career.

What You Need to Know?

Knowledge of Excel formulas is an added advantage.

If you know the Basic pivots it is going to help you in PowerPivot chapters.

Any excel version like 2010 or above is fine.

More details

Description
Section1: We are covering Power Pivot with Dax

What is a PowerPivot and Why do we need it. How it is going to outshine our normal Pivots
Import data from different sources like Excel, CSV Files or Text files or any other database.
Get familiar with PowerPivot ribbon and sorting ,filtering options- all basic features
Know the place to write Measures and Calculated Columns.
What is DAX - A formula language. It is in very detail.
Difference between Measures and Calculated Columns - Which one better and which should you choose?
Basics DAX Functions - SUM,COUNT,COUNTA,COUNTBLANK, - Why they called Aggregate Functions .
Are they DAX Measure or Calculate columns - All Confusion is cleared.
Different Types of DAX Functions - ITERATORS - SUMX , COUNTX, AVERAGEX
Why they are called ITERATORS - Its fundamentals
Learn the most used and Powerful DAX - CALCULATE - It is also famous as CALCULATE IF, Know why?
Deep Dive into ALL FAMILY FUNCTIONS - ALL / ALL SELECTED/ ALL EXCEPT with examples
What is the role of ALL DAX in your Data analysis - Control the data the way you want.
Practical Time - How to calculate overall percentage of different products based on the Team Total?
What are RELATIONSHIPS in PowerPivot - One to One, Many to Many , One to Many and Many to one with examples and challenges
Detailed discussion on HASONEVALUE Dax including IF statements
What is a VALUES Function and how it can change the pivot calculations by giving you more control.
What are implicit and explicit measures and why we should create latter ones.
How to write TOPN Dax, one of my favorites.
How to Use TOPN in practical scenarios .
What is a DAX Studio and how do we download it and use it in Pivots - Challenges and reasons behind using dax studio.
Learn the use of IF dax in PowerPivot. From writing simple IF functions to writing IF inside IFs , we are learning everything
How to use IF as a calculated column and as a measure. What is the difference between both approaches.
What is a SWITCH Dax and how it is used as an alternate of IF Dax.
Learn one of the best dax - SUMMARIZE
How to use summarize in your grand totals and sub-totals.
Learn how to customize calculations for pivot fields and pivot grand totals.
Learn how to avoid showing data for few fields and how to show data for other fields.
Focus on error messages when they come during calculations . Learn what message says about DAX and correct the formulas accordingly.
Time intelligence functions - How to find cumulative sums of sales year wise, or month wise or quarterly basis.
How to calculate the closing balance - month wise or year wise
How to find the start of the year
How to find the end of the year, month or quarter
Create calendar table and why it is important before using time intelligence functions and how to edit or create a relationship with main tables.
how to add or whatever calculation to be done based on two dates - DATEBETWEEN
Surprise Quiz for you to check your gained understanding.

Who this course is for:
This course is for Data , Research analysts and MIS people who work day and night on data and create reports
Those who want to add extra wings to their excel normal pivots - Definitely this course is for you
PowerPivot and DAX are the skills highly in demand in our industry. Booster for your career.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

ajay parmar

Instructor's Courses

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.