Learn Microsoft Power BI
4.3 (135 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
837 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Microsoft Power BI to your Wishlist.

Add to Wishlist

Learn Microsoft Power BI

Learn how to turn data into information by creating dashboards to share with your colleagues/friends
4.3 (135 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
837 students enrolled
Created by Lee Hawthorn
Last updated 10/2016
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • 4 Articles
  • 15 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Transform data into interactive visualisations to tell a story
  • Turn data into insight with Power BI and share it with others
  • Develop data modelling skills
  • Learn how to automate the cleansing of data
  • Query data from sources such as Text Files, Excel, Databases, the Web
View Curriculum
  • Access to Windows 7 + is required.
  • Near the start of the course you'll be directed to download and install Power BI Desktop and sign up for the free Power BI.com service.
  • Internet Explorer 9+ is a prerequisite for Power BI Desktop
  • For lecture 17 (Refreshing Data) Power BI Professional (Paid version) is required. However, if you want to follow along without paying you may be able to start a 60 day trial if you have not previously done so.
  • During the course I teach how to query SQL Server databases for the benefit of students who need to query this data source. However, if you don't have access to SQL Server there is no need to install it as the assignment doesn't use it as a data source.

This course introduces you to Power BI from Microsoft. Power BI is easy to use software & services that can be used to turn data into actionable insight so that you can convey stories to yourself and others through the use of highly interactive visualisations.

Acquire the Skills to Query Data, Transform it, Visualize it and Publish it.

Learn how to:

Query data from

  • Excel
  • Databases
  • Web
  • Web Services
  • Text files

Transform data by

  • Cleaning
  • Pivoting
  • Enriching
  • Calculating

Communicate insights by

  • Creating dashboards
  • Adding interactivity
  • Publishing dashboards for others to use

Power BI is a new tool that empowers you to be a master of data rather than a servant of it.

Previously these skills were limited to experts but with the modern software the technical barrier has been lowered to such an extent that most people are capable of producing and sharing dashboards.

The only prerequisite I have is that students must be data literate. Excel users will have no problem learning Power BI. If you don't know what a table of data is this course isn't for you.

SQL or BI developers probably won't get a lot from this course as there aren't any complex queries or calculations.

The type of terminology used on this course includes, Tables, Relationships, Models, Calculations, Visualizations.

The course is taught using screencasts, slides, with set assignments. I encourage you to have a go at the assignments as this will solidify what you've learnt

The files I use on the course are available for you to download..

It can take between 2 and 4 hours to take this course (including assignments).

There are over 2 hours of screencasts.

The course is structured using key learning points, starting at the very beginning and progressing so that may the end of the course you'll have the skills to create data models with dashboards.

The skills you'll gain on this course will help boost your career as you'll be seen as a powerful steward of data.

Power BI is becoming increasingly in demand in organisations of all sorts of sizes. Take advantage of this opportunity today and hit that enroll button.

Who is the target audience?
  • This course is targeted at Excel users who are able to format a table and write simple formulas such as SUM(A1:A10)
  • Excel knowledge is not required. Anyone who understands basic tables should be fine with the course material.
  • If you have any doubt please sample one of the lectures.
  • If you are a BI or SQL developer this course is probably not for you as you won't find complex queries or functions.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
42 Lectures
Getting Started
9 Lectures 25:35

This lecture describes course content.

Preview 00:59

Objectives: Getting Started

This lecture explains how to install Power BI Desktop and sign up for the service.

Getting set up

This lecture introduces you to the Power BI user interface. You'll learn how to navigate through the application.

First look at the user interface

Assignment 1: Getting Started

In this lecture we load data from Excel into Power BI and create a simple dashboard.

Your first visualization

In this lecture we look at styling the dashboard by changing the properties for various aspects of the visualization. Have some fun.

Styling the visualization

Summary: Getting Started
Creating professional dashboards
8 Lectures 24:50
Objectives: Creating professional dashboards

In this lecture you'll build upon the skills learnt so far by using multiple visualizations to create a dashboard.

Creating a dashboard

In this lecture you'll learn about the different types of filtering in Power BI. Starting with Visual filters moving onto Page and Report fitlers.

Preview 04:25

You'll learn how to utilise the drill through features of Power BI that you can use when you have hierarchical data i.e.


Product Sub Category--Product Category

Drill through features

In this lecture we look at using a custom visualisation from the Power BI Gallery.

Custom Visualisations

Dashboard design best practices

In this assignment I want you to try and replicate the dashboard I created showing sales for July 2008.

Use attached resources (Assignment3_data.xlsx and Assignment3 output required.png) but try not to peek at the solution unless you're totally stuck.

Assignment 3: Creating a well designed dashboard

Summary: Creating professional dashboards
Querying data from different sources
6 Lectures 19:40
Objectives: Querying data from different sources

You'll learn how to query a database in this lecture. SQL Server, one of the most popular databases on the market is used in the example.

Querying a SQL Server database

You'll learn how to query a text file. Lots of data exists in text files so this is a useful skill to have.

Querying a text file

In this lecture you'll learn how to extract data from the page of web pages. It's much easier than you'll imagine.

Preview 05:24

In this lecture we'll review querying data from the many different API based sources. Many services are packaged with a Power BI connector. This avoids the need for you to get into detail. We query GitHub data in this video but many other sources are available as you'll see.

Querying web API based data

Summary: Querying data from different sources
Cleaning & Transforming Data
5 Lectures 23:08
Objectives: Cleaning & Transforming data

In this lecture we'll apply data cleaning steps from data pulled from the web. You can apply these steps to any data. With Excel we had to use formulas for much of this. With Power Query we can use the UI and steps will be repeatable.

Cleaning up web data

In this lecture we will apply more changes to the data to show off Power Query features.

Transforming data

Assignment 4: Querying and Cleaning data

Summary: Cleaning & Transforming Data
Publishing visualisations on Power BI.com
6 Lectures 23:02
Objectives: Publishing Visualisations on Power BI.com

Publishing your visualisations

In this lecture you'll learn about the different options available in the free vs professional edition of Power BI that enables you to refresh data.

Refreshing data

In this lecture you'll learn how to share data to groups within your organisation using Content Packs

Creating Content Packs

Assignment 5: Publishing and Sharing content

Summary: Publishing Visualisations on Power BI.com
Bonus Lectures
3 Lectures 15:26
Creating a data model

Creating calculated columns to enrich the data model

This lecture is for students who may already have Excel Power Pivot models held in Excel workbooks. We'll look at how we can import such models into Power BI Desktop without having to re-create them. If you don't have Excel Power Models this lecture is not relevant.

Importing an Excel data model
New features as of Oct-16
5 Lectures 16:44
Introduction to new features

Line Chart Drill Down

New Drill Down features

Slicer searching

Mobile Reporting
About the Instructor
Lee Hawthorn
4.2 Average rating
258 Reviews
3,357 Students
3 Courses
Data & Finance professional

I'm a business intelligence professional who has 10 years’ experience turning data into information. I work with companies in the UK & Ireland to help them by building systems that provide reports and dashboards in a fully automated manner.

Qualifying as a Chartered Management Accountant in 2005 and a degree in Performance Management. Before working in the field of BI I worked in Finance as a Financial Analyst.

I have given training to over 200 people on Excel & Microsoft BI. I've received excellent feedback too.

I learnt to code as a child but I'm not a professional coder. This allows me to relate to non-technical people and explain concepts in easy to understand terms.

Having worked for some of the largest organisations I’ve seen personally have BI can be used to improve business performance. I blog about BI & Data Analytics see blog link in my profile.

I have a passion for sharing knowledge as I know it has the power to change the world.