Udemy

Platform

English

Language

Data & Analytics

Category

Microsoft Power BI - A Complete Introduction [2021 EDITION]

Learn how to use Microsoft's Power BI Tools, including Power BI Desktop, Power BI Pro (Service) and PowerBI Developer

4.54 (42431 reviews)

144439

Students

23.5 hours

Content

Nov 2020

Last Update
$94.99
Regular Price

What you will learn

At the end of this course students will be able to analyse data from different data sources and create their own datasets

Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together

Students will have the required knowledge to dive deeper into Power BI and find out more about its advanced features




Description

[This course was completely updated (= re-recorded) to reflect all the latest Power BI Desktop, Power BI Pro (Service) and Power BI Mobile updates that took place recently. Enjoy this 100% up-to-date course]

---

You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?

Then the Power BI tools are the tools to choose for you!

In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes. 

This is what you will learn:

  • Get to know the different tools of the Power BI universe and learn how to use them

  • Understand Power BI Desktop and its components

  • Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps

  • How to work in the different views of the Data Model

  • How to create calculated columns and measures

  • How to build relationships between different tables

  • How to create a report with different interactive visualization types

  • Learn how to use Power BI Service (= Power BI Pro) to create dashboards and to share and publish your results

  • How to access your results from multiple devices using Power BI Mobile

  • How to create custom visuals using typescript and the Power BI Developer Tools

  • And more!


This is what this course offers, but is this the right course for you?

If you...

  • ...never worked with the Power BI tools before

  • ...have a basic understanding of selected tools of the Power BI universe and want to learn how these tools work together

  • ...want to understand the latest updated version of Power BI Service, including the newly introduced App Workspaces and the creation and publishing of Apps including your dashboards, reports and datasets

  • ..want to understand the basic concepts regarding the creation of customized visuals using the Power BI Developer Tools

...then this is the right course for you.

I would be really happy to welcome you in this course!

Manuel


Screenshots

Microsoft Power BI - A Complete Introduction [2021 EDITION]
Microsoft Power BI - A Complete Introduction [2021 EDITION]
Microsoft Power BI - A Complete Introduction [2021 EDITION]
Microsoft Power BI - A Complete Introduction [2021 EDITION]

Content

Getting Started

Welcome to this Course

Understanding the Power BI Tools

Join our Online Learning Community

Initial Project 1/3: Installing Power BI Desktop and Connecting to Data

Important: The "Locale" Used in This Course

Initial Project 2/3: Working in the Query Editor

Initial Project 3/3: Working in the Data Model and Creating a Visualization

Course Outline

How to use the Attached Project Files

An Introduction to Power BI Desktop

An Overview of the Workflow in Power BI Desktop

Introducing the Different Views of the Data Model

Taking a Closer Look at the Query Editor Interface

Important! Before we Dive Deeper: Required Power BI Settings

Course Slides

An Introduction to the Query Editor

Just to be sure: What is the Query Editor?

Before we Start - About the Attached Project Files

Connecting Power BI Desktop to our Data Sources

Editing Rows

Understanding Append Queries

Editing Columns

Replacing Values

Formatting Data

Pivoting and Unpivoting Columns

Splitting Columns

Creating a New Group for our Queries

What we Achieved until Now and How to Continue

Introducing the Star Schema

Duplicating and Referencing Queries

Creating the DIM Region Table

Entering Data Manually

Merging Queries

Finishing the DIM Region Table

Introducing the DIM AgeGroup Table

Creating an Index Column

Duplicating Columns and Extracting Information

Creating Conditional Columns

Creating the FACT Population Table

Performing Basic Mathematical Operations

Improving Performance and Loading Data into the Data Model

Module Summary

[OPTIONAL] Assignment Instructions

[OPTIONAL] Assignment Solution

Working on our Data Model: Data & Relationship View

Module Introduction

Query Editor vs. Data Model

Introducing and Understanding Relationships

Editing Relationships

Understanding Cardinality

Cross Filter Selection and Many-To-Many Relationships

Active Properties

Understanding the differences between the M-Language and DAX

M vs. DAX applied: Calculated Columns

M vs. DAX: Conclusion

DAX - Basic information

DAX and Calculated Columns

Calculated Columns vs. Measures

Introducing DAX-Measures

DAX-Measures Continued

Categorizing Data

Module Summary

[OPTIONAL] Assignment Instructions

[OPTIONAL] Assignment Solution

Working in the Report View to Visualize our Results

Module Introduction

Understanding the Interface of the Report View

Creating our First Visualizations

Editing Interactions and Adding Tooltips

Adding Data Colors & Understanding Conditional Formatting

Understanding Hierarchies and Adding Drill-Down

Formatting Charts and Sorting

About the Slicer

Introducing Slicers

Adding Treemaps and Tables

Applying different Filter Types

Creating (Multi-Row) Cards

Understanding Combined Visualizations and Waterfalls

Module Summary

[OPTIONAL] Assignment Instructions

[OPTIONAL] Assignment Solution

One Last Thing: Additional Features

Power BI Service & Power BI Mobile - How to Continue?

Module Introduction

Continuing our Work and why we need Power BI Service

Comparing Power BI Free, Pro and Premium

Logging in to Power BI Service

Understanding the Interface

Importing our Data from Power BI Desktop to Power BI Service

Understanding the Dataset Menu

Working on Reports

Introducing Dashboards

Exploring our Workspace

Understanding Gateways

Comparing Personal and On-Premise Gateway and Installing a Gateway

Working alone or Collaborating with Colleagues

Collaborating in App Workspaces

Sharing the Results

Publishing the App

Content Packs from Online Services

Power BI Mobile: Installing and Understanding the Mobile App

One Last Thing: Excluding Datasets from Sharing

Module Summary

Other Data Sources

Module Introduction

Importing JSON Data

Importing Data from REST APIs

Preparation: Setting up a MySQL Server

Importing Data from a MySQL Server (and other SQL Servers)

Wrap Up

Creating Custom Visuals (Power BI for Developers)

Developer Prerequisites

Module Introduction

How do Custom Visuals Work?

Using Data Driven Documents (D3)

Please Read - Creating & Installing a Certificate

Creating and Using a Visual

Installing an IDE (Code Editor)

Understanding the visuals.ts File

Understanding the Project Structure

Installing d3.js (Data Driven Documents)

Adding a First Shape

Connecting Shapes to Data

Scaling Shapes

Managing Visual Capabilities to Allow Data Input

Starting the Data Extraction

Limiting the Data Input

Extracting Data

Displaying the User Data

Optimizing the Code

Adding Dynamic Coloring

Making Bars Selectable (Cross-Visual)

Adding X-Axis Labels

Adding Custom Visuals Settings

Extracting the Visual Configuration

Informing Power BI About the Custom Configuration

Next Steps

Packaging the Custom Visual

Wrap Up

Further Resources

Course Roundup

Congratulations

Bonus: More Content!

Bonus: Selected Features by Example & Refresher Project

About this Module

Understanding Column from Examples

Group By, Big Data & DAX Studio

Please Read: Bonus Project Introduction

Taxi Project - Query Editor

Taxi Project - Data Model & Visuals

Taxi Project - Power BI Service



Reviews

K
Kevin8 October 2020

Everything was super easy to follow and I love how I onloy have to download the sources once for a lot of the sections. One thing I did not enjoy is that I do not have enough ram so loading the data sets are not as fast as the video and had to go over a few of those instructions again because I was lagging behind. Had to pause a few of them to catch up. Loved this course, it was great.

A
Andre8 October 2020

The instructor is very clear. I am a novice so need it to be clear. Also very interactive which I believe it needs to be. Finally, the instructor explains everything in detail which is important for a novice.

J
Jakub1 October 2020

I've chosen this course mainly because of it's 22+hours duration. In fact it's around 10hour long, the remaining part is a old version/repeated course. It's important to mention I believe. Overall it was one good course.

A
Ajay30 September 2020

too many different files, no continuation. Instructor goes on a very fast pace, should understand as this course if for beginners who are yet to explore Power Bi. Very disappointed with the structure and instructor.

V
Vee29 September 2020

lovely and clear instruction and really great content, i am familiar with power bi and power query and am learning things already

S
Sanat29 September 2020

I thoroughly enjoyed taking this course. Aside from the perks and benefits of being able to move at my own pace which allowed me to accommodate my schedule and obligations, Manuel and Maximilian did a phenomenal job with the execution and and delivery. They were clear, concise, comprehensive, and ensured to show us applicable uses for the lessons and tips that they covered. I have already recommended this course to couple of my friend, and without a doubt I will continue to do so. The experience was great, and thank you for being such a great instructor.

A
Alisha28 September 2020

Yes, it was a good experience. I was hoping for individual assignments etc that could be graded?. but its great value for money and definitely worth the time

N
Neha27 September 2020

so far seems precise and to the point. great content and easy to understand. hope this continues as we progress to other sections.

R
Renan25 September 2020

So far the course has been very good. The instructor explains very well and seems very knowledgeable of the topic

M
Michael26 February 2020

I've never used Power BI before and so far it's easy to follow and interesting. I'm nervous but excited to dig into this even more.

S
Saurabh23 February 2020

Well explained with all the reference likes and resources. Very Good Job. Above Expectation. Both the Tutor are amazing.

S
Stefano21 February 2020

Definitely what I expected from this course. Looking forward to see more advanced features such as data cleansing and analytics tools

V
Venkata20 February 2020

During the initial stage I have zero knowledge on Power BI before I start this course but now I'm fully confident and this course helped me a lot. Thanks for the instructor. one thing I must say this is the course from Zero to Hero in Power BI

C
Cosmos18 February 2020

This course deserves all the stars, the instructors are great and they take the time to explain the course

S
Sandip18 February 2020

The course is of course above expectations. I didn't expected it to be precise and detailed. It was fun to learn this POWER BI course and kept my focus to the content.


Coupons

StatusDateDiscount
Expired12/29/201994% OFF
Expired5/27/202095% OFF
Expired9/14/202093% OFF
Expired12/17/202095% OFF


1208634

Udemy ID

5/8/2017

Course created date

6/8/2019

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram
Android PlayStore
Apple Appstore