1 / 24

EPA’s Social Business Intelligence @ Work

EPA’s Social Business Intelligence @ Work. Brand Niemann Senior Enterprise Architect U.S. EPA November 7, 2010. Overview. National Computer Center Application Hosting Customer Workshop, November 2, 2010:

satya
Download Presentation

EPA’s Social Business Intelligence @ Work

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. EPA’s Social Business Intelligence @ Work Brand Niemann Senior Enterprise Architect U.S. EPA November 7, 2010

  2. Overview • National Computer Center Application Hosting Customer Workshop, November 2, 2010: • Purpose: To provide an overview of new tools, innovative technologies, and process improvements to support Agency business partners achieve their information technology goals.  • 1:45-2:30 pm Tools: Business Intelligence at Work: Discover how business intelligence tools can be used to analyze business trends and provide real-time information for decision-making. Timothy Hinds, OTOP, and Lisa Jenkins, OSWER. Excerpts from Their Slides in the Next Slides. • BusinessObjects XI, Oracle Business Intelligence Enterprise Edition, Informatica Power Center, and SAS. • Social Business Intelligence: • What is "social BI"? Is that Social networking?: • Empowerment of the User, Community Collaboration, Telling Stories with Data, and Self-Publishing: • See http://spotfire.tibco.com/silverspotfire/social-bi.aspx and http://epadata.wik.is/EPA's_Business_Intelligence_at_Work. • EPA’s Office of Communication uses Socrata and I use Spotfire.

  3. Business Intelligence at Work • National Computer Center Application Hosting Customer Workshop, November 2, 2010: • The BIAC – Timothy Hinds • OSWER Projects – Lisa Jenkins • Cleanups in My Community (CMIC) • OSWER Performance Assessment Tool (OSWER PAT) • Engaging the BAIC – Timothy Hinds • Questions – Timothy Hinds & Lisa Jenkins

  4. Business Intelligence & Analytics Center (BIAC) http://cfint.rtpnc.epa.gov/otop/biacoe/index.cfm

  5. Business Intelligence and Analytics: BI $244.00 Versus Free by Me! http://cfint.rtpnc.epa.gov/otop/currentfyservices/bi/bi.cfm

  6. Regional Analysis https://obistaging.rtpnc.epa.gov/analytics/saw.dll?Dashboard&_scid=x1Ausrmu8NI

  7. Brand Analysis https://obistaging.rtpnc.epa.gov/analytics/saw.dll?Dashboard

  8. Year over Year Analysis https://obistaging.rtpnc.epa.gov/analytics/saw.dll?Dashboard

  9. Download Video • Another Tab Option is Download Video: • 22 files, 62 MB! • One is Introduction.ppt, 7 slides. • Office of Underground Storage Tanks, LUST4, Demonstration and Training, Produced 2009.09.04 by the US EPA Business Intelligence and Analytics Center: • LUST4 Uniform Resource Locator (i.e., “Web Address”): https://oasext.epa.gov/pls/apex/f?p=101 (Requires Log-in) • For More Information: Matt Young, 703-603-7143, young.matthew@epa.gov, http://www.epa.gov/swerust1/eparecovery/index.htm • Found EPA has no “UST/LUST site-specific database” per Larry Zaragosa (just an unpublished Google Map of the sites). So I created a UST/LUST state database from EPA Public Web Page content (see next slides). Note: Tried lots of other links, but found nothing.

  10. Cleanup Site Map Service Next slide The Cleanup Site Map Service (CSMS) is a project of the United States Environmental Protection Agency. Comments are welcome, and can be sent to the developer who will distribute them.

  11. Cleanup Site Map Service http://csms.terradex.com/

  12. Cleanup Site Map Service Unpublished Google Map

  13. State And Territory UST/LUST Program Status And Contacts http://www.epa.gov/swerust1/states/statcon1.htm http://epadata.wik.is/@api/deki/files/947/=UST-LUST.xls

  14. Cleanups in My Community http://iaspub.epa.gov/apex/cimc/f?p=255:41:1348532294532633

  15. Cleanups in My Community • About This Site: • Cleanups in My Community is a mapping and listing tool that shows sites where pollution is being or has been cleaned up throughout the United States. It maps, lists and provides cleanup progress profiles for:- Sites, facilities and properties that have been contaminated by hazardous materials and are being, or have been, cleaned up under EPA's Superfund, RCRA and/or Brownfields cleanup programs.- Federal facilities that have been contaminated by hazardous materials and are being, or have been, cleaned up under EPA's Superfund and/or RCRA cleanup programs. • Note: Currently, we can only show sites, facilities and properties for which EPA collects information by law, or voluntarily via grants. At present, this does not include state or locally funded cleanups. We are working with our state and local partners to expand the scope of cleanups to be accessed through Cleanups in My Community in the future. In addition, data in this system is updated according to the data update schedule and may not yet reflect real changes at the locations covered here. • Need Additional Cleanup Information? • Brownfields • Federal Facilities • Regional Emergency Management Links • Resource Conservation and Recovery Act Information (RCRAInfo) • Spills of oil, gas, pipeline liquids and hazardous substances • Superfund (including non-NPL and archived sites) • Underground storage tanks - state web pages (recall slide 11) http://iaspub.epa.gov/apex/cimc/f?p=255:57:3832742373095607

  16. EPA Response to PB Oil Spill in the Gulf of Mexico • EPA Response to BP Spill in the Gulf of Mexico: • Click here for BP Deep Horizons Oil Spill Data • http://iaspub.epa.gov/apex/cimc/f?p=255:59 • View BP Deep Horizons Oil Spill Data: • Air Data: http://epa.gov/bpspill/air.html • Water Data: http://epa.gov/bpspill/water.html • Sediment Data: http://epa.gov/bpspill/sediment.html • Waste Data - Oil Sample Results: http://epa.gov/bpspill/waste.html#samples • Dispersant: http://epa.gov/bpspill/dispersants.html#bpdata • Data Interactive map of air monitoring locations: http://iaspub.epa.gov/pls/apex/f?p=100:2:908430046142441 • See Next Slide.

  17. BP Oil Spill - Sampling and Monitoring Sites Note: Error Occurred http://iaspub.epa.gov/pls/apex/f?p=100:2:384415141293784

  18. Air Data from the Gulf Coastline http://epa.gov/bpspill/air.html

  19. EPA Sampling Data: Response to the BP OIl Spill Export to CSV http://www.socrata.com/Government/EPA-Sampling-Data-Response-to-the-BP-OIl-Spill/7ee5-4s6h

  20. Data Sources • Looking for Data in Socrata this time (previously I used the Data Download Tool): • Air Data: http://epa.gov/bpspill/air.html • Air Monitoring: http://www.socrata.com/Government/EP...pill/n63a-2n37CSV • Air Sampling: http://www.socrata.com/Government/Ai...ling/hwcu-fexfCSV • Note: For all hydrogen sulfide (H2S) data posted before May 17, the detection limit is 1 ppm. For all H2S data posted May 17 or after the detection limit is 0.1 ppm.  • Water Data: http://epa.gov/bpspill/water.html • Dispersant analyses from water samples: http://www.socrata.com/Government/EP...rom-/iy8m-cbcuCSV • Dispersant analyses from sediment samples: http://www.socrata.com/Government/EP...s-fr/5e5d-45awCSV • Analysis of water samples for chemicals and compounds associated with oil:http://www.socrata.com/Government/Su...ling/82gb-zn72CSV • Oil Sample Results: http://www.socrata.com/Government/Oi...ions/zhpf-r9rnCSV • Sediment Data: http://epa.gov/bpspill/sediment.html • http://www.socrata.com/Government/Se...ling/dhdf-vsziCSV • Waste Data - Oil Sample Results: http://epa.gov/bpspill/waste.html#samples • http://www.socrata.com/Government/Wa...ling/p9z5-dbi3CSV • Dispersant: http://epa.gov/bpspill/dispersants.html#bpdata • Data Interactive map of air monitoring locations: http://iaspub.epa.gov/pls/apex/f?p=1...08430046142441 • UST/LUST State Data Summaries: http://www.epa.gov/swerust1/states/statcon1.htm in Excel: http://epadata.wik.is/@api/deki/files/947/=UST-LUST.xls • Google Earth Maps: BPGulfSpillResponse.kmz, dhorizon_apr2010_main.kml, dhorizon_apr2010_nlink.kml http://epadata.wik.is/EPA's_Business_Intelligence_at_Work#Data_Sources

  21. Social Business Intelligence • Empowerment of the User: • Cloud Computing-no hassle with IT investment • Community Collaboration: • Social features supplement traditional BI for broader information sharing • Telling Stories with Data: • Exploratory Data Analysis • Self-Publishing: • Does not cost $244/hour! Socrata is free to Data.gov users. Spotfire Silver is free (one year and up to 3 files of <10MB). August 25, 2010, Webinar: BI in the Cloud: The Pervasive, Self-Service, Social Approach

  22. Spotfire Desktop PC

  23. Spotfire Web Player

  24. Some Conclusions and Next Steps • The EPA Response to PB Oil Spill in the Gulf of Mexico provides data in both a Data Download Tool and Socrata. The former was used previously and the latter used in this analysis because it is a Social BI Tool. • Social BI differs from conventional BI in a number of ways, especially cost. • Social BI should be applied to additional EPA data sets, especially water geospatial data downloads. • http://www.epa.gov/waters/data/downloads.html

More Related