Launch OfferYearly ₹8,999 ₹5,999 · Quarterly ₹4,999 ₹2,999Code · till 30 Nov 2026Claim offer →
+91 95189 33742 · WhatsApp Request a call back·Student help desk
Data Analytics

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.

Beginner → Intermediate8 topicsLive + recordedIncluded in membership

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.

  1. 01 Excel FundamentalsFormulas and references · Sorting and filtering · Conditional formatting · Basic charts→
  2. 02 Advanced ExcelVLOOKUP, XLOOKUP, INDEX-MATCH · Pivot tables · IF, COUNTIFS, SUMIFS · Data validation→
  3. 03 Data Cleaning & ProcessingRemoving duplicates · Handling blanks and errors · Text functions · Power Query basics→
  4. 04 SQL BasicsSELECT, WHERE, ORDER BY · Filtering and operators · Creating tables · Inserting and updating data→
  5. 05 SQL Joins, Grouping & SubqueriesINNER, LEFT, RIGHT joins · GROUP BY and HAVING · Subqueries · Common SQL interview questions→
  6. 06 Power BIImporting and transforming data · Data modelling · Visuals and slicers · Publishing reports→
  7. 07 DAX BasicsMeasures vs calculated columns · SUM, CALCULATE, FILTER · Time intelligence intro · KPIs→
  8. 08 Dashboards & Business ReportingDashboard design principles · Choosing KPIs · Storytelling with data · Analytics project→

How you'll learn

MonLive Classes
TueLive Classes
WedLive Classes
ThuLive Classes
FriLive Classes
SatDoubt-Solving
SunTests & Assessments

Missed a class? Watch the recording.

Every live class is recorded for revision during your membership validity.

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 included

Frequently 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.

CodeMBS Membership

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.

Join Yearly · ₹5,999 Launch Offer · use code LAUNCH · till 30 Nov 2026 Compare plans →
Launch Offer · Yearly₹8,999 ₹5,999
Join now