Compelling Data Storytelling with Power BI: Global Brand Insights - 20 Years of Financial Trends

Explore the creative journey behind the Global Brand Insights Report on Power BI, showcased on the Power BI Data Stories Gallery.

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. 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.

Chapters

• 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

Useful Links

• Global Brand Insights: 20 Years of Financial Trends
• Power BI Data Stories Gallery: Learning From Disaster - Titanic Passenger Diagnostics
• Power BI Data Stories Gallery: World Bank Heath and Wealth Report
• Accessible Data Storytelling with Power BI: Design Concepts and Accessible Colours
• Data Storytelling with Power BI: The World Bank World Health and Wealth Report
• How to Build Navigation into Power BI
• How to develop an accessible colour palette for Power BI
• How to enable data teams with the design assets required for impactful data storytelling in Power BI
• How to Create Custom Buttons in Power BI
• How to Build a Branded Power BI Report Theme
• Generating custom themes in Power BI – A designer's perspective

From Descriptive to Predictive Analytics with Microsoft Fabric:

• Part 1 - Overview of the Course
• Part 2 - Data Validation with Great Expectations