Blog

Dimensional modeling

Valuable management information based on your data

By Davy Groffen

 

Organisations are increasingly focusing on data. Makes sense, because data can contain a lot of value. "Data is the new oil," you may have heard. Where is your hidden oil in your organisation? Through dimensional modeling, we can convert your data into insightful dashboards so you can make decisions bases on valuable management information.

 

What is dimensional modeling?

With dimensional modeling, you get the valuable information from various sources on an operational, a tactical, and a strategic level. The challenge for dimensional modeling lays in all the different available data. Your data is stored in different systems (databases, CRM systems, inventory management systems, etc.), but is not centralized, yet. Together we want to combine these different sources.

In order to obtain clear management information, it is important that users can aggregate and filter these data for dashboards and reports. Dimensional modeling is therefore concerned with the question “How do I organise my data warehouse in such a way that I get the right insights from dashboards and reports?”.

 

Discover

In the discovery phase, we map the available data of the organisation. This gives us an overview of different applications that are spread over multiple databases. We investigate whether we can obtain clear management information by means of dimensional modeling.

 

Design

If it appears that dimensional modeling provides a valuable addition to the organisation, we elaborate on the so-called star schema. The star schema forms the basis for the data warehouse on which the reports and dashboards can be made.

 

Develop

After we worked out the design, we start with the technical implementation of the data. The relevant source data is placed in the data warehouse, after which it can be used for creating reports and dashboards.

 

Deliver

In the deliver phase we check whether the data warehouse provides the desired insights. The data in the data warehouse must be easy to use. For example, users should be able to filter valuable information for their point of interest.

 

Do you want to extract valuable management information? We are happy to help you achieve the desired growth, insight into your processes, optimization, and innovation. Please feel free to contact our Data Wizard Bas. You can call +31646165358 or send an email bas@datawizards.nl

#dimensionalmodeling #solutions #decisionbased #data

Data Wizards Projectwall.jpg

Contact us

Do you want to get to know us?

Please contact Bas Fransen

+31646165358bas@datawizards.nl

Privacyverklaring

Algemene Voorwaarden

Alle rechten voorbehouden

Contact

E: hello@datawizards.nl

T: +31646165358

Reactorweg 301

3542 AD Utrecht

Nederland

©2020 Data Wizards B.V.