1 / 25

Deploying BI to the Enterprise

Deploying BI to the Enterprise. Toronto Area Users Group Sept. 14 2001 Tim Quigg inbusiness solutions. Overview. inbusiness solutions Case Study Questions . About e-services group . Team Partner (Highest Level) Offices in Ottawa Toronto

rollin
Download Presentation

Deploying BI to the Enterprise

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Deploying BI to the Enterprise Toronto Area Users Group Sept. 14 2001 Tim Quigg inbusiness solutions

  2. Overview • inbusiness solutions • Case Study • Questions

  3. About e-services group • Team Partner (Highest Level) • Offices in • Ottawa • Toronto • Projects throughout North America • Business Partners with other Cognos Partners • CODA • Concur Technologies • Artemis • Business Intelligence Practice • 50 BI consultants in Canada and US Slide 10 of 28

  4. About inbusiness

  5. inbusiness Portals

  6. BI Web-based Solutions

  7. Why web-based reporting • Companies and customers are more global today • Easier to Deploy • Consistent with other corporate applications • Easier to use • Improved performance • Does not require high-end client machines • Integrated Security

  8. Case Study • Federal Government Department • Human Resources Development Canada • 1995 – Proof of Concept • October 1998 – Client Server Deployment • October 1999 – Web Pilot • October 2000 – 1 year later • Today

  9. Client Overview • Human Resources Development Canada • 11 Region Offices and 320 HRCC Offices • 26,000 Employees Across Canada • Bilingual Workforce • Process U.I., OAS, CPP payments

  10. 1995 - Proof of Concept • Purpose was to evaluate User based Query Tool • Impromptu • Reporting against operational data • DMSII on the mainframe via ODBC software • Limited number of users • Financial data only

  11. Oct. 1998 – Client Server Deployment • Background • PP 5.21 and Impromptu 4 • Database cubes in regional servers • Centralized Oracle warehouse • Architecture • 1 PowerPlay Cube server per region • Unix-based Oracle Database Server • Size of the Application • 16 Models and 60 Reports • User Community • 700 users

  12. October 1998 - Architecture

  13. October 1998 - Challenges • Installing software on the desktop • Shipping database cubes to regional servers • User buy-in (data and new tools) • Network Infrastructure • Data Quality

  14. October 1999 – Web Pilot • Background • PowerPlay Enterprise Server 6.5 • Impromptu Web Reports 5.0 • Size of the Application • 20 PowerPlay Cubes • 75 IWR Reports • User Community • 75 Pilot users

  15. Oct. 1999 – Web Pilot Architecture

  16. October 1999 - Challenges • Installing software on the servers • Version1 growing pains • Shift in thinking to web-based reporting • Developer / User Training • Security and User Classes • Defining the processes (Dev to Prod) • Training the ITC security administrators

  17. October 2000 – 1 year Later • Architecture • PowerPlay Enterprise Server 6.5 • IWR 6.0 • Size of the Application • 50 Cubes • 250 IWR Reports • 100 GB Data warehouse • User Community • 2000 Users

  18. October 2000 - Architecture

  19. October 2000 - Challenges • Process from Dev to QA to Prod • Scheduling of Cube Builds, Loads • Source Financial System was replaced • Reporting no longer part of operational system • User Training was after the fact

  20. Today • Architecture • PowerPlay Enterprise Server 6.6 • IWR 6.0 • KPI Business Pack • Size of the Application • 100 Cubes • 1000 IWR Reports • 120 GB Data warehouse • User Community • 3500 Users • 120 User Classes

  21. Present Production Architecture

  22. Present Challenges • Integrating Security between MF and Web • Development / Production Support training • User Business Knowledge / Data training • Communication between various groups • (BI Developers, DBAs, Prod Support, Users) • Client Server functionality from the Web

  23. Future Plans • Optimizing the warehouse • Web-based ad-hoc querying • EP Series 7 / Upfront migration • More data / applications • Unix based Servers

  24. Questions • Ottawa Contact Info • Tim.Quigg@inbusiness.com • Toronto Contact Info • Tim.Attia@inbusiness.com • HRDC Contact Info • John.Harder@hrdc-drhc.gc.ca

More Related