Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
Principles and Rules Listing Page

Field Tips Series- Streamlining & reducing cost of Business Intelligence- Evaluate Open Source

You can reduce your costs, by gradually testing and adopting Open-Source BI in a select set of areas. Open-source BI is gradually gaining attention. Open Source BI is essentially business intelligence software which is open-source. There is a difference within open source and commercial open source. In this page we are talking about commercial open source (don't even think of pure open source, if you are a medium level enterprise and above), which is not free of cost but of minimal cost, with adequate support and services infrastructure. Pentaho and Jasper are examples of commercial open source.
 
This page of 'Principles and Rules' is linked to:  Data Analysis/OLAP, BI platform Tools Evaluation, Data Quality, BI business intelligence end-to-end view, Data Warehousing,

Open source BI brings in the advantages of

  • Low cost
  • Quicker fixing of bugs.
  • Easier to integrate with the other application, as the API used are not proprietary.

However, Open source (at this point of time), should not be seen as the replacement of your core BI platform. The reasons are:

  • Its end to end BI platform capabilities and robustness has not been proven over a time-span and across various organizational scenarios.
  • The ease of use of the proprietary BI platforms, and user friendly documentation (though open source has more comprehensive and transparent documentation.
  • The BI platform providers bring in a whole framework of BI implementations, which is critical element of success.

We recommend Open Source to be used for the peripheral or non-core platforms like:

  • Interactive visualization tools
  • Performance management tools
  • Business modeling tools
  • Reporting & Querying tools. These are not enterprise reporting tools, but used for small-scale ad hoc querying and analysis.
  • Core elements like OLAP servers, ETL, Enterprise Reporting Tools, Enterprise Analytics tools for non-critical stand-alone BI requirements. This can be taken as a pilot for a functional level data-mart.

This open-source BI usage approach has the following advantages:

  • It allows you to gain experience on how to handle the open-source environments, without risking your core installations.
  • It has a good cost-advantage. One of the biggest barrier of making BI to reach every end-user is the user-based/client based licensing of proprietary BI. In this kind of licensing regime, one needs to pay for every user who wants to view a report. Though the cost per license is minor but it adds to huge costs for a large user-base. Even if there is an enterprise level license, it has an inherent usage driven license fee calculation.
  • Open-source data presentation tools, are best of both the worlds, as they free of cost (or even if there is a license for commercial open source, it is typically at an enterprise level and quite cheap), and non-risky for this kind of application. This is one area, which is a Quick-hit

As you evaluate open-source, one has to be more diligent as this is a new trend. Even if the commercial open source is a very low-cost, every acquisition takes a lot of energy, and you may not like to go wrong. While we have separate section (under tool domain) for vendor and tool evaluation, the broad items, which one has to focus more for open-source BI are:

  • Licensing terms of commercial open source.
  • Watch a comprehensive demo.
  • Check on the framework they have on resolving bugs and issues.
  • The Support SLAs.
  • Proposed upgrade path.
  • Retro-fitting support.
  • Check on Consulting and IT service providers, which are the implementation partners of these packages.
  • Diligent reference checks

Quick Feedback- Was this information helpful ?
Relevant Links to this page
Principles & Rules → Data Warehouse application is not limited to Analytics → Principles & Rules → Store as much detailed and granular data in data warehouse as possible → Principles & Rules → Data Normalization is not the best approach in Dimensional modeling → Principles & Rules → Keep the same names and definitions for all data elements → Principles & Rules → You cannot have a super-flexible Data warehouse → Principles & Rules → Dimensional models can be extensible and scalable → Principles & Rules → Data Marts should be ideally based upon a business process and not on a department. → Principles & Rules → Business Intelligence competency groups should be well-linked with business → Practice Techniques → Aggregation Queries on slowly changing Dimensions → Practice Techniques → Documenting your data-integration system → Principles & Rules → For a Data Warehouse/Data-Mart solution, analyze well, but be decisive → Principles & Rules → Maintain a trail of the key dimensional elements from source system to loaded → Principles & Rules → Conformed dimensions are must for cross-drilling → Practice Techniques → Checksum Approach for identifying the changed records from source systems → Principles & Rules → Data Quality is a subject of business ownership and not of IT-ownership → Principles & Rules → Don't create a hype on Data Quality Program. → Principles & Rules → Sponsor for a Data Quality Program → Practice Techniques → Business Case for Data Quality → Principles & Rules → Data Quality is not Perfect Quality → Principles & Rules → Engage the Vendors in Data Quality Program → Practice Techniques → How to get more data along with Sales leads → Practice Techniques → Ask for dates instead of number of years → Principles & Rules → How to Maximize the effectiveness of Data Stewardship → Practice Techniques → Field Tips Series#1- Data Mapping and Assessment → Principles & Rules → Data Management Standards for Data Entities will be a mix of collaboration and top-down → Principles & Rules → Data Management standards for data entities are not only for IT systems → Principles & Rules → Cascade your standards and guidelines to business partners and Vendors → Principles & Rules → Data quality assurance and control guidelines are no-brainer. Publish one immediately and evolve thereafter. → 
 
 
Content Contributed
More Details, Examples, Techniques related to this topic   

Back
 
Relevant links to this page
Data Warehouse application is not limited to Analytics
Store as much detailed and granular data in data warehouse as possible
Data Normalization is not the best approach in Dimensional modeling
Keep the same names and definitions for all data elements
You cannot have a super-flexible Data warehouse
Dimensional models can be extensible and scalable
Data Marts should be ideally based upon a business process and not on a department.
Business Intelligence competency groups should be well-linked with business
Aggregation Queries on slowly changing Dimensions
Documenting your data-integration system
For a Data Warehouse/Data-Mart solution, analyze well, but be decisive
Maintain a trail of the key dimensional elements from source system to loaded
Conformed dimensions are must for cross-drilling
Checksum Approach for identifying the changed records from source systems
Data Quality is a subject of business ownership and not of IT-ownership
Don't create a hype on Data Quality Program.
Sponsor for a Data Quality Program
Business Case for Data Quality
Data Quality is not Perfect Quality
Engage the Vendors in Data Quality Program
How to get more data along with Sales leads
Ask for dates instead of number of years
How to Maximize the effectiveness of Data Stewardship
Field Tips Series#1- Data Mapping and Assessment
Data Management Standards for Data Entities will be a mix of collaboration and top-down
Data Management standards for data entities are not only for IT systems
Cascade your standards and guidelines to business partners and Vendors
Data quality assurance and control guidelines are no-brainer. Publish one immediately and evolve thereafter.
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators

Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Leads Management SWOT
Variable Sales Cost
Sales Channel Management Overview
Sales facility Infrastructure
Sales Revenue Management
Read more...
  Customer Relationship Management
What is Customer Segmentation?
Customer Value and Profitability- BI
Customer Value and Profitability Data Management
Customer Service and Support - Strategic Role
Customer Service and Support Overview
Read more...
  Human Resources & Leadership
Roles and Level based Competency Segregation
Competencies Definitions
Give feedback closer to the observation
Developing Leaders- Few Leadership Traits
Strategic Business Plan
Read more...
 
 
Business Performance & Planning
Strategy Map Objectives Measures and Initiatives
Dashboard Health Checklist
Strategic Business Plan
Scorecard Health Checklist
Review Session should stay focused
Read more...
  Business Intelligence & Data Quality
Data Group to Custodian Map
BI Competency Centre- Establish Phase
Source system mapping matrix
Dimensional Attributes+ Facts + Source Matrix
Data Governance Checklist
Read more...
  IT Vendors & Tools Management
Technical Evaluation- Interoperability
Data Quality Tools Integration
Vendor Commercial Evaluation- Billing structure
Report Development for Enterprise Reporting
Technical Customization Evaluation
Read more...