4.52 out of 5
4.52
6286 reviews on Udemy

Complete Introduction to Microsoft Power BI [2020 Edition]

Learn to use the free Microsoft Power BI to create reports, analyze data and develop interactive dashboards in minutes
Instructor:
Ian Littlejohn
26,473 students enrolled
English [Auto] More
Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor
Learn to create POWERFUL reports and dashboards with Microsoft PowerBI with a few clicks of the mouse
Gain valuable INSIGHT and INTELLIGENCE from your business and marketing data in a FRACTION of the time of traditional spreadsheets
PUBLISH reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes
Learn to create Data Models and use the DAX Formula language to develop POWERFUL calculations
Easily create a wide range of GRAPHS and VISUALISATIONS using drag and drop technologies
Use the Power BI Q & A feature to easily ask QUESTIONS of your data and provide new insight

**** Updated April 2020 – This best selling Udemy Power BI course has been updated to the new Power BI interface ****

Recent reviews:

“Great experience of learning and a bunch of thanks for those Challenges. It helped a lot and are very helpful while revising the sections rather than going through each lesson.”

“Really good course, easy to follow and wonderful examples combined with useful insights.”

“Clear and concise, the course provided all the information needed for using power BI, and did so while providing enough details and examples however without stretching too long”

In this course you will learn the BEST techniques and tools for turning data into MEANINGFUL analysis using Microsoft Power BI

This course is lead by Ian Littlejohn – an international trainer, consultant and data analyst with over 100 000 enrollments on Udemy and consistently high reviews.  Ian specialises in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI and Google Data Studio. 

**** Life time access to course materials and practice activities. ****

In this course we are going to show you how to SUPERCHARGE your Power BI skills, and learn to create INTERACTIVE Dashboards and INCREDIBLE reports.  

In this course we are going to teach you the following:

  • Using the  Table and Matrix visualizations for cross filtering and drill downs

  • Creating Drill through between different sheets.  For example you could be reviewing a list of Products and want to select one Product to view a summary of this product

  • Themes – Learn how to add  Power BI Themes from the Community Theme Gallery

  • Changes in  Custom Visuals – We look at how to easily add Custom Visualizations from the new Microsoft Office Store

  • Creating Apps – Learn how to easily share your dashboards and reports using Power BI apps and App workspaces

  • Relative Date Filters – In this lesson we show how to easily create a dashboard displaying Microsoft stock data.  Easily filter your data to display the last 7 days, last 14 days, last month or previous 3 months using relative date filters

  • Drill Through – Create drill throughs between different pages in a report

  • Ribbon Chart – Learn to use the new Ribbon Chart to visualize the ranking of items across dates ranges or other categories.

Microsoft Power BI is the easiest to use reporting, data analysis and interactive dashboard tool available today!  Microsoft Power BI is available for free – all you need to do is sign up!

In this course I will teach you how to easily turn your data into powerful intelligence and insight to drive your business decisions.  Power BI uses simple drag and drop techniques that make it a breeze to create reports and dashboard.  I will also show you how easy it is to publish your dashboards and to access them through your smartphone, tablet or laptop.

This course is for anybody who works with data and wants to learn how to quickly and easily get to speed with the cloud version of Power BI or learn the more powerful Power BI Desktop Designer.   

The course has the following topics:

  • Introduction to Power BI and how to signup

  • How to create your first online report and dashboard

  • How to download the Power BI Desktop Designer

  • Loading, transforming and filtering data in Power BI

  • Creating tables and reports

  • Using filters and slicers

  • Learning how to use the wide range of graphs and visualizations

  • Creating relationships between tables of data

  • Creating powerful calculations, key metrics and key performance indicators

  • Creating interactive dashboards

  • Publishing dashboards to Power BI

In this course we use a step by step video based approach to show you how to create reports, analyze data and develop interactive dashboards.  The videos are extremely easy to follow and data is provided so you can follow the instructions at the same time.

Introduction

1
Introduction to PowerBI

In this introduction we discuss the different topics and modules that we will be covering in the course. Different topics include Loading data, creating tables and reports, creating visualizations, developing dashboards and sharing data through the PowerBI cloud solution.

2
About the Course
3
Download the Training Data Files

Download the data files that will be used during the course

Sign Up for Power BI

1
Introduction to Signing Up for Power BI
2
Signing up for PowerBI

In this lesson we will show how you will sign up for the PowerBI service. This will create a user login and password for the PowerBI service.

3
Load Data into the Power BI Service

In this lesson we learn how to load data into the Power BI Service

4
Practical Activity

Practical activity to sign up and start using Power BI

The Power BI Desktop

1
Introduction to PowerBI Desktop Section

Introduction to the Power BI Desktop section

2
Introduction to the Power BI Desktop

In this lesson we will learn how to access and use the PowerBI interface. The PowerBI Interface consists of functions to upload or access data, create reports and create dashboards.

Creating Reports in Power BI Desktop

1
Create Reports in Power BI Desktop Section
2
Creating Tables in Power BI

In this lesson we learn how to create tables in Power BI

3
Table Styles and Formatting

In this lesson you will learn to format and style your table

4
Matrix Visualization
5
Tables and Metrics Practical Activity
6
Answers to Tables and Metrics Practical Activity

In this lesson we go through the answers to the practical

7
Changing the Method of Aggregation

In this lesson you will learn to change the method of aggregation from Sum to other options such as Average, Count, Max, Min and Distinct

8
Methods of Aggregation Challenge
9
Methods of Aggregation Challenge Completed

In this lesson we will go through the answers to the practical activity

10
Cards and Multi Row Cards

In this lesson we will review how to create cards and multi row cards in Power BI

11
Cards, Matrix and Multi Row Card Challenge
12
Answers to Cards Challenge
13
Percentage Calculations
14
Filtering Data - Using Slicers
15
Filtering Data - Visual Filters
16
Filtering Data - Page Filters
17
Filtering Data - Drill Through Filter
18
Practical Activity - Filters
19
Practical Activity Filters Completed

Graphs and Visualizations

1
Introduction to Visualization Section
2
Clustered Column Graphs

In this lesson you will learn how to create clustered column and bar graphs. Clustered Column and Bar graphs are ideal for displaying data when you want to know which is the largest item or which is the smallest item or how much bigger one item is then another.

3
Stacked and 100% Graphs

In this lesson we will review the stacked bar and column graph. The stacked column and bar graph places each series on top of each other and displays the aggregated total.

4
Column Graph Challenge
5
Column Graph Challenge Completed
6
Graph Options

In this lesson you will learn the different features that can activated with Power BI 

7
Trend Analysis Graphs

In this lesson you will learn how to create line charts to display trends. Displaying and analyzing how data changes over time is a powerful method of analysis that provides input into forecasting.

8
Area Graphs

In this lesson you will learn how to use area graphs to chart and understand trends

9
Ribbon Graphs

In this lesson you will learn how to create a Ribbon graph visualizations.  The ribbon graph dispalys the ranking of the items that are being displayed.  If for example you are displaying Sales by Product Category then  it will display the Product Category with the highest Sales at the top and then the second highest and so on

10
Additional Graphs

In this lesson we will learn how to different types of graphs in Power

11
Scatterplots and Bubbleplots

In this lesson we will learn how to create scatterplot and bubbleplot graphs. 

12
Decomposition Tree

Interactive Dashboards

1
Creating Interactive Dashboards
2
Challenge - Create an Interactive Report
3
Completed Challenge - How to Create an Interactive Report
4
Publishing Reports to the Power BI Service
5
Pinning Visualizations to Dashboards
6
Mobile Reports
7
Q and A
8
App Workspaces
9
Publishing an App
10
Using Themes in Power BI
11
Using Custom Visualizations

DAX Formulas

1
DAX Formulas Section
2
DAX Formulas

In this lesson you will learn to create calculated columns using DAX formulas.  DAX formulas are very similar to Excel 

3
Date Functions

In this lesson you will learn how to create new time intelligence fields such as Year, Month and Week 

4
Formatting Dates
5
Date Master Tables

DAX Measures

1
Introduction to Measures Section
2
Introduction to DAX Measures

In this lesson you will learn about the power of calculated measures to create powerful key metrics and key performance indicator calculations.

3
DAX Measures Practical Activity
4
DAX Measures Activity Completed
5
The =Calculate Formula

In this lesson you will learn how to use the = calculate function to filter 

Relationships

1
Relationships Section
2
Creating and Managing Relationships in Power BI

In this lesson you will learn how to create relationships between  tables

3
Relationship Calculations

Power BI Query Editor

1
Introduction to Power BI Query Editor
2
Basic Transformations - Part 1

In this lesson you will learn the Edit Query interface and how to load data

3
Basic Transformations - Part 2
4
Aggregating Data

In this lesson you will learn how to transform data into aggregations using the Query 

Analyze Data with Excel

1
Introduction to Power BI and Excel
2
Please Note
3
Power BI and Excel Connections
4
Pinning Excel into Power BI
5
Loading Excel files into Power BI Service

Corona Virus Case Study

1
Introduction to the Corona Virus Case Study
2
Corona Virus Link
3
Corona Virus Case Study Part 1
4
Corona Virus Case Study Part 2
5
Corona Virus Dashboard Update
6
Corona Virus Dashboard Update

Conclusion

1
Conclusion

Conclusion for the course

2
Useful Resources and Links
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
6286 Ratings

Detailed Rating

Stars 5
3082
Stars 4
2496
Stars 3
636
Stars 2
67
Stars 1
25
1b4f7d38d2664784e5268d955de8e486

Includes

6 hours on-demand video
13 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion