People Innovation Excellence

Busines Intelligence di Organisasi

Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes. BI technologies are capable of handling large amounts of unstructured data to help identify, develop and otherwise create new strategic business opportunities. The goal of BI is to allow for the easy interpretation of these large volumes of data. Identifying new opportunities and implementing an effective strategy based on insights can provide businesses with a competitive market advantage and long-term stability.

BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies are reportingonline analytical processinganalyticsdata miningprocess miningcomplex event processingbusiness performance managementbenchmarkingtext miningpredictive analytics and prescriptive analytics.

BI can be used to support a wide range of business decisions ranging from operational to strategic. Basic operating decisions include product positioning or pricing. Strategic business decisions include priorities, goals and directions at the broadest level. In all cases, BI is most effective when it combines data derived from the market in which a company operates (external data) with data from company sources internal to the business such as financial and operations data (internal data). When combined, external and internal data can provide a more complete picture which, in effect, creates an “intelligence” that cannot be derived by any singular set of data.

Often BI applications use data gathered from a data warehouse (DW) or from a data mart.

According to Kimball et al., there are three critical areas that organizations should assess before getting ready to do a BI project:

  • The level of commitment and sponsorship of the project from senior management
  • The level of business need for creating a BI implementation
  • The amount and quality of business data available.

The quality aspect in business intelligence should cover all the process from the source data to the final reporting. At each step, the quality gates are different:

  1. Source Data:
    • Data Standardization: make data comparable (same unit, same pattern…)
    • Master Data Management:unique referential
  2. Operational Data Store (ODS):
    • Data Cleansing:detect & correct inaccurate data
    • Data Profiling: check inappropriate value, null/empty
  3. Data warehouse:
    • Completeness: check that all expected data are loaded
    • Referential integrity:unique and existing referential over all sources
    • Consistency between sources: check consolidated data vs sources
  4. Reporting:
    • Uniqueness of indicators: only one share dictionary of indicators
    • Formula accuracy: local reporting formula should be avoided or checked

Reference : http://en.wikipedia.org/wiki/Business_intelligence#Data_warehousing


Published at :
Leave Your Footprint

    Periksa Browser Anda

    Check Your Browser

    Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

    Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

    Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

    Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

    We're Moving Forward.

    This Site Is No Longer Supporting Out-of Date Browser.

    If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

    Best viewed with one of these browser instead. It is totally free.

    1. Google Chrome
    2. Mozilla Firefox
    3. Opera
    4. Internet Explorer 9
    Close