Workplace Skills Mastery Program
Excel, SQL, Power B & Tableau Duration: 6 months Projects: 20 industry projects 1 Cpastone Project CV building Interview Prep
₹13499.00 ₹14999.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
5 Exercises • 2 Learning Materials
Introdution to Excel
Introduction to Excel - Part 1
Introduction to Excel Part 2
Explore the Excel Ribbon
Formulas & Functions in Excel
Logical Functions
Excel Project 1 : Sales & Inventory Optimization | Retail
Retail Sales & Store Performance Analysis
Meet the New Excel Engine
Text Functions
Excel Project 2: Production Quality Tracker | Manufacturing
Production & Defect Monitoring Dashboard
Conditional Formatting & Date/Time Functions
Charts
Excel Project 3: Campaign Performance Analysis | Marketing
Campaign ROI Analysis
Pivot Tables Basics
Pivot Charts & Advanced Pivot Tables
Power Query Basics
Excel Project 4: Resource Utilization Analysis | Healthcare
Hospital Cost & Capacity Analysis
Power Query Advanced Features
Power Pivot
Dashboard Design Principles
Excel Project 5: Yield & Cost Dashboard | Agriculture
Crop Yield & Cost Efficiency Analysis
Google Sheets Basics & Collaboration
Google Sheets Advanced
Dashboard Integration (Excel + Sheets)**
VBA Fundamentals & Automation
VBA Forms & Events
Automated Reporting Tool
Full Project on Excel
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 • 157 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy