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

Power BI Dashboards from Zero

Import, clean, model and visualise data in Power BI Desktop and build two portfolio-ready dashboards

Ghosla Academy · Data Team

Power BI is one of the most requested tools in Indian analyst and MIS job descriptions. This course starts from absolute zero: installing the free Power BI Desktop, understanding what a dashboard is for, and importing your first Excel or CSV file. You then learn the three skills that separate good dashboards from messy ones: cleaning data in Power Query, building a star-schema model with a date table, and writing DAX measures. Every idea is taught with India-relevant examples such as a retail chain's sales across cities, GST-inclusive prices and April–March financial years. Two hands-on projects, a sales dashboard and an HR attrition dashboard, give you portfolio pieces you can show in interviews. Explanations are in simple English with a little Hinglish.

What you will be able to do

  • Plan a dashboard around clear business questions, KPIs and audience
  • Import Excel and CSV data and clean it with Power Query: types, splits, unpivot, merge and append
  • Build a star-schema data model with correct relationships and a proper date table
  • Write DAX measures with SUM, DIVIDE, CALCULATE and time intelligence such as YTD and month-on-month growth
  • Design clean, readable report pages with the right visuals, slicers, drill-through and tooltips
  • Understand publishing, sharing and licence options, and present dashboards in a portfolio

What you build

  • Monthly sales dashboard for a multi-city retail chain with YTD and growth KPIs
  • HR attrition dashboard with drill-through and tooltips as a portfolio piece

What you need to start

  • A Windows 10/11 laptop for Power BI Desktop (Mac users need a Windows virtual machine or cloud PC)
  • Basic Excel comfort: rows, columns, simple formulas; no coding needed

Curriculum · 5 sections, 22 lectures

Getting Started with Power BI4 lectures
  1. What Power BI Is and How a Dashboard Gets BuiltFree preview11 min
  2. Installing Power BI Desktop and a Tour of the InterfaceFree preview12 min
  3. Planning a Dashboard: Questions, KPIs and Audience10 min
  4. Quiz: Getting Started6 min
Getting and Cleaning Data with Power Query4 lectures
  1. Importing Excel and CSV Files12 min
  2. Power Query Cleaning: Types, Splits, Unpivot and Merge15 min
  3. Applied Steps and Refresh: Why Power Query Is Repeatable10 min
  4. Quiz: Power Query7 min
Data Modelling4 lectures
  1. Star Schema: Fact and Dimension Tables14 min
  2. Relationships, Cardinality and Filter Direction12 min
  3. Building a Date Table12 min
  4. Quiz: Data Modelling7 min
DAX Essentials5 lectures
  1. Measures vs Calculated Columns14 min
  2. CALCULATE and Filter Context15 min
  3. Time Intelligence: YTD, Previous Month and Growth %12 min
  4. Project: Sales Dashboard for a Multi-City Retail Chain20 min
  5. Quiz: DAX Essentials7 min
Visuals, Interactivity and Sharing5 lectures
  1. Choosing the Right Visual and Designing a Clean Layout13 min
  2. Slicers, Drill-Through and Tooltips11 min
  3. Publishing and Sharing: Service, Licences and Alternatives11 min
  4. Project: HR Attrition Dashboard Portfolio Piece20 min
  5. Quiz: Visuals and Sharing7 min

Who this is for

  • Students and freshers aiming for data analyst, MIS executive or business analyst roles
  • Excel users who want interactive dashboards instead of static reports
  • Small business owners and team leads who want to track sales or operations visually