Data Analytics (Excel, SQL & Power BI)
Learn the practical analytics toolkit — Excel, SQL and Power BI — and work with real datasets to clean data, write queries and build dashboards.
Who this course is for
- Engineering, BSc, BCS, BCA and MBA aspirants
- Students interested in analyst roles
- Beginners — no coding required to start
What you'll be able to do
- Clean and analyse data in Excel
- Write SQL queries for reporting
- Build interactive Power BI dashboards
- Present insights clearly
Syllabus & topics covered
Click any topic to see what it covers.
- 01 Excel FundamentalsFormulas and references · Sorting and filtering · Conditional formatting · Basic charts→
- 02 Advanced ExcelVLOOKUP, XLOOKUP, INDEX-MATCH · Pivot tables · IF, COUNTIFS, SUMIFS · Data validation→
- 03 Data Cleaning & ProcessingRemoving duplicates · Handling blanks and errors · Text functions · Power Query basics→
- 04 SQL BasicsSELECT, WHERE, ORDER BY · Filtering and operators · Creating tables · Inserting and updating data→
- 05 SQL Joins, Grouping & SubqueriesINNER, LEFT, RIGHT joins · GROUP BY and HAVING · Subqueries · Common SQL interview questions→
- 06 Power BIImporting and transforming data · Data modelling · Visuals and slicers · Publishing reports→
- 07 DAX BasicsMeasures vs calculated columns · SUM, CALCULATE, FILTER · Time intelligence intro · KPIs→
- 08 Dashboards & Business ReportingDashboard design principles · Choosing KPIs · Storytelling with data · Analytics project→
How you'll learn
One membership, many courses
This course is part of the Data Analytics track. With a CodeMBS membership you also get access to the other learning tracks — programming, Python, data science, analytics, aptitude, DSA and placement preparation.
See what's includedFrequently asked questions
Is Data Analytics (Excel, SQL & Power BI) taught live?
Yes. Classes are live and instructor-led as per the timetable, and every class is recorded for revision.
Do I need any prior knowledge?
The level for this course is Beginner → Intermediate. Beginners can start with the Programming Fundamentals track.
How do I clear my doubts?
Ask during live classes, attend the Saturday doubt-solving session, or use the Student Help Desk.
Is this course included in the membership?
Yes. It is included in both the Yearly and Quarterly memberships along with the other learning tracks.
Also included in your membership
C Programming
The language that teaches you how computers really work.
View course →Included in membershipC++ Programming
Object-oriented programming and the language of competitive coding.
View course →Included in membershipPython Programming
The most beginner-friendly language — and the gateway to data science and AI.
View course →Learn Data Analytics (Excel, SQL & Power BI) live — plus every other track.
Live classes Monday to Friday, Saturday doubt-solving, Sunday tests and recordings for revision — across programming, Python, data science, analytics, aptitude, DSA and placement prep.
