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, they get filled yet.

Eventually we can also load other databases into the data warehouse. That way we create a very complete picture 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
Subscribe to our newsletter and stay up to date

[inbound_forms id=”1101″ name=”Newsletter subscription”]