Power BI Data Stories: Global Brand Insights: 20 Years of Financial Trends

This walkthrough of The Global Brand Insights Report using financial data ingested from the Yahoo Finance API, examines how design and visualisation choices data stories with Power BI compelling. Explore the creative journey behind the Global Brand Insights Report on Power BI, showcased on the Power BI Data Stories Gallery: https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Global-Brand-Insights-20-Years-of-Financial-Trends/m-p/4061980 We crafted this report for educational purposes to highlight features in Power BI that allow you to work with data rich in imagery. In this case, we wanted to show how brand logos can be adopted in a Power BI report to improve accessibility and the drive an engaging user experience. In the report we work with financial data which has been sourced from Yahoo Finance: https://finance.yahoo.com/ We explore visuals that work well with financial data that spans a time period of 20 years. This is aided by a custom date dimension which is used to aggregate financial results from the raw daily level, up to weekly, monthly, quarterly and annual levels. We explore the use of a 2D heat map to display high density information, showing how a RAG (read, amber, green) colour scheme can help your eye to isolate trends and anomalies in the data. We dynamically rank each company based on its share price in any year. This brings out some interesting techniques based on use of rank to explore relative performance of the brands over time. We adapt the Formula 1 lap chart visual for this purpose. We support the end to end user journey using a custom icon based navigation, custom tool tip and drill through. - 00:00 Introduction to Endjin's Global Brand Insights Report - 01:25 Data Sourcing and Preparation - 02:40 Data Wrangling and Aggregation - 04:45 Building the Power BI Report - 05:44 Creating Interactive Visuals with DAX Measures - 08:11 Exploring the Report Pages - 10:48 Analyzing Trends and Rankings - 13:25 Conclusion and Key Takeaways Follow Barry Smart: - https://www.linkedin.com/in/barryjasmart/ - https://twitter.com/barry_j_a_smart