Business Intelligence Megan Amberson Mallory Conger Tamara Day
What is Business Intelligence (BI)? A set of business processes for collecting and analyzing business information. This includes the technology used in these processes, and the information obtained from these processes. (Wikipedia.org)
What Counts? Various software programs have been developed to ease the work of gathering and analyzing large quantities of data.
BI Technology TERMDEFINITIONEXAMPLE (Safeway Club Cards) Data Warehouse: A repository of integrated information from various sources, for queries and analysis. (Wikipedia.org) A summary of data collected from every Safeway card used in all Safeway stores. Data Mart: A subset of a data warehouse. Contains specific, predefined groups of data. (Wikipedia.org) Customers purchasing Pepsi and customers purchasing Doritos. Data Mining: Exploration of the data contained in data warehouses or marts in search of patterns. (Wikipedia.org) Do customers that purchase Pepsi also purchase Doritos?
Business Processes Example Extending UML 2 Activity Diagrams With Business Intelligence Objects (pg.10)
Finding Patterns in Data Many methods can be used to find usable data out of the volumes generated in todays technology driven world. These can include: Decision Trees: has limited applicability and works best for classification tasks Genetic Algorithms: selection of data that best fits optimal criteria Nonlinear Regression Methods: based on searching for a dependence of the target variable on other variables.
Business Intelligence Companies (Gartners Magic Quadrant) Figure 1. Magic Quadrant for BI Platforms, 1Q06
What do the Quadrants Mean? Leaders (Global companies that offer a complete range of products) Visionaries (Market thought leader and innovator with gaps) Challengers (supplementing current business offerings) Niche Players (only offering a specific part of BI, not a complete package)
Profile of Companies and Products Microsoft Late to market mover, but going in right direction Actuate Good understanding of the market, but facing difficulty proving legitimacy Cognos #1 company in BI software and performance Hyperion Broad array of BI capabilities and good overall vision
Top 10 Trends in BI during 2006 1. Information Quality 2. Master Data Management 3. Data Governance 4. Enterprise-Level BI 5. Regulatory Compliance
Top 10 Trends in BI during 2006 6. Enterprise Data Transparency 7. Actionable BI 8. Service-oriented Architecture 9. Rightshoring 10. Semi-structured and Unstructured Data
The Future of BI Gartners Predictions for Year-End 2007 3 main continued trends -Consolidation -Strategic to Operational -More Sophisticated Analytics