70 778 Analyzing And Visualizing Data With Power Bi

Tags: Microsoft Power BI , Microsoft Certification

Learn skills for Microsoft DA-100 certification using the free Power BI Desktop. Learn Power Query, DAX, M and more.

Last updated 2022-01-10 | 4.6

- 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.

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 DA-100 certification exam, current as per the DA-100 exam update of 23 November 2021.

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 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 25 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 DA-100 exam - wouldn’t that certificate look good on your CV or resume? And if you are an American college student, you might even get college credit for passing that exam.

Who this course is for:

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.

Course content

36 sections • 287 lectures

Introduction 8 lectures

Introduction Preview 01:37

Welcome to Udemy Preview 01:08

The Udemy Interface Preview 02:00

Do you want auto-translated subtitles in more languages? Preview 01:10

What are we going to learn? Preview 06:37

Installing Power BI Desktop Preview 05:21

Resources Preview 00:56

Saved Power BI files Preview 00:18

Level 1: Creating and formatting a table visualization 8 lectures

Welcome to Part 1: Visualizations Preview 02:48

1b. Importing from Excel, and Creating our first visualization Preview 05:10

Viewing data Preview 05:37

Focus mode and Different visualizations Preview 03:06

Why do I need a Work email address? And how can I get one, if I don't have it? Preview 06:35

10b. Saving visualization to the Desktop and to the Power BI service Preview 05:10

Practice Activity Number 1 Preview 00:26

Practice Activity Number 1 - The Solution Preview 07:24

Level 2: Formatting our first visualization 10 lectures

Formatting font and font size Preview 04:52

Formatting colors Preview 05:24

Stylistic options Preview 06:49

Position visuals Preview 05:45

Align visuals Preview 04:34

Format Painter Preview 02:45

Configuring summarization, both default and in a specific visualization Preview 10:01

Changing number and date formatting Preview 07:07

Practice Activity Number 2 Preview 00:59

Practice Activity Number 2 - The Solution Preview 07:58

Level 3: Creating different visualizations: Matrices and bar charts 10 lectures

Matrix Preview 07:01

Drill down data, see data and records, and export data Preview 08:25

Stacked bar charts and 8j. switch theme for reports Preview 06:51

Bar Chart formatting Preview 04:51

Configure interactions between visual (Edit interactions) Preview 08:32

Clustered and 100% Stacked bar charts Preview 05:47

Line and area charts, including 8b. Configure duplicate pages Preview 05:16

Combo charts (Line and column charts) Preview 06:04

Practice Activity Number 3 Preview 00:51

Practice Activity Number 3 - The Solution Preview 07:43

Level 4: Adding more control to your visualizations 15 lectures

Adding Text boxes, Images and Shapes Preview 07:25

Visual level, page level and report level filters - basic filters Preview 06:58

Advanced Filtering Preview 10:40

Filter Top N Items Preview 05:29

Slicer Preview 10:32

Including View - Sync slicers

Slicer Warning Preview 03:16

Sort visuals Preview 07:24

Including clicking on the "More Options" button

Configure small multiples Preview 08:22

Use Bookmarks for reports Preview 06:12

Drillthrough Preview 10:59

Buttons and Actions Preview 14:00

Enable Natural Language Queries (Ask A Question) Preview 08:14

Tooltip Pages Preview 09:01

Practice Activity Number 4 Preview 01:41

Practice Activity Number 4 - The Solution Preview 10:44

Level 5: Other visualizations 9 lectures

Ribbon charts Preview 06:22

Waterfall charts Preview 08:04

Scatter, bubble and dot charts Preview 09:39

Pie charts and donut charts Preview 03:33

Treemaps Preview 02:25

Funnel charts Preview 02:37

Adding Marketplace visualizations (Import a Custom Visual) Preview 03:05

Practice Activity Number 5 Preview 00:50

Practice Activity Number 5 - The Solution Preview 07:27

Level 6: Mapping 8 lectures

Maps Preview 07:30

Formatting maps Preview 04:46

8g. Adding Data Categories Preview 07:22

Filled Maps,Conditional Formatting, and color blindness Preview 10:10

Creating hierarchies Preview 07:23

ArcGIS Maps for Power BI Preview 10:32

Practice Activity Number 6 Preview 01:26

Practice Activity Number 6 - The Solution Preview 12:28

Level 7: Measure performance by using KPIs, gauges and cards 6 lectures

Gauges Preview 06:02

a) calculate the actual

b) calculate the target

c) calculate actual to target

d) configure values for gauges

e) use the format settings to manually set values

Cards and Multi-row cards Preview 04:45

More conditional formatting Preview 07:56

KPIs Preview 04:14

Practice Activity Number 7 Preview 01:30

Practice Activity Number 7 - The Solution Preview 16:02

Part 1 Level 8: Other Visualization Items for the DA-100 exam 15 lectures

Define quick measures Preview 07:16

Export report data Preview 03:56

Create reference lines by using Analytics pane Preview 09:37

Design and configure for accessibility Preview 05:45

Identify outliers Preview 03:23

Use Anomaly Detection Preview 05:11

Add a Smart Narrative visual Preview 06:18

Use groupings and binnings Preview 06:47

Use the Key Influencers to explore dimensional variances Preview 08:44

Use the decomposition tree visual to break down a measure Preview 06:04

R and Python Visualizations Preview 04:17

Use or create a PBIDS file Preview 03:03

Creating a paginated report Preview 06:00

Exploring Power BI Report Builder Preview 06:53

End of Part 1 Preview 01:28

Part 2 Get and Transform Data: Level 1 - Home Part 1 9 lectures

Welcome to Part 2: Get and Transform Data Preview 01:49

Introduction - let's Get some more Data Preview 04:51

Exploring the Power Query Editor interface Preview 09:06

Introducing the M language Preview 09:16

Let's start look at the Home tab Preview 04:19

Close - New Query - Data Sources and Query sections.

Home menu - Manage Columns Preview 06:05

Home menu - Reduce Rows and Use First Row as Headers Preview 07:27

Use the full CD collection with a few header rows.

Manage Columns reduces the number of columns.

Keep/Remove Rows reduces the number of rows

Sort can put the rows that you want to keep/remove at the top.

Practice Activity Number 8 Preview 00:33

Practice Activity Number 8 - The Solution Preview 07:16

Part 2 Level 1 - Get Data - Home 5 lectures

Sort and Filter Preview 05:52

Split Column Preview 07:14

Split the path by delimiter.

Then look at the other options.

Other Transform activities Preview 09:51

Group By.

Data Type - look at the errors if you do it to the wrong type. But you can get rid of errors in the Transform section.

Replace Values.

Practice Activity Number 9 Preview 00:51

Practice Activity Number 9 - The Solution Preview 05:15

Part 2 Level 2 - Getting Multiple files 7 lectures

Merge Queries and Expand Table Preview 06:07

Merge Queries with Group By, and different types of Joins Preview 06:54

Appending two queries together Preview 04:33

Divide Computer logins into 12 months worth of data. Import the first two.

Appending three or more queries together + resolving a problem with data types Preview 06:31

Combine Files (getting information from a folder) Preview 09:17

Practice Activity Number 10 Preview 01:20

Practice Activity Number 10 - The Solution Preview 15:45

Part 2 Level 3 - Transform Menu 8 lectures

Transform - Table and Any Column Preview 05:27

Transpose, and Reverse Rows

Count Rows, Group By (reminder).

Data Type (reminder).

Detect Data Type

Rename

Replace Values

Fill Down/Up (reverse rows if needed).

Move left/right.

Convert to list

Pivot Column Preview 09:55

Pivot the tblHPAdmins by RegionName going across and Date going down.

Unpivot Preview 10:30

· pvtHPIAdmin - Unpivot – 1 level deep – Regions Across, Date down

Practice Activity Number 11 Preview 00:14

Practice Activity 11 - The Solution Preview 07:08

Unpivot in conjunction with other Transform features Preview 09:57

· pvtHPIAdmin2 - Unpivot – 2 levels deep – have Year and Month running across – Region Across with subtotals, Years and Month going down, with gaps in the year.