Using Power Pivot & DAX For Powerful Business Reports

12.1: Final Quiz

13.1: Test

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.

Using Power Pivot & DAX For Powerful Business Reports

Prev Next

Lecture Content Locked

Enroll in Course to Unlock

Contents

1: Welcome to The Excel Experience

1.1: How Can Learning Excel Help You in Your Career?

1.2: How is this Excel Course Different From Other Courses On the Internet?

1.3: What Support Do You Provide If I Have Doubts?

1.4: System Requirements

1.5: Course Outline

2: Enhance your Learning Experience

2.1: Join Discord for doubt clearing support & networking

2.2: Setting Video Resolution and Video Speed Globally

3: Excel Basics: Getting Started

3.1: Peter Pandey’s Journey and Need to Learn Excel

3.2: Installing Excel: Windows / Mac

3.3: Getting Familiar With Excel

3.4: Getting More Familiar With Excel

3.5: Introduction to Formulas

3.6: Formula Behavior

3.7: Introduction to Tables

3.8: Introduction to Charts

3.9: Other Essential Features

3.10: Peter Gets His First Assignment From His Senior

3.11: Practice Exercise: Personal Expense Tracker

3.12: Quiz

3.13: Chapter Summary

4: Excel Basics: Cleaning & Combining Data

4.1: Intro to Movies Dataset

4.2: Cleaning Bad Data

4.3: Combining Data From Two Tables (VLOOKUP)

4.4: Combining Data From Two Tables (INDEXMATCH)

4.5: Combining Data From Two Tables (XLOOKUP)

4.6: Peter’s Request To Tony

4.7: Practice Exercise

4.8: Quiz

4.9: Chapter Summary

5: Excel Basics: Applying Business Maths & Statistics

5.1: Basic Maths to Business Metrics (Bollywood movies revenue avg)

5.2: Commonly Used Business Metrics (P&L)

5.3: Commonly Used Statistic Concepts (Mean, Median, Mode)

5.4: Commonly Used Statistic Concepts (Variance, Standard Deviation)

5.5: Commonly Used Statistic Concepts (Correlation)

5.6: Peter Gets to Solve a Real Time Problem

5.7: Practice Exercise

5.8: Quiz

5.9: Chapter Summary

6: Excel Basics+: Data Transformation Using Power Query

6.1: What is Power Query and Why it is the game changer?

6.2: Cleaning Data In Power Query

6.3: Merging Data in Power Query

6.4: Adding New Columns in Power Query

6.5: Loading Power Query Data to Excel

6.6: Peter Get’s His Hand Dirty

6.7: Practice Exercise

6.8: Quiz

6.9: Chapter Summary

7: Excel Basics+: Creating Business Reports Using Pivot Table & Power Pivot

7.1: Pivot Table Introduction: Apple Product Sales

7.2: Pivot Table For Movie Analytics

7.3: Creating a Report Using Pivot Table

7.4: Pivot Table Options & Formatting

7.5: Using Power Pivot & DAX For Powerful Business Reports

7.6: Adding Targets Using Data Modelling in Power Pivot

7.7: Breaking Down Complex Problems: Thinking Process of a Highly Paid Data Analyst

7.8: More Business Metrics and Conditional Formatting

7.9: VBA Basics & How Much VBA You Should Learn

7.10: Peter Practices On His Own

7.11: Practice Exercise

7.12: Quiz

7.13: I Need a Favour

7.14: Chapter Summary

8: Atliq Hardware & Problem Statement

8.1: Atliq’s Business Model

8.2: Usage of Excel & Business Requirement in Atliq

9: Excel Advanced: Sales Analytics

9.1: ETL (Extract, Transform and Load Data) in Excel I

9.2: ETL (Extract, Transform and Load Data) in Excel II

9.3: Business Report: Solution Design Thought Process

9.4: Creating Connections Among Tables Using Data Modelling

9.5: Adding a Date Table Using Power Query

9.6: Functional Knowledge: Sales

9.7: Sales Analytics: Creating Customer Performance Report