GFOASC 2011 Fall Conference SCEIS Reporting

1. GFOASC 2011 Fall ConferenceSCEIS Reporting

2. SCEIS Reporting: What is SCEIS BI? Business Intelligence, or BI, mainly refers to computer-based techniques used to identify, collect, and analyze business data in order to provide historical, current and predictive views of business operations with the goal of supporting better business decision making. It is a Decision Support System (DSS). A Decision Support System (DSS) is a computer-based information system that supports business or organizational decision-making activities in a rapidly changing environment. Decision Support Systems are designed to serve the management ,operations, and planning levels of a organization. Decision Support Systems are intended to help decision makers compile useful information from a combination of data sources, business models, and professional experiences in order to identify and solve problems.

3. SCEIS Reporting: What is SCEIS BI? Typical BI Maturity Model -----------| After SCEIS ERP (Enterprise) -----------------------------------| Before SCEIS ERP (Silo)

4. SCEIS Reporting: What is SCEIS BI? Typical BI Value Model

5. SCEIS Reporting: What is SCEIS BI? Typical BI Layers

6. SCEIS Reporting: What is SCEIS BI? SAP Solution Model

7. SCEIS Reporting: What is SCEIS BI? Typical BI Implementation Model :)

8. SCEIS Reporting: What is SCEIS BI? Typical BI Implementation Model (No, Really!)

9. SCEIS Reporting: What is SCEIS BI? Typical BI Implementation Model

10. Strategic Tactical Operational SCEIS Reporting: Our Reporting Strategy • Upper Management • Highly Summarized KPIs • Dashboards • Middle Management • Summarized Data with • Drilldowns • Ad-Hoc Queries • Operations Analyst • Detail-level data • Preformatted

11. Strategic Tactical Operational SCEIS Reporting: Our Reporting Strategy • In Scope: • SCEIS • Customers • Out of Scope: • Non-SCEIS • Customers • Upper Management • Highly Summarized KPIs • Dashboards • Middle Management • Summarized Data with • Drilldowns • Ad-Hoc Queries • Operations Analyst • Detail-level data • Preformatted

12. SCEIS Reporting: Governance Reporting User Group “RUG”

13. SCEIS Reporting: Governance (“RUG”) • History: • Began approximately 1.5 years ago with Finance • Added Human Resources January 2011 • Added Materials Management (Procurement & Inventory) • Purpose: • Identify Data Needs to drive Business Process Reengineering • and Best Practices • Prioritize “the work” • Design Best Practice Enterprise solutions • Knowledge Sharing • Format: • Monthly Meetings • Communities of Interest (CoI) Representative

14. SCEIS Reporting: Governance (“RUG”) Current Make-Up

15. SCEIS Reporting: BW Accomplishments • http://sceis.sc.gov

16. SCEIS Reporting: Business Objects • Developer Licensing - ~1500 • Deployment Strategy • Prorated based on ERP licenses • Example: Agency A 10% of total SCEIS ERP licensing will receive 10% of BO licensing • Requires Cooperative Commitment • Peer Development of Std Enterprise Rpts • Train-the-Trainer duties

17. SCEIS Reporting: Business Objects • Phased Approach • Control • Manageable • In 1/3 • 2 months increments, may adjust • Starts with RUG members • Open to All SCEIS Agencies • 1 Finance Representative • 1 Human Resources Representative • Materials Management Jan 2012

18. SCEIS Reporting: Business Objects

19. SCEIS Reporting: BW Accomplishments • Peer Development • STARS Equivalents • BOBJ Rollout • Phase 1 Complete • Phase 2 Complete

20. SCEIS Reporting: Future Plans • Additional BW Reports: • FI 2nd “Top 10” • HR “Top 10” List • MM “Top 10” List • Additional BOBJ Capabilities: • Phase 3 Rollout • MM Rollout • New data sources (e.g. 1018 universe) • Data Sharing • Low Tech – FTP • High Tech – Web Services • Proof-of-Concepts (DPS & HHS) • System Enhancements: • BOBJ Health Check • BW Upgrade

21. SCEIS Reporting: Future Plans • Data Sharing: