Agenda What is Business Intelligence ? Why do organisations use it? BI tools overview. - презентация

1 Agenda What is Business Intelligence ? Why do organisations use it? BI tools overview

2 Generally Speaking…………………… According to Google………………… Business intelligence (BI) is a broad category of technologies that allows for gathering, storing, accessing and analyzing data to help business users make better decisions

3 Companies need to buy …transactional Systems Financials JDE, Oracle, PSFT, SAP Supply Chain Management IBM, SAP, PSFT, Manugistics Customer Relationship Management Clarify, Onyx, Pivotal Sales Force Automation Seibel, Salesforce.com Etc……

4 In its simplest form data Database report data report Database

5 B I …………….AKA Reporting Analytics Decision Support Data Warehousing EIS Dashboarding

6 Some Terms you might hear Transactional Reporting Relational Reporting Multi-dimensional Reporting Analytics Predictive Analytics Data Mining Data Visualisation Database Schema (Star, Snowflake) Dashboards, KPIs LIs Balanced Scorecarding OLAP, ROLAP, MOLAP, DOLAP, HOLAP…..SCHMOLAP !

7 Some People you might hear of Business Objects / Crystal Cognos Microstrategy Microsoft SAP Panorama IBI Hyperion

8 Relational BI tools Easiest to use Query, Reporting, Analysis & Dashboarding OLAP BI tools Most Scalable, Powerful Analytics BI Platform Complete & Powerful Solution A Single Platform for Breakthrough Performance Everywhere

9 Highlights Dashboards for user-directed analysis Self-service access to graphical views of key performance indicators Central distribution of dashboards for any group, role, or individual Full range of Query, Reporting and Analysis Capabilities Management Reporting, End-User Reporting, Production Reporting Report Delivery & Alerting Zero footprint, browser-based query, reporting and analysis Distribution of dashboards, reports and analytics to a broader user base Extending visibility to customers and partners outside the firewall

10 Highlights (cont.) Web-based administration, publishing, scheduling, and delivery Single management environment reduces administration time Logging mechanism provides continuous system performance tuning Enables Intelligence and SQR to benefit from common functionality Role-based access control Administration can be delegated so user communities can be self sufficient Leverage existing investments in external authentication systems Unified, scalable architecture with single repository Services run as distributed, multi-threaded processes on back- end servers High performance and dependability via fail-over and load balancing

11 Information The Way You Want It Drag & Drop Query Graphical Charts and Cross-tab Analysis Presentation- Quality Reports Platform for Dashboard Applications

12 Enterprise Reporting ANY report layout ANY data manipulation ANY numeric manipulation

13 Single Pass, Multiple Outputs