BI summary

BI Architecture

BI architecture involves the design and implementation of data marts, OLAP cubes, reporting systems and dashboards and portals. A well designed system allows 'information self-service' at every required level from the highest aggregation level to individual records of data.

OLAP Cubes

Online analytical processing is an advanced BI technique which uses hierarchies and measures to 'slice and dice' data and quickly retrieve statistics for the user.

SAS Consultancy

As a SAS consultant, Clare Nicklin has a large amount of experience in the SAS Enterprise Business Intelligence suite, which provides a complete portfolio of business intelligence capabilities from OLAP Cube Studio to BI Dashboard to leveraging the functionality of Microsoft Office.

Award winning

Presented awards in previous job and international conferences for BI design, implementation and problem solving.

Business Intelligence Services

Business Intelligence Architecture

As a BI architect, it is necessary to engage with key stakeholders to understand their needs and the needs of their business. Such stakeholders need the right intelligence on which to base their decisions and create their future strategy. Once this 'intelligence' is understood, portals, dashboards and reporting systems can be planned and designed by the architect using the most appropriate technology such as web based applications or mobile apps. The architect then needs to extract and organise the necessary data. Such organisation of data involves the effective use of data marts i.e. extracting precisely the required data and creating the statistics which are to be measured, and the efficient creation of OLAP cubes if they are to be used.

OLAP Cubes

Cubes allow architects to pre-plan the kinds of queries business users might make on data. Certain queries will be expected i.e. plotting a specific measure against a hierarchy such as time (year>quarter>month) or geography (country>region). An understanding of the data and likely report requirements will dictate the structure of the cube. Once built, these cubes will deliver complicated information very quickly and allow the user to expand and collapse the hierarchy to see information plotted by parent and child nodes of the hierarchy instantaneously. If the cube is correctly designed, it will also deliver 'drillthrough' where a paricular slice of data can be interrogated to get the precise data records which make up the statistic, removing the overheads involved in data users sending ad-hoc query requests to developers.

SAS Consultancy

All the techniques described here, from the storage and extraction of data to the visualisation of graphics, can be implemented using The SAS System. SAS offers an extensive toolset, in which Clare Nicklin has a large amount of experience.  Read More

Award Winning

Presented award for Outstanding Delivery in IT Development in previous role for designing and implementing a set of institutional dashboards for The Open University's executive board. Winner of Best Contributed Paper in Business Intelligence section at the 2009 SAS Global Forum in Washington DC for a paper documenting how to overcome problems in OLAP cubes using SAS Enterprise BI Server.