Objectives

1
Objectives

• Develop 2 different but connected toolsets
• Toolset for data analysts
• Collect, Monitor, Analyze and make strategic
  decisions
• Toolset for surfacing data for internal and
  public use
• Rich User Interface with only pertinent data
  display
• A major goal is to create a data warehouse to
  serve as the repository for both.

2
VisibleStrategies vs. PPS vs. datafx

• visiblestrategies

• PPS

• Great interface
• Simple tools
• Limited options for data
• Great display but limited in number of features

• Part of sharepoint
• Complex tools
• Most options for data
• Many options for display
• Can be used for other dept. needs right away.
• Almost too many choices
• Can read datafx

softwareFX

• Great interface in Sharepoint
• Simple tools
• Many options for data
• Great display but limited in number of features

3
PPS

• Future of Microsoft and Sharepoint Performance
  Management
• Can choose between displaying reports based on
  unlimited datasources and types.
• Automatically creates rolled up dashboards and
  can secure individual web parts
• Creates connected web parts, providing ease of
  use and navigation
• Can easily take snapshots and create
  dynamic/interactive experience for
  albemarle.org(non-PPS) users
• Can start off with a small group of users, build
  the LC KPI pages, then add on.
• Can incorporate the softwareFX dataparts if
  desired.
• Provides a longer term toolset, could be used to
  improve ER (our fledging budgeting tool) for
  enhanced budgeting
• By purchasing we also obtain addl features
  (excel services)

4
Timeline

• Build 25 LC KPI as is with softwareFX
• Develop presentation for public
• Start data warehouse project
• Already started with Enterprise Reporting (ER)
  and Pistol (PD Records)
• PPS becomes analysis and monitoring toolset
• SSIS ties into other production databases (GP,
  Laserfiche)
• SQL Reporting Services, Excel Services and PPS
  provide data surfacing and monitoring
• Build a richer presentation set.