Powerful Reports and Dashboards with Microsoft Power BI

Learn to use the free Microsoft Power BI to create reports, analyze data and develop interactive dashboards in minutes
4.2 (176 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.
1,136 students enrolled
25% off
Take This Course
  • Lectures 60
  • Length 4.5 hours
  • Skill Level Intermediate Level
  • 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


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.

About This Course

Published 11/2015 English

Course Description

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 powerful drag and drop capabilities 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 PowerBI Desktop Designer.

The course covers 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
  • 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.

What are the requirements?

  • You will need to know how the basics of working with data in Excel
  • In the course you will need to sign up for the free Microsoft PowerBI service

What am I going to get from this course?

  • Create powerful reports and dashboards with Microsoft PowerBI with ease
  • Publish reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes
  • Learn to use the free Microsoft PowerBI to easily ask questions of your data
  • Easily create a wide range of graphs and visualizations using drag and drop technologies
  • Gain valuable insight and intelligence from your business and marketing data in a fraction of the time of traditional spreadsheets
  • Create a powerful dashboard and Business Intelligence system for free

Who is the target audience?

  • All Excel users who work with data, reports or dashboards
  • All existing Business Intelligence developers and users
  • This course is not for users who are not yet familiar with working with data in Excel

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.


Section 1: Introduction
Introduction Section

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.

Download the Training Data File
Practical Activity

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.

Section 2: The Power BI Desktop Designer
Intro to PowerBI Desktop Section

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.

Section 3: Creating Reports in Power BI Desktop
Create Reports in Power BI Desktop Section

In this lesson we learn how to load data into the PowerBI Desktop. We review the different types of data that can be loaded and also the methods and processes for loading data.

Tables and Metrics Practical Activity

In this lesson you will learn to summarize your data using Cards and Gauges. These visualization options are powerful for displaying key metric data and key performance indicator calculations.


In this lesson you will learn to analyze your data using Tables and Matrix visualizations. Tables and Matrixes make it easy to aggregate your data and provide quick summaries. Different methods of aggregation such as Sum, Average, Count, Distinct Count, MIn and Max are also shown.


In this lesson you will learn how to use Slicers to easily filter your data. Slicers are text or category items that can easily filter your data. For example you may have a list of different branches in your company and then want to filter your reports to display one branch at a time.

Challenge 2

In this lesson you will learn to filter data in reports using page filters. Page allow conditions such as Start With, Contains, Is Greater Than and Before and After Dates.


In this lesson we will review how to create tables, key metrics and filters in this practical activity

Challenge 3
The Quick Calc Option
Filtering Data - Using Slicers
Filtering Data - Visual Filters
Filtering Data - Page Filters
Challenge 4
Challenge 4 Completed
Section 4: Graphs and Visualizations
Intro to Visualization Section

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.


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.

Challenge 5

In this lesson you will learn the power of cross filtering between Column and Bar 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.


In this lesson we will learn how to create Pie charts in PowerBI. Pie charts are useful for showing the percentage that item contributes to the whole or the 100%


In this lesson we will learn how to create area graphs. Area graphs are useful when you want to see how data changes over time and also see how the magnitude of the data changes over time.


In this lesson you will learn how to create a Treemap visualizations. TreeMap is another method of visualizing your data to understand which items contribute the most or the least to the total.

Section 5: Interactive Dashboards
Creating Interactive Dashboards
Interactive Dashboard Section
Publishing Dashboards
Pinning and Q & A
Sharing Dashboards
Power BI on Mobile
Section 6: DAX Formulas
Relationships Section

In this lesson you will learn to create relationships between different tables of data. Relationships allow the creation of reports using fields from different tables such as lookup fields. For example you may have a Product ID in your main table, but want to know what the Product Name is. Relationships are used to join the two tables.


In this lesson you will learn how to analyze and create reports using relationships between more than one table of data.

Formatting Dates
Date Master Tables
Section 7: DAX Measures
DAX Measures Section

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


In this lesson you will learn how to create Sum, Count, Distinct Count, Average, Min and Max calculations in PowerBI.

Section 8: Relationships
Relationships Section

In this lesson you will learn how to create an interactive dashboard that can be uploaded to the PowerBI cloud.


In this lesson you will learn how to load your dashboard into the cloud.

Using the Related Formula
Section 9: Enhancing Power BI
Enhancing Power BI Section

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


In this lesson you will learn how to transform and correct data errors in PowerBI

Section 10: Analyze Data with Excel
Setting up Power BI Data to work with Excel
Introduction to Analyze Power BI Data with Excel
Creating Measures for Excel Analysis
Additional Measures for Excel
Section 11: Conclusion
Conclusion Section

The conclusion of the course

Useful Resources and Links

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ian Littlejohn, Excel Business Intelligence and Power BI Trainer

Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and techniques making it easy for learners to harness the power of Excel PivotTables, PivotCharts, PowerPivot, Power Query, PowerView and Power BI.

Ian has been training learners on these powerful technologies for a number of years making it easy for the business user to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.

Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.

Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.

Ready to start learning?
Take This Course