If you already have data models
If you’ve already worked systematically with reporting and have the data models in place, it’s relatively easy to get started.
What are data models?
If your organization has multiple data sources – the amount of data naturally increases. It can be difficult to understand the meaning of data if it stands alone. At the same time, it can be difficult to compare data when it comes from different data sources. That’s why we structure and process data and compile it into data models that take into account the relationships between the many different data sources – so they can be compared.
The data models can either be built directly in Power BI or you can choose to use a tool that contains pre-built data models that we can build on, such as Jet Analytics.
In Power BI, we build the data models from scratch. However, if we choose to use one of the pre-built Business Central specific data models in Jet Analytics, we have a solid foundation to build on. This means that we can use an already prepared model and then maybe just make minor corrections to it.
Get to grips with the terms:
Data – all the numbers and information contained in the company’s systems.
Data sources – the various systems where data and information is entered/collected – and from which it can be retrieved.
Data models – abstract models that systematize, organize and standardize data and that take into account the relationships between the many different types of data so that they can be compared.
Visualization – the presentation of data with e.g. Power BI.