Data Analyst Course
Practical projects • Interview prep • Lifetime access
Time left to enroll — 15:00
Master Excel, SQL & Power BI
Real datasets • 1:1 mentorship • Interview questions — get job-ready.
📚 30+ Hours
Detailed video lessons & walkthroughs
❓ 100+ Interview Questions
Curated with solutions & approach
💻 11+ Real Projects
Hands-on datasets & step-by-step solutions
📂 Raw files & templates
Downloadable practice files
👨🏫 1:1 Mentorship
Personal doubt-solving sessions
🎯 Job Guidance
Resume, interview tips & mock interviews
♾ Lifetime Access
Course updates included
🎖 Verified Certificate
Shareable credential after completion
Complete Curriculum (detailed)
Excel Module — Foundations → Advanced
🔒
01. Introduction to Excel UI & Navigation
🔒
02. Cell Referencing & Absolute/Relative ($)
🔒
03. Data Entry, Formatting & Shortcuts
🔒
04. Basic Functions — SUM, AVERAGE, COUNT
🔒
05. Logical Functions — IF, AND, OR, NOT
🔒
06. LOOKUPs — VLOOKUP & HLOOKUP
🔒
07. INDEX & MATCH (Advanced Lookups)
🔒
08. Text Functions — LEFT, RIGHT, MID, CONCAT, TRIM
🔒
09. Date & Time Functions
🔒
10. COUNTIF, COUNTIFS, SUMIF, SUMIFS
🔒
11. Conditional Formatting & Data Validation
🔒
12. Pivot Tables — Build & Analyze
🔒
13. Pivot Charts & Slicers
🔒
14. Advanced Formulas — Dynamic Arrays & SEQUENCE
🔒
15. Lookup Patterns & Error Handling
🔒
16. Charts — Best Practices & Customization
🔒
17. What-if Analysis — Goal Seek & Data Tables
🔒
18. Power Query Intro — Get & Transform
🔒
19. Basic Macros & Automation (Recording)
🔒
20. Excel Project — End-to-end Dashboard
SQL Module — Core → Advanced
🔒
01. Intro to Databases & SELECT basics
🔒
02. Filtering — WHERE, boolean logic
🔒
03. ORDER BY, LIMIT, DISTINCT
🔒
04. Aggregations — GROUP BY & HAVING
🔒
05. JOINs — INNER / LEFT / RIGHT / FULL
🔒
06. Subqueries & Derived Tables
🔒
07. Window Functions — ROW_NUMBER, RANK
🔒
08. CTEs & Recursive Queries
🔒
09. Performance — Indexes & EXPLAIN
🔒
10. Data Cleaning in SQL — string/date ops
🔒
11. SQL Projects — Interview-style problems
🔒
12. Advanced Patterns & Optimization
Power BI Module — Desktop → Dashboards
🔒
01. Power BI Desktop Setup & Interface
🔒
02. Data Sources & Connections
🔒
03. Power Query — transforms & M basics
🔒
04. Data Modeling — relationships & star schema
🔒
05. DAX Basics — calculated columns & measures
🔒
06. DAX Advanced — time intelligence
🔒
07. Visuals & Interactions
🔒
08. Storytelling & Dashboard Layout
🔒
09. Power BI Service — Publish & Share
🔒
10. Row-level Security & governance
🔒
11. Power BI Project — Sales dashboard walkthrough
🔒
12. Optimization, Tips & Best Practices
Rahul Khanna
Senior Data Analyst & Mentor
5+ years experience working with product & consulting teams. Expert in Excel, SQL, Power BI & Python. Mentored 2000+ students — focuses on practical, job-ready projects, interview prep.
What you’ll get from the instructor:
- Practical project walkthroughs
- Resume & interview feedback
- Real World Interview Questions
Frequently Asked Questions
Do I need prior experience?
No — we start from basics and move to advanced with projects.
Will I get a certificate?
Yes — verified certificate after project completion.
How long do I have access?
Lifetime access with updates.
Refund policy?
7-day refund policy if not satisfied.