1. BI background;
Big picture, bring into BI domain
data --> info, provide information to help
better making decision for executives
Technical parts:
Data Mining:
OLAP: Online Analytic Processing
Query and Reporting:
Dashboard:
Scorecard:
Analytic Application:
Data Warehouse: no update, maintain all history data
ETL: Extract, Transform, Load
Source system: ERP, CRM
Business parts:
1. Query:
Business View of the data, Web Based Querying, Prompting,
Muitlpe Data Source, Business Question Complexity
2. Reporting:
Production and Management Reports Merge
Document Complexity(Band, group)
Charting(Pie, Bar, Line)
Report Interactivity
Formulas and Functions
3. Information Delivery
Push/Pull
Scheduling
Alerts (revenue lose)
BI Portal
4. Excel Integration
Interactivity
Export/Import
5. OLAP
advantages to Reporting:
Multidimensional, Consistently fast, Varying levels of aggregation,
Cross-dimensional calculations
Architectures: MOLAP(multidimensional), ROLAP(relational), DOLAP(dynamic/desktop)
(Cube built in advance, slow response time)
Drill down/Drill up:
Sources to Populate Cubes:
Analysis and Reporting Integration: (Summary level OLAP + detail level reporting)
6. Administration
Security(Integration security - LDAP, authentication/authorization)
metadata
Impact Analysis
Usage Monitoring
7. SOA(Service Oriented Architecture): web service
总的来说，要做好一个完全的BI解决方案，决不是一天两年的事，甚至不是一年两年的事，其中既有技术的难度，又是业务领域的难度，也许正象一位业内专家说的，要实现BI最好是业务驱动，客户需要什么我们就做什么，而不是做一个大而全或者引入一个大供应商的整套解决方案，总之具体问题具体分析。
