English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 25h 43m | 14.8 GB
Learn skills for Microsoft DA-100 certification using the free Power BI Desktop. Learn Power Query, DAX, M and more.
This course covers the content required for the DA-100 certification exam, current as per the DA-100 exam update of 24 September 2021.
Do you already use reporting software such as Access, SSRS, Tableau or WebI? Or is this your first reporting software tool? Either way, welcome.
In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft Power BI certification.
Power BI is one of the most requested reporting tools that are requested in the job market, and the ability to being able to use it now could be very useful for your current work, and your next job hunt.
This course comes in three parts:
Part 1 – Creating Visualizations (also known as Visualize the Data, and Analyze the Data)
We’ll download and install for free Power BI Desktop. We’ll start by creating our first visualizations (vizzes) and investigate the Power BI interface.
We’ll look at the various visualisations available, and go through their common properties. We’ll create maps, hierarchies, KPIs, guages, and all sorts of chart types.
Part 2 – Get and Transform Data (also known as Prepare the Data)
We see how data can be transformed, saving you time in analysing the data. We’ll look at sorting and filtering, split columns, and other transform activities. We’ll merge, append and combine queries together. We’ll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language.
Part 3 – Refining the model (also known as Model the Data)
We’ll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.
Part 4 – Power BI Service
We’ll then publish our visualisations onto the Power BI Service (which you can sign up for free), and then from your reports create dashboards. With the Power BI Pro (for which you can get a free trial), you can also create workspaces and apps.
The course will take around 24 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems.
The course increases in difficulty slowly, so you’ll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.
The course is fairly relaxed – there will be a few “wrong turns”, so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I’ll introduce every component as we go on.
At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves. And if you are an American college student, you might even get college credit for passing that exam.
What you’ll learn
- Download for free and install and run the full version of Power BI Desktop, the BI and analysis software.
- Be able to create analyses, such as line charts, stacked bar charts, or geographic analyses using maps.
- You will be able to format numbers and dates, and add labels, tooltips and animation.
- You will be able to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting.
- Building and refine models, including adding calculated columns and measures.
- You will learn the important M and DAX functions, to enable you to build your own formulas.
Table of Contents
Introduction
1 Introduction
2 Welcome to Udemy
3 The Udemy Interface
4 Do you want auto-translated subtitles in more languages
5 What are we going to learn
6 Installing Power BI Desktop
7 Resources
8 Saved Power BI files
Level 1 Creating and formatting a table visualization
9 Welcome to Part 1 Visualizations
10 b. Importing from Excel, and Creating our first visualization
11 Viewing data
12 Focus mode and Different visualizations
13 Why do I need a Work email address And how can I get one, if I don’t have it
14 b. Saving visualization to the Desktop and to the Power BI service
15 Practice Activity Number 1
16 Practice Activity Number 1 – The Solution
Level 2 Formatting our first visualization
17 Formatting font and font size
18 Formatting colors
19 Stylistic options
20 g. Position visuals
21 g. Align visuals
22 Format Painter
23 f. Configuring summarization, both default and in a specific visualization
24 i. Changing number and date formatting
25 Practice Activity Number 2
26 Practice Activity Number 2 – The Solution
Level 3 8a. Creating different visualizations Matrices and bar charts
27 Matrix
28 Drill down data, see data and records, and export data
29 Stacked bar charts and 8j. switch theme for reports
30 Bar Chart formatting
31 c. Configure interactions between visual (Edit interactions)
32 Clustered and 100% Stacked bar charts
33 Line and area charts, including 8b. Configure duplicate pages
34 Combo charts (Line and column charts)
35 Practice Activity Number 3
36 Practice Activity Number 3 – The Solution
Level 4 Adding more control to your visualizations
37 a. Adding Text boxes, Images and Shapes
38 b. Visual level, page level and report level filters – basic filters
39 Advanced Filtering
40 Filter Top N Items
41 Slicer
42 Slicer Warning
43 g. Sort visuals
44 j. Use Bookmarks for reports
45 Drillthrough
46 Buttons and Actions
47 e. Enable Natural Language Queries (Ask A Question)
48 Tooltip Pages
49 Practice Activity Number 4
50 Practice Activity Number 4 – The Solution
Level 5 8a. Other visualizations
51 Ribbon charts
52 Waterfall charts
53 Scatter, bubble and dot charts
54 Pie charts and donut charts
55 Treemaps
56 Funnel charts
57 Adding Marketplace visualizations (Import a Custom Visual)
58 Practice Activity Number 5
59 Practice Activity Number 5 – The Solution
Level 6 Mapping
60 Maps
61 Formatting maps
62 g. Adding Data Categories
63 Filled Maps,Conditional Formatting, and color blindness
64 Creating hierarchies
65 ArcGIS Maps for Power BI
66 Practice Activity Number 6
67 Practice Activity Number 6 – The Solution
Level 7 6. Measure performance by using KPIs, gauges and cards
68 Gauges
69 Cards and Multi-row cards
70 More conditional formatting
71 KPIs
72 Practice Activity Number 7
73 Practice Activity Number 7 – The Solution
Part 1 Level 8 Other Visualization Items for the DA-100 exam
74 Define quick measures
75 Export report data
76 Create reference lines by using Analytics pane
77 Design and configure for accessibility
78 Identify outliers
79 Use Anomaly Detection
80 Add a Smart Narrative visual
81 Use groupings and binnings
82 Use the Key Influencers to explore dimensional variances
83 Use the decomposition tree visual to break down a measure
84 R and Python Visualizations
85 Use or create a PBIDS file
86 Creating a paginated report
87 Exploring Power BI Report Builder
88 End of Part 1
Part 2 Get and Transform Data Level 1 – Home Part 1
89 Welcome to Part 2 Get and Transform Data
90 Introduction – let’s Get some more Data
91 Exploring the Power Query Editor interface
92 Introducing the M language
93 Let’s start look at the Home tab
94 Home menu – Manage Columns
95 Home menu – Reduce Rows and Use First Row as Headers
96 Practice Activity Number 8
97 Practice Activity Number 8 – The Solution
Part 2 Level 1 – Get Data – Home
98 Sort and Filter
99 Split Column
100 Other Transform activities
101 Practice Activity Number 9
102 Practice Activity Number 9 – The Solution
Part 2 Level 2 – Getting Multiple files
103 Merge Queries and Expand Table
104 Merge Queries with Group By, and different types of Joins
105 Appending two queries together
106 Appending three or more queries together + resolving a problem with data types
107 Practice Activity Number 10
108 Practice Activity Number 10 – The Solution
Part 2 Level 3 – Transform Menu
109 Transform – Table and Any Column
110 Pivot Column
111 Unpivot
112 Practice Activity Number 11
113 Practice Activity 11 – The Solution
114 Unpivot in conjunction with other Transform features
115 Practice Activity Number 12
116 Practice Activity 12 – The Solution
Part 2 Level 4 – Transform – Text and Numbers
117 Transform Add Column – Text – Format
118 Transform Add Column – Text – Merge Columns
119 Transform Add Column – Text – Extract
120 Transform Add Column – Text – Parse
121 Transform Add Column – Number Column – Statistics and Standard
122 Transform Add Column – Other Number Column functions
123 Practice Activity Number 13
124 Practice Activity Number 13 – The Solution
Part 2 Level 5 – Transform – Dates and Time
125 Creating a list of dates
126 Transform Add Column – Date
127 Transform Add Column – Dates in other cultures languages
128 Transform Add Column – Time
129 Transform Add column – Duration
130 Practice Activity Number 14
131 Practice Activity Number 14 – The Solution
Part 2 Level 6- Add Columns, View and Help Menus
132 Column from examples
133 Conditional Column
134 Resolving Errors from Conditional Columns
135 Index Column and Duplicate Column
136 Custom Column – If Then Else
137 Practice Activity Number 15
138 Practice Activity Number 15 – The Solution
Part 2 Level 7 – View and Help menus and advanced functionality
139 Other M Functions
140 View and Help menus, including Column Properties
141 Profile the data
142 Advanced Editor
143 Functions and Parameters
144 DateTimeZone date type and Functions
145 Worked Practice Activity 16 – Dividing Annual data into Months
146 MFunctions191009
Part 2 Level 8 – Get other types of data
147 Introduction to SQL Server
148 Importing database data into Power BI, and Query Folding
149 Select a storage mode
150 Expanding multiple tables in SQL Server
151 Importing data from SQL Server Analysis Services (SSAS)
152 Setting up Azure SQL Database
153 Using Azure SQL Database in Power BI
154 Automatic page refresh
155 Using Big Data
156 Use the Microsoft Dataverse
Part 2 Level 9 – Other Get and Transform Topics for the DA-100 exam
157 Resolve problems
158 Configure data loading
159 Identify query performance issues, including Query Diagnostics
160 Apply AI Insights
161 End of Part 2
Part 3 Level 1 – An introduction to DAX functions, including Logical functions
162 Welcome to Part 3 – Modeling and DAX functions
163 Small changes to the menus
164 Get multiple data sets, and connecting them together
165 The problems with direction of relationships between data sets
166 DAX functions – A useful Resource
167 Calculated columns – an introduction
168 Basic operators
169 IF, BLANK and ISBLANK
170 AND, OR and NOT
171 SWITCH
172 Other functions
Part 3 Level 2 – Statistical functions
173 Measures – an introduction, with standard aggregations including Countblank
174 Aggregation of calculations
175 Other statistical functions
Part 3 Level 3 – Mathematical functions
176 Introduction to mathematical functions
177 Rounding functions
178 Division functions – MOD and QUOTIENT
179 SIGN (and use with SWITCH) and ABS
180 Exponential functions
181 Other functions
Part 3 Level 4 – Text functions
182 Text searching
183 Text extraction and substitution
184 Text conversion
185 Other functions
Part 3 Level 5 – Information Functions
186 ISERROR and LOOKUPVALUE
187 Other functions
Part 3 Level 6 – Filter and Value Functions
188 RELATED
189 RELATEDTABLE and COUNTROWS
190 Context
191 ALL
192 FILTER
193 CALCULATE
194 ALLEXCEPT
195 ALLSELECTED
196 Other functions
Part 3 Level 7 – Time Intelligence Functions
197 Date and Time Functions
198 FIRSTDATE, LASTDATE
199 Start of… and End of
200 Previous… and Next
201 DATESINPERIOD
202 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
203 Opening Balance and Closing Balance
204 Semi-additive Measures
205 SAMEPERIODLASTYEAR and PARALLELPERIOD
206 Other Time Intelligence Functions
Part 3 Level 8 – Other Modeling and DAX Topics for the DA-100 exam
207 Create calculated tables
208 Create a common date table
209 Define role-playing dimensions
210 Resolve many-to-many relationships – Joint Bank Accounts
211 Resolve many-to-many relationships – Different types of granularity
212 Improve cardinality levels through summarization and by changing data types
213 Identify poorly performing measures, relationships, and visuals
214 End of Part 3
Part 4 Section 1 – An Introduction to the Power BI Service
215 Welcome to Part 4 The Power BI Service
216 Introducing The Power BI Service
217 Logging into Power BI Service and a quick look around
218 Power BI Terminology
219 Datasets and Reports in the Power BI Service
220 Get Data – Other People’s Data
221 Get Data – Your Data
222 The Navigation Pane, including Add a Quick Insights result to a report
Part 4 Section 2 – Power BI Pro and adding users
223 Signing up for Power BI Pro
224 Adding new users
225 Creating a new report
226 Sharing my new report
Part 4 Section 3 – Row and Object Level Security
227 Adding role-based Row Level Security
228 Adding Dynamic Row Level Security
229 Testing Dynamic Row Level Security in the Power BI Service
230 Implement Object-Level Security
Part 4 Section 4 – Dashboards
231 Differences between dashboards and reports
232 Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options
233 Dashboards Options
234 Configure Subscriptions
235 Pin a Live Report Page to a Dashboard
236 Use the Q&A Feature
237 Add a Dashboard Theme
238 Apply or Change Sensitivity Labels
239 Configure Data Alerts
Part 4 Section 5 – Manage datasets
240 Analyze in Excel
241 Promote or Certify (Endorse) a Dataset
242 Manually Refreshing data in the Power BI Service
243 Data Gateways; Providing Access to Datasets
244 Configure a Dataset Scheduled Refresh
245 Configure Incremental Refresh Settings – Step 1
246 Configure Incremental Refresh Settings – Step 2
Part 4 Section 6 – Create and manage workspaces
247 Create and Configure a Workspace
248 Assign Workspace Roles
249 Providing Access to Datasets
250 Configure and Update a Workspace App
251 Promote or certify Power BI report or app
252 Publish, Import or Update Assets in a Workspace – Publish securely
253 Publish reports on the web, so the public can see
Part 4 Section 7 – Other Power BI Service Topics
254 Drillthrough from another report
255 Export Data
256 Recommend a Development Lifecycle Strategy
257 Identify downstream dataset dependencies
258 Personalize visuals
259 Use or create a dataflow
260 Dataflow Scheduled Refresh and Endorsement
261 Connect to a dataset using the XMLA endpoint
262 Configure large dataset format
263 Dashboard Data Classifications
264 That’s almost it for the Power BI Service
265 End of Part 4
Well done
266 Bonus Lecture
267 Congratulations for finishing the course
Resolve the captcha to access the links!