Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included) скачать в хорошем качестве

Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included)

DAX (Data Analysis Expressions) is the language used by Power Pivot (and Power BI) to build calculations and to analyze data. If you want to be good in Power BI, then you must learn DAX. In this comprehensive video, learn how to get started and use DAX for many practical scenarios with 20+ examples. What is covered? ============== 1️⃣ What is DAX & Power Pivot? 2️⃣ How to create and edit measures in Power BI? 3️⃣ Evaluation Context explained 4️⃣ Customizing the DAX measure display settings 5️⃣ Reusing DAX measures to build complex calculations 6️⃣ How to use CALCULATE() to change the "FILTER" criteria 7️⃣ DAX Measures vs. Columns 8️⃣ Using Variables in DAX 9️⃣ OR conditions, IN operator in DAX 🔟 DAX tips & guidance to improve your skills SAMPLE WORKBOOKS 📂 ===================== Blank Power BI File (with data model) to follow along - https://files.chandoo.org/pbix/gettin... Completed Power BI File (with 20 DAX examples) - https://files.chandoo.org/pbix/gettin... Raw Data file (Excel workbook) - https://files.chandoo.org/pbix/ac-sam... ⏱ Video Topics 👇 ================ 0:00 - What is DAX & Power Pivot? 2:10 - Our first DAX measure 4:46 - Understanding the Power Pivot Calculation Engine & Evaluation Context 7:10 - Formatting the DAX measures 11:32 - Reusability of DAX measures 18:29 - IF Condition in DAX 25:27 - DISTINCTCOUNT in DAX 31:05 - MIN / MAX / AVERAGE 31:42 - CALCULATE in DAX 41:11 - Adding columns with DAX 45:03 - Alternate syntax for CALCULATE() 46:10 - Variables in DAX 48:36 - OR Conditions in DAX (with CALCULATE) 49:45 - 20 DAX measures (recap) 51:48 - How to learn more DAX? LEARN MORE about DAX 💻💡 ======================== My Power BI Course - https://chandoo.org/wp/power-bi-play-... BOOK RECOMMENDATIONS 📚 ========================== Supercharge Power BI with DAX by Matt Allington - https://amzn.to/3HiPYEt Definitive Guide to DAX by Marco Russo & Alberto Ferrari - https://amzn.to/3O9f4b6 More videos on Power BI & DAX 📺 ============================= Introduction to Power BI (45 minutes, 100k+ views) -    • Beginner to PRO Data Analysis with Power B...   Introduction to Power Query (80 minutes, 240k+ views) -    • Power Query Tutorial - What is it, how to ...   Another video on DAX (live stream, 50k+ views) -    • Getting started with Power Pivot & DAX - 1...   My Power BI Videos (playlist) -    • Beginner to PRO Data Analysis with Power B...   ~ What song do Data Analysts dance for? DAX the way... aha aha I Iike it... aha aha 😂 #PowerBI #dax