際際滷

際際滷Share a Scribd company logo

Business Intelligence and Analytics

Download as PPT, PDF
Human Managed
Human Managed

This presentation briefly overviews the history of the company, the traditional BI solution architecture and how the Dimensional Insight solution is different. Contact us today for a free consultation and PoC!

1 of 16
Downloaded 29 times
Anwar McEntee Inroads Limited Hong Kong Official APAC Distributor for Dimensional Insight Business Intelligence Analytics and Reporting Made Simple
C O M P A N Y O V E R V I E W About Dimensional Insight Founded in 1989 Privately-held; no venture capital or debt Worldwide presence in 31 countries Fully integrated BI solution Customer and brand focused 5000+ customers Customer visits Great customer satisfaction
The News Group The New York Post The Washington Post Milwaukee Journal-Sentinel The Orlando Sentinel Champaign News-Gazette South Bend Tribune Charleston Post & Courier The National Post (CAN) Trinity Mirror Corp (UK) Aetna/US Healthcare Avera Health Plans Baycare Health Systems Care 1st Centura Health System Delta Health System Partners HealthCare Lee Memorial Health System Parkview Health Green Ribbon Health Humana HHSI EMC Intuit Altera Corporation Perkin-Elmer AP Biosystems Juniper Networks RSA Security Lockheed-Martin Xerium Daimler-Chrysler DuPont ExoPack ITW Devcon Michelin North America Beaulieu of America Mohawk Industries Southern Wine & Spirits Martignetti Liquors Empire Merchants Fedway Associates Glazers Empire of GA AL & GA Crown Great Lakes W & S United of GA Badger Liquors Mutual Distributing Eder Brothers Major Brands Nu Horizons Electronics The News Group New Balance Doc Martens The Gem Group Prince Sports Morning Sun Lacrosse Footwear Design Tex Tandy Brands Floridas Natural Pacific Tomato Growers Naturipe Ferrari Carano Ausome Snacks Kendall Jackson Banfi Vintners Wilson Daniels Far Niente Pernod Ricard USA SKYY Vodka Patron Healthcare Suppliers Apparel/Fashion Distribution Manufacturing Publishing Hi-Tech W H O U S E S T H E D I V E R S O L U T I O N
Early design focus on end user analytics Help users know what they dont know (and why) Self service analytics and reporting T H E D I V E R S O L U T I O N
Traditional Data Warehouse Architecture Typical BI projects are lengthy due to the complex architecture Not all projects require this architecture!
Data is diveable in any direction in one report. Data is converted directly to models. Users can back up, change directions with a click. Performance Enhanced Summary values pre-calculated, dim-counts; Add columns after Models built; Multi-Sort, ad-hoc, predictive analytics Diver Model (Sphere) vs. Data Warehouse (Cube) Data loaded to a specific cube with preset allowable drill paths & hierarchy into the Data Warehouse. Users follow predefined drill paths, top down. Subtotals and Calculations made at the time user selects report or drilldown; must wait for calculations. )
Existing BI Infrastructure Where DI Fits In Dimensional Insight Business Objects, Cognos, TM1, Hyperion, SAS Data Warehouse (i.e.Teradata) Free-form analytics Non-predictable queries Special reporting Self-service, wide distribution Repeatable reports Structured analysis Structured data relationships and dependencies Not Required: SQL Universe Data warehouse Detailed meta data
Types of Users D I V E P O R T C E L L D I V E R P R O D I V E R D I V E R E R P S Y S T E M S L E G A C Y S Y S T E M F L A T F I L E S I N T E G R A T O R & B U I L D E R D A T A W A R E H O U S E M I C R O S O F T Production Environment N E T D I V E R Power Analysts Report Consumers Business Analysts Remote Analysts Accessible User Interfaces Executives & Information Consumers D A T A M O D E L S Form Follows Function
Best Handset For Revenue in IT&T Segment Diving History Maximize Revenue & ARPU and Minimize (User View)
Highlight summaries and exceptions Summarize related information together Use simple indicators to denote exceptions Use charts to add meaning to tabular data
Todays Dashboard Web based distribution Customers, Partners, Shareholders
Implement and deploy BI applications quickly Deploy BI applications all within a single platform that is easy to use for non-technical users Empowers Self-Service Agile and Affordable DI customers experience rapid deployment of BI applications, often in less than 30 days Source: Aberdeen Group, March 2008 Why Dimensional Insight
Fin Thank you. Questions? Next steps? Contact: anwar.mcentee@inroads.com.hk
EMC 40,000 people worldwide Revenue of US$ 14.9 Billion in 2008 30 Years of Operation Publicly Traded on NYSE S&P 500 Dimensional Insight Greater than 500 DI Users in First 12 months Examples of Consultancy Companies Using Diver
Founded 1976 Revenue run rate of CDN$3.8 billion/US$3.3 billion Approximately 25,000 professionals 100+ offices serving clients in 16 countries 2006 average 8.8 out of 10 satisfaction ranking from 1,900+ client interviews Among largest independent, full-service IT and business process services companies NYSE: GIB TSX: GIB.A CGI - Key statistics
Provides user community with autonomy for reporting and analysis Automation of manual tasks Single tool for multiple data sources Reduced reporting cycle Reduced customization of source systems Reduced load on source systems Web tool available for Casual users Solid infrastructure to enable scaling and stability CGI DI Deliverables

More Related Content

Business Intelligence and Analytics

  • 1. Anwar McEntee Inroads Limited Hong Kong Official APAC Distributor for Dimensional Insight Business Intelligence Analytics and Reporting Made Simple
  • 2. C O M P A N Y O V E R V I E W About Dimensional Insight Founded in 1989 Privately-held; no venture capital or debt Worldwide presence in 31 countries Fully integrated BI solution Customer and brand focused 5000+ customers Customer visits Great customer satisfaction
  • 3. The News Group The New York Post The Washington Post Milwaukee Journal-Sentinel The Orlando Sentinel Champaign News-Gazette South Bend Tribune Charleston Post & Courier The National Post (CAN) Trinity Mirror Corp (UK) Aetna/US Healthcare Avera Health Plans Baycare Health Systems Care 1st Centura Health System Delta Health System Partners HealthCare Lee Memorial Health System Parkview Health Green Ribbon Health Humana HHSI EMC Intuit Altera Corporation Perkin-Elmer AP Biosystems Juniper Networks RSA Security Lockheed-Martin Xerium Daimler-Chrysler DuPont ExoPack ITW Devcon Michelin North America Beaulieu of America Mohawk Industries Southern Wine & Spirits Martignetti Liquors Empire Merchants Fedway Associates Glazers Empire of GA AL & GA Crown Great Lakes W & S United of GA Badger Liquors Mutual Distributing Eder Brothers Major Brands Nu Horizons Electronics The News Group New Balance Doc Martens The Gem Group Prince Sports Morning Sun Lacrosse Footwear Design Tex Tandy Brands Floridas Natural Pacific Tomato Growers Naturipe Ferrari Carano Ausome Snacks Kendall Jackson Banfi Vintners Wilson Daniels Far Niente Pernod Ricard USA SKYY Vodka Patron Healthcare Suppliers Apparel/Fashion Distribution Manufacturing Publishing Hi-Tech W H O U S E S T H E D I V E R S O L U T I O N
  • 4. Early design focus on end user analytics Help users know what they dont know (and why) Self service analytics and reporting T H E D I V E R S O L U T I O N
  • 5. Traditional Data Warehouse Architecture Typical BI projects are lengthy due to the complex architecture Not all projects require this architecture!
  • 6. Data is diveable in any direction in one report. Data is converted directly to models. Users can back up, change directions with a click. Performance Enhanced Summary values pre-calculated, dim-counts; Add columns after Models built; Multi-Sort, ad-hoc, predictive analytics Diver Model (Sphere) vs. Data Warehouse (Cube) Data loaded to a specific cube with preset allowable drill paths & hierarchy into the Data Warehouse. Users follow predefined drill paths, top down. Subtotals and Calculations made at the time user selects report or drilldown; must wait for calculations. )
  • 7. Existing BI Infrastructure Where DI Fits In Dimensional Insight Business Objects, Cognos, TM1, Hyperion, SAS Data Warehouse (i.e.Teradata) Free-form analytics Non-predictable queries Special reporting Self-service, wide distribution Repeatable reports Structured analysis Structured data relationships and dependencies Not Required: SQL Universe Data warehouse Detailed meta data
  • 8. Types of Users D I V E P O R T C E L L D I V E R P R O D I V E R D I V E R E R P S Y S T E M S L E G A C Y S Y S T E M F L A T F I L E S I N T E G R A T O R & B U I L D E R D A T A W A R E H O U S E M I C R O S O F T Production Environment N E T D I V E R Power Analysts Report Consumers Business Analysts Remote Analysts Accessible User Interfaces Executives & Information Consumers D A T A M O D E L S Form Follows Function
  • 9. Best Handset For Revenue in IT&T Segment Diving History Maximize Revenue & ARPU and Minimize (User View)
  • 10. Highlight summaries and exceptions Summarize related information together Use simple indicators to denote exceptions Use charts to add meaning to tabular data
  • 11. Todays Dashboard Web based distribution Customers, Partners, Shareholders
  • 12. Implement and deploy BI applications quickly Deploy BI applications all within a single platform that is easy to use for non-technical users Empowers Self-Service Agile and Affordable DI customers experience rapid deployment of BI applications, often in less than 30 days Source: Aberdeen Group, March 2008 Why Dimensional Insight
  • 13. Fin Thank you. Questions? Next steps? Contact: anwar.mcentee@inroads.com.hk
  • 14. EMC 40,000 people worldwide Revenue of US$ 14.9 Billion in 2008 30 Years of Operation Publicly Traded on NYSE S&P 500 Dimensional Insight Greater than 500 DI Users in First 12 months Examples of Consultancy Companies Using Diver
  • 15. Founded 1976 Revenue run rate of CDN$3.8 billion/US$3.3 billion Approximately 25,000 professionals 100+ offices serving clients in 16 countries 2006 average 8.8 out of 10 satisfaction ranking from 1,900+ client interviews Among largest independent, full-service IT and business process services companies NYSE: GIB TSX: GIB.A CGI - Key statistics
  • 16. Provides user community with autonomy for reporting and analysis Automation of manual tasks Single tool for multiple data sources Reduced reporting cycle Reduced customization of source systems Reduced load on source systems Web tool available for Casual users Solid infrastructure to enable scaling and stability CGI DI Deliverables

Editor's Notes

  • #4: This is a sampling of the industry players who use the Diver Solution to solve the problem of delivering information internally and externally.
  • #6: For global, standardized reporting across large organizations, the typical, heavy Data Warehouse architecture may be required.
  • #7: .
  • #11: As examples, Ill use a prototype set of dashboards that we developed for our healthcare solution using Diveport 6.2. Granted we may not have gotten to exactly where we want to go with the upcoming technology but we did get a fair amount of the way there. One of the most necessary and important things to do is to summarize information in such a way that you can group a lot of related information together in the same dashboard screen. Example: grouping related information for Inpatient, Ancillary (Outpatient/ED) and Surgery. Use simple indicators to draw attention to exceptions: In this case, were showing that two exceptions using the red square: the one at the bottom denotes outpatient volumes being slightly below the year-to-date target. Finally, use line and bar charts to add meaning to the data: in this case the month to month trends in inpatient discharges, compared with budget and last year. This is an example of a key leading indicator.
  • #12: And thats where dashboards come in: they are a tool to help you achieve this goal of focused analysis.
  • #16: This slide includes CGI financial performance data released for Q2 of FY2007, which ended on March 31, 2007.