• views: 115
• date: 14 January 2024
• posted by: voska89

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

https://www.udemy.com/course/microsoft-365-power-bi-desktop-intermediate/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.