LIVE CLASSES

Job Assistance

Master Data Analytics
with Live Instructor-Led Training

A focused data analytics course covering the complete analyst toolkit — Excel, SQL, Python (Pandas, Matplotlib), Power BI, and Tableau. Learn to clean, analyse, visualise, and communicate data insights for business decision-making. Live classroom · Certificate · Job Assistance.

Excel SQL Python Pandas Matplotlib Seaborn Power BI Tableau Statistics Data Visualisation

★★★★½ 4.8 4–6 Months Classroom English / Hindi / Marathi Certificate Job Assistance

LIVE INSTRUCTOR-LED COURSE

Data Analytics

Interactive live sessions · Real-time Q&A · Job Assistance

Demo: Yes

Duration: 4–6 Months

Language: English / Hindi / Marathi

Location: Classroom

Certificate: Yes

Assessments: Yes

Job Assist: Yes

Select Your Batch:

May 5, 2025

Mon, Wed, Fri — 7:00 PM to 9:00 PM IST

8 seats left

May 17, 2025

Sat & Sun — 10:00 AM to 1:00 PM IST

18 seats left

June 2, 2025

Mon, Wed, Fri — 8:00 AM to 10:00 AM IST

Open

Enroll & Reserve Seat Request a Callback

7-Day Money-Back Guarantee

Live interactive classroom sessions

Session recordings after every class

Real-time Q&A with instructor

Private batch — max 30 students

Job assistance included

Industry-recognized certificate

4–6 Months Duration

Classroom Location

4.8/5 Rating

Included Job Assistance

About the Course

What This Course Covers

This course prepares you for a career as a Data Analyst by teaching you the complete industry toolkit — from Excel and SQL for data handling, through Python (Pandas, Matplotlib, Seaborn) for analysis and visualisation, to Power BI and Tableau for interactive business dashboards. You will work on real datasets, learn to tell stories with data, and build a portfolio of analytics projects.

Note: 90% hands-on practical experience · 10% essential theory. Anyone who wants to learn from Basics to Advanced Level. Programmers looking to improve programming skills.

Excel & SQL

Master Excel for data cleaning, pivot tables, and formulas; SQL for querying relational databases.

Python Analytics

Analyse and transform data with Python, Pandas, and NumPy; visualise with Matplotlib and Seaborn.

Power BI

Build interactive dashboards in Power BI — data models, DAX, slicers, and published reports.

Tableau

Create compelling visualisations and story-driven dashboards in Tableau for business audiences.

Statistics & EDA

Apply descriptive statistics, hypothesis testing, and exploratory data analysis to real business datasets.

Business & Communication

Translate data findings into actionable insights — storytelling, stakeholder reports, and presentation skills.

Course Curriculum

What You'll Learn — Module by Module

Microsoft Excel

Live sessions

Introduction to Excel — Interface & NavigationLIVE —

Data Entry & FormattingLIVE —

Formulas & Functions — SUM, AVERAGE, IF, VLOOKUP, INDEX-MATCHLIVE —

Text Functions — CONCATENATE, LEFT, RIGHT, MID, TRIMLIVE —

Date & Time FunctionsLIVE —

Conditional FormattingLIVE —

Sorting & FilteringLIVE —

Pivot Tables & Pivot ChartsLIVE —

Data Validation & Named RangesLIVE —

Charts — Bar, Line, Pie, ScatterLIVE —

What-If Analysis — Goal Seek, ScenariosLIVE —

Doubt Clearing Session + RecordingREC —

SQL for Data Analysis

Live sessions

Introduction to SQL & Relational DatabasesLIVE —

SELECT, WHERE, ORDER BY, LIMITLIVE —

Filtering — AND, OR, NOT, BETWEEN, LIKE, INLIVE —

Aggregate Functions — COUNT, SUM, AVG, MIN, MAXLIVE —

GROUP BY & HAVINGLIVE —

Joins — INNER, LEFT, RIGHT, FULLLIVE —

Subqueries & CTEsLIVE —

Window Functions — ROW_NUMBER, RANK, LAG, LEADLIVE —

Data Cleaning with SQLLIVE —

SQL for Business Analytics — Real Dataset PracticeLIVE —

Python for Data Analytics

Live sessions

Introduction to Python for AnalyticsLIVE —

Variables, Data Types, Control StructuresLIVE —

Functions & List ComprehensionsLIVE —

Introduction to NumPyLIVE —

NumPy Arrays & OperationsLIVE —

Introduction to PandasLIVE —

DataFrames — Creating, Indexing, SelectingLIVE —

Data Cleaning — Handling Missing Values, DuplicatesLIVE —

Data Manipulation — Merge, Group, PivotLIVE —

Introduction to MatplotlibLIVE —

Customizing PlotsLIVE —

Introduction to Seaborn LibraryLIVE —

Exploratory Data Analysis (EDA) on Real DatasetsLIVE —

Statistics for Analytics

Live sessions

Descriptive Statistics — Mean, Median, Mode, VarianceLIVE —

Distributions — Normal, BinomialLIVE —

Correlation & CovarianceLIVE —

Hypothesis Testing — T-test, Chi-SquareLIVE —

Confidence IntervalsLIVE —

Regression Analysis BasicsLIVE —

Power BI

Live sessions

Introduction to Power BI DesktopLIVE —

Connecting to Data Sources — Excel, CSV, SQLLIVE —

Data Transformation with Power QueryLIVE —

Data Modelling & RelationshipsLIVE —

DAX — Measures, Calculated Columns, KPIsLIVE —

Visualizations — Bar, Pie, Line, Map, Card, TreemapLIVE —

Slicers & Page-Level FiltersLIVE —

Building & Publishing Interactive DashboardsLIVE —

Power BI Service & Sharing ReportsLIVE —

Tableau

Live sessions

Introduction to Tableau DesktopLIVE —

Connecting to Data SourcesLIVE —

Building Basic ChartsLIVE —

Filters, Sorting & GroupingLIVE —

Calculated Fields & Table CalculationsLIVE —

Dashboard Design & InteractivityLIVE —

Story Points — Data StorytellingLIVE —

Publishing to Tableau PublicLIVE —

Capstone Projects & Career Prep

Live sessions

Analytics Project 1 — Sales & Revenue Dashboard (Power BI)LIVE —

Analytics Project 2 — Customer Segmentation (Python + SQL)LIVE —

Analytics Project 3 — HR Analytics Dashboard (Tableau)LIVE —

Portfolio Building & GitHubLIVE —

Resume Writing for Data Analyst RolesLIVE —

Mock Interviews — SQL & Case Study RoundLIVE —

Certificate Award SessionLIVE —

What You'll Learn

Excel — pivot tables, VLOOKUP, charts

SQL — queries, joins, window functions

Python — Pandas, NumPy, Matplotlib

Seaborn data visualisation

Exploratory Data Analysis (EDA)

Statistics & hypothesis testing

Power BI — dashboards & DAX

Tableau — charts & story points

3 real-world analytics projects

Portfolio & GitHub setup

Interview preparation

Live Classroom 4–6 Months Certificate

Enroll Now

About Instructor

Learn from an Industry Expert

Prof. Santtosh Upadhyay

Lead Instructor — Data Analytics, CodeMines Academy

12+ Years Experience 100+ Students Mentored MSc Data Science, Dublin Business School (Ireland)

With over 12 years of extensive experience in software development, I bring a wealth of knowledge in PHP, .NET, Python, Java, and cloud technologies. My passion for teaching has led me to mentor and educate more than 100 students across various courses, including web development and app development.

I am dedicated to providing a comprehensive and engaging learning experience, helping students to not only grasp the fundamentals but also master advanced concepts. Join me on this educational journey and unlock your full potential in the world of technology. Don't miss out on our special offers.

FAQs

Frequently Asked Questions

Our counsellors are available Mon–Sat, 9am–7pm IST.

Call Us Now

Is a demo lecture available?

Yes. A free demo lecture is available. Contact us via WhatsApp or phone to schedule.

Do I need prior programming experience?

No prior experience is required. Anyone who wants to learn from Basics to Advanced Level is welcome.

Is this a classroom or online course?

This is a live, classroom-based course with in-person instruction.

What language are classes taught in?

Classes are conducted in English, Hindi, and Marathi.

Will I get a certificate?

Yes. An industry-recognized certificate is awarded on successful completion of all modules and assessments.

Is job assistance included?

Yes. Job assistance including resume preparation, mock interviews, and placement support is included.

Do I need coding experience for this course?

No. The course starts from the basics of Excel and SQL, and Python is introduced step by step from scratch.

What tools will I learn?

Excel, SQL, Python (Pandas, Matplotlib, Seaborn), Power BI, and Tableau — the complete data analyst toolkit.

Master Data Analytics
with Live Instructor-Led Training

Data Analytics

What This Course Covers

Excel & SQL

Python Analytics

Power BI

Tableau

Statistics & EDA

Business & Communication

What You'll Learn — Module by Module

Microsoft Excel

SQL for Data Analysis

Python for Data Analytics

Statistics for Analytics

Power BI

Tableau

Capstone Projects & Career Prep

Our Students Are Getting Hired

Learn from an Industry Expert

Frequently Asked Questions

Is a demo lecture available?

Do I need prior programming experience?

Is this a classroom or online course?

What language are classes taught in?

Will I get a certificate?

Is job assistance included?

Do I need coding experience for this course?

What tools will I learn?

Ready to Start Your Data Analytics Career?

Master Data Analyticswith Live Instructor-Led Training

Data Analytics

What This Course Covers

Excel & SQL

Python Analytics

Power BI

Tableau

Statistics & EDA

Business & Communication

What You'll Learn — Module by Module

Microsoft Excel

SQL for Data Analysis

Python for Data Analytics

Statistics for Analytics

Power BI

Tableau

Capstone Projects & Career Prep

Our Students Are Getting Hired

Learn from an Industry Expert

Frequently Asked Questions

Is a demo lecture available?

Do I need prior programming experience?

Is this a classroom or online course?

What language are classes taught in?

Will I get a certificate?

Is job assistance included?

Do I need coding experience for this course?

What tools will I learn?

Ready to Start Your Data Analytics Career?

Master Data Analytics
with Live Instructor-Led Training