Udemy

Platform

English

Language

Data & Analytics

Category

Power BI Essentials 2021: Comprehensive Power BI Training

Microsoft Power BI Online Training: Comprehensive Course on Power BI Desktop, Power BI service & Power BI mobile

4.55 (1947 reviews)

Students

21 hours

Content

Aug 2021

Last Update
Regular Price


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


Description

The comprehensive introduction to Microsoft Power BI, fully updated for 2021 and covering many of the topics required for the exam DA-100.

Master  Power BI Desktop, the Power BI service & Power BI mobile. This user-friendly course is designed to familiarize you with Microsoft Power BI’s  business intelligence capabilities in the most logical order.

The course consists of 30 sections, arranged into seven groups that reflect the way in which Microsoft Power BI works and the order in which operations are carried out: Getting Started, Connecting to Data, Data Wrangling, Data Modelling, DAX formulas, Visualization, and Publishing & Sharing.

Each of the 30 sections in this course starts with an overview and ends with a section summary which recaps the key topics covered and reminds you where these techniques fit into the overall Microsoft Power BI cycle.

So, take your time and work your way slowly but surely through the course material; and when you’re done, you should find that you know Micrososft Power BI pretty well.

INTERACTIVE  PDF

The course also includes a fully interactive PDF file containing hundreds of backlinks to the exact point in the video where that topic was discussed.

EXAM DA-100 COVERAGE AND MAPPING

Although this course is aimed at beginners, it covers a lot of the topics required for the Microsoft DA-100 exam. At the end of each section, we'll highlight which topics have been covered, so you can start checking them off your list.

CUSTOMIZABLE COURSE DURATION

If you are too busy to complete the whole course straightaway, no problem. We have shortened versions of the course created for people just like you.

There are three of these shortened courses.

The Executive Overview course (6 hours) is designed for users who want to get up to speed on Power BI as quickly as possible, without going into too much detail.

The Report Developer course (6 hours) will suit anyone who will be focusing on creating Power BI reports based on datasets created by their IT department or by other colleagues.

And the Dataset Developer course (9 hours) is for people in the opposite camp, those who will be responsible for developing datasets from which their colleagues can build reports.

GETTING STARTED

The first group of sections is, naturally enough, Getting Started. This is where you’ll get up and running and download all of the resources you’ll need; and where you’ll get an overview of the Power BI product, Microsoft Power BI tenants and Power BI licenses.

CONNECTING TO DATA

Then we dive straight into using Power BI and the first business intelligence skill you need to master: connecting to data sources.

In these five sections, you’ll learn how to bring data into Power BI from Text Files, CSVs and Excel Files; as well as how to connect to a Folder of Data, either on your own file system or in a SharePoint library, and automatically combine all the files inside the folder into a single table.

You’ll also learn how to Connect to data on websites and how to scrape data from the web page itself.

And, naturally, you’ll get plenty of practice in connecting to Power BI’s most frequent data partner: SQL Server. You’ll learn how to work in import, DirectQuery and composite modes and how to retrieve data from both views and database tables, as well as by executing SQL statements.

DATA WRANGLING

Once you’re comfortable with getting data into Power BI, we’ll move on to the next stage in the Power BI cycle: Data Wrangling.

It’s very rare that the data you connect to is already optimized for reporting; so our four sections on data cleansing and transformation will fully familiarize you with using Power Query, the utility built into Power BI whose user-friendly interface allows you to carry out powerful and sophisticated transformation with just a few mouse clicks, as well as how to edit the underlying M language code generated by the interface.

DATA MODELLING

After mastering the first two steps in your Power BI journey, connecting to data and data cleansing, you’ll be ready to move on to the next stage: data modelling.

In this group of sections, you’ll learn how to combine the various tables that you need into a single entity called a data model.

DAX FORMULAS

Having created a data model, our next group of sections focuses on using the DAX language to add insights and enhancements.

We’ll look at the three types of calculation which you can create using the DAX language:

Calculated columns

Calculated tables

And measures

And we’ll get to grips with the most important function in the DAX language: the CALCULATE function.

And we’ll end the section by looking at DAX time intelligence functions which enable you to compare calculations based on different time periods, to provide such insights as year-on-year growth and year to date sales.

VISUALIZATION

Once we have built our data model, we’ll move on to the next phase in the Power BI development cycle: visualization and report creation.

We’ll start with what I like to call the big-picture visuals, those which give your audience with key metrics at a glance. As you’ll see in this section Power BI has three big picture visuals: the card, the KPI visual and the gauge.

And, of course, we’ll talk about many other visuals and visualization techniques as we work through these sections.

We’ll even look at using DAX measures to enhance the user experience by making titles change dynamically as users interact with them.

PUBLISHING AND SHARING

OK, so now we have a report, in our last group of sections, we will look at how we can make our content available to our intended audience.

First, we’ll look at publishing from Power BI Desktop into the Power BI service.

Then, you’ll learn how to create dashboards in the Power BI service and the different ways of adding content to them.

You’ll learn how to create app workspaces and how to grant access to fellow report developers, so that your team can collaborate on the creation of content; and how the different strategies for sharing that content throughout the entire organisation.

And, in our section on Power BI mobile, you’ll learn how to create reports and dashboards which are optimised for mobile viewing.


Screenshots

Power BI Essentials 2021: Comprehensive Power BI Training
Power BI Essentials 2021: Comprehensive Power BI Training
Power BI Essentials 2021: Comprehensive Power BI Training
Power BI Essentials 2021: Comprehensive Power BI Training

Content

1. Welcome

1. Welcome to Microsoft Power BI Introduction

2. Downloading the course files

2. Getting Started

1. The Power BI product

2. Using the Query Editor in Power BI Desktop

3. Creating a report in Power BI Desktop

4. Publishing a report to the Power BI service

5. Creating app workspaces

6. Creating dashboards

7. Publishing an app

8. The Power BI mobile experience

9. Connecting to GitHub in the Power BI Service

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

Quiz

3. Connecting to Data Sources

1. Connecting to CSV files

2. Connecting to Excel data

3. Connecting to a Folder of data

4. Connecting to a web URL

5. Connecting to web page content

6. Connecting to a Microsoft Access database

4. Cleaning up and transforming data

1. Trim, Clean and Case

2. Renaming and adding metadata

3. Splitting columns

4. Removing rows

5. Replace Values

7. Unpivot Columns

8. Rearranging columns

9. Creating custom columns

10. Append queries

11. Merge queries

12. Grouping data

5. Data modelling

1. Adding data to the data model

2. Examining the data model

3. Creating relationships automatically

4. Creating relationships manually

5. Creating a composite primary key

6. Creating a date table

7. Creating calculated columns

8. Creating measures

9. Using the SUMX function

10. Using RELATED and RELATEDTABLE

11. Creating a calculated table

6. Creating a Power BI report

1. Overview of report

2. Backgrounds, logos and images

3. Working with themes

4. The card big-picture visual

5. Using visual filters

6. Using the format painter

7. Gauges and targets

8. Creating bar charts

9. Editing visual interactions

10. Using slicers

11. Using the treemap visual

12. Creating a map visual

13. Date hierarchies and drill-down

14. Using time intelligence functions

7. Sharing and Collaborating

01-Creating Users in the Power BI service

2. Creating groups for collaboration

3. Creating groups for distribution

4. Dashboards and Q&A

5. Sharing dashboards with your organization

6. Creating content Packs

7. Publishing reports to the web

8. Row level security


Reviews

Z
Zachary27 August 2020

Very clear and easy to understand walk through. Stays very basic, would be interested to see a Google Analytics section.

K
Kiran26 August 2020

This course helped me a lot in creating an important dashboard quickly. Trainer explained tips and tricks in an easily understandable way with good examples and his voice narration was just awesome.

R
Rogério18 August 2020

sim está dentro das minha expetativas, apesar de ter como base versões antigas do Power BI. É de lamentar que a legendagem tenha sido feita de modo automático sem posterior validação. Por vezes são exibidas algumas aberrações linguísticas \ contextuais.

D
Dorn16 July 2020

Yes, but navigating back to the start was unnecessarily difficult after having gone out to download practice data and mistakenly closed the main window.

A
Anthony18 June 2020

Power BI/APPS were suggested by my supervisor at the beginning of the year as on of my development goals.

P
Pascal26 February 2020

Should be five star, but a little difference because with the currenct version of Power BI Desktop. I recommend this cours for beginners for starting their journey with Power BI

G
Greg14 February 2020

Content was good and very helpful in learning the basics of PowerBI. there was some background noise that was distracting as well as monotone in voice which cause me to lose focus sometimes.

D
Dianne22 January 2020

sometimes I feel as though he goes through some of the processes too quickly. I am just stopping the video and then moving forward once I have the correct area updated.

M
Mary27 December 2019

As that I need to learn the practical (what to click on and how to use) for Power BI, I'm very thankful that Mr. Gamble shows how to use Power BI from getting data and onward.

L
Lakhtey14 December 2019

Certainly it has been a good learning experience but had blur contents in some sections and the quality of videos was also compromised.

R
Rocio7 December 2019

My ONLY complain about this course is how slow the instructor talks, I saw it on 1.75 and it was still slow, but that's a me problem. For the rest: it's great! The information is very valuable, he goes all the way with the explanation, there's no extra data that's not important made only to get more course hours. As someone who works with Power BI this was great to see a few more features and re-understand some concepts.

T
Thomas11 November 2019

I really liked this course since it quickly helped me to understand the basics of Power BI. After having taken this course I feel confident enough to begin creating dashboards myself. Unfortunately there are many issues with the audio in this course which is at times quite disturbing.

B
Bindu22 October 2019

It was indeed one of the best training which has given detailed information on the concepts and practical application of the Power BI tool.

A
Andrew9 October 2019

The course content was fine, however, the audio and video should have been recorded with much higher quality. The child or macaw in the background and the mechanical keyboard are impossible to forget.

M
Muthumeenal25 September 2019

its good for beginners:)Easy to understand . clearly explained. Covered all the Essentials for beginners.


1184840

Udemy ID

4/18/2017

Course created date

11/22/2019

Course Indexed date
Bot
Course Submitted by