Business Intelligence: The destination

Business Intelligence: The destination

1. Ability to transform raw data to actionable information

   • Capturing
   • Consolidating
   • Organizing
   • Storing
   • Distributing
   • Analyzing
   • Providing quick and easy acces to it

2. Helps a company create knowled from that information to enable better decision making and to convert those decisions into action

3. Help with the critical issues of a company

   • Finding areas with the best growht opportunites
   • Understanding competition
   • Discovering the major profit and loss areas
   • Recognizing trends in customer behavior
   • Determining their key performance indicators
   • Changing business processes to increase productivity

4. BI analyzes historical business data

   • created by business or derived from external sources
     • Climatic conditions and demographic data
     • Study a particular function or line of business

5. Information is used to

   • understand business trends
   • strenghts, weaknesses
   • analyze competitors and market situation

6. Information environment

   • Have a structured and organized information
   • Particular advantage
   • Business requirement
   • Information Pyramid
     • Operational Systems
       • Operational
     • Staging, Detail, Denormalized, and Raw Source
       • Tactical
     • Near 3rd Normal Form, Subject Area, Code and Reference tables
       • Tactical
     • Summarized Data, Performance and Rolled-up Data
       • Strategic
     • Dimensional, Data Marts, Cubes
     • Static Reports, Dashboards
       • Strategic

7. Web services

   • Requirements
     • A technique to formal service requests and responses
     • A way to describe the service
     • A method to discover the existence of the service
     • The ability to transmit requests and responses to and from services across a network
   • One key characteristic is that they are platform neutral and vendor independent

8. Activity examples

   • Multidimensional Cube Analysis
   • Business Analysis
   • Clickstream analysis
   • Information visualization
   • Forecasting
   • Data mining
   • Trending analysis
   • Query and reporting
   • Geo-spatial analysis
   • Enterprise portal implementation
   • Digital dashboards
   • Usages in company
     • Operations
     • Finance
     • Customer Service
     • Human Resources
     • Marketing

9. Drivers

   • Business measurments
   • Business complexity
   • Business costs

10. Key business initiatives

    • Business performance management
      • The ability to improve business performance is therefore a critical requirement for organizations.
      • Flexibility and business agility are key to remaining competitive and viable
      • The objective of BPM is to help companies improve and optimize their operations across all aspects of the business
      • Business need the information with a single view of their enterprise
        • Make more informed and effective decisions
        • Manage business operations and minimize disruptions
        • Align strategic objectives and priorities both vertically and horizontally throughout the business
        • Establish a business environment that fosters continuous innovation and improvement
      • assists here by providing performance metrics, or key performance indicators (KPIs), which businesses can employ to evaluate business performance
        • KPI is a performance metric for a specific business activity that has an associated business goal or threshold
      • BPM and BI
        • It might be easy to conclude therefore that BI and BPM are the same thing
        • BPM is focused, however, on a subset of the information delivered by a BI system.
        • BPM is concerned with information that shows business performance and indicates business success or failure.
    • Real-time business intelligence
      • the key now is that management works with data that is genuinely current, that is, real-time, or near real-time, data.
      • Implementing real-time BI
      • To increase the value received, the environment needs to be proactive.
      • Enable the environment to recognize important events and alert users automatically so they can take corrective action
      • the environment must display current status as changes occur rather than requiring a user to ask for current status
    • Data mart consolidation
      • is a small data warehouse built to satisfy the needs of a particular department or business area
      • consists of historical, summarized, and possibly detailed data captured from transaction processing systems (called independent data marts)
      • from an existing enterprise data warehouse (called dependent data marts).
      • Lyfe cycle
        • Assessment
        • Planing
        • Design
        • Implementation
        • Testing
        • Deployment
        • Loopback