Microsoft 365 Power Bi Desktop - Intermediate

[nieriorefasow63]

Microsoft 365 Power Bi Desktop - Intermediate

Published 1/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.53 GB | Duration: 3h 45m


Expand upon introductory Power BI Desktop knowledge

What you'll learn
Data Refresh and Storage Mode Types
Data Modeling
Column Calculations
Visualizations
Filters and Slicers
Interactive Dashboard

Requirements
Excel level 2
Power BI Desktop - Beginner

Description
Modern reports and dashboards are highly interactive and use data from multiple sources. Managers want real-time information for analysis and decision making. This course builds on the beginner course and enables dashboard creators to support these requirements.Data is only as up to date as its latest refresh. The location of data has refresh implications, as does the feature used by Power BI Desktop to connect to that data. This course covers the issues that must be addressed to determine the freshness of an organizations reporting data.Data often comes from different sources. When all that data together must be used for visualizations and analysis, the data must be modeled. Data modeling includes the topics: Table Relationships, Cardinality, Row-level Security, and Referential Integrity.Sometimes a data source does not have all the information that is required for reporting or forecasting. Calculated columns may be added to produce the data required for further analysis. Calculated columns are covered in this course.Visualizations that are not covered in the beginner course are covered here. This course includes: Donut Charts, Tree Maps, Line and Stacked Column charts, Line and Cluster Column charts, Maps, and Filled Maps. Perhaps mostly importantly, use cases that determine when each of these visuals is the best one to use are explained and demonstrated.Filters are introduced as a technique for interactively analyzing data. Filters may be applied to single visualizations, pages, or entire reports. Each has its place. Special filters are also included such as: Include / Excluded filters, Cross filters, Top N filters, and relative Date filters.Slicers are visual filters that enhance interactivity, especially on dashboards. There are various types of slicers, and this course covers date slicers, time slicers, numeric range slicers, and others.Even though dashboards are covered in the beginner course, there is so much that can be done with them! In this course, dashboards are created the use the new visualizations and that also incorporate filters and slicers!Instructor: Eric W. Brockway

Overview
Section 1: Introduction

Lecture 1 Introduction

Section 2: Refreshing Data

Lecture 2 Why It's Important

Lecture 3 Implications for a Data Model

Lecture 4 Introduction to Storage Modes

Lecture 5 Import Mode

Lecture 6 DirectQuery Mode

Lecture 7 Live Connect Mode

Lecture 8 Dual Mode

Lecture 9 Push Mode

Lecture 10 Introduction to Refresh Types

Section 3: Data Modeling

Lecture 11 Examining Data Modeling

Lecture 12 Table Relationships - Cardinality

Lecture 13 Creating Visuals from a Multi-Table Model

Lecture 14 Table Relationships - Filter Direction

Lecture 15 Type Detection Options

Lecture 16 Understanding Row-Level Security

Section 4: Column Calculations

Lecture 17 Understanding Calculated Columns

Lecture 18 Creating a Calculation with Operators

Lecture 19 Creating a Calculation with the IF Function

Lecture 20 Creating a Calculation with the SWITCH and TRUE Functions

Lecture 21 Creating a Stacked Column Chart from Calculations

Section 5: Visualizations

Lecture 22 Introduction to the New Visualizations

Lecture 23 Creating Donut Charts

Lecture 24 Creating TreeMaps

Lecture 25 Creating Line & Stacked Column Charts

Lecture 26 Creating a Line & Cluster Column Chart

Lecture 27 Creating a Map

Lecture 28 Creating a Filled Map

Section 6: Filters

Lecture 29 Defining and Applying Filters

Lecture 30 Page Filters and Report Filters

Lecture 31 Using a Date Range Filter

Lecture 32 Using a Top N Filter

Lecture 33 Filters and Dashboards

Section 7: Slicers

Lecture 34 Defining Slicers

Lecture 35 Prepping a Report

Lecture 36 Applying Slicers

Lecture 37 Adding Multiple Slicers to a Visual

Lecture 38 Adding Slicers to a Tree Map

Lecture 39 Adding Slicers to Line and Stacked Column Charts

Lecture 40 Adding Slicers to a Map

Lecture 41 Syncing Slicers

Section 8: Dashboard Enhancements

Lecture 42 Slicers, Filters, and Dashboards

Section 9: Conclusion

Lecture 43 Course Recap

Section 10: Microsoft 365 Power BI Desktop - Intermediate Assessment

Anyone with basic Power BI and Excel skills that wants to expand their knowledge.

HOMEPAGE

[To see links please register or login]

DOWNLOAD

[To see links please register or login]