Power BI – Introduction

Power BI – Introduction 2019-05-24T11:00:16+00:00

Power BI – Introduction

Duration: 2 day

Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports.

This course is an introduction to Power BI to get you started on creating a powerful reporting capability.

By the end of the course you will be able to:

  • Import data from multiple data sources
  • Edit and transform data before importing
  • Create reports
  • Create different visualisations
  • Create data models
  • Build data relationships
  • Use the drill down features
  • Create measures
  • Use the Power BI Service
  • Build dashboards
  • Use the mobile app
  • Power BI Desktop
  • Power BI Service
  • Data sources
  • Importing data
  • Editing your data
  • Setting data types
  • Removing columns/rows
  • Choosing columns to keep
  • Setting header rows
  • Splitting columns
  • Columns from example
  • Custom columns
  • Conditional columns
  • Importing folders
  • Setting up and using append queries
  • Creating and saving reports
  • Adding pages
  • Renaming pages
  • Interactivity
  • Refreshing your data
  • Adding chart elements
  • Choosing chart types
  • Setting properties
  • Setting values, axis and legends
  • Using tooltips
  • Visual filters
  • Setting page and report filters
  • Adding table elements
  • Adding maps
  • Working with cards
  • Working with matrices
  • KPIs and Gauges
  • The data model
  • Multiple data tables
  • Building relationships
  • Relationship types
  • Setting up and using merge queries
  • Hierarchies
  • Drill down
  • Drill up
  • See next level
  • Expand a hierarchy
  • Create a new hierarchy
  • DAX functions
  • DAX syntax
  • Creating a new measure
  • Using quick measures
  • Shared workspaces
  • My workspace
  • Dashboards
  • Reports
  • Datasets
  • Drill down in dashboards
  • Focus mode
  • Using Q&A
  • Refreshing data
  • Using Quick Insights
  • Installing the Mobile App
  • Phone view
  • Using the Power BI Mobile App

As a complete novice to Power BI (Never used before) it covered all of the basics and by the end I was comfortable in making different visualisations using a variety of data sources. Well presented, just the right pace for a novice and broken up at the right level. Never did I once feel swamped with information.

Simon, Tokyo Electron Europe Ltd.

It was very interactive with lots of workshops, good course, overall good course and delivery

Henry, Tokyo Electron Europe Ltd.

I would recommend the course as my company is starting to use Power BI more and this course would be useful to people with no experience of the product. The course was structured well, showing us a new aspect of the software and then testing us on it afterwards. The course is a good introduction to Power BI.

Philip, Tokyo Electron Europe Ltd.

Excellent course and trainer. It was very organised and useful to have exercise as well. Trainer was very good.

Mayuko, Tokyo Electron Europe Ltd.
I would recommend the course, the trainer was very clear, and gave effective solutions for our reporting.
Pip, Tokyo Electron Europe Ltd.

I can recommend the course to other people. The course is very comprehensive and visual. Our trainer was very supportive. The course offered an opportunity to do lots of practice.

Mariana, Tokyo Electron Europe Ltd.

Excellent course and trainer. Potentially very useful MS Product trained in a clear manner with practical exercises.

Julian, Tokyo Electron Europe Ltd.

A clear, well thought out learning format. I really liked the way the Susan gave us a demonstration and then we put the knowledge to test on different exercises. It really helps underpin what we are learning. Having played around with Power BI it made me realise that I was using it well and has certainly taught me some of the anomalies with the software! Understanding the different ways of filtering and highlighting certain data has really helped.

Liz, Civil Aviation Authority

Excellent course and trainer, I would recommend it, it was a very good introduction to PowerBI, with lots of clear examples. Our group had different levels of experience of PowerBI, and there was plenty of time for everyone to get to the end of each exercise before we moved on to the next topic. There was also a lot of opportunity for us to ask extra questions to explore issues that we have encountered when using PowerBI. The most useful part of the course was the chance to go through all the basic elements of PowerBI, some of which I was familiar with and some of which I wasn’t.

Philip, Civil Aviation Authority

Excellent course and trainer. Course was a useful introduction to Power BI, starting from basics. Good pace of the session, allowing all participants to complete the exercises. I was also impressed with the way Susan was able to handle more advanced queries for individuals who were faster learners. Most useful part course was getting to grips with cleaning the data in the Edit Queries stage.

Eric, Civil Aviation Authority