Power Pivot with DAX (Basic To Advance) – Hindi
Power Pivot with DAX (Basic To Advance) – Hindi
Do any data analysis & calculations with Power pivot.
Created by Ajay Parmar
Course Description
- What is a PowerPivot and how to install it.
- How to 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.
- 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
- Surprise Quiz for you to check your gained understanding.
- 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
Course Curriculum
Training Starts
-
Intro to PowerPivot
06:16 -
Import Excel Data
18:28 -
Import data from external sources
15:45 -
Chapter4 – How to Create Measures Calculated Columns
39:14 -
Basics of DAX
19:14 -
Divide DAX
14:30 -
Dax Iterators with Filter
36:37 -
Calculate Dax
40:55 -
ALL Family DAX
57:05 -
ALL Except dax
20:10 -
How Measure works – Fundamentals
09:04 -
Related Dax
47:27 -
Project – Customer wishlist books
26:08 -
IF Dax as a measure & Calculated Column – V imp
56:43 -
Switch DAX
22:04 -
TopN dax studio
34:12 -
HasOneValue DAX
40:07 -
Summarize DAX
59:22 -
Implict Explict concept
25:37
Power Pivot with DAX (Basic To Advance) – Hindi
Course Description
- What is a PowerPivot and how to install it.
- How to 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.
- 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
- Surprise Quiz for you to check your gained understanding.
- 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
Course Curriculum
Training Starts
-
Intro to PowerPivot
06:16 -
Import Excel Data
18:28 -
Import data from external sources
15:45 -
Chapter4 – How to Create Measures Calculated Columns
39:14 -
Basics of DAX
19:14 -
Divide DAX
14:30 -
Dax Iterators with Filter
36:37 -
Calculate Dax
40:55 -
ALL Family DAX
57:05 -
ALL Except dax
20:10 -
How Measure works – Fundamentals
09:04 -
Related Dax
47:27 -
Project – Customer wishlist books
26:08 -
IF Dax as a measure & Calculated Column – V imp
56:43 -
Switch DAX
22:04 -
TopN dax studio
34:12 -
HasOneValue DAX
40:07 -
Summarize DAX
59:22 -
Implict Explict concept
25:37