Data warehouse & OLAP Cubes

The Datawarehouse structures, collects and cleans corporate data

The data warehouse (DWH) is actually the heart of your Business Intelligence solution. We take data from your existing databases of Microsoft Dynamics NAV and Dynamics AX, clean it and complement it. So when some fields are not filled correctly, the person responsible gets a signal.

Data gets interesting when it is combined with data from other sources. We can load other databases into the datawarehouse. That way we create the 360 degree view of your company in numbers.

A big advantage is that data can not be adapted in the data warehouse by people that are not allowed to do so. We make sure everyone works with numbers that originate from one single system and prevent that users see different numbers in reports.

“With our OLAP Cubes we are able to improve our KPIs”

For most financial controllers slicing en dicing is very important. After receiving the data from the data warehouse, they are loaded in OLAP Cubes. That is the last step in the Extract, Transform, Load (ETL)-process. That enables you to slice through different areas of application. For instance when you want to know how many products you sold last month in France, you can easily walk through the ‘sales’. The reporting tool that you use, gets its data from the OLAP Cubes. So you can use Microsoft Excel to view your data. At the same time you can interactively let other measures and dimensions appear in the same report.

Datawarehouse Business Intelligence for Microsoft Dynamics AX NAV Power BI Hillstar

For us it is a way to flexibly provide unambiguous information needed to run the business.

“Not only for the monthly reporting but also as part of our day-to-day business operations. It is vital that the information that is  reported is based on the same definitions. With our first set of Cubes we know for sure that the monthly reports are based on the correct data and that it is safe for users to generate reports themselves on an ad hoc basis. You just know for sure that it is correct.”

Read more

Promens Plastic Manufacturing with Hillstar Business Intelligence
Subscribe to our newsletter and stay up to date