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.58 (70422 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
Microsoft Power BI - The Practical Guide 2024
283,558
students
17.5 hours
content
Jan 2024
last update
$124.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

Why take this course?

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!

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

Screenshots

Microsoft Power BI - The Practical Guide 2024 - Screenshot_01Microsoft Power BI - The Practical Guide 2024 - Screenshot_02Microsoft Power BI - The Practical Guide 2024 - Screenshot_03Microsoft Power BI - The Practical Guide 2024 - Screenshot_04

Our review

### Overview of the Power BI Course **Course Rating:** 4.58/5 **Recent Reviews Consensus:** The Power BI course has been highly praised for its layman-friendly approach to teaching complex concepts, making it accessible even to beginners. The content is divided into compact modules, which facilitates a structured learning process. Users have found the knowledge gained from this course to be invaluable, with many emphasizing that the foundational understanding provided can lead to a successful career in data analytics. ### Pros of the Course: - **Layman Terms:** Concepts are explained simply, which is ideal for newcomers to the subject. - **Ease of Learning:** The course is split into compact modules that greatly simplify the learning process. - **Priceless Knowledge:** Many learners feel that the price they paid for the course is negligible compared to the knowledge they gained. - **Guided System Navigation:** It serves as an excellent guide for beginners who are new to the system. - **Recommendation:** The course is highly recommended for its comprehensive and informative content. - **Enthusiastic Instructors:** The instructors' enthusiasm adds a positive bonus to the learning experience. - **Clear and Structured Content:** The course is clear, well-explained, and structured in a way that enhances understanding. - **Engaging Pacing:** The course maintains an engaging pace that allows learners to follow along actively without unnecessary delays. - **Useful Mini Course:** A mini course at the end of the main course provides additional value for faster learning. - **Resourceful Instructor Explanations:** The instructor's explanations are detailed and dynamic, making the class enjoyable. - **Well-Structured and Presented:** The course is well-structured and presented, making it helpful for beginners starting with BI. - **Hands-On Learning:** The ability to work hands-on with data during the course aids in understanding the platform. - **Well Thought Off Content:** The course content, as per previous learners, is well thought out and delivered professionally by Academind. - **Positive Learner Experience:** Many learners report that they are excited about Power BI and find the training enjoyable and fun. ### Cons of the Course: - **Outdated Content:** Some users have pointed out that the course is not up to date with the latest Power BI user interface and functions, which can be misleading if expectations are set for the most current version. - **Explanation Pace:** A few learners found the course to be too slow, with some common knowledge-type explanations taking up time that could have been used for more advanced or less commonly known information. - **User Interface Issues:** Some users mentioned issues with the user interface, such as accidentally hitting the pause button during a task. - **Lack of Projects:** There is a desire for more projects to be included in the course for practical application of skills learned. - **Beautification Focus:** While the course covers details well, there's a suggestion that more work could be done on teaching report beautification techniques. - **Organization Permissions:** One learner had difficulty obtaining permissions from their organization to install PBI Desktop, which could affect their experience with the training. ### Additional Notes: - The course is well-reviewed across a broad spectrum of learners, from those with a SQL background to complete beginners. - The teaching style of Manuel Lorenz has received particular praise for its clarity and engagement. **In Summary:** This Power BI course stands out for its accessible and detailed instruction, making it an excellent choice for those looking to dive into the world of business intelligence. While there are a few areas that could be improved, such as staying current with updates and increasing the number of projects, the course remains highly recommended by the majority of users who have completed it.

Coupons

DateDiscountStatus
12/29/201994% OFF
expired
5/27/202095% OFF
expired
9/14/202093% OFF
expired
12/17/202095% OFF
expired
2/27/202293% OFF
expired
4/27/202294% OFF
expired
9/4/202285% OFF
expired
12/28/202285% OFF
expired
1/3/202388% OFF
expired
5/25/202387% OFF
expired

Charts

Price

Microsoft Power BI - The Practical Guide 2024 - Price chart

Rating

Microsoft Power BI - The Practical Guide 2024 - Ratings chart

Enrollment distribution

Microsoft Power BI - The Practical Guide 2024 - Distribution chart

Related Topics

1208634
udemy ID
5/8/2017
course created date
6/8/2019
course indexed date
Bot
course submited by