1 / 68

Teaching Business Intelligence

Teaching Business Intelligence. Paul Hawking Victoria University. Why BI?. Motivation Tools Resources. Why Not BI?. Teaching Business Intelligence. Information And Analytics. Implementation. Corporate Performance Management. BI Competency Centre. Data Quality.

kamana
Télécharger la présentation

Teaching Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Teaching Business Intelligence Paul HawkingVictoria University

  2. Why BI?

  3. Motivation Tools Resources Why Not BI?

  4. Teaching Business Intelligence Information And Analytics Implementation CorporatePerformanceManagement BI Competency Centre Data Quality Business Intelligence Governance How is my company performing? How do I implement BI best practices across the enterprise? What are the best practices to ensure data quality? How to best implement BI in my company. Business Intelligence Architecture Architecture Extraction Transformation Loading Query Development Performance Mobile BI What objects do I need to create in my BI environment? How do I load and integrate data from different source systems? How do I build efficient queries? How can I improve the performance of my BI environment? How can I make my BI mobile?

  5. Business Intelligence Focus

  6. Strategy and Business Processes

  7. Business Process Elements • Organisational Units • Sales Area • Distribution Channel • Transactions • Sales Order Creation • Goods Issue • Data • Master Data • Customer • Material • Transactional Data • Sales Quantity • Sales Price Process Indicator

  8. Strategic Success – Tetra Pak Process Performance People Tools

  9. The Result: Workers Lose Productivity from Inadequate Information Access 54%Lose Productivity Other effects: 47% Make Flawed Decisions45% Lose Competitive Agility Source: Economist, ‘Enterprise Knowledge Workers Study; November, 2007

  10. Growing Importance of Business Intelligence

  11. Top 10 Business and Technology Priorities in 2010 Source: Gartner EXP (January 2010)

  12. Business Intelligence Process

  13. Information Systems To Support Decision Making

  14. SAP Business Objects Business Intelligence

  15. Business Intelligence Platform

  16. Business Drivers and Target Groups

  17. Business Drivers and Target GroupsReporting Tools for Different User Groups

  18. Business Drivers and Target GroupsReporting Tools for Different User Groups

  19. Crystal Reports • Proven standard for report design • Used by more than over 500 major software vendors • Sophisticated report formatting • Pixel perfect reports • Create multi-page • Multi-query • Templates and wizards to speed • up report creation • Secure, large scale distribution of • reports • Connectivity to any data source

  20. SAP Crystal Reports Access http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx

  21. SAP Crystal Report Resources • Crystal Reports 2011 http://www.sdn.sap.com/irj/scn/crystal-reports-elearning?refer=main • Crystal Reports Enterprise http://www.sdn.sap.com/irj/scn/crystal-reports-enterprise-elearning?refer=main

  22. Business Drivers and Target GroupsReporting Tools for Different User Groups

  23. SAP Business Objects Dashboard (formerly xcelsius) • Personalised Flash based dashboards • Variety of output mediums • Microsoft Office Documents • Portals • PDF • Empower business users with interactive information • Powerful “what if” analysis with slidersand other controls • Ability to drill down • Pre-built components, skins, maps, charts, gauges, and selectors

  24. SAP Business Objects Dashboard Design Access http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx

  25. SAP Business Objects Dashboard Resources • http://www.sdn.sap.com/irj/scn/dashboards-elearning?refer=main

  26. Business Drivers and Target GroupsReporting Tools for Different User Groups

  27. Web Intelligence (Interactive Analysis) • Self service analysis and reporting • Business Users • (Limited) technical expertise (report designers), • business domain expertise • Interactive report creation • Flexible formatted reports with built-in analysis features • Built on any type of data source

  28. SAP Business Objects Web Intelligence Access http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx

  29. SAP Business Objects Web Intelligence Resources • Web Intelligence http://www.sdn.sap.com/irj/scn/web-intelligence-elearning?refer=main

  30. Business Drivers and Target GroupsReporting Tools for Different User Groups Analysis (OLAP/Office)

  31. Analysis (OLAP/Office) • Optimized for highly interactive analysis (Ad Hoc) • Explore multi-dimensional data sets • Available for Web based and Microsoft Office focused deployments • Comprehensive range of business and time calculations • Visualization options • Exception highlighting • Ability to drill down into details (Web Intelligence or Crystal Reports)

  32. SAP Business Objects Analysis Resources http://www.sdn.sap.com/irj/boc/analysis-office-elearning?refer=product-help

  33. Business Drivers and Target GroupsReporting Tools for Different User Groups Analysis (OLAP/Office)

  34. Business Objects Explorer • Search and navigation tool for casual users to access business data • Ability to search, explore and visualise large data volumes via Business Warehouse Accelerator (BWA) • Guided analysis and smart visualisations • Limited training required

  35. SAP Business Objects BI On Demand Resources http://www.sdn.sap.com/irj/boc/ondemand

  36. Interaction Teaching Approaches Tell me, I’ll forget 告诉我，我会忘记 展示给我，我会记住 涉及到我，我会了解 Show me, I’ll remember Involve me, I’ll understand

  37. Business Intelligence Knowdules

  38. SAP Business Intelligence Tools and Tutorials

  39. SAP Community NetworkLeadership in Social Innovation, Social Commerce and Social Intelligence > 2.3 million members strong > 200 countries and territories ~ 20,000 new members / month Members ~ 1.1 million unique visitors / month > 4 million visits @ 20 million pages / month Traffic > 200,000 have contributed (ever) > 99,000 last year w/ 2,000 top contributors ~ 6,000 bloggers … 100+ SAP Mentors … Contributors ~ 4,000 posts / day in 350+ forums ~ 2 million topic threads @ 7M messages ~ 2 million monthly newsletter impressions “SAP Community Network may be the most extensive use to date of social media by a corporation.” Leveraging the Talent-Driven Organization The Aspen Institute - 2010 Momentum ~ 700+ SAP ecosystem solutions Thousands of demos and trials delivered Serving >200 countries @ all industries Impact

  40. BI Community Content – Open to Public • Keycode for 3-month validity (Crystal Reports and Dashboards)

  41. Steps to access UA-members only content • Log on to www.uac.sap.com with user ID and password • On UAC landing page, click this on top right-hand corner : • Select “Business Intelligence” section under UA Library (left-hand bar) • Scroll down to “UA Business Intelligence Curricula”. All BI-related content are available here. • Additional Resources • Check out “Recent BI documents” for additional teaching materials d by other professors • Participate in “BI discussion forum” or post your own questions to start communicating with others in the community UA Program Members Access UA Library Reserve Desk

  42. BI Curricula for UA Members only

  43. SAP Crystal Reports & SAP Integration Kit https://cw.sdn.sap.com/cw/docs/DOC-116115 • Step 1: Download slides, case studies and xls files for exercises Step 2: Download softwareswith 6-month validity keycode

  44. SAP Crystal Dashboard Design • Step 1: Download slides, case studies and xls files for exercises Step 2: Download software with 6-month validity keycode

  45. SAP Crystal Dashboard Design -Complete Standalone Kit without going to UCC • Lecture Slides & teaching notes Case studies/exercises Data sources for exercises

  46. SAP BusinessObjects Web Intelligence & Universe Design https://cw.sdn.sap.com/cw/docs/DOC-51386

  47. SAP Business Objects Explorerhttps://cw.sdn.sap.com/cw/docs/DOC-124419

  48. SAP Business Objects Explorer • Lecture slides • teaching notes • Exercises plus data source • Case study based on GBI

More Related