1 / 28

Lighting up “Fermidash” – Fermilab’s Executive Dashboard

NLIT 2012. Lighting up “Fermidash” – Fermilab’s Executive Dashboard. Agenda. Explain the background, purpose, and objectives related to the Executive Dashboard (“FermiDash”) Review a high level overview of the architecture and tools being used

morleyr
Télécharger la présentation

Lighting up “Fermidash” – Fermilab’s Executive Dashboard

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. NLIT 2012 Lighting up “Fermidash” – Fermilab’s Executive Dashboard

  2. Agenda Explain the background, purpose, and objectives related to the Executive Dashboard (“FermiDash”) Review a high level overview of the architecture and tools being used Describe the approach for completing the project Highlight the dashboard features and functions Share lessons learned Present the future phases and what they will deliver NLIT 2012 FermiDash

  3. About “FermiDash” Background • Fermi Research Alliance (FRA), Fermilab’s prime contractor, committed to providing an Executive Dashboard (“FermiDash”) in its contract with the Department of Energy.  Over the past year, a team of Fermilab’s staff and contractors implemented the first phase of FermiDash. Purpose • The purpose of this project is to display crucial information in a clear and concise manner for making key decisions. The primary audience is Fermilab’s senior management, the Department of Energy, and the FRA board. NLIT 2012 FermiDash

  4. About “FermiDash” Objectives • To meet the contractual obligation for a management decision dashboard. We met this object ive by completing Phase 1 by the end of CY 2011 • To provide a visualization of the lab’s key performance indicators (KPIs). This is an ongoing process, but there is much progress and momentum NLIT 2012 FermiDash

  5. Architecture Primarily based on Microsoft (MS) Platforms MS SharePoint Enterprise Edition • PerformancePoint Dashboard Designer • Excel Services • Visio Services • Integrated Reporting Services • Site Collections to aggregate dashboards and KPIs into “FermiDash” MS SQLServer Database • Provides data storage for cubes and data marts • SQLServer Reporting Services (SSRS) – Displays data via reports and KPIs • SQLServer Integration Services – Moves data from source data stores to data mart for use in Dashboards, KPIs, and Reports • SQLServer Analysis Services(SSAS) - Delivers online analytical processing (OLAP) and data mining functionality NLIT 2012 FermiDash

  6. Architecture A wide array of back end data stores that contain source data • Oracle databases of Financial, HR, Safety data • SharePoint lists containing data that was not already available in databases • Excel spreadsheets that had been used prior to the Dashboard being available • Web Pages NLIT 2012 FermiDash

  7. NLIT 2012 FermiDash

  8. Approach Wanted to leverage existing SharePoint and SQL Server platforms Bring in business intelligence experts with Microsoft specific skill sets to accelerate the project Provide a solid infrastructure Work on “low-hanging fruit” dashboards. Meaning dashboards that can be derived from existing data sources and/or manually created reports. NLIT 2012 FermiDash

  9. There are eleven management system areas NLIT 2012 FermiDash Business Operations Communications Corporate Governance Engineering ES&H Finance Information Technology Performance Planning Quality Science Stakeholder Relations

  10. FermiDash – Welcome Page NLIT 2012 FermiDash

  11. FermiDash – Business Operations (1) NLIT 2012 FermiDash

  12. Fermidash – Bus. Ops. – HR - Balanced Score Card(1.1) NLIT 2012 FermiDash

  13. FermiDash – Communications (2) NLIT 2012 FermiDash

  14. FermiDash – Corporate Governance (3) NLIT 2012 FermiDash

  15. FermiDash – Engineering (4) NLIT 2012 FermiDash

  16. FermiDash – ES&H (5) NLIT 2012 FermiDash

  17. FermiDash – ES&H – Traffic (5.1) NLIT 2012 FermiDash

  18. FermiDash – Finance (6) NLIT 2012 FermiDash

  19. FermiDash – Information Technology (7) NLIT 2012 FermiDash

  20. FermiDash – Performance Planning (8) NLIT 2012 FermiDash

  21. FermiDash – Quality (9) NLIT 2012 FermiDash

  22. FermiDash – Science (10) NLIT 2012 FermiDash

  23. Fermilab – Science – Detector Performance (10.1) NLIT 2012 FermiDash

  24. FermiDash – Stakeholder Relations (11) NLIT 2012 FermiDash

  25. “Baseball Card” Display These are used to provide a visual menu to the various dashboards available. They make finding information quicker and easier. NLIT 2012 FermiDash

  26. Lessons Learned Leveraging a full service consulting firm seems to provide greater value and less risk than relying on a single expert Reports that appear to have been generated based on existing data, may not be based on the data, and/or may need to have extra processing to achieve desired format or message. Needed to provide structure to capture and store data that was only available in documents, presentations, or spreadsheets. Data owners needed reassurance that providing the data and support for the system was not going to come back to haunt them. Changing peoples frame of reference from Reports to Dashboards can differ based on each person. NLIT 2012 FermiDash

  27. Future Direction More Automation Better systems for collection, storing data Migrate reports and basic dashboards to dashboards using more advanced dashboard capabilities Provide more granular levels of role based security Add more content (dashboards, KPIs, Reports, etc.) Provide ability to analyze data Provide data, KPIs, reports to lower level managers NLIT 2012 FermiDash

  28. Conclusion Questions Comments Discussion NLIT 2012 FermiDash

More Related