PowerPivot with DAX - Basic to Advance (13 Hours)

PowerPivot with DAX - Basic to Advance (13 Hours) free download

Complete Data Analysis and making pivot reports

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.