Data Analytics 2025 - Parikh
Jain (Sample View)
Hello and welcome! I'm Parikh Jain, and I’m excited to present this complete guide
to Data Analytics (DBMS) — built from real-world experience and interview-driven
scenarios.
This kit is based on my journey as an SDE at Amazon, a founding member at
Coding Ninjas, and the founder of ProPeers, where I’ve worked extensively on
data-heavy systems. The goal is to help you go beyond theory and confidently
handle Data Analytics in interviews and real projects.
Section 1: Introduction & Roadmap
What is Data Analytics?
Types of Data Analysts (DA, BI, Product Analyst, etc.)
Skills Required
Tools Overview (Excel, SQL, Python, Tableau/Power BI)
Career Roadmap (Step-by-step plan)
Covered in detail in the full version : [Link]
Section 2: Excel & Google Sheets for Analysts
Basics: Cell references, formulas, formatting
Data Cleaning Techniques
Functions: VLOOKUP, IF, COUNTIF, SUMIFS, INDEX/MATCH
Pivot Tables & Charts
Excel Dashboard Walkthrough
50+ Practice Exercises (with datasets)
Data Analytics 2025 - Parikh Jain (Sample View) 1
Covered in detail in the full version : [Link]
Section 3: SQL for Data Analytics
SQL Basics: SELECT, WHERE, ORDER BY
Joins: INNER, LEFT, RIGHT, FULL
GROUP BY & Aggregates
Subqueries & CTEs
Window Functions
Business Scenarios: 5 Case-Based Problems
100+ Practice SQL Queries
Covered in detail in the full version : [Link]
Section 4: Statistics for Analysts
Descriptive Statistics (mean, median, std deviation)
Probability Concepts
Distributions: Normal, Binomial
Hypothesis Testing
Confidence Intervals & P-values
A/B Testing Framework
20+ STAR-format Interview Qs with Business Context
Covered in detail in the full version : [Link]
Section 5: Python for Data Analysis
Intro to Pandas & NumPy
Data Cleaning & Preprocessing
Data Aggregation, Filtering, Grouping
Visualization using Matplotlib & Seaborn
Data Analytics 2025 - Parikh Jain (Sample View) 2
2 Case-Based Assignments
20+ Practice Exercises (with code solutions)
Covered in detail in the full version : [Link]
Section 6: Data Visualization (Tableau / Power BI)
Principles of Good Visualization
Bar, Line, Pie, Donut, Funnel, Heatmaps
Filters, Parameters, Drilldowns
Building Dashboards (step-by-step screenshots)
3 Mini Projects with Storytelling
Covered in detail in the full version : [Link]
Section 7: Business Problem Solving
Cohort Analysis
Funnel & Conversion Metrics
Revenue Analysis
Retention & Churn
Customer Lifetime Value (LTV)
ROI & Marketing Performance
5 Business Case Studies (with datasets + solutions)
Covered in detail in the full version : [Link]
Section 8: Interview Kit
100+ Interview Questions (DA, BI, Product Analyst)
STAR-Format Answers with Business Scenarios
Case-Based Estimation Questions
Portfolio & Resume Guide
Data Analytics 2025 - Parikh Jain (Sample View) 3
Mock Interview Templates
Covered in detail in the full version : [Link]
Section 9: Capstone Projects
E-Commerce User Funnel Analysis (SQL + Excel + Dashboard)
Marketing ROI Tracker (Stats + Excel)
User Retention Case Study (Python + Tableau)
Final Submission Guidelines
Covered in detail in the full version : [Link]
Section 10: Bonus Add-ons
Cheatsheets (Excel, SQL, Python, Stats)
Downloadable Practice Datasets
Career Roadmap Infographic (PDF)
Assignment Tracker Template
Covered in detail in the full version : [Link]
Sample Interview Question (SQL + Business Insight)
Q: Tell me about a time you used SQL to solve a business problem or identify a
hidden [Link] Format Answer
S – Situation
At my previous internship, the product team was concerned about a drop in user
engagement on our platform. They wanted to understand whether this drop was
due to a technical issue, seasonal behavior, or a specific user segment churning.
T – Task
I was tasked with analyzing user login and activity patterns using our PostgreSQL
database to:
Data Analytics 2025 - Parikh Jain (Sample View) 4
Identify which user cohorts had declined in engagement
Pinpoint any sudden behavioral changes across time
A – Action
I wrote SQL queries to:
Segment users by acquisition month ( user_created_at )
Calculate weekly active users (WAU) for each cohort
Join this with product usage data to check for drop-offs
sql
SELECT
DATE_TRUNC('week', activity_date) AS week,
DATE_TRUNC('month', u.created_at) AS cohort,
COUNT(DISTINCT a.user_id) AS wau
FROM users u
JOIN activity_log a ON [Link] = a.user_id
WHERE a.activity_date >= NOW() - INTERVAL '3 months'
GROUP BY 1, 2
ORDER BY 1, 2;
From the data, I visualized the WAU trend per cohort in Excel.
R – Result
The analysis showed that users acquired via a specific referral campaign in March
had a 60% drop in engagement in the second month post-acquisition. We later
found they were primarily coupon-based users, leading to short-term usage.
This insight helped the marketing team refine future campaigns to focus on quality
over quantity, increasing Day 30 retention by 12% in the following quarter.
Why this works
Data Analytics 2025 - Parikh Jain (Sample View) 5
Combines SQL + business thinking
Uses data storytelling
Shows impact on retention, a key metric
Can be modified for different industries (e.g., e-commerce, SaaS)
100+ interview questions covered in full version
Covered in detail in the full version : [Link]
Data Analytics 2025 - Parikh Jain (Sample View) 6
