With the proliferation of low cost data storage most organizations today are accumulating large amounts of data about their business - sales, inventory, financial and customer data. However it can be very challenging to access and extract this data in a meaningful way to support business decision processes.

Decentrix's Business Intelligence consulting team together with the BIAnalytix toolset are designed to provide a rapid response solution to this vexing problem. The consulting process starts by an interviewing process with executives and users. The objective is to identify key business questions for which your business is seeking answers. Given those answers what business decisions would be made as a result? This process is intended to crystallize the structure of an executive dashboard, supporting reports and graphical presentations which can be used as key components of the decision making process.

As a part of the process we need to identify where the underlying data is retained (or if it is retained). The data sources may be held in totally disparate applications on different databases (these could be financial data on a separate financial system, a sales system that tracks sales people and their performance in a separate database, an inventory management system attached to a warehousing function etc.). These data sources need to be cleansed and moved to a data warehouse to act as a repository for further analysis.

The Decentrix BIAnalytix toolset provides Powerful tools for each component of the BI solution:

• Extract, Transfer and Load (ETL) tool to import customized data - Finance, Inventory, Rates...
• Database tool for the data warehouse - to structure the transaction history
• OLAP (on-line analytical processing) tool to manage all the cube subtotals - cubes can be created based on any data stored in the data warehouse
• Analysis Presentation tools - allowing the creation of scorecards, dashboards, reports and visualization in graphs, charts and maps
• Portal tools to customize the analysis layout for job roles and users

In specific industries such as online web commerce, media and entertainment where Decentrix has consulted extensively we can fast track some of these processes by utilizing the knowledgebase and templates we have previously developed.

This knowledge transfer process consists of:

• Quick Start
  • Standard tools and templates
• Business Intelligence Kit
  • ETL for media source data
  • Data Warehouse design
  • Pre-defined Cubes and Measures
  • Standard analysis BIAnalytix views/reports
• Hardware and Software Resources definition
• Installation management
• Knowledge Transfer
  • Administration/design training
  • User training
• Prerequisites
  • Data sources exist and are available for extraction to the Data Warehouse

Back to Decentrix website solution and collaborative intranet tools