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

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

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……

In its simplest form data Database report data report Database

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

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 !

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

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

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

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

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

Enterprise Reporting ANY report layout ANY data manipulation ANY numeric manipulation

Single Pass, Multiple Outputs