|
You can now have instant answers to nested questions like.
- Which area makes up the bulk of our Sales last month
- Who was our top Sales Rep in that area
- What was his most popular line
- What percentage of his Sales did this line make up
- Which Customers bought this line from him
Answers to all of these questions without the need to design and redesign new reports.
Using OLAP – On Line Analytical Process, the INTACT Data Drill effectively replaces the Report Writing as we know it.
The Drill comes with three default Drill maps – Sales, Purchases and Nominal. Each of these maps establishes a set of dimensions and measures underneath which one can analyse. Once we set the parameters, the Data Drill builds a model of all the unique instances of the dimensions into a summary file. We can then interrogate this file however we please. The speed at which the data is then recovered and displayed is so much quicker than the conventional method as the data is already present in the model file.
OLAP is an acronym for “On Line Analytical Processing” and it is becoming the fundamental foundation for Intelligent Solutions including, Business Performance Management, Planning, Budgeting, Forecasting, Financial Reporting, Analysis, Simulation Models, Knowledge Discovery, and Data Warehouse Reporting. OLAP performs multidimensional analysis of enterprise data including complex calculations, trend analysis and modeling. OLAP enables end-users to perform ad hoc analysis of data in multiple dimensions, thereby providing the insight and understanding they need for better decision making. With our solutions OLAP is more, it is FAST, EASY, SIMPLE CONTROLLABLE access to the intelligence that is locked in your data. And it can be done through the Excel spreadsheet that you already know how to use.
|