Course Content
Introduction to Data Analytics
0/7
What is Data Analytics? Types: Descriptive, Diagnostic, Predictive, Prescriptive
Metrics & KPIs
Types of Data (Structured, Unstructured)
Introduction to Data Visualization
Exploratory Data Analysis (EDA) Basics
Case Study: Hopscotch
Data Analytics Quiz
Excel for Data Cleaning & Formatting
0/6
Excel UI, rows/columns/cells, keyboard shortcuts
Formatting & Cleaning Techniques
Data Protection & Validation
Removing Duplicates, Handling Nulls
Case Studies: Snapdeal, Indigo Airlines
Excel for Data Quiz
Excel for Analysis
0/7
Lookup (VLOOKUP, HLOOKUP, XLOOKUP)
Merging Techniques
Pivot Tables & Grouping
Conditional Formatting
Scenario Analysis (What-if, Goal Seek)
Case Studies: IMDB, Indigo Airlines
Excel for Analysis Quiz
Excel Dashboards
0/6
Charts and Data Visualization Techniques
Dashboard Design Principles
Interactive Charts with Slicers
Pivot Charts & Dashboards
Case Studies: Starbucks, Indigo Airlines
Excel Dashboards Quiz
SQL Basics
0/6
Introduction to Relational Databases
SQL Syntax: SELECT, WHERE, ORDER BY
Data Types, Operators, Functions
Aggregations, GROUP BY, HAVING
Case Study: Amazon
SQL Basics Quiz
SQL Joins & Subqueries
0/5
INNER, LEFT, RIGHT, FULL Joins
CASE Statements, Date-Time Functions
Subqueries (Single & Correlated)
Case Studies: Amazon, IPL Analytics
SQL Joins & Subqueries Quiz
Advanced SQL
0/4
Window Functions (RANK, DENSE_RANK, LEAD, LAG)
Common Table Expressions (CTE
SET Operators (UNION, INTERSECT, EXCEPT)
Case Studies: Airbnb, Razorpay Payroll
Data Preparation & EDA
0/6
Tableau Installation and Setup
Loading & Cleaning Data
Aggregations & Logical Functions
Filters and Analytics Pane
Case Studies: Zomato, Swiggy
Data Preparation & EDA Quiz
Tableau – Dashboards & Stories
0/5
Chart Types (Bar, Line, Scatter, Maps, etc.)
LOD Expressions, Calculated Fields
Dashboard Actions, Parameters, Story Boards
Case Studies: NextLeap, Swiggy
Tableau Quiz
Python Basics
0/6
Python Setup (Jupyter/VS Code)
Data Types, Variables
Strings, Lists, Sets, Tuples
Input/Output and Type Casting
Case Studies: Adidas, NextLeap
Python Basics Quiz
Python Programming
0/5
Dictionaries
If-else, Loops, Control Flow
Functions and Modules
Error Handling
Case Studies: Tinder, Adidas
Python for Data Analysis
0/5
NumPy Arrays, Math Functions
Pandas Series, DataFrames
Data Cleaning, Filtering, Sorting
EDA and CDA with Pandas
Case Studies: Cult.Fit, Zomato
Data Visualization in Python
0/5
Matplotlib Basics
Seaborn for Statistical Plots
Plotly for Interactive Graphs
Choosing the Right Chart
Case Studies: YouTube, Zomato
Applied Statistics for Analytics
0/5
Descriptive vs Inferential Stats
Z-score, Central Limit Theorem
Hypothesis Testing (t-test, p-value)
Power Analysis & Confidence Intervals
Case Studies: Uber Ratings, Food Delivery Apps
AWS for Data Analytics
0/6
Data Collection (Kinesis, Snowball, DMS)
Data Storage (S3, RDS, Redshift)
Processing (Lambda, Glue, EMR)
Visualization using QuickSight
Data Pipeline Security & Encryption
Case Studies: Climate Data, Stock Market Analytics
Final Projects & Interview Preparation
0/4
Capstone Projects
Resume Building for Data Analysts
Portfolio Creation (GitHub + Tableau Public)
Mock Interviews and Graduation Test
🎁 Bonus Modules (Integrated Throughout)
Database Design with SQL
0/2
Schema Design, Normalization & Denormalization
Views, Indexing, Primary & Foreign Keys
Data Storytelling
0/3
Visual Design Principles
Insight-to-Action Narratives
Trend Spotting and Communication
Git + GitHub
0/2
Version Control Basics
Publishing Portfolio Projects
Data Analytics 
Case Studies: Adidas, NextLeap


Studying how real companies use Python helps students see the practical value of basic programming skills. Let’s explore how Adidas and NextLeap apply Python fundamentals like data types, input/output, conditionals, loops, and data structures.

Case Study 1: Adidas – Analyzing Product Reviews

Problem: Adidas collects thousands of product reviews online and needs a way to analyze the feedback.

 

Python Concepts Used:

 

  • String Handling – for cleaning review texts
  • Lists – to store and process batches of reviews
  • Loops – to go through each review
  • Conditional Statements – to detect positive or negative sentiment

Case Study 2: NextLeap – Managing Student Feedback

Problem: NextLeap collects feedback from learners after each module and wants to summarize it for mentors.


Python Concepts Used:

  • Dictionaries – to store student scores or feedback
  • Input/Output – to allow users to enter their ratings
  • Loops & Aggregation – to calculate average ratings
Previous
Next
0% Complete
Get SDE Ready

Learning often happens in classrooms
but it doesn’t have to.

+91-9773728034
[email protected]
WhatsApp Icon
close menu icon

Hi Instagram Fam!
Get a FREE Cheat Sheet on System Design.

close menu icon

Hi LinkedIn Fam!
Get a FREE Cheat Sheet on System Design

close menu icon

Loved Our YouTube Videos? Get a FREE Cheat Sheet on System Design.