Home

All courses

Microsoft Power BI - The Practical Guide 2024

Business

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power BI - The Practical Guide 2024

Dive in and learn the Power BI tools! Learn Data Analysis & Visualization and more in Power BI Desktop & Power BI Pro!

4.6

(74981)

306030 enrolled on this course

Last updated 11/2021

Manuel Lorenz

₹ 3999.0

₹ 5499.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

This course turned more than 250.000 students into Power BI professionals and was specifically created for
business users
who need to learn fast, comprehensive and efficient to get the job done!
-
In the course you can take
two paths
:
- The
Complete Path
(full >15h course also teaching more advanced concepts & features)
- The
Summary Path
(2h crash course to master Power BI as quick as possible)
Both approaches will teach you Power BI in great detail and turn you into a Power BI professional.
You decide
what learning type you are - it’s your choice!
-
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
Learn how to filter and format data, how pivoting and unpivoting works
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 Pro
to create dashboards and to share and publish your results
How to access your results from multiple devices using
Power BI Mobile
And more!
Don't miss this opportunity to become a Power BI expert today! Enrol now, unlock your potential & transform your career today!
Who this course is for:
People who never worked with Power BI and who want to understand how to use these tools
Anyone who is interested in learning how to connect the different Power BI tools with each other
People who want to understand how to create customized visuals with the Power BI Developer tools

What you'll 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

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Getting Started

1.1-Welcome to This Course

1.2-What is Power BI?

1.3-Installing Power BI Desktop

1.4-Connecting Power BI Desktop to Source Files

1.5-Creating our First Visuals

1.6-Join our Online Learning Community

1.7-Comparing Excel & Power BI

1.8-Course Outline

1.9-The Two Ways (Paths) Of Taking This Course

1.10-How to Get the Most Out of This Course

1.11-Important: How to Access Course Resources, Project Files & Slides

2-Understanding the Power BI Desktop Basics & Preparing the Course Project

2.1-Module Introduction

2.2-The Power BI Desktop Workflow

2.3-Interface Tour

2.4-Important! Creating the Project Template & Recommended Settings

3-Data Preparation in the Power Query Editor

3.1-Module Introduction

3.2-Understanding Data Preparation / Cleaning / Cleansing

3.3-Connecting Power BI Desktop to Source Files

3.4-How Power BI Queries Data

3.5-Understanding Basic Row Operations

3.6-Filtering Data

3.7-Analyzing Columns & Removing Blank Fields

3.8-Understanding & Using the Append Feature

3.9-Choosing & Removing Columns

3.10-Append Behind the Scenes

3.11-Understanding the Transpose Feature

3.12-Replacing Values

3.13-Working with Dates - The Basics

3.14-Understanding Data Formats

3.15-Handling Data Format Errors

3.16-Understanding Pivoting & Unpivoting

3.17-Applying Pivoting & Unpivoting

3.18-Fixing a Sorting Problem

3.19-Extracting Data, Splitting Columns & Sorting Multiple Columns

3.20-Introducing the "Group By" Feature

3.21-Improving the Project Structure

3.22-Wrap Up

4-Data Transformation in the Power Query Editor

4.1-Module Introduction

4.2-Data Warehouse, Data Model & Data Schema

4.3-The Star Schema - Theory

4.4-Applying the Star Schema to our Project

4.5-Understanding References

4.6-Comparing References & Duplicates

4.7-Importing Country & Region Codes

4.8-Using "Enter Data" to Create a Table

4.9-Understanding the Merge Feature

4.10-How to Join Tables

4.11-Understanding Outer, Inner & Anti Joins

4.12-Join Kind in Practice

4.13-Handling Merge Errors

4.14-Understanding the DIM-age Table

4.15-Bringing Back the "age-group" Column

4.16-Getting the Maximum Values From Each Age Group

4.17-Creating Conditional Columns

4.18-Creating an Index Column

4.19-Creating a DIM-gender Table

4.20-Understanding the FACT Table

4.21-Finishing the FACT Table

4.22-Applying Basic Mathematical Operations

4.23-Using the Enable Load Feature

4.24-Wrap Up

4.25-Time to Practice - Query Editor

5-The Data Model: Working with Relationships & DAX (Data Analysis Espressions)

5.1-Module Introduction

5.2-Query Editor vs Data Model

5.3-Understanding Relationships

5.4-Creating our First Relationship

5.5-Understanding Cardinality & Difference Relationship Types

5.6-One to Many & Many to One

5.7-One to One

5.8-Many to Many

5.9-Fixing the Column Order Bug

5.10-Understanding the Cross Filter Direction

5.11-Understanding Active Properties

5.12-Adding Relationships to the Project

5.13-M-Language vs DAX (Data Analysis Expressions)

5.14-Creating a Custom Column with the M-Language

5.15-Creating a Calculated Column with DAX

5.16-M vs DAX - What Should I Choose?

5.17-The DAX Basics

5.18-The Core DAX Syntax

5.19-DAX Data Types

5.20-DAX Operators

5.21-DAX Core Functions

5.22-Creating a Table with the CALENDAR Function

5.23-Extracting Data with the DOT Notation

5.24-Adding & Dividing Columns

5.25-Working with IF Functions

5.26-Understanding Relationship Functions

5.27-Calculated Column vs Measure

5.28-Understanding & Creating Measures

5.29-Working with FILTER & CALCULATE Functions - Theory

5.30-Combining CALCULATED & FILTER Functions

5.31-Adding the Filter Condition to CALCULATE

5.32-Using Measures in Measures

5.33-Changing the Measure's Home Table

5.34-Understanding the Data Category

5.35-Wrap Up

5.36-Time to Practice - Data Model & Relationships

6-Creating Visuals in the Report View

6.1-Module Introduction

6.2-The Power BI Workflow & Understanding Basics Visual Elements

6.3-Creating & Duplicating Pages

6.4-Organizing Visuals

6.5-Creating a New Visual

6.6-Creating Line & Column Charts

6.7-How FILTER Affects the Visual

6.8-Understanding Interactions

6.9-Hierarchies & Drill Down

6.10-Formatting Chart Colors

6.11-The Canvas

6.12-Formatting the Page Background / Wallpaper

6.13-Formatting the Filter Pane & Filter Cards

6.14-Formatting Visuals: General Settings

6.15-Diving Deeper Into Formatting Visuals

6.16-Working with Report Themes

6.17-Finishing the Report Theme

6.18-Understanding the Slicer

6.19-Default Summarization & Sorting Order

6.20-Creating Treemaps & Working with Multiple Slicers

6.21-Creating Tables

6.22-Syncing Slicers

6.23-Filter on Visual, Page & Report Level

6.24-Creating Single & Multi Row Cards

6.25-Adding a Secondary Y-Axis

6.26-Combining Column & Line Charts

6.27-The Waterfall Chart

6.28-Importing Visuals

6.29-Finishing Touches

6.30-Wrap Up

6.31-Time to Practice - Visualizations

7-Power BI Pro & Mobile: Sharing & Collaborating with Workspaces & Apps

7.1-Module Introduction

7.2-The Next Steps

7.3-Power BI Pro Pricing

7.4-Power BI Pro Interface Tour

7.5-Publishing & My Workspace - Theory

7.6-Publishing / Importing Power BI Desktop Projects to Pro

7.7-Datesets Walkthrough

7.8-List View vs Lineage View

7.9-Exploring Reports In Pro

7.10-Understanding Dashboards

7.11-Creating Reports & Dashboards

7.12-Diving Deeper Into "My Workspace", Understanding Refresh and a Refresh Error

7.13-Gateways - Theory

7.14-Gateways: Configuring Manual & Scheduled Refreshs

7.15-Sharing Data From "My Workspace" via Direct Access

7.16-Sharing Links

7.17-Understanding Collaboration Workspaces - Theory

7.18-Creating Colaboration Workspaces

7.19-Sharing Data via Apps

7.20-Publishing & Unpublishing Apps

7.21-Deleting Collaboration Workspaces

7.22-Workspaces vs Apps

7.23-Working with Power BI Mobile

7.24-Wrap Up

8-Other Data Sources

8.1-Module Introduction

8.2-Importing JSON Data

8.3-Updated Star Wars API URL

8.4-Importing Data from REST APIs

8.5-Preparation: Setting up a MySQL Server

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

8.7-Wrap Up

9-How to Stay Up-to-Date in the Power BI World?

9.1-Module Introduction

9.2-Helpful Resources

9.3-Using Preview Features

10-Course Round Up

10.1-Congratulations! What you Learned & How to Continue

11-Optional: Power BI Desktop Crash Course / Introduction & Summary

11.1-Module Introduction

11.2-Project Setup

11.3-Connecting Power BI Desktop to the Source Files

11.4-Query Editor Walkthrough

11.5-Removing Blank Rows & Fixing Format Errors

11.6-Saving the Project

11.7-Duplicates vs References

11.8-Appending Queries

11.9-Splitting Columns & Extracting Data

11.10-Basic Column Interactions

11.11-Data Modelling Theory

11.12-Creating the "Orders" Table

11.13-Working with Indexes

11.14-The Formula Bar

11.15-Merging Queries

11.16-Loading Data Into the Data Model

11.17-Creating Line Charts

11.18-Understanding Relationships

11.19-Formatting Numbers in Charts

11.20-Understanding Interactions

11.21-Hierarchies & Drill-Down

11.22-Sorting Axis Values

11.23-Formatting Visuals & Applying Report Themes

11.24-Reports, Map Visual & Default Summarization

11.25-The Data Category

11.26-Applying Filters to Visuals

11.27-Understanding Slicers

11.28-Creating Tables

11.29-Working with DAX ("Data Analytics Expressions")

11.30-Sorting Weekdays with Calculated Columns

11.31-Fixing the Revenue Calculation

11.32-Introducing Measures

11.33-Working with Quick Measures

12-Bonus: Selected Features by Example & Refresher Project

12.1-About this Module

12.2-Understanding Column from Examples

12.3-Group By, Big Data & DAX Studio

12.4-Please Read: Bonus Project Introduction

12.5-Taxi Project - Query Editor

12.6-Taxi Project - Data Model & Visuals

12.7-Taxi Project - Power BI Service

13-This Course Was Completely Updated

13.1-Old Course Content Download

14-Course Roundup

14.1-Course Roundup

14.2-Bonus: More Content!

Course Categories

Popular Courses

Microsoft Power BI - The Practical Guide 2024

Description

What you'll learn

Requirements

Course Content

You May Like