English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 204 lectures (17h 38m) | 11.66 GB
Dive in and learn the Power BI tools! Learn Data Analysis & Visualization and more in Power BI Desktop & Power BI Pro!
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 Qery 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!
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
Table of Contents
Getting Started
1 Welcome to This Course
2 What is Power BI
3 Installing Power BI Desktop
4 Connecting Power BI Desktop to Source Files
5 Creating our First Visuals
6 Join our Online Learning Community
7 Comparing Excel Power BI
8 Course Outline
9 The Two Ways Paths Of Taking This Course
10 How to Get the Most Out of This Course
11 Important How to Access Course Resources Project Files Slides
Understanding the Power BI Desktop Basics Preparing the Course Project
12 Module Introduction
13 The Power BI Desktop Workflow
14 Interface Tour
15 Important Creating the Project Template Recommended Settings
Data Preparation in the Power Query Editor
16 Module Introduction
17 Understanding Data Preparation Cleaning Cleansing
18 Connecting Power BI Desktop to Source Files
19 How Power BI Queries Data
20 Understanding Basic Row Operations
21 Filtering Data
22 Analyzing Columns Removing Blank Fields
23 Understanding Using the Append Feature
24 Choosing Removing Columns
25 Append Behind the Scenes
26 Understanding the Transpose Feature
27 Replacing Values
28 Working with Dates The Basics
29 Understanding Data Formats
30 Handling Data Format Errors
31 Understanding Pivoting Unpivoting
32 Applying Pivoting Unpivoting
33 Fixing a Sorting Problem
34 Extracting Data Splitting Columns Sorting Multiple Columns
35 Introducing the Group By Feature
36 Improving the Project Structure
37 Wrap Up
Data Transformation in the Power Query Editor
38 Module Introduction
39 Data Warehouse Data Model Data Schema
40 The Star Schema Theory
41 Applying the Star Schema to our Project
42 Understanding References
43 Comparing References Duplicates
44 Importing Country Region Codes
45 Using Enter Data to Create a Table
46 Understanding the Merge Feature
47 How to Join Tables
48 Understanding Outer Inner Anti Joins
49 Join Kind in Practice
50 Handling Merge Errors
51 Understanding the DIMage Table
52 Bringing Back the agegroup Column
53 Getting the Maximum Values From Each Age Group
54 Creating Conditional Columns
55 Creating an Index Column
56 Creating a DIMgender Table
57 Understanding the FACT Table
58 Finishing the FACT Table
59 Applying Basic Mathematical Operations
60 Using the Enable Load Feature
61 Wrap Up
The Data Model Working with Relationships DAX Data Analysis Espressions
62 Module Introduction
63 Query Editor vs Data Model
64 Understanding Relationships
65 Creating our First Relationship
66 Understanding Cardinality Difference Relationship Types
67 One to Many Many to One
68 One to One
69 Many to Many
70 Fixing the Column Order Bug
71 Understanding the Cross Filter Direction
72 Understanding Active Properties
73 Adding Relationships to the Project
74 MLanguage vs DAX Data Analysis Expressions
75 Creating a Custom Column with the MLanguage
76 Creating a Calculated Column with DAX
77 M vs DAX What Should I Choose
78 The DAX Basics
79 The Core DAX Syntax
80 DAX Data Types
81 DAX Operators
82 DAX Core Functions
83 Creating a Table with the CALENDAR Function
84 Extracting Data with the DOT Notation
85 Adding Dividing Columns
86 Working with IF Functions
87 Understanding Relationship Functions
88 Calculated Column vs Measure
89 Understanding Creating Measures
90 Working with FILTER CALCULATE Functions Theory
91 Combining CALCULATED FILTER Functions
92 Adding the Filter Condition to CALCULATE
93 Using Measures in Measures
94 Changing the Measures Home Table
95 Understanding the Data Category
96 Wrap Up
Creating Visuals in the Report View
97 Module Introduction
98 The Power BI Workflow Understanding Basics Visual Elements
99 Creating Duplicating Pages
100 Organizing Visuals
101 Creating a New Visual
102 Creating Line Column Charts
103 How FILTER Affects the Visual
104 Understanding Interactions
105 Hierarchies Drill Down
106 Formatting Chart Colors
107 The Canvas
108 Formatting the Page Background Wallpaper
109 Formatting the Filter Pane Filter Cards
110 Formatting Visuals General Settings
111 Diving Deeper Into Formatting Visuals
112 Working with Report Themes
113 Finishing the Report Theme
114 Understanding the Slicer
115 Default Summarization Sorting Order
116 Creating Treemaps Working with Multiple Slicers
117 Creating Tables
118 Syncing Slicers
119 Filter on Visual Page Report Level
120 Creating Single Multi Row Cards
121 Adding a Secondary YAxis
122 Combining Column Line Charts
123 The Waterfall Chart
124 Importing Visuals
125 Finishing Touches
126 Wrap Up
Power BI Pro Mobile Sharing Collaborating with Workspaces Apps
127 Module Introduction
128 The Next Steps
129 Power BI Pro Pricing
130 Power BI Pro Interface Tour
131 Publishing My Workspace Theory
132 Publishing Importing Power BI Desktop Projects to Pro
133 Datesets Walkthrough
134 List View vs Lineage View
135 Exploring Reports In Pro
136 Understanding Dashboards
137 Creating Reports Dashboards
138 Diving Deeper Into My Workspace Understanding Refresh and a Refresh Error
139 Gateways Theory
140 Gateways Configuring Manual Scheduled Refreshs
141 Sharing Data From My Workspace via Direct Access
142 Sharing Links
143 Understanding Collaboration Workspaces Theory
144 Creating Colaboration Workspaces
145 Sharing Data via Apps
146 Publishing Unpublishing Apps
147 Deleting Collaboration Workspaces
148 Workspaces vs Apps
149 Working with Power BI Mobile
150 Wrap Up
Other Data Sources
151 Module Introduction
152 Importing JSON Data
153 Updated Star Wars API URL
154 Importing Data from REST APIs
155 Preparation Setting up a MySQL Server
156 Importing Data from a MySQL Server and other SQL Servers
157 Wrap Up
How to Stay UptoDate in the Power BI World
158 Module Introduction
159 Helpful Resources
160 Using Preview Features
Course Round Up
161 Congratulations What you Learned How to Continue
Optional Power BI Desktop Crash Course Introduction Summary
162 Module Introduction
163 Project Setup
164 Connecting Power BI Desktop to the Source Files
165 Query Editor Walkthrough
166 Removing Blank Rows Fixing Format Errors
167 Saving the Project
168 Duplicates vs References
169 Appending Queries
170 Splitting Columns Extracting Data
171 Basic Column Interactions
172 Data Modelling Theory
173 Creating the Orders Table
174 Working with Indexes
175 The Formula Bar
176 Merging Queries
177 Loading Data Into the Data Model
178 Creating Line Charts
179 Understanding Relationships
180 Formatting Numbers in Charts
181 Understanding Interactions
182 Hierarchies DrillDown
183 Sorting Axis Values
184 Formatting Visuals Applying Report Themes
185 Reports Map Visual Default Summarization
186 The Data Category
187 Applying Filters to Visuals
188 Understanding Slicers
189 Creating Tables
190 Working with DAX Data Analytics Expressions
191 Sorting Weekdays with Calculated Columns
192 Fixing the Revenue Calculation
193 Introducing Measures
194 Working with Quick Measures
Bonus Selected Features by Example Refresher Project
195 About this Module
196 Understanding Column from Examples
197 Group By Big Data DAX Studio
198 Please Read Bonus Project Introduction
199 Taxi Project Query Editor
200 Taxi Project Data Model Visuals
201 Taxi Project Power BI Service
This Course Was Completely Updated
202 Old Course Content Download
Course Roundup
203 Course Roundup
204 Bonus More Content
Resolve the captcha to access the links!