POWER BI – DATA MODELING & DAX

Power BI Data Modeling & DAX participants across Mumbai, Kolkata, Bangalore, New Delhi, Gurgaon, Chennai, Hyderabad, Pune, Nasik, Ahmedabad, etc.

DAX (Data Analysis Expressions) is a formula language used in Power BI, Power Pivot, and Analysis Services to define measures and calculations for data modeling. It is similar to Excel formulas, but is more powerful and flexible, allowing you to create complex calculations and analyses that are not possible with traditional Excel formulas.

Overall, Power BI DAX is a powerful tool that allows you to create complex calculations and measures in Power BI and is an essential part of data modeling in Power BI.

With the aim of equipping with this Ninja-level power. We have developed a 1-day workshop, which has been conducted at prestigious companies, including PwC, EY, ITC, Coca-Cola, Flipkart, Asian Paints, etc.

Pre -Training Video

Introduction to Power Query and Power BI Desktop [FREE Course]

Enquiry For Corporate Training +91-9167847797

Power BI - Data Modeling & DAX | Course Outline

Program Name: Power BI – DAX
Software: MS Power BI Desktop
Level: Intermediate to Advanced
Duration: 8 hrs.

Learning Material: Datasets-based case studies, PDF and YouTube videos from our channel for revision

Delivery Style:

  • Hands-on practice (Demo -> Practice side-by-side).
  • First, show a demo with the problem statement and solution.
  • Then, slow down the pace to let people practice along with the Instructor.

Who is this program for?
Learners who have completed L1-L2 level (Basic to Intermediate) of Power BI training

Objectives: By the end of this session, you will be able to understand and apply the:

  1. Top 10 essential concepts, theories and fundamentals of how DAX works.
  2. The top 10 commonly used DAX measures.
  3. Basics of Data Modeling & Relationship cardinality.

Coverage:

  1. Writing DAX formulas.
  2. Defining calculated tables and columns.
  3. Defining measures.
  4. Using DAX iterator functions.
  5. Modifying filter context.
  6. Using DAX time intelligence functions

Important Note: This is a hands-on practice based workshop. Learners are expected to complete the program pre-requisites before the start of the program.

Program Pre-requisite:

  1. Download and Install Power BI Desktop (free) from this Microsoft link:
    https://www.microsoft.com/en-us/download/details.aspx?id=58494
  2. Download the detailed case studies and PDF material from the link that will be shared in the email.
  3. 25-mins ‘Pre-Training Prep’ video course:
    courses.yodalearning.com/p/introduction-to-power-query-and-power-bi-desktop/

A: Fast recap of earlier session | 30 mins.

Visualisation, Power Query

B: Basics of Data Modeling & Relationship cardinality | 25 mins.

  1. What is a Data Model?
  2. Relationship Cardinality – Uniqueness of Values in Columns
  3. What are Table relationships? What are active relationships?
  4. Most popular Table relationship – One to Many
  5. Data Tables (FACT or Transactions Tables) vs. Lookup Tables (DIM or Master Table)
  6. ‘Manage relationship’ feature
  7. Recommended reading –
    • Database Normalization: Concepts & Rules (1NF, 2NF, 3NF)
    • What is Denormalization?
    • Key Types: Primary, Foreign, Composite
    • Star Schema

C: Using DAX - Data Analysis Expression | 280 mins.

  1. “DAX is simple, but it is not easy.”
  2. What is DAX? Why is it needed?
  3. How DAX works in the background?
  4. Calculated Columns & Measures
  5. Implicit Measures vs Explicit Measures
  6. New Measure or New Column – Which one to use when?
  7. Evaluation Context = [Filter + Row] Context; Context Transition
  8. Iterator function (SUMX)
  9. Exercise: Discount calculation [Sales x Disc %] using Calculated Column, SUM, SUMX
  10. Overview – ‘Quick Measure’ for readymade DAX Patterns
  11. Why create a measure for a simple thing as SUM?
  12. What is the concept of Time Intelligence functions? Where is it used?
    • Date Master (List of unique dates with no gaps)
    • One to Many relationships
  13. How to add Comments in a DAX
  14. CALENDARAUTO
  15. CALENDAR with DATE, MAXX and MINX
  16. CALCULATE & the concept of modifying Filter context
  17. CALCULATE with DATEADD (compare sales of different periods)
  18. DATESINPERIOD
  19. FIRSTDATE, LASTDATE
  20. DATESYTD, TOTALYTD
  21. DIVIDE (handles error cases)
  22. ALL vs ALLSELECTED
  23. Using in-built filters of CALCULATE with operators for AND / OR logic
  24. CALCULATE with FILTER
  25. DISTINCTCOUNT (unique customers, products etc.)
  26. COUNTROWS (total transactions)
  27. RELATED
  28. IF vs. SWITCH [if time permits]

D: Overview of some report visualisation features | 30 mins.

  1. Toggle-based Charts view: Use Shapes as buttons along with ‘Selection Pane’ & ‘Bookmarks’
  2. Using ‘New Parameter’ to create ‘What if’ – GENERATESERIES, SELECTEDVALUE
  3. Custom Tooltip – On hover visuals
  4. Overview of DAX Suggestions (new update)

FAQs:

Power BI is a data visualization and business intelligence tool that allows users to create interactive reports and dashboards.

Corporate Power BI training is typically attended by a variety of professionals, including business analysts, data analysts, data scientists, and other professionals who are responsible for creating and sharing data insights within their organization.

Corporate Power BI training can help professionals develop the skills and knowledge they need to effectively use Power BI to create, present, and communicate data insights within their organization.

It’s important to create a supportive environment that encourages your employees to continue learning and practicing their Power BI skills after the training has ended. This can help them retain the skills they learned and continue to improve their proficiency with the tool.

  1. Download and Install Power BI Desktop (free) from this Microsoft link (PBIDesktopSetup_x64.exe):
    https://www.microsoft.com/en-us/download/details.aspx?id=58494
  2. Download the detailed case studies and PDF material from the link that will be shared in the email.
  3. 25-mins ‘Pre-Training Prep’ video course:
    courses.yodalearning.com/p/introduction-to-power-query-and-power-bi-desktop/
Trustpilot

Enquiry For Corporate Training
+91-9167847797

WHAT STUDENT SAYS

Pre-Training Prep Course Testimonials

Trustpilot
Kapila Basnayake
Causeway Paints
Read More
It is highly appreciating the way he teaches us. We are a much more comfortable zone to understand since we are in the beginning.
Prasoon Mehra
EY
Read More
The video and modules illustrated were good with the proper shortcuts mentioned. a great training prep.
Sanyam Kalra
PwC
Read More
This Excel Speed Training was really helpful and informative. Shortcuts were really good to know. Flash Fill. Vlookup and Pivot Table as well. Helped me get to the next level. A big thanks to PwC and Yoda Learning Team for introducing me to this course.
Harsh Bhati
PwC
Read More
It's short, and concise yet pretty informative, your way of describing things and the edits mentioning the shortcuts on the screen helped me with the learning.
Vishal Sharma
PwC
Read More
The way these sessions are planned is way more helpful than physical training in the classroom. These are very much helpful.
Chandni Lakdawala
PwC
Read More
Now I can easily and efficiently use excel. Also really good and quick coverage Of the topics.
Mohit Kumar
EY
Read More
Pre-Training preparation is very crisp and really useful to refresh the formulas for advanced training.
Ankit Singh
EY
Read More
All the concepts were explained very clearly and were easy to understand. The information conveyed was relevant and is really going to be handy.
Kavya Gupta
PwC
Read More
All the topics were relevant and can be used in day-to-day projects. Very insightful and informative topics were covered.

WHAT STUDENT SAYS

Post-Training Testimonials

Trustpilot
Kaustubh Raul
EY
Read More
It was a superb and 2 ways session. The trainer made it so comfortable and easy for everyone though for almost everyone this is was the very first time to be working on Power BI.
Anushree krishania
EY
Read More
It was excellent!! Very very worthwhile to attend it. Thank you so much, and I hope to have more sessions.
Pushkar Thakur
PwC
Read More
Just excellent. Such detailed explanation and patience, Sir, has no word other than 'excellent.' When training can be tedious, Sir has made the session interactive and not just for the namesake; because it's so exciting and accurate to its name Sir has done justice to the 'advanced excel training.' Kudos!!
Chetan Nagaraju
Razorpay
Read More
The presenter was able to explain all aspects clearly. He was patient and was able to answer all Qs.
Chirag Jain
ITC
Read More
The session was great, and the way the trainer told things was convenient and easy to understand.
Diganta Kakati
T&A Consulting
Read More
So far, I have enjoyed the session. It was very informative and exciting. I like the pace that the trainer conducts the session. Looking forward to learning more new and exciting stuff.

Most Demanded Programs

Advanced Excel Training
Advanced Excel TrainingLevel 1 (6 hours)
Read More
Power Query Training
Power Query Training6 hours
Read More
Storytelling using PowerPoint
Storytelling using PowerPoint6 hours
Read More
Advanced Excel Training
Advanced Excel TrainingLevel 2 (6 hours)
Read More
Alteryx <br> Training
Alteryx
TrainingLevel 1 (7 hours)
Read More
Alteryx <br> Training
Alteryx
TrainingLevel 2 (7 hours)
Read More
Power BI <br>Training
Power BI
TrainingVisualization (6 hours)
Read More
Tableau <br>Training
Tableau
Training7 hours
Read More
Power BI DAX Training
Power BI DAX Training6 hours
Read More

Company

Call us:

+91-91678-47797

Email us:

[email protected]

Recent Posts