Beginner
Certified Industry Program
Data Analytics
A basic-to-advanced analytics program focused on turning raw data into useful business insights and dashboards.
Duration
3 Months
Regular Batch
2 hours/day (Monday–Saturday)
Weekend Batch
3 hours/class (Saturday–Sunday)
Course Fee
INR 20,000.00
Course Overview
Data Analytics is a comprehensive 3-month program designed to take learners from foundational spreadsheet analysis to advanced SQL querying, statistical modeling, Python data manipulation with Pandas, interactive Power BI dashboards, and AI-accelerated business analytics.
What You Will Learn (Learning Outcomes)
Clean, analyze and summarize business data.
Use Excel, SQL, Python and BI concepts for analytics.
Build clear dashboards and data stories.
Use AI responsibly to accelerate analysis and reporting.
Course Modules & Detailed Syllabus
7 Modules • 34 Classes / Topics
01
Module 1 – Data Analytics Foundations
4 Topics / Classes-
What is data analytics and how businesses use data
-
Types of data and analytics
-
Data collection, cleaning and preparation basics
-
Understanding KPIs, metrics and business questions
02
Module 2 – Excel for Analytics
5 Topics / Classes-
Excel fundamentals for data work
-
Formulas and logical functions
-
Lookup functions and data cleaning
-
Pivot tables and pivot charts
-
Conditional formatting and dashboard basics
03
Module 3 – SQL for Data Analysis
5 Topics / Classes-
Database and table fundamentals
-
SELECT, WHERE, ORDER BY and filtering
-
Aggregate functions and GROUP BY
-
JOIN concepts
-
Subqueries and practical business queries
04
Module 4 – Statistics for Analysts
5 Topics / Classes-
Mean, median, mode and spread
-
Percentage, ratios and growth calculations
-
Correlation and basic probability concepts
-
Sampling and basic interpretation of trends
-
Using statistics for business decisions
05
Module 5 – Python for Data Analysis
6 Topics / Classes-
Python basics for analysts
-
Working with data using Pandas
-
Cleaning and transforming datasets
-
Basic NumPy concepts
-
Exploratory data analysis
-
Data visualization basics
06
Module 6 – BI & Dashboarding
5 Topics / Classes-
Power BI fundamentals
-
Data import and transformation basics
-
Data modeling concepts
-
Visuals, filters and interactive dashboards
-
Business dashboard design and storytelling with data
07
Module 7 – AI-Assisted Analytics & Projects
4 Topics / Classes-
Using AI to explain formulas, SQL and analysis
-
AI-assisted data cleaning and insight generation
-
Creating summaries and business reports
-
End-to-end analytics project using a practical dataset
Batch Timings & Fee Structure
| Batch Type | Schedule & Timing | Program Fee | Action |
|---|---|---|---|
| Regular Batch | 2 hours/day (Monday–Saturday) | INR 20,000.00 | Enroll Now |
| Weekend Batch | 3 hours/class (Saturday–Sunday) | INR 20,000.00 | Enroll Now |
Flexible installment and EMI options available upon academic counselling request.