Published 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.83 GB | Duration: 7h 11m
Hone your Power BI Expertise by Learning Advanced Power BI Skills and Techniques
What you'll learn
Advanced features of Microsoft Power BI
Extend your knowledge of Power Query
Advanced insights into Power Query and the M language
Advanced data modelling and visualization techniques
Requirements
Knowledge of the basics of Power BI Desktop and the Power BI service
Description
The G Com Solutions Power BI Advanced course is designed to give experienced Power BI users the opportunity to hone their expertise in Power BI by tackling a series of challenging and useful Power BI techniques.This course assumes that you are already familiar with Power Query and so we dive straight into advanced topics like the optimizing Data Types, column Profiling and writing M language code, as well as discussing advanced data connection techniques used when working with JSON, XML and SharePoint libraries and folders.The course also provides further practice on data modelling, discussing such topics as role-playing dimensions and use of inactive relationships to cater for multiple significant dates within a main fact table. And, naturally, you will get plenty of additional practice in all aspects of DAX: calculated columns, calculated tables, DAX measures and time-intelligence functions.As an advanced Power BI report developer, it is also important that you build and utilize datasets in the most efficient manner. In this course, you will learn how to implement data centralization by using PBIDS Files, disabling the export of static data from your reports, creating dataflows and shared Datasets and how to promote and certifying your centralized datasets.The course also provides advanced visualization practice, and you will be given the opportunity to create a sophisticated sales pipeline dashboard, starting from scratch and using such techniques as dynamic chart titles and colors and Dynamically Showing a Chart.Then, back in the Power BI service, we discuss the finer points of dashboard tiles: Creating Hyperlinks in a Text Box, working with Image Tiles, Web content tiles, Video Tiles, and Streaming Real-time data by integrating Power Automate functionality.We then turn our attention to visualizing our data, we look at using the form of visual as well as displaying a hierarchy of images in slices, which enable the user to track the performance of sales managers, as well as individual salespeople. We also look at a useful technique for creating a chart which only becomes visible when a slicer selection is made by the user.In short, this course will offer Power BI users who are familiar with all of the fundamentals a challenging hands-on workshop, which will expand their familiarity with Power BI best practices, data modelling, visualization and report creation.
Overview
Section 1: 01-Advanced Data Connections
Lecture 1 0100a-Welcome
Lecture 2 0100b-Download the Course Files
Lecture 3 0101-Navigating Data Structures
Lecture 4 0102-Connecting to JSON Files
Lecture 5 0103-Connecting to XML Files
Lecture 6 0104-Connecting to Files in a SharePoint Library
Lecture 7 0105-Connecting to SharePoint Folders
Lecture 8 0106-Accessing SharePoint Sub-Folders
Lecture 9 0107-Understanding Storage Modes
Lecture 10 0108-Using PBIDS Files
Section 2: 02-Advanced Power Query
Lecture 11 0201-Optimizing Data Types
Lecture 12 0202-Grouping Data
Lecture 13 0203-Column Profiling
Lecture 14 0204-Column Profile Statistics
Section 3: 03-Examining M Language Code
Lecture 15 0301-TableCombine
Lecture 16 0302-TableNestedJoin
Lecture 17 0303-TableRemoveColumns vs TableSelectColumns
Lecture 18 0304-TableUnpivotOtherColumns
Lecture 19 0305-TableReplaceValues
Lecture 20 0306-TableTransformColumnTypes
Lecture 21 0307-TableRenameColumns
Lecture 22 0308-Writing an M Function
Section 4: 04-Data Centralisation
Lecture 23 0401-Disabling Data Export
Lecture 24 0402-Creating a Dataflow
Lecture 25 0403-Creating a Shared Dataset
Lecture 26 0404-Promoting and Certifying Datasets
Lecture 27 0405-Granting Access to Datasets
Lecture 28 0406-Using Microsoft Dataverse
Section 5: 05-Advanced Data Modelling
Lecture 29 0501-Many-to-Many Relationships
Lecture 30 0502-Cross-Filter Direction
Lecture 31 0503-Setting Table Properties
Lecture 32 0504-Setting Field Properties
Section 6: 06-Advanced DAX
Lecture 33 0601-RELATED and RELATEDTABLE
Lecture 34 0602-Using ADDCOLUMNS
Lecture 35 0603-Using SUMMARIZE
Lecture 36 0604-Semi-Additive Measures
Lecture 37 0605-DAX Path Functions
Section 7: 07-DAX Time Intelligence
Lecture 38 0701-DATESYTD and DATESMTD
Lecture 39 0702-SAMEPERIODLASTYEAR
Lecture 40 0703-DATEADD
Lecture 41 0704-PARALLELPERIOD
Lecture 42 0705-Running Total
Lecture 43 0706-DATESINPERIOD
Section 8: 08-Role Playing Dimensions
Lecture 44 0801-Connecting to the data
Lecture 45 0802-Performing Basic Transformations
Lecture 46 0803-Connecting to an External Date Table
Lecture 47 0804-Overview of Relationships
Lecture 48 0805-Engineering a One-to-Many Relationship
Lecture 49 0806-Handling multiple significant dates
Lecture 50 0807-Active and Inactive Relationships
Lecture 51 0808-Using the Default Relationship
Lecture 52 0809-The USERELATIONSHIP Function
Lecture 53 0810-Calculating Key Metrics
Section 9: 09-Advanced Visualization Practice
Lecture 54 0901-Visualizing our Data
Lecture 55 0902-Displaying Top 5 Customers
Lecture 56 0903-Sources of Business
Lecture 57 0904-Displaying the Sales Funnel
Lecture 58 0905-Converted and Lost Business
Lecture 59 0906-Displaying Target vs Actual
Lecture 60 0907-Sales Opportunities by Month
Lecture 61 0908-Displaying Sales Managers
Lecture 62 0909-Displaying Sales People
Lecture 63 0910-Dynamically Showing a Chart
Lecture 64 0911-Optimizing Visual Interactions
Section 10: 10-Advanced Dashboard Tiles
Lecture 65 1001-Creating Hyperlinks in a Text Box
Lecture 66 1002-Creating Image Tiles
Lecture 67 1003-Creating Web-Content Tiles
Lecture 68 1004-Creating Video Tiles
Lecture 69 1005-Streaming Real-Time Data Tiles
Section 11: 11-Power BI AI Capabilities
Lecture 70 1101-The Key Influencers Visual
Lecture 71 1102-The Decomposition Tree Visual
Lecture 72 1103-The Q&A Visual
Lecture 73 1104-Quick Insights
Lecture 74 1105-AI Insights
Existing users of Power BI looking to extend their knowledge
Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
