Microsoft Power BI For Beginners

Language: english

Note: 0/5 (0 notes) 567 students New course

Instructor(s): Charles Smith

Last update: 2022-09-27

What you’ll 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 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
Build bar charts, line charts, cards, donut charts, tables, scatter plots, and maps and identify appropriate data types, as well as common business uses
Format Power BI visualizations and navigate the unique customization options that vary between data visuals
Edit interactions between visuals and layer fields to create drilling and cross-filtering functionality that helps viewers dig for insights

Requirements

For the majority of the course you must have a computer with Windows as operating system
Basic understanding of data analysis is a plus but not required

Description

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!

—

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 Pro, including “My Workspace”, Collaboration Workspaces and Apps

…then this is the right course for you.

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

Who this course is for

Data Engineers
Data Scientists
BI Developers
DataOps Engineers
Data Analysts
DevOps Engineers
Data Architects
Data Visualization Engineers
Solution Architects
System Engineers

Course content

Learning Objectives
- Learning Objectives
Lesson Overview
- Lesson Overview
Lesson Prerequisites
- Lesson Prerequisites
- Query overview in Power BI Desktop
- Shape and combine data in Power BI
Introduction to Data Visualization
- Introduction to Data Visualization
Why is Data Visualization Important?
- Why is Data Visualization Important?
Stakeholders
- Stakeholders
When To Use Data Visualization
- When To Use Data Visualization
Tools & Environment
- Tools & Environment
- Tools & Environment Part 2
- Tools & Environment Part 3
- Tools & Environment Part 4
- Tools & Environment Part 5
Lesson Objectives
- Lesson Objectives
Big Picture
- Big Picture
- Summary
Bar Charts & Line Charts
- Bar Chart Visualization
- What are bar charts and why do they matter?
- Anatomy of a Bar Chart
- Important Bar Chart Components
- The 4 Flavors of Bar Charts
- Four Varieties of Bar Charts
- The 3 Types of Line Chart
- What’s so great about line charts?
- New Terms
Demo: Bar Charts
- Bar Chart Demonstration
Demo: Line Charts
- Line Chart Demonstration
Demo: How Power BI Visualizations Interact with Each Other
- How Power BI Visualizations Interact with Each Other
Cards, Donut Charts, and Tables/Matrices
- Cards
- Cards Summary
- Donut Chart: Pies are Out, Donuts are In
- Donut Charts Summary
- Tables
- Tables Summary
- Tables Vs. Matrices
- Matrices
- New Terms
Demo: Cards
- Cards Demonstration
Demo: Donut Charts
- Donut Charts Demonstration
Demo: Tables & Matrices
- Tables & Matrices Demonstration
Maps
- Maps
- Maps Overview
- Bubble Maps
- Summary
- New Terms
Demo: Bubble Maps
- Bubble Maps Demonstration