1 / 4

Enhancing Data Analysis and Presentation with Integrated Toolsets

This project aims to develop two interconnected toolsets tailored for data analysts and public/internal data display. The first toolset focuses on collecting, monitoring, and analyzing data to facilitate strategic decision-making. The second toolset will surface data for various uses, featuring a rich user interface that showcases only pertinent information. Key goals include creating a comprehensive data warehouse, enhancing current budgeting tools, and providing dynamic reporting capabilities through integration with existing systems.

shandra
Télécharger la présentation

Enhancing Data Analysis and Presentation with Integrated Toolsets

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. 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 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 • Great interface • Simple tools • Limited options for data • Great display but limited in number of features • $$$ 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 softwareFXdataparts 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 add’l 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.

More Related