Jack Cheung 5-Mar-2013
• What’s Business Intelligence
• How BI provides business values to enterprises • Popular BI applications
– – – – – – BI reports and dashboards Budget planning Financial consolidation and reporting What-if analysis Balanced scorecard Data mining
• Challenges of implementing BI projects
• Hot BI topics in 2013
– Big data – Cloud – Social networking
• BI career development
• References • Q&A
What’s Business Intelligence (BI)?
What’s …
From Data to Knowledge
Operational Systems
Business Knowledge
Key Value Drivers
Accounting Manufacturing
POS
Customer
Supplier Payroll Etc.
Most Profitable Areas Seasonal Trends Consolidated Results Rolling Forecast
Scenario Analysis Etc.
From Flat Tables to Multi-aspect Views
Segment Fashion Chemical Healthcare Industrial Retail Fashion Chemical Healthcare Industrial Retail Fashion Chemical Period Jan 2012 Jan 2012 Jan 2012 Jan 2012 Jan 2012 Feb 2012 Feb 2012 Feb 2012 Feb 2012 Feb 2012 Mar 2012 Mar 2012 Rev. $ '000 4,231 2,685 1,856 3,651 3,865 4,443 2,819 1,949 3,834 4,058 4,665 2,960
Fashion Chemical Healthcare Industrial Retail
Q1 2012 Q2 2012 Q3 2012 Q4 2012 12,693 13,962 14,597 15,232 8,055 8,861 9,263 9,666 5,568 6,125 6,403 6,682 10,953 12,048 12,596 13,144 11,595 12,755 13,334 13,914
Multiple aspect view Easier to analyze
Store data in flat tables
Transform Data into Business Value
Data > Information > Knowledge > Decision > Profit
Wisdom
Objectives for coming fiscal year • Increase revenue by 20% • Increase profit margin by 5% • ………..
Rev. $M
Profit Margin
Rev. $M
Profit Margin
Annual Targets - Tablet - Worldwide • Profit Margin maintains at 35% • Revenue 20%
Rev. $M Profit Margin
Annual Targets - Tablet - Worldwide • Profit Margin maintains at 35% • Revenue 20%
Rev. $M Profit Margin
BI enables Performance Management
Better Execute on
References: • • • • • • • • • www.epmreview.com www.tdwi.org www.thepalladiumgroup.com (www.bscol.com) www.businessintelligence.com www.gartner.com www.information-management.com www.b-eye-network.com www.hkcs.org.hk/en_hk/sg/bisid/index.asp ………. Business Intelligence Special Interest Group (BISIG) Hong Kong Computer Society (HKCS) Q&A