Powerpivot With Dax – Basic To Advance (13 Hours)

Free Download Powerpivot With Dax – Basic To Advance (13 Hours)
Published 8/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.07 GB | Duration: 13h 1m
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
Requirements
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.
Description
Section1: We are covering Power Pivot with DaxWhat is a PowerPivot and Why do we need it. How it is going to outshine our normal PivotsImport 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 featuresKnow 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, AVERAGEXWhy they are called ITERATORS – Its fundamentalsLearn 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 challengesDetailed discussion on HASONEVALUE Dax including IF statementsWhat 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 everythingHow 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 – SUMMARIZEHow 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 wiseHow to find the start of the year How to find the end of the year, month or quarterCreate 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 – DATEBETWEENSurprise Quiz for you to check your gained understanding.
Overview
Section 1: PowerPivot Begins – Everything you need to know
Lecture 1 Get PowerPivot ready
Lecture 2 How to bring data into PowerPivot and other basic things about its window.
Lecture 3 Import external data in PowerPivot
Lecture 4 Create Calculated Column and Measures
Lecture 5 DAX introduction
Lecture 6 ITERATOR Functions SUMX COUNTX etc
Lecture 7 CALCULATE Dax
Lecture 8 ALL DAX
Lecture 9 ALL Dax Continues
Lecture 10 ALL Except DAX
Lecture 11 ALL Selected DAX
Lecture 12 QUIZ 1
Lecture 13 QUIZ 2
Lecture 14 How Measures work in PowerPivot
Lecture 15 Related DAX
Lecture 16 Many to Many RelationShip begins
Lecture 17 Many to Many RelationShip
Lecture 18 Project
Lecture 19 Use IF fx – Calculated Column and Measure
Lecture 20 More discussion on IF DAX
Lecture 21 SWITCH Dax
Lecture 22 TOPN Dax – Very important
Lecture 23 Question for you – Books revenue
Lecture 24 How to sort months in a pivot
Lecture 25 HASONEVALUE Dax
Lecture 26 HASONEVALUE with Subtotal
Lecture 27 Summarize Dax – My favorite – So useful
Lecture 28 Summarize dax – PowerPivot Subtotal Issue
Lecture 29 VALUES Dax
Lecture 30 VALUES Dax Continues
Lecture 31 Implicit and Explicit
Lecture 32 Date & Time functions
Lecture 33 FirstDate & LastDate
Lecture 34 Start of an Year & End of Month
Lecture 35 Closing Balance
Lecture 36 Date Add
Lecture 37 Date Between
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.
Homepage

https://www.udemy.com/course/powerpivot-with-dax-basic-to-advance-13-hours/

DDOWNLOAD