Business Intelligence
OLAP and Data Mining
Online Analytical Processing (OLAP) simply means being able to analyse your data
in a multi dimensional way. A relational table has two dimensions whereas an OLAP
cube could have many more. We are experts in Microsoft SQL Server Analysis Services
and being able to design, build and utilise the cubes in a practical and efficient
manner.
Cubes are extremely efficient entities when it comes to storing summary levels,
hierarchies and allowing slicing and dicing for analysis. SQL Server 2005 has been
designed to integrate with other well known Microsoft client tools like Excel allowing
for advanced analytics to be done without learning the ins and outs of creating
the cubes behind the scenes. Let us help you build the necessary cubes for
you to obtain real value from your data.
Analysis Services also has advanced Data Mining techniques out of the box and in
the right hands they can be utilised to support your analysis. A common retail example
of such a technique is basket analysis - what products are most
commonly purchased with other ones? We understand Data Mining and can help simplify
and explain this potentially complex area of analysis.