Business Intelligence

InteliSense IT have helped organisations with data management by providing comprehensive, robust data management solutions.

Microsoft Business Intelligence delivers a rich end user experience with a strong Microsoft platform. The Microsoft solution will fully power the investment in the Microsoft platform already made by organisations. Intelisense IT help organisations make best use of their investment in the Microsoft platform and empower users to make informed decisions based on a familiar and consistent product set.

A Data Warehouse is a database that has been structured specifically for reporting and its aim is to form the foundation for all analysis. This structure differs greatly from that of a traditional OLTP (transactional) database.


Data Warehousing enables data from multiple disparate systems to be consolidated into a structure that is easy to understand and consume.

Tables and column names mimic business terminology thereby allowing reports to be generated without in-depth knowledge of source systems.

Business logic is embedded in the data load process, which reduces the strain on the reporting application.

Business Intelligence (BI) involves getting the right data to the right people in the appropriate time-frame so business decisions can be made. BI uses data from your business and processes it to enable the information to be useful in order to meet business needs.Some uses can include: predictive analysis, tracking market trends, and inventory management.

In AX, the end product can be to build a report or to create a dashboard. A dashboard is a visualisation tool that can display a set of metrics or Key Performance Indicators (KPIs) not as tables of numbers but as graphs and charts. AX allows easy access to information by simply exporting the data to Excel. For more complex requirements, another option is to use Microsoft SQL Server Business Intelligence Development Studio (BIDS).