The Workplace Skills Mastery Program in Business Analytics (6 Months)
Excel, SQL, Power BI & Tableau Duration: 6 months Projects: 20 industry projects 1 Cpastone Project CV building Interview Prep
₹22500.00 ₹25000.00 10% 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
6 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 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
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
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: Resource Utilization Analysis | Healthcare
Hospital Cost & Capacity Analysis
VBA Fundamentals & Automation
Introduction to Macros & VBA
Recording Macros vs Writing Code
How To Record Macros
Excel Project 5: Yield & Cost Dashboard | Agriculture
Crop Yield & Cost Efficiency Analysis
Excel Module 1 - 4
Quiz 1 - Excel module 1-4
Excel Quiz 1 - Module 1 to Module 4
SQL
5 Exercises •
Introduction to SQL
Database & Table Operations
Data Operations
SQL Project 1: Sales & Customer Analysis | Ecommerce
E-commerce Sales & Customer Analysis
Aggregations
Joins & Set Operations
SQL Project 2 : Transactions & Account Analysis | Banking
Banking Transactions & Account Analysis
Subqueries & Operators
Functions
SQL Project 3: Student Performance Analysis | Education
Student Performance Analysis
Advanced SQL
SQL Poroject 4: Patient & Visit Analysis | Healthcare
Hospital Patient & Visit Analysis
Transactions & Indexing
Import/Export
SQL Project 5: Logistics & Supply Chain Performance Analysis
Logistics & Supply Chain Performance Analysis
Power BI
Introduction to Power BI
Power Query Editor
Transform Section
Power BI Project 1 : Car Insurance Fraud | Insurance
Add Column section
Analysis and their types
Different Types of Charts
Top N Analysis
Power BI Project 2 : Heart Disease Attack | Pharma Research
Table & Matrix
Filter Section, Q & A AI
Data Modeling
Power BI Project 3: Credit Card Approval | Banking
Dax Queries
Text & Logical Function
Dashboard
Security and Dashboard Sharing
Power BI Project 4 : Churn Problem | Telecom
Power BI Project 5 : Zara Sales | Retail
Tableau
5 Exercises •
Introduction to Tableau
Data Connections
Data Preparation
Tableau Project 1 : Sales Data Exploration & Preparation | Retail
Retail Sales Data Exploration & Preparation
Charts Basics
Tableau Project 2 : Sales & Geography Visual Analysis| Retail
Sales & Geography Visual Analysis
Filtering & Sorting
Calculations
Tableau Project 3 : Campaign Performance Dashboard | Marketing
Marketing Campaign Performance Dashboard
Advanced Calculations
Tableau Project 4: Healthcare Performance & Ranking Analysis
Healthcare Performance & Ranking Analysis
Dashboards
Maps, Storyboards & Publishing
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 • 818 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy