Power BI: from data to dashboards

This course is run on demand: in a virtual classroom or at your premises, on dates that suit you. Ask us for the next dates or a quote for your team.

Power BI replaces hours of manual reporting with automatically refreshed dashboards. You build a complete report step by step: connecting to sources, cleaning, modelling, KPIs, visuals and sharing, while applying readability best practice.

• Import and transform data with Power Query
• Build a star-schema data model
• Create measures with DAX
• Design readable, interactive visuals
• Publish, share and refresh reports

• Management controllers, analysts, reporting managers
• Managers who track KPIs
• Advanced Excel users

Good Excel skills (tables, common formulas, pivot tables).

1. Day 1

   Preparing data

   • –Connecting to sources: Excel, CSV, databases, web
   • –Power Query: clean, merge, append
   • –Data preparation best practice

2. Day 2

   Modelling and calculating

   • –Relationships and star schema
   • –Calculated columns and measures
   • –Essential DAX: CALCULATE, filters, time intelligence

3. Day 3

   Visualising and sharing

   • –Choosing the right visual
   • –Filters, slicers and navigation
   • –Publishing, sharing and refreshing

Build a complete dashboard, on your own data if you wish. Groups of up to 10 participants, in a virtual classroom or at your premises, with a practitioner trainer. For 30 days after the course, you can email your questions to the trainer.

• Power BI file of the running case
• DAX cheat sheet
• Dashboard design guide

Initial assessment, hands-on exercises and a final quiz. Certificate of attendance; Onarcle certificate of achievement from a 70% score on the final quiz.

Public course price per participant, materials included. In-company (up to 10 participants, programme tailored to your needs): €4,190 excl. VAT per group. 10% discount from 3 participants from the same organisation. If your employer or a funding body will pay, contact us and we will find the right arrangement.