Login / Register
Access learning materials

Power Apps - Basic (level 1)

Welcome to the Power BI advanced course

You already have some experience with Power BI but want to learn more about some features? You want to discover the power of Power BI with measurements and calculated columns? Then this course is what you are looking for.

Files

Handbook

Excel files and statements

Power Bi - Solutions

Introduction

1.1 Introduction course

Welcome to the Power BI course. In this video, we look at:

  • What topics are covered in the course
  • Where do you find all the material?
  • What prior knowledge should you have?

1.2 Microsoft PL-300 exam

How to better prepare yourself for the exam:

  • What is this PL-300 exam
  • Where can you find a mock exam?
  • What topics are covered?

Power Query +

2.1 Entering data

Data pass-through is a transformation that will fill in missing data itself. We discuss:

  • The problems of standardization and identities
  • Linking an excel
  • Entering data
  • Data types
  • Creating visualizations

We use the“Sports Clubs” file.

2.2 Linking folders

We can connect various data sources to Power BI. We discuss:

  • How to link a folder
  • What is the benefit of this?
  • Why work online?
  • Examining content problems

We use the“Energy” folder.

2.3 Filtering Extents

Files from the folder are displayed but how best to filter? We discuss:

  • The different extensions
  • two filtering ways, which is the best?
  • Adjusting filters in M

2.4 Using date type

We see a structure like moon/year and want to use this to filter the wrong files. Now we still have to explain this to Power BI. We discuss:

  • Split data
  • Datatype use as structure.
  • Eliciting Errors

2.5 Handling Errors

Errors and errors are convenient to use. We just have to get used to it. We discuss:

  • Display column profiles
  • Filtering by errors
  • Duplicating a query
  • Making honor roll lists

2.6 Combining files

When our file list is pure we can combine.

  • Combining queries or combining files?
  • How to combine content?
  • Which ones are limitations?
  • Oops! No loop?

2.7 Data cleanup

We have yet to clean up the combined result. We perform the following:

  • Values replaced.
  • Changing data types.
  • Renaming columns
  • Renaming tables
  • Filter out empty rows.

Power Pivot +

3.1 Construction of the date table

Dates are quite something special. That’s why we pay more attention to it.

  • What is a date table?
  • How do you create these in Excel?
  • What functions are behind this?

3.2 The wrong dates

All dates are wrong! All the world knows. And yet…

Do you know what went wrong with the date in 1900?

In this “extra” module, we explore it.
A fact you never forget.

3.3 Importing the date table

We connect the date table and make some adjustments:

  • Importing an Excel
  • Using number filters
  • Changing data types
  • Customize data summaries

3.4 Highlighting the date table

Now that you have the date table, you still need to use a special menu in Power BI. And don’t forget your relationships. We finish the import movement and link everything.

All ready to build visualizations.

Power Visuals

4.1 Creating visuals with dates

A visualization is now created on top of the semantic model. We build this visualization together and we emphasize visualizations with the date to use.

4.2 Downloading additional visuals

The standard visuals may be insufficient. We download additional visualizations and use a Timeline.

4.3 Formatting Visuals

Finally, you want to adjust the formatting of the visualizations. Consider the titles, colors and labels. But also display units and conditional formatting.

Measurements, calculated columns and extras

5.1 Renewing data

Your PowerBI dashboard is now completely ready. You also now want to see the power of renewal. We discuss:

  • Import additional documents
  • Why use the dynamic query
  • Automatic renewal – PRO license!

We use two additional files that we put in the“Energy” folder.

5.2 A measurement or a calculated column?

Now we come to the most difficult concept. This is how we view:

  • What is a calculated column?
  • What is a measurement?
  • What is the difference in operation?
  • What is the impact of your choice?

5.3 Creating calculated columns

Now that you understand the difference between the two, let’s start with a calculated column. We use various DAX formulas to calculate data and create calculated columns in our data model.

We will continue working on the“Movies Power BI” we created in the basic course. You can also download those.

5.4 Making measurements

Now that you understand the difference between the two, let’s start with measurement. We use various DAX formulas to calculate data and make measurements in our data model.

We will continue working on the“Movies Power BI” we created in the basic course. You can also download those.

5.5 Using the calculate function

You have some experience with DAX by now. There are a lot of features you can use.

However, one feature is so special that it deserves its own video. The “Calculate” function. We are trying to approach this and see a lot of opportunities.

Evaluation

EDU-Versity evaluation

Are you ready to test your knowledge? You can take a knowledge test at EDU-Versity to see if you have understood everything correctly.

We hereby evaluate:

  • Possible transformations
  • Points to consider when connecting folders
  • Knowledge about the date table
  • What is a calculated column
  • What is a measurement
  • Knowledge about the calculate function
  • What options are available for creating visualizations

Microsoft Certification

Are you ready to test your knowledge? You can take an exam at Microsoft. This is the PL-300 exam and accompanying certificate.

Be sure to contact us if you have any questions about this.

Learn more at Microsoft learn.

Note!

  • This exam is not free.
  • This exam is in English.
  • You must achieve at least 70% to pass.
  • Your certificate must be renewed annually with a knowledge test.