Tell us what you'd like to learn

Takes under a minute. Our team will call or WhatsApp you with upcoming batch dates that suit your schedule.

About you
What are you interested in?
About this course · 32 hours

Learn to turn raw data into clear, interactive dashboards and reports with Microsoft Power BI. You connect to data, clean and model it, write DAX measures, design visuals that tell a story, and publish and share reports with your team. Built around real business scenarios, and suitable for analysts, finance and operations professionals and anyone who works with spreadsheets and wants to go further.

Course content
  1. Introduction to data analytics and Power BI
    • The analytics workflow and where Power BI fits
    • Power BI Desktop, the Service and the report canvas
    • Types of data and choosing the right chart
  2. Getting and preparing data
    • Connecting to Excel, CSV, databases and web sources
    • Power Query: cleaning, transforming, merging and appending
    • Handling errors, data types and dates
  3. Data modelling
    • Fact and dimension tables; the star schema
    • Relationships, cardinality and filter direction
    • Building a date table
  4. DAX fundamentals
    • Calculated columns versus measures
    • CALCULATE, filter context and common functions
    • Time intelligence: year to date, previous period and growth
  5. Report design and visualisation
    • Charts, tables, matrices, maps and cards
    • Slicers, filters, drill-through and bookmarks
    • Layout, colour and storytelling with data
  6. Power BI Service and sharing
    • Publishing, workspaces and apps
    • Scheduled refresh and gateways (overview)
    • Sharing, permissions and row-level security basics
  7. Analytics case study
    • End to end: from raw files to a published dashboard for a business scenario
  8. Capstone project
    • Build, present and defend a dashboard on a dataset of your choice
Weekday = Mon–Fri · Weekend = Sat/Sun