Power BI – introduction (2-day workshop for beginners and those already using Power BI)

A two-day workshop

This course teaches you how to use Power BI but goes beyond just the basics. You will learn about different views of Power BI: Report View, where visualisations are created; Table View, where calculations can be made; Model View, where data model relationships are accessed; and Power Query Editor, where data is shaped and cleaned. Additionally, you will learn how to share your reports using the Power BI service.

The course also provides tools to connect to and transform data from different sources to create reports using various visualisations such as interactive maps and charts. You will learn to write calculations using M formulas in Power Query Editor and DAX in Report View to enhance your reports. The course aims to equip you with the skills you need to use Power BI in building reports.

Learning objectives

The aim of this course is to provide an introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away.

Pre-requisites

The assumption is that you are a regular Excel user, and should be able to write simple formulas, create basic charts, and know what a pivot table is.

Format

A very practical, interactive two-day session for a maximum group size of 8. Comprehensive materials provided, including exercise files and a unique step-by-step guide developed by the trainer specifically for this programme.

This course can be run remotely online or face-to-face onsite.

Expert trainer

Alan became a professional IT trainer in 1995, when on completion of an NVQ accreditation in IT, the organisation providing the course, Apex North London, asked if he would like to join their team, which he happily did. Alan went on to become a City & Guilds Assessor with them.

Alan now freelances and almost exclusively specialises in analytics using Microsoft Power BI as a platform, however he still provide clients with Excel training when requested to. His previous 25+ years within this sector includes both freelancing, and full time employment at various companies including, Lead Trainer at Go Courses, and Training Manager at Ultima Concepts.

See what some of the participants have said about the workshops he’s delivered for us:

‘Fantastic. Well-paced and easy to follow.’
‘Great experience.’
‘Very personable, relatable, patient and able to present complicated processes in an understandable way.’
‘Friendly and good at checking people are up to speed.’
‘Very good and explained and answered all questions.’
‘Explains everything well.’
‘Excellent teacher and very intelligent.’
‘Very knowledgeable would love to have him again if there is another course – thank you.’
‘Alan explains things very clearly and addresses issues on questions before they are visible. Thank you very much!’

1 Getting started

  • The Power BI ecosystem
  • The Power BI service licence
  • The Backstage view
  • Power BI’s four views
  • Dashboards introduced

2 Importing files

  • The process of importing files
  • Importing an Excel file
  • Importing a CSV file
  • Importing data from the web
  • Importing a folder of files
  • Methods of connecting to data
  • Managing imported file

3 Clean data in Power Query

  • The process of cleaning data
  • Power Queries’ applied steps
  • Managing data types

4 Transforming data

  • Add a Custom Column
  • Appending tables together
  • Hiding queries in reports
  • Fixing data error issues
  • Basic maths operations

5 The data model

  • Table relationships
  • Relationship properties

6 Merge queries

  • Merging tables

7 Dashboard visualisations

  • What is data storytelling
  • Inserting an formatting maps
  • Inserting and formatting charts
  • Inserting a tree map
  • Insert a table, matrix, and card
  • Inserting images and text boxes
  • Highlighting key points
  • Filter reports with slicers

8 Publish and share reports

  • Publishing to Power BI service
  • Editing online reports
  • Pinning visuals to a dashboard
  • How to use Q&A
  • Sharing dashboards
  • Exporting reports to PowerPoint
  • Exporting reports as a PDF file

9 Power Query expanded

  • Filling gaps in data
  • Split column by delimiter
  • Add a conditional column
  • More on custom columns
  • Merging columns

10 The M functions

  • Insert a Text function
  • Insert an IF function

11 Pivoting tables

  • Pivot a table
  • Pivot and append tables
  • Pivot but don’t aggregate values

12 Data modelling expanded

  • How table relationships work
  • Marking a table for dates

13 DAX new columns

  • What are DAX functions?
  • New columns and measures
  • New column calculations
  • Insert a SWITCH function

14 DAX measures

  • Common measure functions
  • Insert a SUM function
  • Adding measure to visuals
  • Insert a COUNTROWS function
  • Insert a DISTINCTCOUNT function
  • DAX rules

15 The CALCULATE measure

  • The syntax of CALCULATE
  • Insert a CALCULATE function
  • Control field summarisation
  • Syncing slicers across report pages
  • Things of note

16 The SUMX measure

  • X iterator functions
  • Insert a DIVIDE function
  • Anatomy of SUMX
  • Insert a SUMX function
  • When to use X functions

17 Time intelligence measures

  • Importance of a calendar table
  • Insert a TOTALYTD function
  • Change financial year end date
  • Viewing time intelligence in charts

18 Hierarchies and groups

  • Drill down into data using hierarchies
  • Compare sets of data in groups

Any questions? Please just give us a call on 01582 463463 – we’re here to help!