You’ve figured it out. You need a dashboard. The lack of overview makes you restless, but you do not have the time to prepare an up-to-date report. As a result, you are often looking at an older status, which is probably correct. To make more data-driven decisions, you decide to have a dashboard created. But how does a dashboard work?
How are data sources linked to a dashboard?
A dashboard is developed using business intelligence software, such as Power BI. In this story, Power BI can be seen as the postman/mail program A list of addresses (the group of information sources) is collected, after which information must be retrieved from here. Every hour, Power BI Service visits the information source to retrieve the latest status. When it has visited all sources with the information request, it collects this current data and shows it in the dashboard.
The connection between Power BI and the data source is made using a Power BI connector. Microsoft has developed many different connectors so that Power BI can be connected to almost any system for free. Some applications do not have a free connector. However, there are various parties that have developed a connector that can usually be used for a reasonable monthly fee.