1 / 14

What's on My Dashboard Today ?: Governmentwide Acquisition Contract Dashboard

What's on My Dashboard Today ?: Governmentwide Acquisition Contract Dashboard. Dr. Brand Niemann Director and Senior Enterprise Architect – Data Scientist Semantic Community http://semanticommunity.info/ AOL Government Blogger http://gov.aol.com/bloggers/brand-niemann/ December 13, 2012

taniel
Download Presentation

What's on My Dashboard Today ?: Governmentwide Acquisition Contract 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. What's on My Dashboard Today?:GovernmentwideAcquisition Contract Dashboard Dr. Brand Niemann Director and Senior Enterprise Architect – Data Scientist Semantic Community http://semanticommunity.info/ AOL Government Blogger http://gov.aol.com/bloggers/brand-niemann/ December 13, 2012 http://semanticommunity.info/AOL_Government/Governmentwide_Acquisition_Contract_Dashboard

  2. Some Principles • Everything can be improved. • Get the best people to work on improving it. • Never give up. • Source: TIBCO President VivekRanadive

  3. I Saw This http://gov.aol.com/2012/11/27/gsa-launches-dashboard-tracking-governmentwide-acquisition-contr/

  4. I Went To This http://www.gsa.gov/portal/category/103435

  5. I Waited For This http://www.gsa.gov/portal/category/103435#

  6. I Decided I Needed This http://www.gsa.gov/portal/category/103435#

  7. I Decided To Just Get The Excel Data http://www.gsa.gov/portal/category/103435#

  8. But That Failed, So I Screen Scraped It(All 19, 186 rows by 18 columns!) And made a Data Dictionary  http://semanticommunity.info/@api/deki/files/20124/GWACDashboard.xlsx

  9. Then I Imported Into Spotfire and https://silverspotfire.tibco.com/us/library#/users/bniemann/Public?GWACDashboard-Spotfire

  10. Re-Created the GWAC Dashboard Data https://silverspotfire.tibco.com/us/library#/users/bniemann/Public?GWACDashboard-Spotfire

  11. I Got the Following Results • I used my Spotfire Dashboard to explore the data and found the following highlights: • There are 51 agencies/programs listed but only 47 have data. • There are 5 contract types, 522 Industry Partners, and 10 years of data. • The Department of Defense has the highest total entries (2552), but the Department of State has the highest sum total estimated value of contracts (over $80 B). • SAIC is the leading industry partner (FAS Alliant GWAC of over $70B) out of a total of over $338 in contracts for all 522 Industry Partners.

  12. Conclusions • A Spotfire Dashboard is superior to Flash in the following ways: • Much faster performance due to in-memory analytics - I had to wait forever for the GWAC Dashboard to display different tabs and then query data. • More visualization types - I was able to create a sorted bar chart and dynamic cross-table that can then be searched by the Filters and displayed in the Details-on-Demand. • Stay tuned for my next What's on My Dashboard Today.

  13. My Editor Published This http://gov.aol.com/2012/12/10/the-pros-and-cons-of-gsas-acquisition-contract-dashboard/

  14. I Got A Call From Francis Rose http://www.federalnewsradio.com/?nid=38&query=Brand+Niemann&x=19&y=11

More Related