Power BI Essentials: Introduction to Microsoft Power BI
4.5 (87 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.
2,502 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Power BI Essentials: Introduction to Microsoft Power BI to your Wishlist.

Add to Wishlist

Power BI Essentials: Introduction to Microsoft Power BI

Power BI Online Training: Comprehensive introduction to Power BI Desktop, the Power BI service and Power BI mobile apps
4.5 (87 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.
2,502 students enrolled
Created by Grant Gamble
Last updated 8/2017
English
English [Auto-generated]
Current price: $29 Original price: $200 Discount: 86% off
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to use Power BI Desktop to import and model data and create reports.
  • How to use the Power BI service for the creation of dashboards, collaboration and sharing of content.
View Curriculum
Requirements
  • Ability to use a PC and familiarity with general computing concepts and techniques, such as copying and pasting.
Description

Organizations rely on business intelligence to make better business decisions. Traditionally, BI always referred to Enterprise Business Intelligence. Enterprise BI was always a big deal! Enterprise BI software tools were extremely expensive, technically challenging, and designed for IT specialists.And enterprise BI projects took forever!

Microsoft Power BI offers users true Self-Service BI. Power BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools and devices.

Self-service BI has never been so user-friendly!

Microsoft Power BI Introduction will show you how to create compelling visualizations and reports which provide deep insights into your data.

By the end of the course, you will be confident in using the three main components of Power BI:

  • Power BI Desktop
  • the Power BI Service
  • and Power BI Mobile Apps.

You will know how to connect to a wide variety of data sources, using both Power BI Desktop, and the Power BI Service.

You will be able to use the Query Editor to transform and morph data into the right format for your reporting purposes.

You will be able to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.

You will learn how to share dashboards and reports, with colleagues, business partners and potential clients.

And how to use Power BI’s sophisticated security features to control the exact content your audience is able to view.

In short, this Microsoft Power BI Introduction will equip you with all the skills you need, to start using Power BI with confidence.

Who is the target audience?
  • This course is suitable for anyone who needs to become familiar with Microsoft's Power BI product, whether for work, study or career.
Curriculum For This Course
62 Lectures
07:12:45
+
1. Welcome
2 Lectures 03:35

This ZIP file contains all of the files you see being used in the tutorials of this course.

2. Downloading the course files
00:05
+
2. Getting Started
10 Lectures 01:09:12

In this lesson, we examine the different components of Power BI: Power BI Desktop, the Power BI service and Power BI mobile apps. We also discuss the differences between the free edition of Power BI, Power BI Pro and Power BI Premium.

Preview 05:02

Here, we compare the three main components of Power BI: Power BI Desktop, The Power BI Service and Power BI Mobile Apps

Preview 06:28

When creating content in Power BI, you work with three main elements: datasets, reports and dashboards.

Preview 12:16

In this video, we will publish the report created in the video to the Power BI service. Although Power BI Desktop is the main tool for creating reports, it is possible to edit reports in the Power BI service.

This video will show you how to edit a report in the Power BI service and download it, so that you can continue editing the report in Power BI Desktop.

Preview 08:12

Any reports published to My Workspace, in the Power BI service, will only be available to yourself. To make reports available to other users in your Power BI tenant, you will need to save the report to an app workspace.

This video will show you how to create an app workspace and upload a report to it.

5. Creating app workspaces
04:22

Dashboards are single page summaries, on a single analytical theme, which can contain content from multiple sources. This video looks at creating dashboards in the Power BI service.

6. Creating dashboards
08:01

Once the content in an app has been finalized, publishing the app will make it available to other users. In this video, we look at the process of publishing an app; and how authorized users then consume the app.

7. Publishing an app
06:12

In this video, we discuss the Power BI mobile user experience and look at Power BI's tools for optimizing reports and dashboards for mobile phone display.

8. The Power BI mobile experience
08:16

In this video, we'll look at creating a GitHub report, using one of the pre-created content packs which are built into the Power BI service.

9. Connecting to GitHub in the Power BI Service
03:55

You can connect to online sources in two ways: either using the Power BI service, or using Power BI Desktop. This video compares connecting to Google Analytics using both methods.

10. Connecting to Google Analytics (Service and Desktop compared)
06:28

Test your knowledge of Power BI basics

Quiz
5 questions
+
3. Connecting to Data Sources
6 Lectures 48:58

CSV (Comma Separated Values) is a standard used by many systems as a method of export. In this video, we look at importing a CSV file into Power BI Desktop.

1. Connecting to CSV files
08:54

This video explains how Power BI Desktop allows you to connect to three different types of Excel object: tables, named ranges and worksheets.

Preview 07:01

If you have a series of files which all have the same format, one useful strategy that you can use in Power BI desktop is to place them in the same folder and then connect to the folder. The folder connection will  produce a single table containing all the data currently in the folder.

3. Connecting to a Folder of data
07:48

In this video, we look at importing data from a web site. Naturally, however, when connecting to web sources, there is no implicit file format that you will always be importing.

4. Connecting to a web URL
05:49

In this video, we will look at connecting directly to a web URL; in other words, connecting to the web page itself and importing data stored in HTML tables.

5. Connecting to web page content
10:16

In order to connect to a Microsoft Access database, Power BI Desktop uses the Microsoft Access database engine. This video explains the process involved, and the potential problems, in connecting to Access tables and queries.

6. Connecting to a Microsoft Access database
09:10
+
4. Cleaning up and transforming data
11 Lectures 01:21:24

This video examines the Query Editor's Trim and Clean commands, as well as its functions for changing the case of columns of data.

1. Trim, Clean and Case
07:24

This video examines some useful housekeeping features which you should get into the habit of using: renaming queries, query steps and column headings and adding metadata to query steps.

2. Renaming and adding metadata
09:37

This lesson examines the Query Editor's Split Columns function, which is very similar to Microsoft Excel's Text to Columns command.

3. Splitting columns
07:39

When you connect to data sources, it is often the case that your data does not start on row one. This video shows how the Query Editor's Remove Rows command can be used to suppress any unwanted rows which may precede your data.

4. Removing rows
07:06

This video examines the Query Editor's Replace Values and Fill Down commands, both of which are very useful for changing the actual content of the data which you are importing into Power BI.

5. Replace Values
07:26

When importing reports generated by other systems into Power BI, you may encounter data which has already been subdivided, or pivoted, into separate columns, restricting your options for data analysis. This video shows how to use the Query Editor's Unpivot command to reverse this pivoting.

Preview 08:24

When connecting to data sources, reordering columns can be a useful way of improving your productivity. This video shows you the tools and techniques available for doing this in the Power BI Query Editor.

8. Rearranging columns
06:05

This video discusses the creation of custom columns whose data is based on calculations performed on other columns.

9. Creating custom columns
08:41

This lesson explains how to use the Query Editor's Append Queries command to "stitch together" matching columns of data from separate sources.

10. Append queries
09:16

This lesson explains how to use the Query Editor's Merge Queries command to "stitch together" matching rows of data from separate sources.

11. Merge queries
05:55

This video shows how to aggregate data as you import it into Power BI, a technique which is useful where there is far more granularity in the raw data than you need for your reports.

12. Grouping data
03:51
+
5. Data modelling
11 Lectures 01:27:51

We'll be working on a single project throughout this section and the section which follows. In this video, we connect to the data source which will give us the data model with which we will be working.

1. Adding data to the data model
06:38

This video explains the nature of the Power BI data model; what it is, how it works, and the data modelling tools available in Power BI Desktop.

2. Examining the data model
10:04

Whenever you import multiple tables, relationships, both existing and implied, are automatically recognized and created within Power BI. This video explains this process and how to control it.

3. Creating relationships automatically
07:51

This video explains the manual creation of relationships in Power BI and the various options and settings available.

Preview 11:49

When attempting to create a relationship between two tables, Power BI does not allow the use of composite keys; this video explains a workaround for this limitation.

5. Creating a composite primary key
07:15

Date tables are used to provide the unbroken sequence of dates required by DAX time intelligence functions. This video explains how to create a date table using Microsoft Excel.

6. Creating a date table
07:59

This video demonstrates how to use a DAX formula to enhance the data model by adding calculated columns to selected tables.

7. Creating calculated columns
08:25

This lesson explains the difference between calculated columns and measures, how to create measures and how to create a table for storing measures.

8. Creating measures
08:16

This video explains how to use DAX SUMX function in a measure to iterate through a table, performing a calculation on each row, and then aggregating the results.

9. Using the SUMX function
04:37

This lesson discusses the use of the RELATED and RELATEDTABLE functions to take advantage of the relationships between tables and perform calculations across related tables.

10. Using RELATED and RELATEDTABLE
10:34

This video demonstrates the use of calculated tables to enhance the data model.

11. Creating a calculated table
04:23
+
6. Creating a Power BI report
14 Lectures 01:29:03

In this video, we examine the report which we will be creating. You can find the completed report in training folder; sub-folder 6.1.

Preview 04:39

Before you start building any report, you'll probably want to start thinking about the page as a whole. This video explains the different background options that are available, as well as how to work with image tiles.

2. Backgrounds, logos and images
05:06

In this video, you will learn how to use a JSON file to specify report theme colours which will replace Power BI's built-in theme.

3. Working with themes
07:06

In this tutorial, we begin our creation of the report by using the card visual to display a series of "big picture" metrics at the top of each page.

4. The card big-picture visual
10:16

This lesson will show you how to make "big picture" visuals more versatile by attaching a permanent filter to them. In this example, we will use visual-level filters to display revenue for specific countries.

5. Using visual filters
05:47

The format painter is found in many Microsoft applications. In this tutorial, you will learn how this simple tool can be used in Power BI Desktop to save time by copying formats from one visual to another.

6. Using the format painter
03:06

Here, we examine the second of Power BI's "big picture" visual; the gauge; and look at how it enables you to highlight the differences between actual and target values.

7. Gauges and targets
05:08

The bar chart is one of Power BI's simplest and yet most useful visuals. In this lesson, we learn how to create and format a bar chart.

8. Creating bar charts
05:54

This tutorial explains how to use Power BI's powerful Visual Interactions mode to specify which visuals on the page will be filtered or highlighted when the user interacts with the report. (This is specified on a visual-by-visual basis.)

Preview 03:16

In the last video, we looked at how clicking on on visual can be made to filter other visuals on the page. In this video, we turn our attention to the Power BI visual whose sole purpose in life is to filter the data displayed in other visuals; the slicer.

10. Using slicers
06:29

This video discusses the benefits and drawbacks of Power BI's treemap visual.

11. Using the treemap visual
07:44

In this tutorial, we will create use Power BI's map visual to display the location of our clients and the revenue they generate.

12. Creating a map visual
07:15

In this lecture, we will discuss the various techniques available for exploiting Power BI's useful drill-down feature by creating both formal and informal hierarchies, as well as using automatically generated date hierarchies.

13. Date hierarchies and drill-down
09:12

This video discusses the use of DAX time intelligence functions and the implications regarding the link between the main data table and the dates table.

14. Using time intelligence functions
08:05
+
7. Sharing and Collaborating
8 Lectures 52:42

In this video, we examine one of the fundamental building blocks of sharing and collaboration; the user.

Preview 07:27

This video explains how to create groups in the Power BI service to enable collaboration on the creation of reports.

2. Creating groups for collaboration
09:26

Although groups are primarily used in the Power BI service to enable collaboration, as this video explains, they can also be used as mechanism for distributing content.

3. Creating groups for distribution
06:40

This lesson focuses on the creation of dashboards and the optimization of datasets for the use of the Power BI services's Q&A feature.

4. Dashboards and Q&A
07:53

In this video, you will learn the technique provided by the Power BI service for sharing dashboards, which lands the dashboard straight into the workspace of another user.

5. Sharing dashboards with your organization
04:13

This lecture discusses the main mechanism used in the Power BI service for sharing dashboard, reports and datasets within an organization; the content pack.

6. Creating content Packs
04:39

In this video, we will discuss the use of the Power BI service's Publish to web feature to share reports with a wider audience, including those who are not Power BI subscribers.

7. Publishing reports to the web
03:46

In this lecture, you will learn how to use Power BI's row level security to provide different user experiences, and data, to the consumers of the same report.

8. Row level security
08:38
About the Instructor
Grant Gamble
4.5 Average rating
504 Reviews
13,465 Students
8 Courses
Developer, trainer and author

Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes.

His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI, VBA, web development and Adobe Creative Suite automation.