Analyzing and Visualizing Data with Power BI DavidsonX Full Course Part 2 | Power BI Tutorial

Опис:

Unlock the power of Power BI to analyze and visualize your data like a pro! In this step‑by‑step tutorial, we guide you through best practices for data analysis, visualization, and dashboard creation using Power BI. Whether you’re a beginner or an advanced user, this video helps you master Power BI and make data‑driven decisions with ease. The course is organized into six modules: Global Economic Data Preparation, Global Economic Data Modeling, Global Economic Data Visualization, Polishing the User Experience, Power BI Behind the Scenes, and a Wrap‑Up with a final exercise. Each module covers key concepts such as connecting to data sources, transforming data with Power Query, creating interactive dashboards, using DAX for advanced calculations, optimizing performance, and enhancing the report’s look and feel. Time Stamps: Module 1: Global Economic Data Preparation 00:00:00 Introduction 00:01:23 Getting data from web APIs 00:17:32 Preparing the economic indicators data 00:24:40 Referencing and duplicating queries 00:36:50 Merging queries 00:45:43 Join kinds in Power Query 00:54:19 Query dependencies and lineage1 Module 2: Global Economic Data Modeling 01:03:18 Modeling the economic indicators data with DAX1 01:14:27 Using variables for complex DAX calculations 01:24:09 Using comments to explain DAX formulas Module 3: Global Economic Data Visualization 01:31:35 Mapping countries 01:42:16 Sparklines and conditional formatting 01:55:53 Creating drillthrough pages 02:16:44 Using the filters panel 02:38:36 Comparing Slicers vs Filters 02:47:33 New card visual 03:01:08 AI visuals Q A visual Module 4: Polishing the User Experience 03:10:07 Adding metadata to our report 03:22:32 Creating a multi page report with navigation buttons 03:35:55 Adding documentation to the report 03:44:39 How to make icons for Power BI using PowerPoint 03:50:35 Use PowerPoint to create report backgrounds Module 5: Power BI Behind the Scenes 04:08:36 Performance Analyzer 04:14:26 DAX queries 04:20:53 Power Query diagnostics 04:25:07 Power BI projects 04:38:45 Tabular Model Definition Language TMDL Module 6: Wrap-Up 04:45:26 Introducing the Final Exercise 04:49:37 How to solve the final exercise