ETL - Extract Transform Loading

Load:
1. Initial Load
   2. Historical Load
   3. Incremental Load

Staging : Temporary Place before it reach the destination.

Roles Involved in These Activities
1. BI Infrastructure Architect
2. Data Administrator
3. Meta Data Administrator

Chapter 8

Risk Assessment Variable:

• Technology
• Complexity
• Integration
• Organization
• Project Team
• Financial Investment

Business Intelligence Application
Purpose
Data Envelopment Analysis (DEA)/CCR : Compare performance between brands/company/things.

DMU : Decision Making Unit

Efficient Measure = output/input

Efficient Frontier = Most Efficient (maximum output/minimum input).

The DEA/CCR Model
Charnes, Cooper & Rhoades

Pareto-Koopman efficiency (if there is 2 variable [A and B], A value is static, and B value is keep increasing or vice versa), it called as SLACK.

Agus Widodo
Lecturer

Presentation Session - 09.08.2011

How CFO do Financial
(Sponsors : MicroStrategy, Oracle, Teradata, Visual Mining)
Presentation Summary (Group - Transforming)

Characteristic 

1. Using historical and find the solution. - Menggunakan Data Historikal untuk mencari solusi.

2. It's about team mate between IT dan CFO (Finance) - Berkaitan dengan kerjasama IT dan Finance.

Growth Path

• ·         Bi Foundation (standarization)
• ·         Operational Enviroments - Disajikan dengan BI Tools (misal: Dashboard)
• ·         Analytic Output from the BI Tools
• ·         Financial Report
• ·         Plan and Budget
• ·         Analyses and Model
• ·         Predictions
• ·         Profitable and Risk Analysis
• ·         360-Degree Views
• ·         Subject Area Metric

Obstacles

A. Stuck in the mud

Diverse source and semantics (perbedaan sumber)

Business Impact

IT Shortcomings (misalnya masalah ketepatan waktu)

B. Excel-Based Silos

Spread-marts

Excel Versatility (kemudahan pengunaan)

Managed Reporting (mudah di manage)

Human Data Warehouse

C. Interactability of spread-marts 

Resistance of change

Complex Rules

Semantics

Adhoc Analysis

Perception

Turf Wars (political issues - too transparent (?) )

 D. Execution Gap

Best Practice

A. Sponsorship and partnership

• ·         Find the pain
• ·         Costs - perihal pendanaan
• ·         CFO Certified Metrics 
• ·         Data Lineage- mencari sumber data (?)
• ·         Finance-BI Partnership - duduk pada suatu ruang yang berdekatan
• ·         Proximity - kedekatan antara BI and IT
• ·         Recruiting from Finance - 1:1 antara finance dan IT
• ·         Merge Teams - BI merge dengan finance (?)

Best Practice

Data Warehouse and General Ledgers

1. Merging GL and Transaction (merging using key)

2. Linking Hierarchies

3. Detailed in Scope and Timely Data

4. Enterprise in Scope and Timely (mengetahui masalah sebelum masalahnya muncul)

5. Cleaning up the General Ledger

6. Standarizing Ledgers and Accounts

7. Reconciling Semantics

Managing Excel

1.  Don't Fight Excel
2.  Convert - convert
3.  Co-opt Spreadmarts - kumpulkan semua data
4.  Coerce - memaksa secara halus  

Testimonial

+ Nice voice

+ Basically Nice slide

+ Quite good in Coordination

- Slide color must be better

- Eye Contact (don't to much read the paper)  + Good at the last

- I think to small

Recommendation

• Get sponsors
• Partner with BI Team
• Homogenize Data
• Construct Data Warehouse
• Develop BI Tools
• Coexists with Others
• Leverage to Other Application

Software as a Service (SaaS) 

Chapter 7 -Presentation Summary

Suparto D

Advance Software Engineering

09 August 2011 - Thursday

Business Intelligence - Session 2

Information 

1. Soft Information     : from external.
2. Hard Information   : from internal.

[ 

  Visi --> 

       Misi  --> 

            Tujuan --> 

                 Sasaran --> 

                        Target

                                     ]

Tujuan 

       greater than 

               Sasaran 

                     greater than  

                            Target         

Business Drivers 

Business Strategy, Goals, and Objective.

The main objective is how to make Business Intelligence that can help Executive.

Risk Rendah, Impact Tinggi - Plums
Risk Rendah, Impact Rendah - Easy Wins
Risk Tinggi  , Impact Tinggi - High Risk / Reward
Risk Tinggi  , Impact Rendah - Why Do it?


Practical Considerations : Analysis FIRST!!!

BI Opportunity Analysis:
1. Strategic Alignment
2. Business and IT Partnership
             -> Partnership from complex or one.
3. Continuous Process Improvement Culture
             -> Punish and Rewards  OR Challenge
4. Culture that Supports The Use of Information and Analytic Tools
             -> Use tools (why not?)
5. Decisions Process Engineering Culture
6. BI and DW Technical Readiness
7. BI Portfolio Management

Reference: Suparto

Business Intelligence