Presentation Transcript

1. Business Intelligence

   Jonathan Davis Geoff Witt Cheryl Christian
2. Business Intelligence What is business intelligence? A brief history of business intelligence The “Umbrella Term” Business intelligence solutions Decision-making Support Systems (DSS) Querying and reporting Online analytical processing (OLAP) Statistical analysis Forecasting Data Mining
3. Business Intelligence Why BI is important BI benefits Potential problems Business intelligence solutions 7 tips for rolling out BI Different types of BI software Success factors of implementation Business intelligence vs. business analytics The future of BI software Conclusion
4. What is business intelligence? A broad category of applications and technologies Used for gathering, storing, analyzing, and providing access to data Helps users make better business decisions
5. A brief history of business intelligence Originally phrased in the ‘Cyclopædia of Commercial and Business Anecdotes (1865) by Richard Miller Devens Banker Sir Henry Furnese gained profit by being the first among his competitors to receive and act upon information about his environment.
6. A brief history of business intelligence Today, it is said to have evolved from the decision support systems (DSS) that began in the 1960s, developing throughout the mid-1980s. DSS originated in computer-aided models created to assist with decision making and planning.
7. The “Umbrella Term” BIis often referred to as being an “umbrella term”, having various components “hanging under” it. Data mining Complexity & Business Potential OLAP Frequency and # users Queries & reports Data Warehouse The pyramid tells us that BI consists of various levels of analytical applications/corresponding tools that are carried out on top of a Data Warehouse. The tools will have more users and are used more frequently the lower you go in the hierarchy. Analyses are more complex the higher you go, increasing business potential fromresulting information and knowledge.
8. The Business Intelligence cycle consists of 15 steps:
9. BI Applications include the following activities: Decision-making support systems (DSS) Querying and reporting Online analytical processing (OLAP) Statistical analysis Forecasting Data mining
10. Decision-making support systems (DSS) Designed to facilitate business end users performing computer generated analyses of data Can be model-driven or data-driven Model-driven decision support systems apply a model to a very limited sample in order to extrapolate missing data. Data-driven decision support systems attempt to find patterns in large sets of data.
11. Querying and reporting Querying – the act of retrieving information from the database. SQL is the official database query language used to access and update the data contained within a relational database management system (RDBMS). Reporting – formatting the result of the query for readability and analysis, then distributing it to users.
12. Online analytical processing (OLAP) Enables a user to easily and selectively extract and view data from different points of view. Designed for managers looking to make sense of their corporate data and related information. Structures data hierarchicallyfrom a multi-dimensional database.
13. Statistical analysis Examines every single data sample in a population, rather than a cross sectional representation of samples. Can be broken down into five steps: Describe the nature of the data to be analyzed. Explore the relation of the data to the underlying population. Create a model to summarize understanding of how the data relates to the underlying population. Prove (or disprove) the validity of the model. Employ predictive analytics to anticipate future trends.
14. Forecasting A discipline of analytics that provides the foundation for planning processes across organizations Include demand and inventory planning, budgeting, sales quotas, marketing campaigns and procurement activities. Timely and accurate forecasts can lead to better decisions based on sound predictions of the future.
15. Data mining Data mining is a process used by companies to turn raw data into useful information Helps businesses learn more about their customers and develop more effective marketing strategies as well as increase sales and decrease costs Depends on effective data collection and warehousing as well as computer processing
16. Why is it important? Used by companies to improve decision making, cut costs and identify new business opportunities More than just corporate reporting and more than a set of tools to coax data out of enterprise systems Can also be used to identify inefficient business processes that are ripe for re-engineering
17. What are some potential problems? Although BI holds great promise, implementations can be hindered by technical and cultural challenges. User resistance is one big barrier to BI success Others include having to sort through voluminous amounts of irrelevant data, and poor data quality.
18. Seven tips to rolling out BI systems: Make sure your data is clean. Train users effectively. Deploy quickly, then adjust as you go. Take an integrated approach. Define ROI clearly before you start. Focus on business processes. Don't buy business intelligence software just because you think you need it.
19. Tip 1: Make sure your data is clean. Executives have to ensure that the data feeding BI applications is clean and consistent so that users trust it. Data that is incomplete, inconsistent or in error is useless to business intelligence applications, and using it for decision making can have major consequences.
20. Tip 2: Train users effectively. End users are the ones who are going to take the knowledge gleaned from the application and put it to use. Therefore, the most productive users of the application are those who are trained to use it effectively. If end users are threatened by the system, fail to see how it benefits them, or believe that the system is too hard to use, they will abandon it, rendering the company’s investment in the system useless.
21. Tip 3: Deploy quickly, then adjust as you go. Don't spend a huge amount of time up front developing the "perfect" reports because needs will evolve as the business evolves. Deliver reports that provide the most value quickly, and then tweak them.
22. Tip 4: Take an integrated approach. Build your data warehouse from the beginning. Make sure you're not locking yourself into an unworkable data strategy further down the road.
23. Tip 5: Define ROI clearly before you start. Outline the specific benefits you expect to achieve, then do a reality check every quarter or six months. Periodic reviews will ensure that the program stays on track and achieves the goals that it sets out to. If goals are not being met, reassess the situation and make appropriate changes to get back on track.
24. Tip 6: Focus on business processes. Most companies don't understand their business processes well enough to determine how to improve them, and companies need to be careful about the processes they choose. If the process does not have a direct impact on revenue or the business isn't behind standardizing the process across the company, the entire BI effort could disintegrate.
25. Tip 7: Don't buy business intelligence software just because you think you need it. Deploy BI with the idea that there are numbers out there that you need to find, and know roughly where they might be. Before implementing a BI solution, it is worth taking different factors into consideration before proceeding.
26. Well-known companies offer Business Intelligence Solutions Business Intelligence Solutions for IBM – solutions that tightly integrate with IBM software, hardware, and services. IBM DB2 IBM InfoSphere Warehouse Informix Lotus Notes or Domino Applications Red Brick System i, System x, System P, and System Z Tivoli
27. Well-known companies offer Business Intelligence Solutions Business Intelligence Solutions for Adobe Real-time communication, collaboration, retrieval and exchange of intelligent data New, user-defined work environment from Adobe and SAP Combine BI with the engaging experience of rich Internet applications Use LiveCycle Data Services to stream real=time data into interactive dashboards Allow dashboard users and Flex developers to create richer, more intuitive applications Broaden the landscape of components that both dashboards and Flex developers can use Extend RIAs to the desktop using HTML/CSS, Ajax, Adobe Flash, and Adobe Flex
28. Well-known companies offer Business Intelligence Solutions Business Intelligence Solutions for Oracle Easily and reliably deliver key insights to decision makers – whether your data is stored in Oracle application, databases, or OLAP multidimensional cubes. Deliver integrated, timely, and accurate data across your enterprise Access native drivers for Oracle databases and data warehouses Integrate with PeopleSoft, JD Edwards (JDE), Siebel, and Oracle Enterprise applications Accelerate BI deployment with predefined data marts for multiple Oracle solutions Leverage solutions for business enterprise architecture (BEA) development and portals
29. Well-known companies offer Business Intelligence Solutions Business Intelligence and Performance Management Solutions for Microsoft – As a Microsoft Certified Gold Partner, SAP creates solutions that integrate with the latest Microsoft technologies. Enrich Visual Studio developer applications with SAP Crystal Reports Integrate SAP BusinessObjects solutions with Microsoft Dynamics and Microsoft Office Enhance Excel and SharePoint with eye-catching visualization and analysis capabilities Analyze performance management data using familiar Microsoft Office tools Give managers access to business plans and budgets through SharePoint portals
30. Well-known companies offer Business Intelligence Solutions Business Intelligence Solutions for SAP – Combine data stored in your SAP systems with external information, including other systems and social media. Deliver integrated, timely, and accurate data across your enterprise Collect and share insight with your business users on a single BI platform Access native drivers for SAP ERP Netweaver Business Warehouse, and SAP HANA Accelerate you business intelligence deployment with predefined data marts
31. Well-known companies offer Business Intelligence Solutions Business Intelligence Solutions for Teradata– Enterprise offerings include business intelligence, extractions, transformation, load (ETL), and analytic applications. Extend Teradata Data Warehouse with scalable information management platform Leverage powerful enterprise reporting, query and analysis, and performance management Benefit from Teradata Advisory Group best practices, formed jointly from Teradata and SAP
32. Other types of BI software are offered,including: BOARD Centralized to house data Conduct multi-dimensional analyses (including OLAP) Drill-down to find which areas of a company are performing above and below standard SiSense Developed for all types of users—even those with little or no prior experience with BI software Its tools are used to manage and support business data with powerful visuals and tools.
33. Other types of BI software are offered,including: TIBCO Spotfire Enables companies to synthesize data into a format that is immediately actionable The self-discovery tools make it so that not only IT can dive in and immediately make use of your data. Tableau Engineered to meet the needs of anyone looking to analyze key data Adaptable to most industries Easy to learn
34. Other types of BI software are offered, including: TARGIT Decision Suite A tool for quickly creating customizable dashboards Can be used on iPhones and iPads to analyze pertinent company information. Panorama Offers the industry’s first socially-enabled BI suite. Gives companies the power to gain actionable insights from user behavior.
35. Other types of BI software are offered, including: GoodData Powerful, cloud-based BI suite delivers complete visibility over sales, marketing, and customer service Clear Analytics an Excel-based system that combines the familiar structure of Excel spreadsheets with powerful BI analytics Provides detailed, easy-to-interpret reports
36. Success factors of implementation The level of commitment and sponsorship of the project from senior management The level of business need for creating a BI implementation The amount and quality of business data available
37. Business intelligence vs Business analytics While the terms business intelligence and business analytics are often used interchangeably, there are some key differences:
38. The Future of Business Intelligence Software BI is all set to bring information democracy where end users across an organization will be able to view information related to their segment. Further, with rising customer expectations, there will be demand for capability requirements of BI as well.
39. Conclusion Business intelligence gives you the information you need, when you need it, in the right format. Organizations that are able to successfully implement a business intelligence system to aid in decision-making will make themselves much more competitive in the marketplace.
40. Q&A