Microsoft Power BI – A Complete Introduction

Microsoft Power BI – A Complete Introduction
Microsoft Power BI – A Complete Introduction
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 10 Hours | 1.70 GB

Learn how to use Microsoft’s Power BI Tools, including Power BI Desktop, Power BI Service and PowerBI Developer

You want to analyze data from single or multiple sources? You want to create your individual dataset based on these sources and transform your results into beautiful and easy-to-make visualizations? Moreover, you want to share your results with your colleagues or collaborate on your project? 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
  • 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 service to create dashboards and to share and publish your results
  • How to access your results from multiple devices using Power BI Mobile
  • How to create custom visuals using typescript and the Power BI Developer Tools
  • And more!
Table of Contents

Getting Started
1 Welcome to this Course
2 Understanding the Power BI Tools
3 Initial Project 13 Installing Power BI Desktop and Connecting to Data
4 Important The Locale Used in This Course
5 Initial Project 23 Working in the Query Editor
6 Initial Project 33 Working in the Data Model and Creating a Visualization
7 Course Outline
8 How to use the Attached Project Files

An Introduction to Power BI Desktop
9 An Overview of the Workflow in Power BI Desktop
10 Introducing the Different Views of the Data Model
11 Taking a Closer Look at the Query Editor Interface
12 Before we Dive Deeper Recommended Settings
13 Course Slides

An Introduction to the Query Editor
14 Just to be sure What is the Query Editor
15 Splitting Columns
16 Creating a New Group for our Queries
17 What we Achieved until Now and How to Continue
18 Introducing the Star Schema
19 Duplicating and Referencing Queries
20 Creating the DIM Region Table
21 Entering Data Manually
22 Merging Queries
23 Finishing the DIM Region Table
24 Introducing the DIM AgeGroup Table
25 Before we Start – About the Attached Project Files
26 Creating an Index Column
27 Duplicating Columns and Extracting Information
28 Creating Conditional Columns
29 Creating the FACT Population Table
30 Performing Basic Mathematical Operations
31 Improving Performance and Loading Data into the Data Model
32 Module Summary
33 Connecting Power BI Desktop to our Data Sources
34 Editing Rows
35 Understanding Append Queries
36 Editing Columns
37 Replacing Values
38 Formatting Data
39 Pivoting and Unpivoting Columns

Working on our Data Model Data & Relationship View
40 Module Introduction
41 M vs. DAX Conclusion
42 DAX – Basic information
43 DAX and Calculated Columns
44 Calculated Columns vs. Measures
45 Introducing DAX-Measures
46 DAX-Measures Continued
47 Categorizing Data
48 Module Summary
49 Query Editor vs. Data Model
50 Introducing and Understanding Relationships
51 Editing Relationships
52 Understanding Cardinality
53 Cross Filter Selection and Many-To-Many Relationships
54 Active Properties
55 Understanding the differences between the M-Language and DAX
56 M vs. DAX applied Calculated Columns

Working in the Report View to Visualize our Results
57 Module Introduction
58 Adding Treemaps and Tables
59 Applying different Filter Types
60 Creating (Multi-Row) Cards
61 Understanding Combined Visualizations and Waterfalls
62 Module Summary
63 One Last Thing Additional Features
64 Understanding the Interface of the Report View
65 Creating our First Visualizations
66 Editing Interactions and Adding Tooltips
67 Adding Data Colors
68 Understanding Hierarchies and Adding Drill-Down
69 Formatting Charts and Sorting
70 About the Slicer
71 Introducing Slicers

Power BI Service & Power BI Mobile – How to Continue
72 Module Introduction
73 Exploring our Workspace
74 Understanding Gateways
75 Comparing Personal and On-Premise Gateway and Installing a Gateway
76 Working alone or Collaborating with Colleagues
77 Collaborating in App Workspaces
78 Sharing the Results
79 Publishing the App
80 Content Packs from Online Services
81 Power BI Mobile Installing and Understanding the Mobile App
82 One Last Thing Excluding Datasets from Sharing
83 Continuing our Work and why we need Power BI Service
84 Module Summary
85 Comparing Power BI Free, Pro and Premium
86 Logging in to Power BI Service
87 Understanding the Interface
88 Importing our Data from Power BI Desktop to Power BI Service
89 Understanding the Dataset Menu
90 Working on Reports
91 Introducing Dashboards

Other Data Sources
92 Module Introduction
93 Importing JSON Data
94 Importing Data from REST APIs
95 Preparation Setting up a MySQL Server
96 Importing Data from a MySQL Server (and other SQL Servers)
97 Wrap Up

Creating Custom Visuals (Power BI for Developers)
98 Developer Prerequisites
99 Installing d3.js (Data Driven Documents)
100 Adding a First Shape
101 Connecting Shapes to Data
102 Scaling Shapes
103 Managing Visual Capabilities to Allow Data Input
104 Starting the Data Extraction
105 Limiting the Data Input
106 Extracting Data
107 Displaying the User Data
108 Optimizing the Code
109 Module Introduction
110 Adding Dynamic Coloring
111 Making Bars Selectable (Cross-Visual)
112 Adding X-Axis Labels
113 Adding Custom Visuals Settings
114 Extracting the Visual Configuration
115 Informing Power BI About the Custom Configuration
116 Next Steps
117 Packaging the Custom Visual
118 Wrap Up
119 Further Resources
120 How do Custom Visuals Work
121 Using Data Driven Documents (D3)
122 Creating and Using a Visual
123 Creating & Installing a Certificate
124 Installing an IDE (Code Editor)
125 Understanding the visuals.ts File
126 Understanding the Project Structure

Course Roundup
127 Congratulations