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