Pl-300 Certification: Microsoft Power Bi Data Analyst/Da-100

Learn skills for Microsoft PL-300 certification using the free Power BI Desktop. Power Query, DAX, M, more. (Was DA-100)

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.
Requirements
Before you begin this course, you should have a computer with access to the internet, and be able to install Windows programs.
You will need Windows 8.1, 10 or 11 or Windows Server 2012 R2 or later, to install the Power BI program.
That's it! The more experience in reporting using other packages including Excel, the better, but it is not essential.
If you have a Mac, then you will need to be able to either dual-boot into Windows, or use Parallel Desktop boot into Windows. However, Mac users can use the Power BI Service, and be able to do most of Part 1 and Part 4 of this course.
Description
This course covers the content required for the PL-300 certification exam.What do students like you say about this course?Girma says: "This is another great course taught by the instructor – well-paced, every important aspects of Power BI are discussed in detail. I gained the real power of Power BI in this course."Mohan says: "Another Excellent course by Mr Burton. This course can be used as a refresher , manual reference to review, understand and use Power BI tools efficiently. Explanations are very clear and crisp. Can help from Beginner to Intermediate level learning."Andrew says: "I took a similar Power BI course through my work and I think this one is better. Highly recommend this training. I am a Lead ERP Financial Systems Analyst who worked mostly with Oracle BI tools. Company wants to go in a different direction so I am learning Power BI."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 four 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 ServiceWe'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 27 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 with a bit of practice, you could also go for the official Microsoft PL-300 exam - wouldn’t that certificate look good on your CV or resume?

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Welcome to Udemy

Lecture 3 The Udemy Interface

Lecture 4 Do you want auto-translated subtitles in more languages?

Lecture 5 What are we going to learn?

Lecture 6 Installing Power BI Desktop

Lecture 7 Resources

Lecture 8 Saved Power BI files

Section 2: Part 1 Level 1: Creating and formatting a table visualization

Lecture 9 Welcome to Part 1: Visualizations

Lecture 10 Importing from Excel, and Creating our first visualization

Lecture 11 Viewing data

Lecture 12 Focus mode and Different visualizations

Lecture 13 Why do I need a Work email address? And how can I get one, if I don't have it?

Lecture 14 Saving visualization to the Desktop and to the Power BI service

Lecture 15 Practice Activity Number 1

Lecture 16 Practice Activity Number 1 - The Solution

Section 3: Part 1 Level 2: Formatting our first visualization

Lecture 17 The New Format Pane

Lecture 18 Formatting font and font size

Lecture 19 Formatting colors

Lecture 20 Stylistic options

Lecture 21 Position visuals

Lecture 22 Align visuals

Lecture 23 Format Painter

Lecture 24 Configuring summarization, both default and in a specific visualization

Lecture 25 Changing number and date formatting

Lecture 26 Custom number and date formatting

Lecture 27 Practice Activity Number 2

Lecture 28 Practice Activity Number 2 - The Solution

Section 4: Part 1 Level 3: Creating different visualizations: Matrices and bar charts

Lecture 29 Matrix

Lecture 30 Drill down data, see data and records, and export data

Lecture 31 Stacked bar charts and switch theme for reports

Lecture 32 Bar Chart formatting, including continuous versus categorical axes

Lecture 33 Configure interactions between visual (Edit interactions)

Lecture 34 Clustered and 100% Stacked bar charts

Lecture 35 Line and area charts, including 8b. Configure duplicate pages

Lecture 36 Combo charts (Line and column charts)

Lecture 37 Practice Activity Number 3

Lecture 38 Practice Activity Number 3 - The Solution

Section 5: Part 1 Level 4: Adding more control to your visualizations

Lecture 39 Adding Text boxes, Images and Shapes

Lecture 40 Visual level, page level and report level filters - basic filters

Lecture 41 Advanced Filtering

Lecture 42 Filter Top N Items

Lecture 43 Slicer

Lecture 44 Slicer Warning

Lecture 45 Sort visuals

Lecture 46 Configure small multiples

Lecture 47 Use Bookmarks for reports

Lecture 48 ** Group and layer visuals by using the Selection pane

Lecture 49 Drillthrough

Lecture 50 Buttons and Actions

Lecture 51 Enable Natural Language Queries (Ask A Question) and Page Formatting

Lecture 52 Tooltip Pages

Lecture 53 Practice Activity Number 4

Lecture 54 Practice Activity Number 4 - The Solution

Section 6: Part 1 Level 5: Other visualizations

Lecture 55 Ribbon charts

Lecture 56 Waterfall charts

Lecture 57 Scatter, bubble and dot charts

Lecture 58 Pie charts and donut charts

Lecture 59 Treemaps

Lecture 60 Funnel charts

Lecture 61 Adding Marketplace visualizations (Import a Custom Visual)

Lecture 62 Practice Activity Number 5

Lecture 63 Practice Activity Number 5 - The Solution

Section 7: Part 1 Level 6: Mapping

Lecture 64 Maps

Lecture 65 Formatting maps

Lecture 66 Adding Data Categories

Lecture 67 Filled Maps,Conditional Formatting, and color blindness

Lecture 68 Creating hierarchies

Lecture 69 ArcGIS Maps for Power BI

Lecture 70 Practice Activity Number 6

Lecture 71 Practice Activity Number 6 - The Solution

Section 8: Part 1 Level 7: Measure performance by using KPIs, gauges and cards

Lecture 72 Gauges

Lecture 73 Cards and Multi-row cards

Lecture 74 More conditional formatting

Lecture 75 KPIs

Lecture 76 Practice Activity Number 7

Lecture 77 Practice Activity Number 7 - The Solution

Section 9: Part 1 Level 8: Other Visualization Items for the exam

Lecture 78 Define quick measures

Lecture 79 Export report data

Lecture 80 Create reference lines by using Analytics pane, including the Forecast feature

Lecture 81 Identify outliers

Lecture 82 ** Use clustering

Lecture 83 Use Anomaly Detection

Lecture 84 Use groupings and binnings

Lecture 85 Use the AI Visual Key Influencers to explore dimensional variances

Lecture 86 ** Use the Analyze feature in Power BI

Lecture 87 Use the AI Visual decomposition tree visual to break down a measure

Lecture 88 Creating a paginated report

Section 10: Additional videos - Visualize and Analyze the Data

Lecture 89 Not needed for the PL-300 exam

Lecture 90 Design and configure for accessibility

Lecture 91 Add a Smart Narrative visual

Lecture 92 R and Python Visualizations

Lecture 93 Use or create a PBIDS file

Lecture 94 Exploring Power BI Report Builder

Section 11: End of Part 1

Lecture 95 End of Part 1

Section 12: Part 2 Get and Transform Data: Level 1 - Home Part 1

Lecture 96 Welcome to Part 2: Get and Transform Data

Lecture 97 Introduction - let's Get some more Data

Lecture 98 Exploring the Power Query Editor interface

Lecture 99 Introducing the M language

Lecture 100 Let's start look at the Home tab

Lecture 101 Home menu - Manage Columns

Lecture 102 Home menu - Reduce Rows and Use First Row as Headers

Lecture 103 Practice Activity Number 8

Lecture 104 Practice Activity Number 8 - The Solution

Section 13: Part 2 Level 1 - Get Data - Home

Lecture 105 Sort and Filter

Lecture 106 Split Column

Lecture 107 Other Transform activities

Lecture 108 Practice Activity Number 9

Lecture 109 Practice Activity Number 9 - The Solution

Section 14: Part 2 Level 2 - Getting Multiple files

Lecture 110 Merge Queries and Expand Table

Lecture 111 Merge Queries with Group By, and different types of Joins

Lecture 112 Appending two queries together

Lecture 113 Appending three or more queries together + resolving a problem with data types

Lecture 114 Combine Files (getting information from a folder)

Lecture 115 Practice Activity Number 10

Lecture 116 Practice Activity Number 10 - The Solution

Section 15: Part 2 Level 3 - Transform Menu

Lecture 117 Transform - Table and Any Column

Lecture 118 Pivot Column

Lecture 119 Unpivot

Lecture 120 Practice Activity Number 11

Lecture 121 Practice Activity 11 - The Solution

Lecture 122 Unpivot in conjunction with other Transform features

Lecture 123 Practice Activity Number 12

Lecture 124 Practice Activity 12 - The Solution

Section 16: Part 2 Level 4 - Transform - Text and Numbers

Lecture 125 Transform/Add Column - Text - Format

Lecture 126 Transform/Add Column - Text - Merge Columns

Lecture 127 Transform/Add Column - Text - Extract

Lecture 128 Transform/Add Column - Text - Parse

Lecture 129 Transform/Add Column - Number Column - Statistics and Standard

Lecture 130 Transform/Add Column - Other Number Column functions

Lecture 131 Practice Activity Number 13

Lecture 132 Practice Activity Number 13 - The Solution

Section 17: Part 2 Level 5 - Transform - Dates and Time

Lecture 133 Creating a list of dates

Lecture 134 Transform/Add Column - Date

Lecture 135 Transform/Add Column - Dates in other cultures/languages

Lecture 136 Transform/Add Column - Time

Lecture 137 Transform/Add column - Duration

Lecture 138 Practice Activity Number 14

Lecture 139 Practice Activity Number 14 - The Solution

Section 18: Part 2 Level 6 - Add Columns, View and Help Menus

Lecture 140 Column from examples

Lecture 141 Conditional Column

Lecture 142 Resolving Errors from Conditional Columns

Lecture 143 Index Column and Duplicate Column

Lecture 144 Custom Column - If Then Else

Lecture 145 Converting text from a different locale to a number

Lecture 146 Practice Activity Number 15

Lecture 147 Practice Activity Number 15 - The Solution

Section 19: Part 2 Level 7 - View and Help menus and advanced functionality

Lecture 148 Other M Functions

Lecture 149 View and Help menus, including Column Properties

Lecture 150 Profile the data

Lecture 151 Advanced Editor

Lecture 152 Functions and Parameters

Lecture 153 DateTimeZone date type and Functions

Lecture 154 Worked Practice Activity Number 16 - Dividing Annual data into Months

Section 20: Part 2 Level 8 - Get other types of data

Lecture 155 Introduction to SQL Server

Lecture 156 Importing database data into Power BI, and Query Folding

Lecture 157 Select a storage mode

Lecture 158 Expanding multiple tables in SQL Server

Lecture 159 Importing data from SQL Server Analysis Services (SSAS)

Lecture 160 Setting up Azure SQL Database

Lecture 161 Using Azure SQL Database in Power BI

Lecture 162 Use the Microsoft Dataverse

Lecture 163 Configure data loading

Section 21: Additional videos - Get and Transform

Lecture 164 Not needed for the PL-300 exam

Lecture 165 * Automatic page refresh

Lecture 166 * Using Big Data

Lecture 167 * Resolve problems

Lecture 168 * Identify query performance issues, including Query Diagnostics

Lecture 169 * Apply AI Insights

Section 22: End of Part 2

Lecture 170 End of Part 2

Section 23: Part 3 Level 1: Creating a Data Model

Lecture 171 Welcome to Part 3 - Modeling and DAX functions

Lecture 172 Small changes to the menus

Lecture 173 Get multiple data sets, and connecting them together

Lecture 174 The problems with direction of relationships between data sets

Lecture 175 Practice Activity Number 17

Lecture 176 Practice Activity Number 17 - The Solution

Section 24: Part 3 Level 2 - An introduction to DAX functions, including Logical functions

Lecture 177 DAX functions - A useful Resource

Lecture 178 Calculated columns - an introduction

Lecture 179 Basic operators

Lecture 180 IF, BLANK and ISBLANK

Lecture 181 AND, OR and NOT

Lecture 182 SWITCH

Lecture 183 Other functions

Lecture 184 Practice Activity Number 18

Lecture 185 Practice Activity Number 18 - The Solution

Section 25: Part 3 Level 3 - Statistical functions

Lecture 186 Measures - an introduction, with standard aggregations including Countblank

Lecture 187 Aggregation of calculations

Lecture 188 Other statistical functions

Lecture 189 Practice Activity Number 19

Lecture 190 Practice Activity Number 19 - The Solution

Section 26: Part 3 Level 4 - Mathematical functions

Lecture 191 Introduction to mathematical functions

Lecture 192 Rounding functions

Lecture 193 Division functions - MOD and QUOTIENT

Lecture 194 SIGN (and use with SWITCH) and ABS

Lecture 195 Exponential functions

Lecture 196 Other functions

Lecture 197 Practice Activity Number 20

Lecture 198 Practice Activity Number 20 - The Solution

Section 27: Part 3 Level 5 - Text functions

Lecture 199 Text searching

Lecture 200 Text extraction and substitution

Lecture 201 Text conversion

Lecture 202 Other functions

Lecture 203 Practice Activity Number 21

Lecture 204 Practice Activity Number 21 - The Solution

Section 28: Part 3 Level 6 - Information Functions

Lecture 205 ISERROR and LOOKUPVALUE

Lecture 206 Other functions

Lecture 207 Practice Activity Number 22

Lecture 208 Practice Activity Number 22 - The Solution

Section 29: Part 3 Level 7 - Filter and Value Functions

Lecture 209 RELATED - Flatten out a parent-child hierarchy

Lecture 210 ** Design a data model that uses a star schema (not needed for DA-100)

Lecture 211 RELATEDTABLE and COUNTROWS

Lecture 212 Context

Lecture 213 ALL

Lecture 214 FILTER

Lecture 215 CALCULATE

Lecture 216 ALLEXCEPT

Lecture 217 ALLSELECTED

Lecture 218 Other functions

Lecture 219 Practice Activity Number 23

Lecture 220 Practice Activity Number 23 - The Solution

Section 30: Part 3 Level 8 - Time Intelligence Functions

Lecture 221 Date and Time Functions

Lecture 222 FIRSTDATE, LASTDATE

Lecture 223 Start of… and End of…

Lecture 224 Previous… and Next…

Lecture 225 DATESINPERIOD

Lecture 226 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD

Lecture 227 Opening Balance and Closing Balance

Lecture 228 Semi-additive Measures

Lecture 229 SAMEPERIODLASTYEAR and PARALLELPERIOD

Lecture 230 Other Time Intelligence Functions

Lecture 231 Practice Activity Number 24

Lecture 232 Practice Activity Number 24 - The Solution

Section 31: Part 3 Level 9 - Other Modeling and DAX Topics for the exam

Lecture 233 Create calculated tables

Lecture 234 Create a common date table

Lecture 235 Define role-playing dimensions

Lecture 236 Resolve many-to-many relationships - Joint Bank Accounts

Lecture 237 Resolve many-to-many relationships - Different types of granularity

Lecture 238 Improve cardinality levels through summarization and by changing data types

Lecture 239 Identify poorly performing measures, relationships, and visuals

Lecture 240 End of Part 3

Section 32: Part 4 Section 1 - An Introduction to the Power BI Service

Lecture 241 Welcome to Part 4: The Power BI Service

Lecture 242 Introducing The Power BI Service

Lecture 243 Logging into Power BI Service and a quick look around

Lecture 244 Power BI Terminology

Lecture 245 Datasets and Reports in the Power BI Service

Lecture 246 Get Data - Other People's Data

Lecture 247 Get Data - Your Data

Lecture 248 The Navigation Pane, including Add a Quick Insights result to a report

Section 33: Part 4 Section 2 - Power BI Pro and adding users

Lecture 249 Signing up for Power BI Pro

Lecture 250 Adding new users

Lecture 251 Creating a new report

Lecture 252 Sharing my new report

Section 34: Part 4 Section 3 - Row Level Security

Lecture 253 Adding role-based Row Level Security

Lecture 254 Adding Dynamic Row Level Security

Lecture 255 Testing Dynamic Row Level Security in the Power BI Service

Section 35: Part 4 Section 4 - Dashboards

Lecture 256 Differences between dashboards and reports

Lecture 257 Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options

Lecture 258 Dashboards: Options

Lecture 259 Configure Subscriptions

Lecture 260 Pin a Live Report Page to a Dashboard

Lecture 261 Use the Q&A Feature

Lecture 262 Add a Dashboard Theme

Lecture 263 Apply or Change Sensitivity Labels

Lecture 264 Configure Data Alerts

Section 36: Part 4 Section 5 - Manage datasets

Lecture 265 Analyze in Excel

Lecture 266 Promote or Certify (Endorse) a Dataset

Lecture 267 Manually Refreshing data in the Power BI Service

Lecture 268 Data Gateways; Providing Access to Datasets

Lecture 269 Configure a Dataset Scheduled Refresh

Lecture 270 Configure Incremental Refresh Settings - Step 1

Lecture 271 Configure Incremental Refresh Settings - Step 2

Section 37: Part 4 Section 6 - Create and manage workspaces

Lecture 272 Create and Configure a Workspace

Lecture 273 Assign Workspace Roles

Lecture 274 Providing Access to Datasets

Lecture 275 Configure and Update a Workspace App

Lecture 276 Promote or certify Power BI report or app

Lecture 277 Publish, Import or Update Assets in a Workspace - Publish securely

Lecture 278 Publish reports on the web, so the public can see

Section 38: Part 4 Section 7 - Other Power BI Service Topics

Lecture 279 Create a PivotTable from a Power BI dataset in Excel

Lecture 280 Use or create a dataflow

Section 39: Not needed for the PL-300 exam

Lecture 281 Not needed for the PL-300 exam

Lecture 282 Implement Object-Level Security

Lecture 283 Drillthrough from another report

Lecture 284 Export Data

Lecture 285 Recommend a Development Lifecycle Strategy

Lecture 286 Identify downstream dataset dependencies

Lecture 287 Personalize visuals

Lecture 288 Dataflow Scheduled Refresh and Endorsement

Lecture 289 Connect to a dataset using the XMLA endpoint

Lecture 290 Configure large dataset format

Lecture 291 Dashboard Data Classifications

Section 40: End of Part 4

Lecture 292 End of Part 4

Section 41: Well done

Lecture 293 That's almost it for the Power BI Service

Lecture 294 Congratulations for finishing the course!

Section 42: Bonus Lecture

Lecture 295 Bonus Lecture

This reporting course is meant for anyone who has no prior experience of Power BI. It's also for you if you have used it, but never designed a report.,It's great if you have created analyses in other reporting tools, such as Microsoft Access, WebI, SSRS, Tableau or Yellowfin, but it not essential. If you have, then it will be another string to your bow.,It would also be good if you had prior experience in using Excel formulas, but again, that is not essential.,No prior experience in reporting tools or creating formulas is required.,This course is probably not for you if you always know how to use Power BI and know how to create reports, although we will be looking at some more advanced topics, including the M and DAX languages.,This course may not be for you if you have a Mac, as Power BI is not natively installable onto Macs.