Business Intelligence & Data Warehousing Consultancy

The range of services we offer includes:

Design, delivery and support
Strategic reviews of planned or existing systems
Project Management Services
User requirements analysis
ETL - extract, transform, load
Data management best practice consultancy
Data quality reviews
Development of effective business rules
Appropriate information delivery
Business solutions
Training

• Design, delivery and support

  We provide services to implement a complete Business Intelligence or Data Warehouse solution, or just a component of a solution, e.g. the ETL component or a web reporting capability.

• Strategic reviews of planned or existing systems

  Overall review to revisit business requirements or benchmark against current best practice, architecture review, application review, quality review, procedures review, or solution component review.

• Project Management Services

  Project Management of Business Intelligence or related projects. Business Intelligence projects are different than traditional IT projects, and therefore need to be managed in different way.

• User requirements analysis

  To determine and document what all future users of the Business Intelligence solution require from it. Part of this process is enlightening people as to what is possible from a Business Intelligence system

• ETL - extract, transform, load

  Analyse, design and implement an effective method to load data from operational systems into the data warehouse.

• Data management best practice consultancy

  Data does not manage itself. A successful business intelligence solution requires careful initial design and ongoing management.

• Data quality reviews

  It is vital that users can trust the information coming from the business intelligence system. The business intelligence solution should become the one source of the truth for information in an organisation, rather than conflicting information coming from a number of different sources.

• Development of effective business rules

  Another essential component of a successful business intelligence solution, business rules ensure that all users are using a common and agreed set of logic and understanding to create information from the data warehouse. Too many organisation get different answers to the same question if it is asked of different people or business units.

• Appropriate information delivery

  The most important function of a business intelligence solution is to be able to get information to the people that need it. We can advise on, design and implement the appropriate information delivery mechanisms(s) for an organisation or group of people, e.g. dynamic slice & dice web reporting, customised portal interfaces, simple static web pages, e-mailed results or results in an Excel file ready for further analysis.

• Business solutions

  We can provide full business solutions, for example performance monitoring, customer analytics, fraud analysis, or financial reporting.

• Training

  We provide a wide range of training options, including training needs analysis, business intelligence and data warehouse seminars on various topics, and an extensive range of SAS product training. We deliver most of the SAS Institute training courses in New Zealand and, with our philosophy of and strong commitment to knowledge transfer in client organisations, we endorse and provide customised application training programmes for large and small installations alike.