ENHANCE YOUR POWER BI SKILLS: COMBINE MULTIPLE DATASETS

Power BI is a powerful tool for transforming data in (visual) information. As of today you have perhaps built your first dashboard, and are enthusiastic about the insights that dashboards provide to you. You transformed an Excel sheet in a beautiful Power BI dashboard. You, your colleagues or your superiors see the added value and come up with all kinds of new ideas for additional ideas and insights. However, this requires adding new datasets to your dashboard, and possibly combining multiple datasets. This article tries to explain you how you can best achieve this, without using any programming code. So, to use a popular phrase nowadays: a no-code solution! Only interested in the final result? Please find the Power BI dashboard here.

PENSION DASHBOARD

The pension dashboard provides an overview of the current financial status of the pension funds ABP, PFZW, PMT, and BPF Bouw. This dashboard uses public data sources and open-source software. Various techniques are applied for retrieving and processing the data, including web scraping and APIs. Machine learning techniques are used for forecasting the funding ratios. Software such as Python, Azure Web Apps, Plotly, and Dash are used, all in a fully automated environment. The source code is available on Github!

POWER BI: KEEPING YOUR DASHBOARDS UP-TO-DATE

Do you update your Power BI dashboard by clicking on the Refresh button? And, subsequently, share the updated dashboard by e-mail or other communication methods with your stakeholders? If so, keep on reading!

DASH: A DASHBOARD IN A FEW STEPS USING PYTHON

Dashboards are great instruments tools to get a quick understanding of a certain subject, for instance financial markets. Building and maintaining effective dashboards can be challenging: