Microsoft Fabric Updates Blog

Analyzing country data in less than 60 minutes

Today Marc Reguera, Finance Director at Microsoft, will show us how to build country specific dashboards with key indicators such as growth, resources, population and economy in less than 60 minutes.

To build these visualizations, Marc uses public data available from the World Bank to build the reports and dashboards using Excel and Power BI in 4 easy steps:

  1. Connect to and transform public data through Power Query in Excel
  2. Use Power Pivot in Excel to create relationships between different tables and build a data model
  3. Create reports in Excel using Power View
  4. Publish to Power BI and create a dashboard to monitor the most important data for a specific country

Enjoy and please let us know what you think!

Related blog posts

Analyzing country data in less than 60 minutes

June 16, 2024 by bagweb

Testing Cascading Messaging portal changes

November 20, 2023 by Anshul Sharma

As part of the One logical copy effort, we’re excited to announce that you can now enable availability of KQL Database in Delta Lake format. Delta Lake  is the unified data lake table format chosen to achieve seamless data access across all compute engines in Microsoft Fabric. The data streamed into KQL Database is stored … Continue reading “Announcing Delta Lake support in Real-Time Analytics KQL Database”