37 Minute Power BI Project ✅ End to End ➡️ How to Transform Webpage Data To Stunning Report 🤔

➡️ Microsoft Power BI
➡️ End to End Project Using Real World Data ☑️
👉 Load Image files from Folder; Image URL ; Encoding
➡️ Interactive Visuals ; 2 Report pages ; Data Transformations in Power Query
➡️ Play Axis Visual
➡️ Publish Report to Power BI Service and Publish to Web (Public)

➡️ Data Source : https://en.wikipedia.org/wiki/List_of...
👉 Wikipedia Web Page Data ✨ List of Super Bowl Champions🏆
👉 From Years 1966 to 2024 ;Super Bowl I to LIX
👉 NFL ( National Football League ) ☑️
➡️ Images Credits: Wikipedia, NFL,


AI Summary of this video:
This video provides an end-to-end Power BI project using real-world data, specifically the Super Bowl champions list from Wikipedia (0:00).

The project covers the following key steps:

Data Loading and Transformation:
The video demonstrates how to load data from a web page using the Power BI Web connector (1:55) and perform various transformations and cleaning in the Power Query Editor (3:16). This includes splitting columns, replacing values, renaming columns, and adding prefixes to data.

Image Integration:
It shows how to obtain and load image files from a local folder using the Folder connector (12:42) and how to transform image URLs by encoding binary data to text within Power Query (15:07).

Model Building and Relationships:
The process of reviewing the loaded data model in Power BI Desktop (11:54) and creating relationships between tables (18:27) is explained.

The video also addresses how to fix errors in new tables to ensure correct image display (19:10).
Report Design and Measures:
The creator walks through the design of two report pages (21:21),
showcasing interactive visuals like the Play Axis visual (21:35) and explaining the creation of various measures (22:00) such as attendance, first and most recent wins, total wins, Super Bowl drought, and teams that did not win or reach the Super Bowl.

Publishing and Sharing:
Finally, the video demonstrates how to publish the completed report to Power BI Service (30:33) and explore available sharing options (31:40), including publishing to the web for public access (33:16). It emphasizes the importance of privacy concerns when sharing publicly.

TIMESTAMPS
00:00 Introduction
00:37 About the dataset
01:55 Load Data using Web connector
03:16 Transformations in Power Query Editor
11:54 Review the Loaded Model in Power BI Desktop
12:42 How to get images and then use the Folder connector
15:07 Image URL( Encoding Binary to Text ;Transformation in Power Query)
18:27 Create Relationships in Model View
19:10 Fix any errors in the new table
21:21 Walkthrough of report pages and Measures
30:33 Publish the final report to Power BI Service
31:40 Explore available options in app.powerbi.com
36:09 Wrap up / Conclusion