Get 17 Courses In 5,999/- Rupees & Get 10 Courses In 4,000/-

Log In
Registration

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

Material Includes

  • Lectures Files , HD video lectures with lifetime access on website.

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:15
  • 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:07
  • IF Dax as a measure & Calculated Column – V imp
    56:43
  • Switch DAX
    22:03
  • TopN dax studio
    34:12
  • HasOneValue DAX
    40:07
  • Summarize DAX
    59:22
  • Implict Explict concept
    25:37
₹1,000.00
₹1,000.00 ₹4,000.00
  • Level
    All Levels
  • Total Enrolled
    27
  • Duration
    15 hours
  • Last Updated
    February 5, 2023

Power Pivot with DAX (Basic To Advance) – Hindi

₹1,000.00
₹1,000.00 ₹4,000.00
  • Level
    All Levels
  • Total Enrolled
    27
  • Duration
    15 hours
  • Last Updated
    February 5, 2023

Material Includes

  • Lectures Files , HD video lectures with lifetime access on website.

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:15
  • 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:07
  • IF Dax as a measure & Calculated Column – V imp
    56:43
  • Switch DAX
    22:03
  • TopN dax studio
    34:12
  • HasOneValue DAX
    40:07
  • Summarize DAX
    59:22
  • Implict Explict concept
    25:37

The beautiful thing about learning is that nobody can take it away from you.

Twitter Facebook-f Instagram Telegram-plane Youtube

Quick Links

Imp. Links

Weekly Newsletter

  • Copyright 2022-23 AjayParmarTutor. All Rights Reserved