1 / 28

C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

November 7 - 9, 2002. C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S. Using Business Intelligence Architecture to Empower Thousands of Employees with Information. Daryl Wise Division Director. Bob Latgis IT Specialist. Division of Information & Integrity Systems.

jerzy
Download Presentation

C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

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. November 7 - 9, 2002 C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  2. Using Business Intelligence Architecture to Empower Thousands of Employees with Information Daryl WiseDivision Director Bob LatgisIT Specialist Division of Information & Integrity Systems Social Security Administration

  3. Agenda Business Intelligence Architecture Brio’s Business Intelligence Role Brio Deployment Brief Demo C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  4. Agenda Business Intelligence Architecture Brio’s Business Intelligence Role Brio Deployment Brief Demo C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  5. Agenda Business Intelligence Architecture Brio’s Business Intelligence Role Brio Deployment Brief Demo C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  6. Agenda Business Intelligence Architecture Brio’s Business Intelligence Role Brio Deployment Brief Demo C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  7. Social Security Administration • Retirement Survivors Insurance (RSI - Title II), Supplemental Security Income (SSI -Title XVI), Earnings, & Enumeration • An average of 49 million beneficiaries receiving $33 billion a month • 10 regions; 1300 field offices; 64,000 employees • Very large volumes of data C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  8. Vision • To provide a Business Intelligence (BI) Architecture across SSA’s programs in support of both tactical and strategic decision making. C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  9. Goals & Objectives • Integrate data for better decision making and integrity review functions • Less dependent on applications for reporting needs • More efficient distribution and access to information C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  10. Goals & Objectives • Information based on common values, computations, and definitions • Standard access method across business functions • Consistent reporting • Reduction of fraud and abuse C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  11. Business Drivers • SUMS - SSA’s Unified Measurement System • MCAS - Managerial Cost Accountability System • Fraud/Abuse • QA Modernization C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  12. Data Collection Information Extraction Report ________________________ Data Analysis Strategic Analysis Performance Indication Statistical Analysis Forecasting Business Intelligence Solution Operational & Administrative Transactions Query & Reporting Tools OLAP & Spreadsheet Analysis Planning, Budgeting & Trend Analysis Performance Management, Financial Analysis Balanced Scorecard Data Mining, Cause & Effect Analysis Business Modeling & Simulation C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  13. Forecasting Business Modeling & Simulation Statistical Analysis IBM - Intelligent Miner, Brio Data Mining, Cause & Effect Analysis Performance Management, Financial Analysis, Balanced Scorecard Portal & Visualization Software Performance Indication Planning, Budgeting & Trend Analysis Strategic Analysis Brio, DW OLAP & Spreadsheet Analysis Data Analysis Brio, Repository Brio, WebFOCUS, FOCUS, Cold Fusion Information Extraction Query & Reporting Tool Operational & Administrative Transactions ODS, DW Data Collection Business Intelligence (BI) Tools C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  14. EMIS Current & Future Sources Data Mining ReportingToolsOLAPWeb ETL Data Mart Data Mart Data Warehouse ETL Relational Integration Tables Operational Data Stores Sequential Other Stored Data Documents BI Repository BI Architecture Model C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  15. Brio Deployment • Brio Intelligence deployed by customer type • Power User = Explorer (view, analyze, & query) • End User = Insight(view & analyze) • Static User = Freeview (view only) • Brio Broadcast Server for scheduling requests • Currently have 2,000 copies of Explorer & 7,000 copies of Insight to be distributed nation-wide C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  16. Brio Used for Validation • Brio Intelligence is one of our Systems tool to validate the data • Brio Intelligence provides a huge time savings during our testing phase and provides a more accurate process C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  17. Brio Training Approach • Training based on a rollout strategy of the various subject areas within the BI Architecture • Brio Software training provided in-house and to include an understanding of the subject area • Train the trainer approach • Produced a custom built Brio manual • Planning a Computer-Based-Training (CBT) program C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  18. Brio & Employees with Disabilities • Section 508 (employees with disabilities) requirements mandatory effective June 21, 2001 • A leader in Section 508 compliance, SSA has worked closely with Brio as one of the key drivers to meet the Section 508 requirements • Interim approach for Section 508 requirements with version 6 • Automate the delivery of BQY files in Microsoft Excel (an alternate output) for the visually and hearing impaired • Menu item with a standard bqtools.ini file C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  19. New menu item for Section 508 (bqtools.ini file). Use the Alt key to export sections to Microsoft Excel. The Brio section name is used to name each Excel sheet. Interim approach for Section 508 Brio & Employees with Disabilities C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  20. Brio EIS Template & Wrapper Application • Dynamic Web page of Brio files based on project • Standard view of Brio files across projects • Provide links to other Web sites • Link to the Meta Data repository • Provide filters and other Brio settings C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  21. Sort by Name Sort by Date Project Folders List of Project Files Additional Links Brio Wrapper Application C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  22. BI Repository Icon Query Date What’s New Report Name Options Home Icon Select Criteria Radio Buttons for Report Sections Help Icon User Preferences Print Icon Save File Selection Criteria Select Icon Web Site Links Last Saved Date Brio EIS Template C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  23. Brio & Meta Data Repository • The meta data repository (Computer Associates product) supports our entire BI Architecture. • Web based front-end into the meta data repository • Brio Intelligence easily provides an interface to our repository to display business names, definitions, and other important information • Brio Intelligence links directly into the meta data repository to get detail information on the Brio file C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  24. BI Meta Data Repository C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  25. Remarks and other information from the meta data repository Brio & Meta Data Repository C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  26. Meta Data Repository Access Brio & Meta Data Repository C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  27. Brief Brio Demo C A S E S T U D I E S—S T R A T E G I E S F O R S U C C E S S

  28. Social Security Administration November 7 - 9, 2002

More Related