Serving schools, colleges & students across India Sign inRegister freeFAQsHelpcontact@ghosla.io
GHOSLAGrowth Hub for Opportunities, Skills, Learning & AchievementGrow•Learn•Achieve Login Get Started

Solutions (For Institutions)

School ERPComplete school management College ERPComplete college management University ERPUniversity-wide management Coaching Classes ERPCoaching institute management

For Students

Ghosla AIAI-powered education & career assistant AI Career TestFind the careers that fit you Education LoansPlan, apply & track your loan Skills & CertificationsFree courses, Skill Score, certificates All 103 CoursesJob-ready courses, free right now Find Better SchoolsDiscover the right school for you Find Better CollegesDiscover the right college for you

Discover

Browse by City66 cities across India

Excel to Power BI: Data Analyst Job Track

Clean data, build pivot reports and publish interactive Power BI dashboards employers ask for

Ghosla Academy · Data Team

Most analyst jobs in India start with Excel and move to Power BI. This track covers both in order: first reliable spreadsheet skills and pivot reporting, then data modelling, DAX and dashboard design. Projects use realistic business data such as branch-wise sales, GST categories and HR records, and the final dashboards are portfolio pieces you can discuss in interviews.

What you will be able to do

  • Use Excel formulas: XLOOKUP, IF, SUMIFS, text and date functions
  • Clean and reshape data with Power Query
  • Summarise data with pivot tables and charts
  • Model data with relationships and a star schema in Power BI
  • Write DAX measures such as totals, ratios and time intelligence
  • Design and share dashboards that answer business questions

What you build

  • Monthly sales MIS report in Excel
  • GST-wise sales dashboard in Power BI
  • HR attrition dashboard with DAX measures

What you need to start

  • A Windows laptop (Power BI Desktop is Windows-only)
  • Microsoft Excel 2019/365 or the free web version for practice

Curriculum · 7 sections, 26 lectures

Excel essentials5 lectures
  1. The analyst workflowFree preview8 min
  2. Tables, formatting and data validationFree preview12 min
  3. Logical and lookup functions14 min
  4. SUMIFS, COUNTIFS and date functions14 min
  5. Quiz: formulas5 min
Data cleaning4 lectures
  1. Text functions and Flash Fill12 min
  2. Power Query in Excel15 min
  3. Removing duplicates and errors12 min
  4. Data cleaning checklist10 min
Pivot tables and reporting3 lectures
  1. Pivot tables step by step14 min
  2. Pivot charts and slicers12 min
  3. Project: monthly sales MIS report20 min
Power BI basics4 lectures
  1. Power BI Desktop tour10 min
  2. Importing and transforming data14 min
  3. Relationships and star schema15 min
  4. Quiz: data modelling6 min
DAX4 lectures
  1. Calculated columns vs measures14 min
  2. CALCULATE and filter context16 min
  3. Time intelligence: MTD, YTD, previous year15 min
  4. Common DAX mistakes12 min
Dashboard design3 lectures
  1. Choosing the right visual14 min
  2. Layout, colour and drill-through12 min
  3. Project: GST-wise sales dashboard22 min
Publishing and job prep3 lectures
  1. Publishing to Power BI Service12 min
  2. Project: HR attrition dashboard24 min
  3. Analyst resume and interview tips10 min

Who this is for

  • Graduates targeting MIS executive and data analyst roles
  • Commerce, BBA and B.Com students
  • Working professionals who prepare reports in Excel