Commonly Used Business Metrics (P&L)

Final Quiz Mandatory

Transition to Online Credibility & Power BI

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.

Commonly Used Business Metrics (P&L)

Lecture content Locked

Enroll in Bootcamp to Unlock

Contents

1. Welcome to The Excel Experience

How Can Learning Excel Help You in Your Career?

Course Outline

2. Excel Basics: Getting Started

Peter Pandey’s Journey and Need to Learn Excel

Installing Excel: Windows / Mac

Getting Familiar With Excel

Getting More Familiar With Excel

Introduction to Formulas

Formula Behavior

Introduction to Tables

Introduction to Charts

Other Essential Features

Peter Gets His First Assignment From His Senior

Practice Exercise: Personal Expense Tracker

Quiz

3. Excel Basics: Cleaning & Combining Data

Intro to Movies Dataset

Cleaning Bad Data

Combining Data From Two Tables (VLOOKUP)

Combining Data From Two Tables (INDEXMATCH)

Combining Data From Two Tables (XLOOKUP)

Peter’s Request To Tony

Practice Exercise

Quiz

4. Excel Basics: Applying Business Maths & Statistics

Basic Maths to Business Metrics (Bollywood movies revenue avg)

Commonly Used Business Metrics (P&L)

Commonly Used Statistic Concepts (Mean, Median, Mode)

Commonly Used Statistic Concepts (Variance, Standard Deviation)

Commonly Used Statistic Concepts (Correlation)

Peter Gets to Solve a Real Time Problem

Practice Exercise

Quiz

5. Excel Basics+: Data Transformation Using Power Query

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

Cleaning Data In Power Query

Merging Data in Power Query

Adding New Columns in Power Query

Loading Power Query Data to Excel

Peter Get’s His Hand Dirty

Practice Exercise

Quiz

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

Pivot Table Introduction: Apple Product Sales

Pivot Table For Movie Analytics

Creating a Report Using Pivot Table

Pivot Table Options & Formatting

Using Power Pivot & DAX For Powerful Business Reports

Adding Targets Using Data Modelling in Power Pivot

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

More Business Metrics and Conditional Formatting

VBA Basics & How Much VBA You Should Learn

Peter Practices On His Own

Practice Exercise

Quiz

I Need a Favour

7. Atliq Hardware & Problem Statement

Atliq’s Business Model

Usage of Excel & Business Requirement in Atliq

8. Excel Advanced: Sales Analytics

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

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

Business Report: Solution Design Thought Process

Creating Connections Among Tables Using Data Modelling

Adding a Date Table Using Power Query

Functional Knowledge: Sales

Sales Analytics: Creating Customer Performance Report

User Empathetic Report Design

Sales Analytics: Creating Market Performance vs Targets Reported

Practice Exercise

Quiz

9. Excel Advanced: Finance Analytics

Understanding P & L

Functional Knowledge: Finance

Adding the Finance Data to Data Model

Finance Analytics: P & L by Year Report

Fine Tuning P & L By Year Report

Adding Months & Quarters in Data Model