Building Making It Happen
Building Making It Happen
  Sign-in         Register
    
Principles and Rules Listing Page
For Core BI platform go for a single, established and robust player
Core Business Intelligence Platform includes Data Warehouse Server, Metadata management tool, ETL tool and OLAP server. These are the foundation/plumbing/infrastructure elements of your business intelligence. We recommend for you to go for a single and financially robust vendor for as many of these elements as possible.
 
This page of 'Principles and Rules' is linked to:  BI business intelligence end-to-end view, Business Intelligence and performance management V, Business Intelligence End User Tools Evaluation, BI platform Tools Evaluation, Core Data Management Tools, Data Warehousing, Data Analysis/OLAP,


You should refer BI tool evaluation kit and overall tool landscape to get some detailed back-ground. In-brief, there are two kinds of tools groups

  • Core BI platform tools- Data Warehouse server, OLAP server, ETL tools, Data-federation tools, metadata management tools, data integration tools. These tools have a long list of capabilities, which form the foundation and core of your BI platform.
  • BI end-user tools- These are the tools, which sit over the core BI platform, and used to generate information out of the data stored and administered in the core platform. examples of these kinds of tools are- Enterprise Reporting, Analytics tools, performance manager, data mining tools etc...

Doing first things first, an organization needs to decide the vendors for their core BI before anything else. We recommend that get all these core components from a...

Single vendor

This is similar to getting all the plumbing for your building to be done by a single contractor, while you may buy your bathroom fittings from different vendors. The core platform components need to be well integrated and their level of integration drives the performance. In case of multiple vendors for the core BI platform, you have a the following disadvantages-

  • No end-to-end responsibility
  • Investigation of issues, will involve multiple parties
  • Any change that you will do in your BI model or dimensional model will need to be worked upon by multiple vendors.

In-brief, a single vendor will take away all these nightmarish scenarios. This is similar to you having a single ERP vendor instead of having different components from different vendors.

Therefore, if a vendor is selling you an ELT tool or a 'data-integrator' on a stand-alone basis, one should explore his overall end-to-end BI capability. As a side note, some of these stand-alone products are very good, but they do not become strategic, if not part of an integrated offering.

Financial Robust and Large Vendor

BI space is going through a lot of turmoil for last many years. This is manifested in the spate of acquisitions. At any point of time, half of the BI industry is acquiring the other half. Therefore, it is must that you go for the top line BI vendors, who are financial strong, have depth in their organization and also large number of implementation. This will ensure that vendor will keep on investing the future road-map and also the existence of its products will not be significantly impacted by any acquisitions.

   Access more details on this page   

Quick Feedback- Was this information helpful ?
Relevant Links to this page
Principles & Rules → Dimensional model has to be aligned to the Entity-Relationship → Principles & Rules → Always Use Conformed Dimensions → Principles & Rules → You may not be a able to have a perfect ETL → Practice Techniques → Handling Sparse Dimensional tables → Principles & Rules → Do not separate the parent and child line item data → Practice Techniques → Managing time-stamps across multiple time-zones → Practice Techniques → Recording events in multiple currencies → Practice Techniques → Handle different units of measure in the same fact table → Principles & Rules → Handling of Null foreign Keys in fact tables → Principles & Rules → Dimension Attributes as NULL → Principles & Rules → Don't rely too much on Meta Data Tools to enforce Business Intelligence → Principles & Rules → Don't wait for universal models for Data Marting → 
 
Back
Featured Pages
BI Cost-Reduction- Consolidate Marts
Data Correction Checklist
Data Warehouse ETL Extraction
Data Mart + Dimensions +facts

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
Data Quality Gaps Root Cause Analysis
Data Warehouse Components and Framework
Knowledge Discovery in Databases Process
Metadata Extraction, Transformation and Loading