Power Pivot with DAX - Basic To Advanced Course in Hindi
Learn to do any data analysis & calculations with Power pivot in Hindi.
Office Productivity,Microsoft,Power Pivot
Lectures -19
Duration -9.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
- What is a PowerPivot and how to install it
- How to import data from different sources like Excel, CSV Files, Text files, or any other database.
- Get familiar with the 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 the 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 is 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 alternative to 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 a few fields and how to show data for other fields.
- Focus on error messages when they come during calculations. Learn what the message says about DAX and correct the formulas accordingly.
- Time intelligence functions – How to find cumulative sums of sales year-wise, 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 a 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
Goals
What will you learn in this course:
This course is educating students about PowerPivot & DAX - if you are working on Data and want to come out of data size barriers.
Students will be able to do any type of analysis on small, medium, or Big data using PowerPivot
You will learn how to write Measures and Calculated Columns
You will learn the DAX formula as well. See the Curriculum to know what exactly we are covering.
You will understand the difference between Measure and Calculate Column - Which one better and Why?
Learn SUM, COUNT, COUNTA, COUNTBLANK, CALCULATE, ALL, ALL EXCEPT, ALL SELECTED
Every topic is discussed from the very beginning to advanced levels. Exercises are also discussed to see its practical use.
Prerequisites
What are the prerequisites for this course?
Basics of Excel with functions knowledge can be an added advantage.
You should know Old Excel Pivot.
Curriculum
Check out the detailed breakdown of what’s inside the course
Training starts
19 Lectures
- Intro to PowerPivot 06:15 06:15
- Import Excel Data 18:27 18:27
- Import data from external sources 15:44 15:44
- Chapter4 – How to Create Measures Calculated Columns 39:14 39:14
- Basics of DAX 19:13 19:13
- Divide DAX 14:30 14:30
- Dax Iterators with Filter 36:36 36:36
- Calculate Dax 40:54 40:54
- ALL Family DAX 57:04 57:04
- ALL Except dax 20:09 20:09
- How Measure works – Fundamentals 09:04 09:04
- Related Dax 47:26 47:26
- Project – Customer wishlist books 26:07 26:07
- IF Dax as a measure & Calculated Column – V imp 56:42 56:42
- Switch DAX 22:03 22:03
- TopN dax studio 34:11 34:11
- HasOneValue DAX 40:06 40:06
- Summarize DAX 59:21 59:21
- Implict Explict concept 25:36 25:36
Instructor Details
ajay parmar
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now