1 / 20

Business Intelligence

Business Intelligence. Presented by: Ryan Stephenson. What is Business Intelligence?. Business Intelligence is the processes, technologies, and tools that help us change data into information, information into knowledge and knowledge into plans that guide organizations

joseph-rosario
Download Presentation

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. BusinessIntelligence Presented by: Ryan Stephenson

  2. What is Business Intelligence? • Business Intelligence is the processes, technologies, and tools that help us change data into information, information into knowledge and knowledge into plans that guide organizations • Technologies for gathering, storing, analyzing and providing access to data to help enterprise users make better business decisions

  3. What is Business Intelligence? • Business Intelligence (BI) is about getting the right information, to the right decision makers, at the right time. • BI is an enterprise-wide platform that supports reporting, analysis and decision making. • BI leads to: • fact-based decision making • “single version of the truth” • BI includes reporting and analytics.

  4. History of Business Intelligence • In a 1958 article, IBM researcher Hans Peter Luhn used the term business intelligence. • Business intelligence as it is understood today is said to have evolved from the decision support systems which began in the 1960s and developed throughout the mid-80s. • In 1989 Howard Dresnerproposed "business intelligence" as an umbrella term to describe "concepts and methods to improve business decision making by using fact-based support systems.” • It was not until the late 1990s that this usage was widespread.

  5. Why BI?The Five Questions • What happened? • What is happening? • Why did it happen? • What will happen? • What do I want to happen? Past Present Future Data ERP SCM 3Pty Black books CRM

  6. Benefits of BI • Eliminate report backlog and delays • Find root causes and take action • Negotiate better contracts with suppliers and customers • Identify wasted resources and reduce inventory costs • Sell information to customers, partners, and suppliers • Leverage your investment in your ERP or data warehouse • Improve strategies with better marketing analysis • Challenge assumptions with factual information

  7. Limitations within BI • Very high software cost • Expensive and time consuming training • A wide variety of technology experts • Extensive system upgrade and maintenance • Movement of data between disparate data sources • Queries done out of BI systems can be cumbersome and time consuming to run for end users

  8. Common Problems • Data everywhere, information no where • Different users have different needs • Your format – my format • Security issues 8

  9. Microsoft Business Intelligence Vision Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions • Advanced Analytics • Self Service Reporting • End-User Analysis • Business Performance Management • Operational Applications • Embedded Analytics

  10. Microsoft BI Growth: Gaining Ground “Microsoft's BI Tools revenue growth in 2005 was more than 25 percent, growing at more than twice the rate of the overall market.” “Microsoft's impact on the BI tools market cannot be overemphasized. This impact will mark an evolutionary change that has been put into motion by the database vendors overall and will reshape the BI tools market over the next 15 years.” --- Dan Vesset, IDC (International Data Corporation)

  11. Microsoft BI Platform

  12. Implementation Approach Business Needs Validate Investigate Data Systems Develop Prototype Solution Finalize & Implement Solution Train Users Enterprise-Wide Deployment

  13. PowerPivot for Excel 2010 • Leverage familiar Excel features you already know • Process millions of rows in about the same time as thousands • make the most of multi-core processors and gigabytes of memory for fastest processing of calculations. • Retrieve data from any source • Take advantage of DAX (Data Analysis Expressions) • Only operate on columns of data (not single cells)

  14. PowerPivot for Excel 2010 • Access your workbook applications directly in the browser • Turn your workbooks into shared applications accessible virtually anytime and from any location • Role-based security • Automatic data refreshing • Help Improve IT Efficiency • Monitor and manage your published workbooks • Meet your security and compliance policies • Publish your workbook applications in a managed SharePoint environment

  15. PowerPivot for Excel 2010 ​“With Excel 2010 and Excel Services, the dashboard can scale to give the agents a long-term glimpse into performance trends, and provide deeper analysis in a fraction of the time.” “With Excel 2010, it takes four hours a month to publish more data and requires fewer Excel Web parts—a 75 percent improvement in productivity. The hardware did not change, just the version of Excel.” — Scott Myers, Americas Service Delivery Manager, Dell

  16. PowerPivot for SharePoint 2010 • Make it security-enhanced and easy for business users to share and collaborate • Centralize BI and enterprise data management • Monitor and manage shared applications efficiently • Discover mission-critical BI solutions • Stores documents in a document library.

  17. The Future of Business Intelligence • according to a Gartner survey of more than 1,500 CIOs worldwide released in January 2009, BI software tops the list of technology spending priorities for companies • Market researcher Forrester Research (FORR) expects the BI market to generate more than $12 billion in revenue in 2014, vs. $8.5 billion in 2008. King, By Rachael. "Business Intelligence Software's Time Is Now - BusinessWeek." BusinessWeek - Business News, Stock Market & Financial Advice. Web. 12 Apr. 2011. http://www.businessweek.com/technology/content/mar2009/tc2009032_101762.htm

  18. The Future of Business Intelligence • Through 2012, more than 35 % of the top 5,000 global companies will regularly fail to make insightful decisions about significant changes in their business and markets • By 2012, business units will control at least 40% of the total budget for BI • By 2012, one-third of analytic applications applied to business processes will be delivered through coarse-grained application mash-ups Gartner Research, Jan 2009, http://www.gartner.com/it/page.jsp?id=856714

  19. Business Intelligence Vendors • Jaspersoft • http://www.jaspersoft.com/ • Microstrategy • http://www.microstrategy.com/ • InetSoft • http://www.inetsoft.com/ • Actuate • http://www.actuate.com/home/ • IBM-Cognos • http://www-01.ibm.com/software/data/cognos/# • SAS • http://www.sas.com/ • Tableau • http://www.tableausoftware.com/

  20. Questions?

More Related