Learn Microsoft Power BI
4.6 (88 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.
644 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.6 (88 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.
644 students enrolled
Created by Lee Hawthorn
Last updated 10/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 4 Articles
  • 15 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
Requirements
  • 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.
Description

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
Expand All 42 Lectures Collapse All 42 Lectures 02:28:26
+
Getting Started
9 Lectures 25:35

This lecture describes course content.

Preview 00:59

Objectives: Getting Started
00:54

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

Getting set up
01:05

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
07:27

Assignment 1: Getting Started
00:10

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

Your first visualization
04:32

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
09:17


Summary: Getting Started
01:02
+
Creating professional dashboards
8 Lectures 24:50
Objectives: Creating professional dashboards
00:45

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

Creating a dashboard
07:01

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.

Dates--Month--Qtr--Year.

Product Sub Category--Product Category

Drill through features
03:19

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

Custom Visualisations
02:46

Dashboard design best practices
04:05

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
01:12

Summary: Creating professional dashboards
01:17
+
Querying data from different sources
6 Lectures 19:40
Objectives: Querying data from different sources
01:03

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
06:52

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
01:54

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
03:11

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

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
10:27

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

Transforming data
09:35

Assignment 4: Querying and Cleaning data
00:13

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

Publishing your visualisations
10:31

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
04:47

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

Creating Content Packs
04:37

Assignment 5: Publishing and Sharing content
00:09

Summary: Publishing Visualisations on Power BI.com
01:30
+
Bonus Lectures
3 Lectures 15:26
Creating a data model
07:58

Creating calculated columns to enrich the data model
04:29

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
02:59
+
New features as of Oct-16
5 Lectures 16:44
Introduction to new features
01:29

Line Chart Drill Down
02:24

New Drill Down features
03:03

Slicer searching
03:36

Mobile Reporting
06:12
About the Instructor
Lee Hawthorn
4.6 Average rating
146 Reviews
1,916 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.