200 likes | 316 Views
Ethics.Data.Gov : Big Data and Little Results?. 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/ March 12, 2012. Overview.
E N D
Ethics.Data.Gov:Big Data and Little Results? 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/ March 12, 2012
Overview • Implement Design Principles of Federal Shared Services Strategy in the App: • Big Data in Memory • Search Across Multiple Data Sets • Build a Knowledgebase • Build the Data Sets • Build a Dashboard • Provide a Tutorial
Knowledgebase http://semanticommunity.info/AOL_Government/Ethics.Data.gov
Data Sets http://semanticommunity.info/AOL_Government/Ethics.Data.gov#Data_Sets
Data Sets http://semanticommunity.info/@api/deki/files/17508/=Ethics.xlsx
Dashboard:Cover Page Over 10 M Rows and Almost 100 Columns!
Dashboard:Cover Page Data Sets with Common Data Fields
Dashboard:White House Visitor Records Filter by POTUS, Meeting in White House, with Senator Harry Reid Eight Times, in 2010, with 7636 People!
Dashboard:Lobbying Disclosure Reports Filter by Year, Client County, and Client State: All Years, Saudi Arabia, and All States
Dashboard:FARA Records Filter by Type and Name: 30 Point Strategies, LLC Type: Supplemental Statement Unique Count (Name): 1 Count (Number): 1
Dashboard:FEC Candidates Filter by Party: Independent
Dashboard:OGE Travel Reports Filter by Agency and File Type: 391 Used PDF and 146 Used XLS’s!
Dashboard:FEC Contributions Filter Election Year (All) and Recipient Obama Victory Fund 2012: CA $17M
Dashboard:FEC Contributions Filter Election Year (All) and Recipient Romney For President 2012: CA $4M