Cheat Sheet

Business Intelligence For Dummies

Business intelligence process creates an environment for better decision-making. To make successful business decisions, you need to gain insight in business intelligence, follow the main steps of the key performance indicators (KPI) cycle, find the best source to store and process operational data, and assess and use standard business intelligence applications.

Business Intelligence Insights

To help your company drive smart decisions and improve the way you do business, check out this variety of forms that can provide insight into business intelligence (BI).

  • Query responses: Raw data produced by the BI system, allowing the user to draw immediate conclusions

  • Reports: Structured and formatted data, built as part of a scheduled event, or on the fly as an ad hoc report

  • Derived Analysis: Insights produced by interpretation of a front-end system’s output, after that application has applied rules, heuristics, other business information, and context to it, such as in a dashboard or scorecard

Essential Steps of the Key Performance Indicators Cycle

Business intelligence (BI) is an activity, tool, or process that allows businesses to create clarity and support around their decision-making approach by determining key performance indicators (KPIs). The success level of any business endeavor can almost be measured or quantified in some aspect:

Step 1: Build or define the core business strategy or objectives

Step 2: Specify progress metrics (KPI’s), and define thresholds that indicate degrees of success.

Step 3: Measure performance over time as a baseline

Step 4: Adjust tactics and gauge correlative changes in success metrics

Step 5: Apply lessons to subsequent strategy definition

But business intelligence is very much a cultural phenomenon, moving away from gut-feel strategic choices and moving toward an evidence-driven rational approach to business.

Common Operational Data Sources in Business Intelligence

Businesses digitally store a tremendous amount of operational data, and for business intelligence to function, it needs wide-open roads between data sources. Mainframe legacy systems still form the foundation of many companies’ data centers because of their ability to process and harbor huge quantities of data, but their data is notoriously difficult to get to as many of the legacy applications are obsolete, proprietary, or pre-standards software. Other options for data sources are:

  • Enterprise Resource Planning (ERP): Often implemented throughout the organization in modules that map to specific business domains, such as supply-chain, human resources, finance, accounts payable, and so on. ERP systems store a lot of transactional data used in today’s BI environments.

  • Customer Relationship Management: A common data source for business intelligence, CRM systems do just what they say: they process and store customer profile and behavior information, like purchase activity.

  • E-Commerce: Web applications can act as source data systems for business intelligence platforms by feeding real-time sales activity.

Common Business Intelligence Applications

When choosing a business intelligence application, your goal is put an effective Business Intelligence (BI) solution into place, and you’re looking at processes and software. This chart represents some of the more frequently used BI applications:

Microsoft Oracle SAP IBM Business Objects
Source Data SQL Server, Access Oracle 11g DB2
ETL, Data Integration, Warehousing Integration Services aka SSIS (formerly known as DTS) Warehouse Builder SAP BW DB2 Data Warehouse, Warehouse ManagerWebSphere DataStage (ETL) IBM Information Server Business Objects XI R2: Data Integrator (ETL) Data Federator (virtualization) Rapid Marts (standard platform data marts)
Query and Analysis SQL Server Analysis Services, Access, Excel Warehouse Builder, Oracle Hyperion Essbase Netweaver BI Various Business Objects XI R2: Web Intelligence (query tool) Voyager (OLAP) Desktop Intelligence (query tool)
Reporting, Information SQL Server Reporting Services, Access BI Suite Enterprise & Standard Editions: query, analysis, reporting, Siebel Answers, Interactive Dashboards Netweaver BI BIRT, Design Studio, Alphablox Crystal Reports
Other Front-End Tools Excel Pivot Tables, PerformancePoint 2007 (enterprise scorecarding) Oracle Data Mining Netweaver BI IBM Intelligent Miner (data mining) Crystal Xcelsius (visualization tools), Crystal Vision (dashboard), InfoView (BI portal)
Specialty Apps MS Sharepoint Server 2007 (report distribution) Business domain operational analytics applications, Hyperion System 9 Financial Management, Financial Planning ERP Software, Financial Analytics (formerly Outlooksoft) Websphere Content Discovery (unstructured search) Information OnDemand (hosted BI solutions), Performance Management (Formerly Cartesis)
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.