• Follow Intact Software on Twitter
• Find Intact Software on Facebook
• Find Intact Software on LinkedIn
• View Intact Software on Youtube

Data Drill

The INTACT Data Drill is a now a standard feature of your accounts system and provides state-of-the-art interactive data mining and analysis. This tool complements INTACT's reporting engine by providing real time inquiry of your sales, purchasing, nominal and stock information. 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.

Some Key Terms

In the Data Drill editor under the utilities menu, the mapping can be customised to give maximum effect.

F – Files – The files required can be specified for individual maps.
R – Relationships – Sets the relationship master in this “master / slave” process
S – Slave Tables – Indicates the relational slave tables
D – Dimensions – sets the possible dimensions that may want to be analysed under
M – Measures – sets the measures which will be displayed in the analysis
P – Parameters – sets the limits within which the model will be built

OLAP Explained

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.