COURSE 3 / 15

Complete Data Analysis Course: Excel, VBA, Power BI, Tableau, SQL, Python & AI

Complete working professional course in live online classes: Advanced Excel with AI, VBA Macros, Power BI, Tableau, Excel dashboards, SQL, Python and AI, with real projects and a certificate.

8 modules215 live classesLive onlineReal projectsCertificateLifetime support

Book a free demo →⬇ Download course PDF Call Sujeet Sir for fees

Course highlights

8ModulesExcel to AI in one course

215Live classesDay-wise, with weekly projects

40+DashboardsReal business data

19YearsExperience, since 2007

YOUR TRAINER

Sujeet Sir

Excel | VBA | Power BI | SQL | Python

Data Analytics Expert & Corporate Trainer

Sujit Kumar Singh, founder of IPT Excel School since 2007
Working with Excel since 2003; MIS Executive and VBA Developer in 10+ companies
Reporting consultant for 40+ companies across India
Teaching motto: "Don't work hard, work smart."

What you will learn

Advanced Excel with AI

300+ formulas, pivot, Power Query and Power Pivot.

VBA Macros programming

Loops, UserForms and 5 automation projects.

Power BI Developer

DAX, data modeling, service, gateway and deployment.

Tableau

Charts, calculations, maps, stories and publishing.

Excel dashboard masterclass

30 days of sales, finance, HR and industry dashboards.

SQL query

Joins, window functions, CTE, stored procedures and ETL.

Python data visualization

Pandas, NumPy, Seaborn, Plotly and Streamlit dashboards.

AI for data analysis

Prompt writing, machine learning basics, RAG and AI agents.

BENEFITS

Learn every major data analysis tool in one course
Real workplace examples, projects in every module
Recording access, study material and interview preparation
Certificate of completion and lifetime support

YOUR GOAL

Become a job-ready data analyst who can clean data, build dashboards, query databases and automate reports.

WHO SHOULD LEARN

Students, freshers, working professionals, MIS executives and career switchers.

COURSE OUTLINE

⬇ Download PDF

Module 1 - Advanced Excel with AI (25 days)

Week 1 : Excel foundations and speed: advanced basics, formatting, data handling, Excel AI (Flash Fill, Analyze Data). Project: data entry sheet with Tables and Named Ranges
Week 2 : 300+ formulas: logical, text, date-time, lookups (XLOOKUP, INDEX, MATCH, FILTER), array formulas, LET, HSTACK, VSTACK
Week 3 : Pivot tables: calculated fields, pivot charts, slicers, what-if analysis, formula auditing. Project: sales / HR analysis report
Week 4 : Dashboards: KPI selection, shapes and controls, interactive and live data dashboards. Project: business dashboard
Week 5 : Power Query, Power Pivot, DAX, Copilot / AI in Excel. Final capstone project and certification test

Module 2 - VBA Macros programming (25 days)

Week 1 : VBA basics, recording macros, workbook, sheet and range objects, file and folder handling
Week 2 : Variables, IF / AND / OR / XOR, nested If, Select Case, For, For Each, Do While and Do Until loops
Week 3 : Custom functions, string, number and date functions, lookups with VBA, UserForm basics
Week 4 : Access and SQL connectivity, Outlook and Gmail automation, Word and PDF automation, web connectivity
Week 5 : 5 projects: auto report, data entry form, bulk email system, dashboard maker, complete solution

Module 3 - Power BI Developer (30 days)

Week 1 : Architecture, Power Query M, query folding, star schema, relationships and date table. Project: sales data model
Week 2 : DAX fundamentals, CALCULATE, time intelligence, advanced visualization. Project: management dashboard
Week 3 : Advanced modeling, DAX optimization, Performance Analyzer, Tabular Editor, dynamic measures. Project: enterprise semantic model
Week 4 : Workspace and apps, gateway, scheduled and incremental refresh, RLS and OLS, deployment pipeline
Week 5 : REST API, Power BI Embedded, PBIP with Git and Azure DevOps, paginated reports, Python / R. Final developer project
Week 6 : Bookmarks, drillthrough, dataflows and datamarts, Premium capacity, Copilot and AI visuals, Power Automate

Module 4 - Tableau (25 days)

Week 1 : Interface, data connection, data preparation, dimensions and measures, quick table calculations
Week 2 : Charts, filters and parameters, calculated fields, advanced charts, dashboards and layouts
Week 3 : Date, string and logical functions, level of detail (LOD), table calculations, trend lines and forecasting
Week 4 : Story points, dashboard actions, maps, data blending, publishing and sharing
Week 5 : Tableau with AI, analytics, NLP and data insights, automation. Final project: Data to Viz to Story

Module 5 - Excel dashboard masterclass (30 days, 40+ dashboards)

Level 1 (Days 1-5) : Foundation: sales, product profitability, branch, customer and seasonality dashboards
Level 2 (Days 6-10) : Interactive: target vs achievement, slicers and timeline, KPI scorecard, marketing and ROI
Level 3 (Days 11-15) : Professional MIS: revenue and expense, P&L, budget vs actual, receivables and payables, inventory
Level 4 (Days 16-20) : Departments: purchase, HR, recruitment, attendance, payroll
Level 5 (Days 21-25) : Customer and industry: service, call center, e-commerce, logistics, banking
Level 6 (Days 26-30) : Advanced: healthcare, education, manufacturing, multi-department MIS, CEO dashboard capstone

Module 6 - SQL query (25 days)

Week 1 : Environment, SELECT, WHERE, GROUP BY, ORDER BY, functions, subqueries. Project: basic query report
Week 2 : INNER, LEFT, RIGHT and FULL joins, UNION, views, indexes, stored procedures, triggers. Project: analysis with joins
Week 3 : Window functions, CTE, string and date functions, pivot and unpivot, performance tuning
Week 4 : Import CSV and Excel, data cleaning, SQL Server and ETL, data modeling, reports. Project: end-to-end data pipeline
Week 5 : Advanced SQL and automation

Module 7 - Python data analysis, visualization and dashboards (25 days)

Week 1 : Python basics, data types, loops, functions, NumPy. Project: data processing script
Week 2 : Pandas, reading CSV, Excel, SQL and JSON, data cleaning, GroupBy, merge, pivot. Project: sales data cleaning
Week 3 : EDA, statistics, correlation, hypothesis testing, Matplotlib and Seaborn. Project: EDA report
Week 4 : Advanced Seaborn, Plotly, Streamlit dashboards. Project: interactive analytics dashboard
Week 5 : Python automation, SQL and API connections, AI for analytics, machine learning foundation, end-to-end project

Module 8 - AI course (30 classes)

Foundations : AI, ML, DL and GenAI, Google Colab, Python basics
Python and data analysis : data structures, functions, NumPy, Pandas, data cleaning, Matplotlib, Seaborn, EDA
Machine learning : regression, classification, decision trees, random forest, KNN, K-Means. Projects: house price and customer churn prediction
Deep learning : neural networks, Keras, CNN image classifier
Generative AI : prompt engineering, AI APIs, embeddings, RAG (chat with your PDF), AI agents
Productivity and careers : workflow automation, AI in Excel and Power BI, Streamlit with Git, AI ethics, capstone project, career guidance

Full course outline (PDF)

⬇ Download course outline PDF

COURSE DETAILS

Modules	8 (Excel with AI, VBA, Power BI, Tableau, Dashboards, SQL, Python, AI)
Total classes	215 live classes, day-wise plan in the outline
Mode	Live online classes, with recording access
Batch	One-to-one or group batch
Language	Hindi or English
Projects	Projects in every module and a final capstone
Certificate	Yes, certificate of completion
Support	Doubt support and lifetime support
Demo	Free 3-4 day demo class
Fees	Contact Sujeet Sir: +91 88025 79388

HOW IT IS TAUGHT

Live online by Sujeet Sir in Hindi or English, with real workplace scenarios, hands-on projects, downloadable study material, interview preparation, a certificate and lifetime support.

Join a free demo

Questions about this course

What is the fee of the Complete Data Analysis course?

Fees depend on one-to-one or group batch. Contact Sujeet Sir on +91 88025 79388 or WhatsApp for the current fee.

Is there a free demo?

Yes. Join the 3-4 day free demo before you pay.

Which language is it taught in?

Hindi or English, as you prefer.

← VBA Macros Python Data Visualizations →