群邑中国数据仓库方案.pptxVIP

Data Warehouse  Business Intelligence(DW/BI) Concept Design agenda Challenge DW/BI Overview DW/BI project Overview Microsoft All-up DW/BI DW/BI Architecture Demo Appendix agenda Challenge DW/BI Overview DW/BI project Overview Microsoft All-up DW/BI DW/BI Architecture Demo Appendix GroupM China Challenge No data island? Minder, Matrix, YourReport, Adept, HRM… Most data stored in excel files on every PC Data security Make full use of existing systems, Active Directory, Windows, Office, SharePoint Reduce IT efforts for implementation and maintenance Can current data systems make actionable insight readily accessible to everyone, especially decision maker? Data is data, not Information or Knowledge (Wisdom) Real case in GroupM China Friend or Foe? Which become Which eventually become Existing Reporting Systems Dashboards Analytics Data Mining Reporting Scorecards Data Quality / Master Data Results So users end up… agenda Challenge DW/BI Overview DW/BI project Overview Microsoft All-up DW/BI DW/BI Architecture Demo Appendix What is DW/BI? Data warehouse and business intelligence are techniques to provide business people with the information and tools they need to make both operational and strategic business decisions. “Newly minted executives, managers, and operational staff who have been exposed to better, more integrated information access, analysis, and  management tools will expect to use  them to increase the performance  and competitiveness of their  organizations.” “Worldwide Business Intelligence Tools Software 2009–2013 Forecast,” IDC,  Doc #217443, March 2009 “Through 2012, more than 35 per cent of the top 5,000 global companies will regularly fail to make insightful decisions about significant changes in their business and markets due to underinvestment in their information infrastructure and business user tools.” “Predicts 2009: Business Intelligence and Performance Management Will