Services: BI and Data warehousing

By: Camdeboo Connections  06-Dec-2011

BI services, end-to-end

Camdeboo consultants will build for you anything from a rapid prototype or a proof-of-concept BI system, to a fully-fledged system addressing the needs of senior management, analysts and information "consumers".

Multi-dimensional modelling identifies the key measures specific to your chosen subject area (e.g. sales, inventory, warranty). It identifies the various business aspects you wish to measure (e.g. products, sales branches and reps, customers, promotions). This leads to extremely fast drill-down "cubes", packed with easily accessible information to support smart decisions.

Camdeboo will guide you through the process. We know that rapid results are important, so aim to deliver a high-value "quick-win" first, then further deliverables in stages. You'll like our iterative approach which involves users from early on and ensures the system meets expectations.

A well designed datamart or data warehouse is usually the foundation of a BI system. The datamart is designed "dimensionally" (as per

's guidelines) to hold the "single version of the truth" analytical data, in a fast easy-to-use way.

The datamart is:

- separated from the operational data and activities to reduce contention,

- scanned for data quality or completeness,

- reorganised to enable speed and simplicity of access,

- extended to include smart derived KPI measures, and

- merged to bring multi-company information together.

However, a datamart is not always necessary!

In some cases, a simple BI solution can be prototyped or implemented without the need for constructing a datamart. Where the operational data can be extracted without effort into a cube-friendly format, smart BI modelling tools will enable full cube building and report publishing without the need for any extra data transformation.

Contact Camdeboo Connections


Print this page

Other products and services from Camdeboo Connections


Camdeboo: Services

Automate to streamline and schedule after-hours publishing or distribution of report sets, or to remove the administrative load of processing and distributing cubes. It requires a thorough understanding of performance measurement, best-practice design methodology, business analysis, software tools, database and scripting.


Services: Automation

Automation: refreshes multi-dimensional cubes; publishes and distributes data extracts and reports; consolidates log files; sends notifications or alerts to key users; does house-keeping of files and databases. A "master" job controls everything from start to finish.


Services: Workshops

Because we focus on your business and your data, students instantly relate to the instructor's demonstrations and to the many practical exercises they're expected to complete. Suited to both new users and already-trained users needing a refresher, this workshop is ideal for analysts, frequent report authors, power users and frequent cube browsers.