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:
- Connect to and transform public data through Power Query in Excel
- Use Power Pivot in Excel to create relationships between different tables and build a data model
- Create reports in Excel using Power View
- 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!