Power Query: Best Practices

18.1: Final Quiz Mandatory

19.1: Transition to Online Credibility, Project Portfolio, and Resume

Dhaval Patel

Data Entrepreneur | YouTuber | Ex - Bloomberg, Nvidia

I have 17 years of experience in Programming and Data Science working for big tech companies like NVIDIA and Bloomberg. I also run a famous YouTube channel called Codebasics where I pursue my passion for teaching. Codebasics is one of the top channels on YouTube when it comes to data science, machine learning, data structures, etc. I firmly believe that “Anyone can code” and I use analogies, simple explanations, and step-by-step storytelling to explain difficult concepts in such a way that even a high school student can understand them easily.

Hemanand Vadivel

Ex- Data Analytics Manager, 8+ Years in Europe, Microsoft Certified, Certified Supply Chain Professional

I’m a mechanical engineer who transitioned to a full time Data & Analytics manager in the UK & Germany by teaching myself Power BI, excel & anything else that was required to solve the problem. I have worked with complex data across Supply Chain, Sales, Marketing, Revenue Management, Finance and HR functions over the last 8 years to deliver effective solutions. To me, Analytics is an extra sensory organ that anyone can develop to become a superhuman at work. I have conducted several workshops and internal training to help non-technical people to become superhuman at work and now, really excited for this opportunity to share all that knowledge with you in this course.

Power Query: Best Practices

Lecture Content Locked

Enroll in Bootcamp to Unlock

Contents

1: Welcome to the Power BI Experience

1.1: Welcome to Power BI Experience

1.2: How Learning Power BI Can Help You in Your Career?

1.3: Read Before You Begin

2: Power BI Basics: Getting Started NEW

2.1: Install Power BI

2.2: Power BI: Tool Introduction

2.3: Power Query: Intro & Column Transformations

2.4: Power Query: Merging and Appending

2.5: Power Query: Best Practices

2.6: Introduction to DAX

2.7: Introduction to DAX - II

2.8: Introduction to Data Modeling

2.9: Introduction to Creating Visuals

2.10: Tony asks Peter to Fix Data Holes

2.11: Practice Exercise

2.12: Chapter Summary

2.13: Quiz

3: Project Planning and Scoping

3.1: Problem Statement

3.2: The Email that Started this Project

3.3: Project Kick-off Meeting

3.4: Learn how a ‘Project Charter’ is Used in Companies

3.5: Project Kick-off: Session Debrief

3.6: Senior Data Analyst Sets Up the Next Steps with Junior Data Analyst NEW

3.7: Simplified: Profit and Loss Statement

3.8: Chapter Summary

3.9: Quiz

4: Power BI Basics: Data collection, Exploration & Validation

4.1: Simplified: Data Warehouse, OLTP vs OLAP, Data Catalog

4.2: Install MySQL and Import Data

4.3: Simplified: Data Exploration Using SQL, Star Schema, Fact vs Dimension Tables

4.4: Load and connect data with MySQL

4.5: Create a Date Dimension Table

4.6: Validate Data against Benchmark Numbers

4.7: Tony’s Valuable Advise to Peter NEW

4.8: Practice Exercise

4.9: Chapter Summary

4.10: Quiz

5: Power BI Basics: Data Transformation in Power Query

5.1: Review Finance View Mockups

5.2: How to Enhance your Mockups

5.3: Transform Data in Power Query Editor

5.4: Create Calculated Columns in Power Query Editor

5.5: Power Query Best Practices

5.6: Peter Gets His Hands Dirty NEW

5.7: Practice Exercise NEW

5.8: Chapter Summary

5.9: Quiz

6: Get Your DAX Fear Removed NEW

6.1: Peter's Fear for DAX

6.2: DAX Behaviour: Filter Context

6.3: DAX: Using Calculate to Change Filter Context

6.4: All and ALLEXCEPT

6.5: Direct Filters and FILTER Function

6.6: DAX Calculated Column

6.7: Practice Exercise

6.8: Chapter Summary

6.9: Quiz

7: Power BI Advanced: Data Modeling & Calculated Columns

7.1: Power Query or DAX for Generating Calculated Columns?

7.2: Data Modelling: Star and Snowflake Schema

7.3: Data Modeling: Connect Dimensions with Fact Tables

7.4: Simplified: Why Do We Need Dimension Tables?

7.5: Mentor Talk: Congratulations! You are Levelling Up!

7.6: Create Calculated Columns Using DAX

7.7: Easy Way to Verify Your Numbers in Power BI

7.8: Assignment: Optimize Report and Reduce File Size by 25 %

7.9: I Need a Favour

7.10: Chapter Summary

7.11: Quiz

8: Power BI Advanced: Build Finance View

8.1: Finance View: Prepare a List of Metrics

8.2: Simplified: Calculate Function & Filter Context

8.3: Finance View: Creating Metrics

8.4: Finance View: Create P&L Table Structure

8.5: Finance View: Create Last Year (LY) Column

8.6: Finance View: Build an Ultimate DAX Measure for P & L Table Structure - I

8.7: Finance View: Build an Ultimate DAX Measure for P & L Table Structure - II