Learn Microsoft Power BI

Learn how to turn data into information by creating dashboards to share with your colleagues/friends
4.4 (57 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.
517 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 42
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course 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.

What are the 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.

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
00:59

This lecture describes course content.

Objectives: Getting Started
00:54
01:05

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

07:27

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

Assignment 1: Getting Started
Article
04:32

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

09:17

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

Assignment 2: Create a basic visualization
Preview
Article
Summary: Getting Started
01:02
Section 2: Creating professional dashboards
Objectives: Creating professional dashboards
00:45
07:01

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

04:25

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.

03:19

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

02:46

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

Dashboard design best practices
04:05
01:12

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.

Summary: Creating professional dashboards
01:17
Section 3: Querying data from different sources
Objectives: Querying data from different sources
01:03
06:52

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.

01:54

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

05:24

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

03:11

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.

Summary: Querying data from different sources
01:16
Section 4: Cleaning & Transforming Data
Objectives: Cleaning & Transforming data
01:22
10:27

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.

09:35

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

Assignment 4: Querying and Cleaning data
Article
Summary: Cleaning & Transforming Data
01:31
Section 5: Publishing visualisations on Power BI.com
Objectives: Publishing Visualisations on Power BI.com
01:28
Publishing your visualisations
10:31
04:47

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.

04:37

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

Assignment 5: Publishing and Sharing content
Article
Summary: Publishing Visualisations on Power BI.com
01:30
Section 6: Bonus Lectures
Creating a data model
07:58
Creating calculated columns to enrich the data model
04:29
02:59

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.

Section 7: New features as of Oct-16
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Lee Hawthorn, 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.

Ready to start learning?
Take This Course