Powerful Reports and Dashboards with Microsoft PowerBI

Learn to use the free Microsoft PowerBI to create reports, analyze data and develop interactive dashboards in minutes
4.4 (107 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.
731 students enrolled
$20
Take This Course
  • Lectures 61
  • Contents Video: 3.5 hours
    Other: 2 mins
  • 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

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 11/2015 English

Course Description

Microsoft PowerBI is the easiest to use reporting, data analysis and interactive dashboard tool available today! Microsoft PowerBI 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. PowerBI 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 PowerBI or learn the more powerful PowerBI Desktop Designer.

The course covers the following topics:

  • Introduction to PowerBI and how to signup
  • How to create your first online report and dashboard
  • How to download the PowerBI Desktop Designer
  • Loading, transforming and filtering data in PowerBI
  • 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 PowerBI

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

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

Curriculum

Section 1: Introduction
Introduction Section
Article
02:14

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
Article
Practical Activity
Article
02:31

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: Creating the First Report in PowerBI
First Report Section
Article
02:39

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.

03:10

In this lesson you will learn to load and import data ino PowerBI from different sources.

08:03

This first part shows how to create a report using tables, slicers and visualizations in PowerBI. The lesson will take you through step by step to create the report.

06:53

The second part of creating a report in the PowerBI cloud solution. In the report we show how to create reports, tables, visualizations and dashboards.

02:06

In this lesson you will learn how to download the PowerBI Desktop. The Desktop runs on computer or laptop and includes a number of powerful features such as creating relationships, creating calculated columns, creating calculated measures and editing data which is not available on the cloud software.

First Report Practical Activity
Article
04:13

In this lesson we will review how to complete the practical activity exercises.

Section 3: Introduction to PowerBI Desktop
Intro to PowerBI Desktop Section
Article
04:53

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.

Section 4: Tables and Key Metrics
Tables and Metrics Introduction Section
Article
04:39

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.

04:35

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.

04:38

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.

07:28

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.

Tables and Metrics Practical Activity
Article
04:11

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

Section 5: Graphs and Visualizations
Intro to Visualization Section
Article
07:21

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.

05:17

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.

03:14

In this lesson you will learn the power of cross filtering between Column and Bar graphs.

06:48

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.

03:40

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%

03:54

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.

03:27

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.

02:12

In this lesson you will learn how to create combination graphs. Combination graphs are when you have one series as a column graph and another series as a line graph.

04:11

In this lesson you will learn how to create ScatterPlots in PowerBI. ScatterPlots are a powerful analysis tool for understanding correlations between data. For example you could understand the correlation between Sales and Profit

02:36

In this lesson we will learn how to analyze data using maps. PowerBI uses the Bing mapping engine to automatically geocode data into longitude and latitude.

06:12

In this lesson you will learn to edit and create an interactive dashboard using Cards and different forms of visualizations. PowerBI dashboards use dynamic filtering which makes it easy to ask questions of your data.

Visualization Practical Activity
Article
04:08

In this lesson we review how to complete the practical activity exercise for the Visualization and graph section.

Section 6: Creating Relationships
Relationships Section
Article
Article

Please download the Employee Master training data file

02:38

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.

04:23

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

Section 7: Creating Calculated Columns
Intro to Calculated Columns
Article
08:16

In this lesson you will learn to add new custom calculated columns to your PowerBI data. Calculated columns use the same formulas as Excel and are extremely easy to learn and apply

Calculated Column Activity
Article
06:16

This lesson shows how to calculate calculated columns in PowerBI

Section 8: Creating Calculated Measures
Calculated Measure Section
Article
01:28

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

08:47

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

06:52

In this lesson you will learn to create averages and ratios using the =Divide formula.

11:13

The Calculate formula allows powerful measures to be created in PowrBI. In this lesson you will learn how to create the calculate formula and how to use it in Tables and Visualizations.

06:00

In this lesson you will learn to create Year To Date, Quarter to Date and Month to Date calculations in PowerBI

Section 9: Loading Data into the PowerBI Cloud
Loading Data into the Cloud Section
Article
07:43

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

02:49

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

Section 10: Preparing Data in PowerBI
Preparing Data Section
Article
08:31

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

06:39

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

03:09

In this lesson you will learn to group and summarize data. You will create a total sales, average sales, lowest sale, highest sale and number of transactions.

04:28

In this lesson you will learn to merge different tables of data together into one table.

Section 11: Conclusion
Conclusion Section
Article
00:42

The conclusion of the course

Useful Resources and Links
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ian Littlejohn, Excel Business Intelligence 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 and PowerView.

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