Learn 80% of DAX in an Hour (with FREE sample file) скачать в хорошем качестве

Learn 80% of DAX in an Hour (with FREE sample file)

Want to learn DAX but don't have the time? This is the video for you. In this one-hour masterclass, learn the 80% essential DAX with practical examples. Understand and master concepts like: → How to create measures 🤔 → Measure vs. Column ⚙ → Measure reusability ♻ → Evaluation Context 💻 → Basic DAX functions - SUM, COUNTROWS, AVERAGE, DIVIDE 🧮 → Conditional DAX functions - IF 🌿 → Understanding and using CALCULATE function 📗 → Multiple filters with CALCULATE 🥝 → How to get good with DAX using ACMBU technique 💡 📁 Download practice workbooks: ============================= Blank Power BI file (with data model + data) - https://chandoo.org/wp/wp-content/upl... (unzip this) Sample dataset - https://chandoo.org/wp/wp-content/upl... Completed Power BI file (and rest of the videos + files) - https://chandoo.org/wp/free-data-anal... ⏱ Video Chapters: ================ 0:00 - Introduction to DAX & our data model 3:00 - Our first DAX measures 11:24 - Why we need DAX when you can get the same thing with "auto" calculations 13:18 - DAX Pledge (say it out with me 🗣) 13:39 - Measure vs. Columns 15:08 - More DAX formulas 16:08 - Difference between Excel and DAX functions! 19:24 - Understanding Evaluation Context 25:12 - Reusing DAX measures 28:32 - Why not use table name in the measures? 30:56 - DIVIDE function 34:18 - CALCULATE function 42:21 - More than one filter with CALCULATE() 46:35 - IN operator 49:22 - Conditional logic with IF() 52:51 - Measures are SCALAR (Aggregates) 55:29 - Awesome DAX trick 💡 58:20 - ACMBU Technique for Better DAX 😎 👩‍💻👨‍💻 Join my Power BI Course ========================== Want to master all aspects of Power BI - right from Power Query to Data Modeling to Power Pivot to DAX to Visual design to Report building? Then you are going to LOVE my Power BI Course. Trusted by more than 1000 people all over the world and consistently rated 5* by everyone. Check out the program and sign up today. Go here 👉 https://chandoo.org/wp/power-bi-course/ 📺 More Power BI Videos on my Channel: ================================= Previous concepts: Data modeling:    • Learn Data Modelling & Star Schema for Pow...   Introduction to Power BI:    • Power BI is EASY: Get started and make you...   Introduction to Power Query:    • Power Query - Beginner to PRO Masterclass ...   Power BI Jargon Explainer -    • Power BI Ecosystem - Explained in 25 minutes   Power BI Jargon Explainer (part 2) -    • Power BI Jargon Buster - 25 More Buzzwords...   VIDEOS: Power BI Sales Dashboard in an hour - https://youtube.com/live/mXD0Peot4hY?... Data analysis with Power BI (end to end live) - https://youtube.com/live/8tfcVnoEL0c?... Power BI end-to-end Course -    • Beginner to PRO Data Analysis with Power B...   Power BI + SQL how to - https://youtube.com/live/UQJAHUUFK-o?... How to use DAX (another video, just as awesome) -    • Learn Power Pivot & DAX for Power BI with ...   Complex Power BI Dashboard (end to end tutorial) -    • FREE Adv. Masterclass on Power BI - Create...   Power BI Playlists: FREE Power BI Course -    • FREE Power BI Course 🎁   Power BI tips & examples -    • Power BI Examples, Demos & Tutorials   Power BI DAX -    • DAX & Power Pivot Tips & Tricks   Power BI Power Query -    • Power Query How-to & Tips   COURSES: Power BI - https://chandoo.org/wp/power-bi-course/ Adv. Excel - https://chandoo.org/wp/excel-school-p... Complete DATA Analysis course (Sql, Power BI, Excel, Python) - https://chandoo.org/mdac ~ CALCULATE(), FILTER() and ALL() wanted to have dinner together. But it never happened. Why? Because FILTER() kept excluding people ALL kept ignoring everything and CALCULATE as usual was late 😂 #Powerbi #dax #chandoo #freedataanalystcourse #fdac