Self-Service Business Intelligence for the Product Management Department

Self-Service Business Intelligence for the Product Management Department (Contoso Corporation) (November 2009)

Contents • Executive Summary • Current State Analysis • Future State Analysis • Business Case • Adoption & Implementation Planning • Next Steps 4

Background • (Contoso) currently faces a number of challenges related to its departmental performance reporting processes, including: • Departmental analysts must work through IT department to collect performance data from LOB systems • Access to info is available to the few, not the many • Professional staff time is spent collecting and validating data, leaving little time for analysis and taking time from their regular jobs • IT perceived as a bottleneck for the few execs who do see LOB data • Long reporting process taking 10 days cycle time per month, leading to out-of-date reports when finalized • Limited integration between financial, operational, and unstructured information sources creates integration problems for users to coordinate reports 5

Engagement Participants 6

Executive Summary • (Partner Name) proposes expanding upon (Contoso’s) current Office System deployment to incorporate self-service analysis and reporting capabilities in Office 2010 to improve information access and streamline departmental reporting processes. • Implementing the proposed Self-Service BI Solution will provide (Contoso) with: • Self-service access to critical performance information • More accurate and timely performance reports resulting in better management business decisions • Ability to link operational data to KPI reports • 55% decrease in labor required to develop performance report • Reduce overall reporting cycle time by 80% • Anticipated annual benefit to (Contoso) of $260,000 7

Executive Summary 8

Current State Process Analysis Performance Reporting Process Analysis Summary 10

Current State Process Diagram Total Labor: 3.5 Total Labor: 1.0 Total Labor: 11.25 Total Elapsed Time: 7 Days 11

Current State Process Diagram Total Labor: 0.75 Total Labor: 1.25 Total Labor: 2.0 Total Labor: 8.5 Total Elapsed Time: 3 Days 12

Future State Process Analysis Performance Reporting Process Phases – Analysis Summary 14

Prioritized Process Solutions High 5 Integrate performance data with planning data, operational systems, and unstructured sources (SharePoint Server 2010 with PerformancePoint Services and Excel Services) Level Of Complexity 3 • Develop Executive Performance Dashboard • (SharePoint Server 2010 with PerformancePoint Services and Excel Services) • Open Access to Performance Report Editing by LOB Managers • (SharePoint Server 2010 ) Automated report distribution, publishing, and sharing (SharePoint Server 2010) Low 1 5 1 3 High Low Value to Business 15

Future State Process Diagram Total Labor: 4.25 Total Elapsed Time: 1 Day

Future State Process Diagram Total Labor: 1.0 Total Labor: 2.75 Total Labor: 2.0 Total Labor: 3.5 Total Elapsed Time: 1 Day

Anticipated Benefits - Process 19

Anticipated Benefits - Financial 20

Anticipated Costs 21

Adoption & Implementation Planning Summary 23

Project Plan 24

Potential Adoption Roadblocks 25

Adoption Roadblock Mitigation Actions by Stakeholder 26

Next Steps • Review presentation and proposal with (Customer Name) decision maker and stakeholders for approval • Consider a SharePoint Deployment Planning Services (SDPS) follow-up engagement • Execute work order for project • Schedule kick off meeting for week of _____ and weekly status meetings • Propose schedule: • A) Deadlines for initial milestones, or • B) Date to finalize initial milestones 28

Self-Service Business Intelligence for the Product Management Department