Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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
Transform data by
Communicate insights by
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started|
This lecture describes course content.
Objectives: Getting Started
This lecture explains how to install Power BI Desktop and sign up for the service.
This lecture introduces you to the Power BI user interface. You'll learn how to navigate through the application.
Assignment 1: Getting Started
In this lecture we load data from Excel into Power BI and create a simple dashboard.
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 visualizationPreview
Summary: Getting Started
|Section 2: Creating professional dashboards|
Objectives: Creating professional dashboards
In this lecture you'll build upon the skills learnt so far by using multiple visualizations to create 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.
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
In this lecture we look at using a custom visualisation from the Power BI Gallery.
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.
Summary: Creating professional dashboards
|Section 3: Querying data from different sources|
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.
You'll learn how to query a text file. Lots of data exists in text files so this is a useful skill to have.
In this lecture you'll learn how to extract data from the page of web pages. It's much easier than you'll imagine.
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
|Section 4: Cleaning & Transforming Data|
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.
In this lecture we will apply more changes to the data to show off Power Query features.
Assignment 4: Querying and Cleaning data
Summary: Cleaning & Transforming Data
|Section 5: Publishing visualisations on Power BI.com|
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.
In this lecture you'll learn how to share data to groups within your organisation using Content Packs
Assignment 5: Publishing and Sharing content
Summary: Publishing Visualisations on Power BI.com
|Section 6: Bonus Lectures|
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.
|Section 7: New features as of Oct-16|
Introduction to new features
Line Chart Drill Down
New Drill Down features
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.