Business Intelligence (BI)

1. Business Intelligence (BI) The Key to the Success of Microsoft and Apple

3. Introduction Business Intelligence is a set of theories, methodologies, architectures, and technologies that transform raw data into meaningful and useful information for business analysis purposes. BI can handle enormous amounts of unstructured data to help identify, develop and otherwise create new strategic business opportunities. BI allows for the easy interpretation of volumes of data. Identifying new opportunities and implementing an effective strategy can provide a competitive market advantage and long-term stability.

4. Acknowledgement First and foremost, we would like to express our gratitude to our advisor /teacher, Ms. Marisol D. Payra, for the continuous support of our study /research, for her patience, motivation, and immense knowledge. We could not have imagined having a better advisor and mentor for our study.Besides our advisor, we would like to thank the rest of our friends for their encouragement, insightful comments, and hard questions.Lastly, we would like to thank God for providing us the strength and wisdom we need to accomplish this study.

5. Abstract Business Intelligence refers to computer-base techniques used in spotting, digging-out, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes. BI technologies provide historical, current, and predictive views of business operations. Common functions of business intelligence technologies are reporting, online analytical processing, analytics, data mining, business performance management, benchmarking, text mining, and predictive analytics. Business intelligence aims to support better business decision-making. Thus a BI system can be called a decision support system (DSS). Though the term business intelligence is sometimes used as a synonym for competitive intelligence, because they both support decision making, BI uses technologies, processes and applications to analyze mostly internal, constructed data and business processes while competitive intelligence gathers, analyzes, and disseminates information with a topical focus on company competitors. Business Intelligence understood broadly can include the subset of competitive intelligence.

6. Scope & Delimitation The study will focus on the creation of public awareness and further realization about what business intelligence is and how important it is in the industry. The study has one main point and that is to deeply understand the importance of it and to further explain the pros and cons of Business Intelligence. The proponent of the study strongly believe that Business Intelligence is the key to a lively, successful business. The researchers supposes that awareness on Business Intelligence could be an enormous help to a lot of companies, if used and executed correctly.

7. Significance of the Study This study is important in the sense that it can help others, especially students, in enriching their knowledge when it comes to Business Intelligence, which a computer science student must possess. This study is also essential for the students who are studying the same topic. It can help them to further enhance their research by studying our thesis. Lastly, the study will also give us brand new information that will help us in the future. The study will incline our knowledge on the subject to know the components, fundamentals and such about Business Intelligence. We hope that this study will help enlighten interested people/students.

8. Objectives Organizations have goals and objectives, which are necessary to make appropriate decisions. In this blog we investigate the variations in this domain that can be used to optimize the user interface of business intelligence solutions and dashboards. ·        profitability; ·        productivity and added value; ·        being extremely good at doing some kind of work; ·        social responsibility in employment or environmental issues; ·        growth and continuity; ·        salary; ·        work climate; ·        status and authority; ·        market share..

9. Statement of the Problem This study aimed to seek the answer to the following question: 1. What are the Benefits of using a business intelligence software? 2. How does business intelligence affect a business entirely? 3. Is it necessary for a company to use Business Intelligence software? Why? Why not?

11. What is Business Intelligence? Business Intelligence enables the business to make intelligent, fact-based decisions Aggregate Data Present Data Enrich Data Inform a Decision Database, Data Mart, Data Warehouse, ETL Tools, Integration Tools Reporting Tools, Dashboards, Static Reports, Mobile Reporting, OLAP Cubes Add Context to Create Information, Descriptive Statistics, Benchmarks, Variance to Plan or LY Decisions are Fact-based and Data-driven

12. CPU – Content, Performance, Usability • Content • The business determines the “what”, BI enables the “how” • Performance • Minimize report creation and collection times (near zero) • Usability • Delivery Method Push vs Pull • Medium  Excel, PDF, Dashboard, Cube, Mobile Device • Enhance Digestion  “A-ha” is readily apparent, fewer clicks • Tell a Story  Trend, Context, Related Metrics, Multiple Views

13. How Important is BI? Top 10 Business and Technology Priorities for 2011: 1. Cloud computing 2. Virtualization 3. Mobile technologies 4. IT Management 5. Business Intelligence 6. Networking, voice and data communications 7. Enterprise applications 8. Collaboration technologies 9. Infrastructure 10. Web 2.0 Source: Gartner’s 2011 CIO Agenda (aka “Reimagining IT: The 2011 CIO Agenda”).

14. The July 2010 Forrester report “Technology Trends That Retail CIOs Must Tap to Drive Growth” identified the following technologies that retail CIOs should be considering as part of an overall architecture strategy: Mobile Cloud • Social Computing • Supply Chain • Micropayments • Business Intelligence/Analytics

15. Time Data Opinion (aka Best Professional Judgment) Making Business Decisions is a Balance Why is Business Intelligence So Important? With Business Intelligence, we can get data to you in a timely manner. In the absence of data, business decisions are often made by the HiPPO.

16. Major BI Trends • Mobile • Cloud • Social Media • Advanced Analytics

17. TDWI Executive Summit – August 2010 What BI technologies will be the most important to your organization in the next 3 years? • Predictive Analytics • Visualization/Dashboards • Master Data Management • The Cloud • Analytic Databases • Mobile BI • Open Source • Text Analytics

18. Advanced Analytics / Predictive Analytics • Data Mining • Regression • Monte Carlo Simulation • “Statistically Significant” • Predicting Customer Behavior • Churn/Attrition • Purchases • Profiling

19. BI Today vs Tomorrow • “BI today is like reading the newspaper” • BI reporting tool on top of a data warehouse that loads nightly and produces historical reporting • BI tomorrow will focus more on real-time events and predicting tomorrow’s headlines

20. Collegiate Admissions Criteria • Test Scores: SAT, ACT, AP Exams • Grade Point Average • Class Rank • High School “Strength” • Extracurricular Activities: Band/Choir, Clubs, Sports • Non-School Activities: Work, Volunteer, Community Groups • Area of Focus – Intended Major • Family legacy • Home State or Country Regression Outcome = Graduation (binary) + GPA (linear)

21. Retail Analytics • Market Basket Analytics • Text Analytics • Customer Segmentation/Clustering • Tailored Product Assortments • Inventory Forecasting

22. Amazon.com and NetFlix Collaborative Filtering tries to predict other items a customer may want to purchase based on what’s in their shopping cart and the purchasing behaviors of other customers

23. What Is Text Analytics? …turning unstructured customer comments into actionable insights …finding nuggets of insight in text data that will improve our business From Wikipedia: … a set of linguistic, statistical, and machine learning techniques that model and structure the information content of textual sources for business intelligence, exploratory data analysis, research, or investigation

24. Unstructured Text Processing Facebook Page Twitter Page Customer Sat Survey Comments Call Center Notes, Voice Services Quality Cost Friendliness Competitors’ Facebook Pages Public Web Sites, Discussion Boards, Product Reviews Email Blogs Alerts, Real-time Action Adhoc Feedback

28. What is Information Governance? Information Governance PREVENTS Garbage Out Garbage In BY ENCOMPASSING • Data Stewardship • Data Quality • Data Governance • Master Data Management • Data Stewards for Master Data “Hubs” • Customer, Vendor, Product, Location, Employee, G/L Accounts • Report Governance • Metric Governance CREATING SIGNIFICANT BUSINESS VALUE

29. BI Technologies DB2 Oracle SQL Server Teradata Netezza Vertica Aster Data Par Accel Greenplum Semantic Databases (TIDE) • Analytic Databases • BI is a consolidating industry • Oracle: Siebel, Hyperion, Brio, Sun • SAP: Business Objects, Sybase • IBM: Cognos, SPSS, Coremetrics, Unica, Netezza • EMC: Greenplum • HP: Vertica • Teradata: Aster Data • Independent vendors: MicroStrategy, Informatica, SAS • Reporting standards determined mainly by Microsoft, Apple and Adobe

30. BI Technologies (cont’d) • If you want to learn more about Analytic Databases: http://hosted.mediasite.com/mediasite/Viewer/?peid=120d6b7ba227498b96a8c0cd01349a791d • If you want to learn more about BI in the Cloud: http://hosted.mediasite.com/mediasite/Viewer/?peid=e6d91148a71a47969824c22b3b20d6221d

31. Recommended Reading List • Outliers -- Malcolm Caldwell • Moneyball -- Michael Lewis • The Black Swan -- Nassim Nicholas Taleb • Competing on Analytics -- Tom Davenport • How to Lie with Statistics -- Darrell Huff • Bringing Down the House -- Ben Mezrich • Super Crunchers -- Ian Ayres • Priceless -- William Poundstone • Drilling Down -- Jim Novo • The New Rules of Marketing -- Fred Newell

32. Thank You Q&A