The Workplace Skills Mastery Program in Business Analytics (6 Months) Excel, SQL, Power BI & Tableau
Excel, SQL, Power BI & Tableau Duration: 6 months Projects: 20 industry projects 1 Capstone Project CV building Interview Prep
₹14999.00 ₹25000.00 40% OFF
/CourseBundles(67372)/4738811-WhatsApp_Image_2025-12-13_at_2.10.14_PM_(1).png)
Course Overview
Schedule of Classes
Start Date & End Date
Feb 09 2026 - Jul 09 2026
Course Curriculum
7 Subjects
Excel
8 Exercises • 73 Learning Materials
Introdution to Excel
Introduction to Excel - Part 1
Introduction to Excel Part 2
Excel UI overview
Ribbon walkthrough (Home, Insert, Data, Formulas)
Cell types: General, Number, Currency, Date.
Formatting techniques: alignment, borders, conditional fills, number formatting.
Navigation: Freeze Panes, Split View, Hide/Unhide rows/columns/sheets/Group rows
Explore the Excel Ribbon
Understand the legacy tools available in the ribbon
Sorting
Filter/Advanced Filters - Part 1
Filter/Advanced Filters - Part 2
Remove Duplicate
Text To Column
Formulas & Functions in Excel
Introduction: Why formulas matter for analysts.
How to do arithmetic calculations, including constants in calculations
SUM: Row Totals, Conditional Ranges.
AVERAGE: Handling Blanks vs Zeros.
MIN & MAX for Data Analysis.
Count
Common Mistakes & Error Handling
Logical Functions
IF Function Syntax.
Simple Conditions
Compound Conditions With AND & OR.
Nesting Functions (SUM inside IF)
Introduce IFS For Multi-Level Outcomes.
IFERROR To Handle Invalid Data.
Excel Quiz 1 - Excel module 1 to Module 4
Excel Quiz 1 - Module 1 to Module 4
Excel Project 1 | Retail
Excel Project 1 - Retail Sales & Store Performance Analysis
Meet the New Excel Engine
Introducing The New Excel Engine
Understand The Power Of This New Tool With Examples
Why Lookups Are Essential
Explain Lookup With A Simple Example
Quick review of VLOOKUP and why it is not a great function - Part 1
Quick review of VLOOKUP and why it is not a great function - Part 2
The Modern Replacement XLOOKUP Explained
Text Functions
LEFT, RIGHT, MID, LEN Quick Intro
TRIM & CLEAN (removing unwanted text)
TEXTJOIN, TEXTSPLIT
Using "&" for merging text
Excel Quiz 2 - Module 5 to Module 8
Excel Quiz 2 - Module 5 to Module 8
Conditional Formatting & Date/Time Functions
Conditional Formatting Basics
Highlight Duplicate
Highlight Values Above/Below Average.
Color Scales & Icon Sets
TODAY & NOW, NETWORKDAYS, DATEDIF, EOMONTH
Excel Project 2: Production Quality Tracker | Manufacturing
Excel Project 2: Manufacturing Process Efficiency & Quality Tracker
Charts
Why VIsuals Matter In Analytics (Storytelling)
Choosing The Right Chart For The Right Data
Bar & Column Charts → Comparisons.
Line charts → trends over time.
Combo charts → show 2 metrics (e.g., Sales vs Profit)
Trendlines & Forecasting Basics
Formatting Charts → Axis, Legends, Labels, Colors
Pivot Tables Basics
What is a Pivot Table? Why analysts use it.
Structure: Rows, Columns, Values, Filters.
Aggregations: SUM, COUNT, AVERAGE
Refreshing Pivots When Source Data Updates
Excel Quiz 3 - Module 9-13
Excel Quiz 3 : Module 9-13
Pivot Charts & Advanced Pivot Tables
Pivot Charts Basics: Bar, Line, Pie
Grouping Data: Months, Quarters, Years
Calculated Fields Inside Pivot Tables
Adding Slicers For Interactivity
Excel Project 3: Campaign Performance Analysis | Marketing
Campaign ROI Analysis
Dashboard Design Principles
What Is A Dashboard? Purpose In Business
Good Dashboard Principles
Google Sheets Basics & Collaboration
Difference Between Google Sheets vs Excel (CLoud-Based, Auto-Save, Collaboration).
Basic formulas: SUM, AVERAGE, IF
Sharing files: View, Comment, Edit Permissions
Version History → Restoring Previous Versions
Adding Comments & Assigning Tasks To Teammates
Google Sheets Advanced
UNIQUE → Extract Unique Values From A Column
FILTER → Extract Filtered Data Dynamically
IMPORTRANGE → Import Data From Another Google Sheet.
Add-ons (Installing, Using Third-Party Tools)
Dashboard Integration (Excel + Sheets)**
Import/Export Data Between Excel & Sheets
Linking Excel Dashboards With Google Sheets Data
Excel Project 4: Agriculture Yield & Cost Dashboard
Excel Project 4: Agriculture Yield & Cost Dashboard
VBA Fundamentals & Automation
Introduction to Macros & VBA
Recording Macros vs Writing Code
How To Record Macros
Excel Project 5: Healthcare Operations Automation Analysis
Excel Project 5: Healthcare Operations Automation Analysis
SQL
5 Exercises •
SQL Project 1: Foundation
SQL Project 1 - Foundation
SQL Project 2 : Telecom - Telco Churn Rate Analysis
SQL Project 2 - Telecom - Telco Churn Rate Analysis
SQL Project 3: Superstore Sales Analysis - Ecommerce
SQL Project 3 - Superstore Sales Analysis | Retail
SQL Poroject 4: Netflix Entertainment Analysis | OTT Media
S1L Project 4 : Netflix Entertainment Analysis | OTT Media
SQL Project 5: Food & Beverage | Pizza Sales Analysis
SQL Project 5: Food & Beverage | Pizza Sales Analysis
Power BI
5 Exercises •
Power BI Project 1 | Banking | Credit Card Approval
Power BI Project 1 | Banking | Credit Card Approval
Power BI Project 2 : Ecommerce Sales modelling | E-commerce
Power BI Project 2 - Ecommerce | Ecommerce Sales modelling
Power BI Project 3 : Pizza Sales Analysis | Restaurant
Power BI Project 3 : Pizza Sales Analysis | Restaurant
Power BI Project 4 : Retail | Sales Analysis
Power BI Project 4 : Retail | Sales Analysis
Power BI Project 5 : Restaurant | Dashboard
Power BI Project 5 : Restaurant | Dashboard
Tableau
5 Exercises •
Tableau Project 1 : Sales Data Exploration & Preparation | Retail
Retail Sales Data Exploration & Preparation
Tableau Project 2 : Sales & Geography Visual Analysis| Retail
Sales & Geography Visual Analysis
Tableau Project 3 : Campaign Performance Dashboard | Marketing
Marketing Campaign Performance Dashboard
Tableau Project 4: Healthcare Performance & Ranking Analysis
Healthcare Performance & Ranking Analysis
Tableau Project 5: Delivery Performance Dashboard | Quick Commerce
Quick Commerce Delivery Performance Dashboard
CV Optimization
CV Design, Keywords, Projects, Skills
Interview Preparation
Softskills, Job Description, Introduction, Follow-ups, Negotiation
Capstone Project
Course Instructor
Harsh Dalmia
11 Courses • 3032 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy