Microsoft Power BI Service Training Course

at CitizenM London SE1 0NZ

Download Course Information

We have successfully run many on-site Power BI courses for clients, teaching them how they can extract, analyse and visualise large amounts of data with Microsoft's cloud based Power BI. We are delighted now to offer regular courses in Power BI at the excellent citizenM facilities, just a short step from the City of London. The courses run monthly, see the registrations options on the right

The course covers the essential skills in Power BI, Extracting, Transforming and Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts and Dashboards, these can then be shared with collegues or others with the Power BI service and in many other ways. We also cover Power Pivot in Excel and how that can feed data to Power BI and be combined in Dashboards and Visualisations. You can see the full course content below, or download the course details from the link on the right.

Prerequisites

We provide everything necessary for the Training Course, a full specification laptop, pre-loaded with Power BI Desktop, Office 2016 and Training Data. Attendees should have a knowledge of Excel, and familiarity with Excel Pivot Tables and Excel Functions like SUMIFS and VLOOKUP. People with Database, Programming or other BI experience will be qualified for the course even if they don't have Excel experience.

Course Cost

This course is available for £ 650.00 (Excl VAT) per person for the two days. You can pay online with a Credit or Debit card, or select "Pay by Check" in the online registration to request an Invoice for the course.  Lunch and morning and afternoon tea or coffee are included in the cost, and you'll also get  a USB drive with all the Training data, and worked examples from the course. The course is limited to a maximum of ten attendees, so you'll allways get individual attention from the two Trainers running the course.

Course Venue

The course is run at CitizenM 20 Lavington Street, London SE1 0NZ. They have excellent facilities with a stylish comfortable set of Training rooms and fast free WiFi. The rooms are located close to London Bridge Station, and a short walk from the City of London. citizenM is also an Hotel and you can book accommodation, if you require it, direct with them.

What past attendees have said...

"We covered in 2 days what would have taken a week or more for us to glean for ourselves. If you need comprehensive Power BI training, then look no further".

"I've attended numerous system training courses and while about a third of the content of most is of use – yours was pure gold from start to finish! I left feeling ready to tackle Power BI and with enough knowledge to explore it with confidence. Thanks again."

Run this course at your Company

If you have several attendees we can run this course at your company, at dates to suit you. Just contact us to discuss.

Microsoft Power BI Service course content

Download full course details using the link at the top right.

What is Microsoft Power BI

  • Understanding the Power BI environment 

Exploring Power BI Desktop

  • Working with the Fields and Visualisation Panes
  • Using Report View to create visualisations
  • Using Data View to sort and Format data

Understanding Data Sources in Power BI Desktop

  • Importing a variety of data sources into Power BI Desktop
  • Connecting to Excel Workbooks, Access Databases, CSV Files and other data locations.

Visualisations Workshop using Power BI Desktop

  • Adding visualisation to the Report Canvas
  • Understanding and controlling interactions between visualisations
  • Using Drill Down and Drill Through on visualisations
  • Creating and using Heirarchies
  • Importing custom visualisations
    (Course attendees can practice creating and designing a variety of the many interactive visalisations available in Power BI) 

Creating a Data Model in Power BI desktop

  • Understanding the Data Model
  • Using Relationship View
  • Creating Many-to-One relationships
  • Understanding Filter propagation

Introduction to DAX in Power BI Desktop

  • Exploring the importance of custom calculation within the Data Model
  • Creating Calculated Columns 
  • Creating simple Measures to summarise data
  • Understanding Evaluation Context
  • Using CountRows and DistinctCount Functions
  • Advanced DAX functions: SUMX and CALCULATE
  • Time Intelligence Functions

Using Queries in Power BI Desktop

  • Understanding the role of Queries in data import
  • Understanding Extract, Transform & Load (ETL)
  • Exploring a variety of data transformations
  • Working with Applied Steps
  • Using the Unpivot Transformation
  • Appending CSV and XLSC files

Publishing to Power BI Service

  • Publish your Report to PowerBI.com
  • Creating Dashboards
  • How to Share your Interactivie Power BI Dashboards with people both inside and outside your organisztion.
  • Using Quick Insights
  • Using Q & A for interactive data searching. 

Importing Data into Power BI Service

  • Connecting to a variety of Cloud-based data sources, including OneDrive, Google Analytics, Azure SQL Databases and Websites.

Apps & Groups

  • Benefits of using Apps and Groups
  • Creating Groups to restrict access to dashboards
  • Creating Organsiation Apps
  • Connecting to Cloud based Apps

Data Refresh

  • Manually refreshing data
  • Installing and using the Personal Gateway
  • Installing and using the Enterprise Gateway
  • Creating a Scheduled Refresh

 Using Power BI on Mobile Devices

  • Understanding the mobile clients
  • Tablet Clients, Windows 10, IPad and Android
  • Differences between IPhone, IPad and Android clients

 

 


 Call us on 0800 0199 746