Description
Video description
Discover how to use Microsoft’s Power BI tools, including Power BI Desktop, Power BI Pro (Service), and Power BI Developer
About This Video
Get to grips with the different tools in the Power BI ecosystem and learn how to use them
Analyze data from different data sources and create datasets
Learn how to use Power BI Pro to create dashboards and to share and publish your results
In Detail
Whether you want to analyze data from single or multiple sources or create impressive visualizations from datasets and share your results with colleagues, Power BI is the tool that will help you achieve your business intelligence goals. With this video course, you will learn how to use Power BI’s set of business intelligence tools effectively.
The course starts by taking you through the course objectives and introducing you to Power BI Desktop. Next, you will connect Power BI to various source types using the Query Editor, understand the data model, and add relationships between different tables. Moving ahead, you will create visuals in the report view and share your work with colleagues and others using Power BI Pro.
As you advance, you will get prepared to import data from sources such as JSON, REST APIs, and MySQL Server. Later, you will explore tips to stay ahead in the Power BI world and create custom visuals using TypeScript and Power BI Developer tools. Toward the end, you will test your skills by working through interesting projects and reinforcing your knowledge by revising old topics in Power BI.
By the end of this course, you will be able to analyze data from different data sources and create their own datasets, be able to comfortably work with the different tools of the Power BI universe, and know how the different tools work together.
Audience
This course is designed for anyone who has never worked with Power BI and wants to understand how to use the different tools; those interested in learning how to connect the different Power BI tools with each other; and others who want to understand how to create customized visuals with Power BI Developer tools. A basic understanding of data analysis will be beneficial but is not mandatory.
Table of contents
Chapter 1 : Getting Started
Welcome to This Course
Module Introduction
What Is Power BI?
Installing Power BI Desktop
Connecting Power BI Desktop to Source Files
Creating Our First Visuals
Comparing Excel and Power BI
Course Outline
How to Get the Most Out of This Course
Important: How to Access Course Resources, Project Files, and Slides
Chapter 2 : Understanding the Power BI Desktop Basics and Preparing the Course Project
Module Introduction
The Power BI Desktop Workflow
Interface Tour
Important! Creating the Project Template and Recommended Settings
Chapter 3 : Data Preparation in the Power Query Editor
Module Introduction
Understanding Data Preparation / Cleaning / Cleansing
Connecting Power BI Desktop to Source Files
How Power BI Queries Data
Understanding Basic Row Operations
Filtering Data
Analyzing Columns and Removing Blank Fields
Understanding and Using the Append Feature
Choosing and Removing Columns
Append Behind the Scenes
Understanding the Transpose Feature
Replacing Values
Working with Dates – The Basics
Understanding Data Formats
Handling Data Format Errors
Understanding Pivoting and Unpivoting
Applying Pivoting and Unpivoting
Fixing a Sorting Problem
Extracting Data, Splitting Columns, and Sorting Multiple Columns
Introducing the “Group By” Feature
Improving the Project Structure
Wrap Up
Chapter 4 : Data Transformation in the Power Query Editor
Module Introduction
Data Warehouse, Data Model, and Data Schema
The Star Schema – Theory
Applying the Star Schema to Our Project
Understanding References
Comparing References and Duplicates
Importing Country and Region Codes
Using “Enter Data” to Create a Table
Understanding the Merge Feature
How to Join Tables
Understanding Outer, Inner, and Anti Joins
Join Kind in Practice
Handling Merge Errors
Understanding the DIM-age Table
Bringing Back the “age-group” Column
Getting the Maximum Values from Each Age Group
Creating Conditional Columns
Creating an Index Column
Creating a DIM-gender Table
Understanding the FACT Table
Finishing the FACT Table
Applying Basic Mathematical Operations
Using the Enable Load Feature
Wrap Up
Chapter 5 : The Data Model: Working with Relationships and DAX (Data Analysis Expressions)
Module Introduction
Query Editor Versus Data Model
Understanding Relationships
Creating Our First Relationship
Understanding Cardinality and Difference Relationship Types
One to Many and Many to One
One to One
Many to Many
Fixing the Column Order Bug
Understanding the Cross Filter Direction
Understanding Active Properties
Adding Relationships to the Project
M-Language Versus DAX (Data Analysis Expressions)
Creating a Custom Column with the M-Language
Creating a Calculated Column with DAX
M Versus DAX – What Should I Choose?
The DAX Basics
The Core DAX Syntax
DAX Data Types
DAX Operators
DAX Core Functions
Creating a Table with the CALENDAR Function
Extracting Data with the DOT Notation
Adding and Dividing Columns
Working with IF Functions
Understanding Relationship Functions
Calculated Column Versus Measure
Understanding and Creating Measures
Working with FILTER and CALCULATE Functions – Theory
Combining CALCULATED and FILTER Functions
Adding the Filter Condition to CALCULATE
Using Measures in Measures
Changing the Measure’s Home Table
Understanding the Data Category
Wrap Up
Chapter 6 : Creating Visuals in the Report View
Module Introduction
The Power BI Workflow and Understanding Basic Visual Elements
Creating and Duplicating Pages
Organizing Visuals
Creating a New Visual
Creating Line and Column Charts
How FILTER Affects the Visual
Understanding Interactions
Hierarchies and Drill Down
Formatting Chart Colors
The Canvas
Formatting the Page Background / Wallpaper
Formatting the Filter Pane and Filter Cards
Formatting Visuals: General Settings
Diving Deeper into Formatting Visuals
Working with Report Themes
Finishing the Report Theme
Understanding the Slicer
Default Summarization and Sorting Order
Creating Treemaps and Working with Multiple Slicers
Creating Tables
Syncing Slicers
Filter on Visual, Page, and Report Level
Creating Single and Multi-Row Cards
Adding a Secondary Y-Axis
Combining Column and Line Charts
The Waterfall Chart
Importing Visuals
Finishing Touches
Wrap Up
Chapter 7 : Power BI Pro and Mobile: Sharing and Collaborating with Workspaces and Apps
Module Introduction
The Next Steps
Power BI Pro Pricing
Power BI Pro Interface Tour
Publishing and My Workspace – Theory
Publishing/Importing Power BI Desktop Projects to Pro
Datasets Walkthrough
List View Versus Lineage View
Exploring Reports in Pro
Understanding Dashboards
Creating Reports and Dashboards
Diving Deeper into “My Workspace”, Understanding Refresh and a Refresh Error
Gateways – Theory
Gateways: Configuring Manual and Scheduled Refresh
Sharing Data from “My Workspace” Through Direct Access
Sharing Links
Understanding Collaboration Workspaces – Theory
Creating Collaboration Workspaces
Sharing Data Through Apps
Publishing and Unpublishing Apps
Deleting Collaboration Workspaces
Workspaces Versus Apps
Working with Power BI Mobile
Wrap Up
Chapter 8 : 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
Chapter 9 : How to Stay Up-to-Date in the Power BI World
Module Introduction
Helpful Resources
Using Preview Features
Chapter 10 : Course Round Up
Congratulations!
Chapter 11 : Bonus – Selected Features by Example and Refresher Project
Understanding Column from Examples
Group By, Big Data, and DAX Studio
Taxi Project – Query Editor
Taxi Project – Data Model and Visuals
Taxi Project – Power BI Service
Reviews
There are no reviews yet.