Online course · 42% off today

Data Analytics

Name: Data Analytics
Price: 699 INR
Availability: InStock

Learn Excel, statistics, SQL, Power BI and Python by solving real Indian business problems, from your first spreadsheet to job-ready projects

ACreated byAditya English 45 Lessons 19:14:23 Hours Certificate

About course

Every company in India now runs on data: quick-commerce apps, banks, retailers and startups all need people who can turn numbers into decisions. Data analytics is one of the most useful skills you can learn, whatever your degree.

This course takes you from zero to job-ready across six modules: analytics foundations, Excel and Google Sheets, statistics for analysts, SQL, Power BI and data storytelling, and Python with forecasting and customer segmentation. You also learn to use AI tools responsibly and what India’s DPDP Act means for analysts.

You learn by doing. You follow Meera, a fresher analyst at a fast-growing grocery delivery company, through real problems with real tools. Two hands-on live projects take you from messy raw data to clear recommendations, and every module comes with summary notes and a practical self-assessment task.

You get 43 lectures plus 2 live projects (about 19 hours of video), 6 module notes, 6 self-assessment tasks and practice datasets. You earn a certificate at 80% completion and a letter of recommendation at 100%.

Overview

What you'll learn

Turn vague business questions into clear, measurable analysis plans

Clean messy data and build dashboards in Excel and Sheets

Use statistics and A/B tests to make confident decisions

Write SQL with joins, CTEs and window functions

Build Power BI dashboards with data models and DAX measures

Analyse data with Python, pandas and clear charts

Forecast trends and segment customers using RFM and k-means

Present findings as short, answer-first stories for managers

Curriculum

45 Lessons · 19:14:23 Hours

What is Data Analytics & Why It Matters in India00:19:16
The 4 Types of Analytics00:17:05
The Data Analytics Lifecycle00:16:53
Understanding Data: Types & Sources00:21:57
Thinking Like an Analyst: Questions, Metrics & KPIs00:21:55
The Analyst’s Toolkit & Career Roadmap in India 200:18:33
Swiftbasket orders sampleFile
Notes Foundations of Data AnalyticsNotes
Self Assessment Turn a Vague Request into an Analysis PlanTask

Spreadsheet Essentials: Tables, Sort, Filter & Formatting00:22:20
Must-Know Formulas: SUMIFS, COUNTIFS, IF, Text & Dates00:29:24
Lookups: VLOOKUP, XLOOKUP & INDEX-MATCH00:25:13
Cleaning Messy Data: Duplicates, TRIM & Power Query 200:36:01
Pivot Tables & Pivot Charts 200:30:20
Choosing the Right Chart 100:24:32
Project: SwiftBasket Sales Dashboard 200:31:12
Swiftbasket week1 rawFile
Notes Excel and Google Sheets for AnalysisNotes
Self Assessment Clean and Build a City Dashboard in ExcelTask

Mean, Median, Mode & Why Averages Lie 100:22:07
Probability basics for business decisions 100:23:45
Sampling, surveys & bias 100:22:21
Correlation vs Causation 100:23:12
Hypothesis Testing & A/B Tests 100:31:04
Spread: Range, Standard Deviation & Percentiles 100:24:06
Distributions, the Normal Curve & Outliers 100:24:59
Swiftbasket ab testFile
Swiftbasket orders juneFile
Notes Statistics for AnalystsNotes
Self Assessment Delivery Statistics and an AB Test VerdictTask

Databases & Why SQL 200:20:02
SELECT, WHERE, ORDER BY & LIMIT 100:25:14
GROUP BY & HAVING 100:25:01
JOINs: Combining Tables 100:29:58
Subqueries & CTEs 100:27:55
Window Functions 100:29:54
CASE, Dates & Text Functions 100:25:16
Project: Customer Analysis in SQL 100:29:56
SwiftbasketFile
Notes SQL for Data AnalysisNotes
Self Assessment Answer Business Questions with SQLTask

BI Tools Compared 500:20:24
Power Query 600:27:08
Star Schema 800:27:23
DAX 100:32:43
Dashboard Design 200:25:01
Storytelling 100:22:07
Project: City Ops Dashboard 100:30:12
Swiftbasket modelFile
Project qa queriesProject
Self Assessment Build a Store Manager Dashboard in Power BITask
Notes Power BI and Data StorytellingNotes

Python Basics 100:27:23
pandas 300:31:43
EDA & Charts 200:31:36
Regression & Forecasting 200:30:58
RFM & Clustering 200:28:53
AI for Analysts & the DPDP Act 100:26:23
Capstone 500:32:10
Portfolio & Interviews 300:25:52
Swiftbasket customersFile
Swiftbasket ordersFile
Notes Python AI and Advanced AnalyticsNotes
Self Assessment Python Analysis Payment Methods and CustomersTask

Live Project 1: Festive Sale Analysis (Python) 100:18:13
Live Project 2: Ride Cancellations in SQL 300:16:43

Video LecturesWatch & rewatch anytime

Best Interactive ContentQuizzes and activities that stick

GuidanceAsk doubts, get expert answers

Why learn Data Analytics?

Every industry in India now hires people with data skills

Analysts move into high-growth roles in product, business and AI

Data skills make your decisions faster and more convincing

One skill set works across sales, marketing, finance and operations

AI tools need people who can check and question numbers

Strong portfolio projects help freshers stand out in interviews

You can start from any degree with no coding background

Who this course is for:

College students planning a career in data analytics

Freshers preparing for data or MIS analyst roles

Working professionals who want to make better data-driven decisions

Excel users ready to move into SQL and Power BI

Commerce, engineering and arts graduates switching to tech roles

Founders and freelancers who want to understand their business numbers

Anyone curious about turning data into decisions