1 / 16

Data Management and Analysis

Data Management and Analysis. Project Teams. Consumer Behavior Studies. Benefits Analysis. Plan Development and Assistance (Technical Advisory Group). Data Hub. SGIG/SGDP Build and Impact Metrics Correlation and Benefits Estimation. Data Management and Visualization. Smartgrid.gov.

theta
Download Presentation

Data Management and Analysis

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. Data Management and Analysis Project Teams Consumer Behavior Studies Benefits Analysis Plan Development and Assistance (Technical Advisory Group) Data Hub SGIG/SGDP Build and Impact Metrics Correlation and Benefits Estimation Data Management and Visualization Smartgrid.gov Smart Grid Clearinghouse Smart Grid Systems Report 1

  2. Build Metrics Reporting Timeline • Build metric submittals will cover the previous quarter • Data should be compiled during the following month • Build metrics are do no later than the last business day of the following month Legend Measurement Period Reporting Period Reporting Dead Line Q3 Q4 2010 Q2 2011 Q3 2010 Q1 2011 10/29/2010 1/31/2011 4/29/2011 7/29/2011

  3. Introduction of the Data Hub • Enterprise system to manage data • Collect, manage, and store metrics and benefits data (both build and impact metrics) for the ARRA funded Smart Grid Program • Provide convenient access to data reporting functions via the SmartGrid.gov website • Make data available to DOE for reporting, analysis, and visualizations • Projects will have their own recipient specific project page to view data submitted • The Data Hub supports data access and visualizations that are portrayed on SmartGrid.gov

  4. Process & Background • Once MBRPs are approved, projects are expected to report on a quarterly basis (refer to your individual project schedules) • Based on an approved MBRP, we will create a project-specific data input template that presents the specific data fields that will be entered into the Data Hub • If there are discrepancies between the template and your approved MBRP, please contact your Metrics and Benefits Team representative • The template details will be incorporated into the Data Hub for customized reporting • Once you receive the template and a username and password, you will be able to begin reporting

  5. Accessing the Data Hub ARRA Project Teams FederalReporting.gov Smart Grid Data Hub VIPERS SIPRIS One touch entry to all reporting functions

  6. SmartGrid.gov Project Teams Page www.smartgrid.gov/teams You will find guidance documents and be able to access the Forum to share information with other project recipients

  7. How will I get Access to the Data Hub? • IDs will be assigned and sent via e-mail to the prime project contact upon approval of the MBRP • The prime contact can request that others be added to the approved access list • IDs will be given to these additional people via e-mail • Users can create their own passwords once IDs are provided E-mail: projects-admin@smartgrid.gov Provide this information: Name, organization, & e-mail address IDs Security Access Passwords

  8. Using the Data Hub - Initial Set up

  9. Two Ways to Submit Data • Editable PDF Forms • Simple Web form approach for entering data into the form • Ability to save the file and route for additional input or internal approvals prior to submitting the form • XML • Automated approach using an XML schema • Requires a programmer who understands how to create an XML document based on an XML schema

  10. Reporting Data Flow Process for PDF Login Select PDF Complete PDF Save PDF (can be shared and distributed to others) Submit PDF? No Yes Click “Submit” Click “Submit” while logged-in or upload No No Yes Data Submitted for Metrics and Benefits Team Review And available for project team to view and print Data Format Check – Are there errors?

  11. Reporting Data Flow Process for XML Login Select and Download XSD Create XML that conforms to XSD Submit XML to Web Service No Data Submitted for Metrics and Benefits Team Review And available for project team to view and print Yes No Data Format Check – Are there errors?

  12. Data Review and Approval Process Submitted PDF Data Submitted – but awaiting review (PDF or XML) Project Team Resubmits updated Data Submitted XML Metrics and Benefits Team Review No Metrics and Benefits Team, discusses issues with project team for data resubmittal No Does Data Conform to MBRP? Yes Complete Submission

  13. Using Editable PDF Forms Demo .

  14. XML Schema Demo

  15. Here’s what we are doing with your data • Build metrics for each project will be showcased on SmartGrid.gov • Build and Impact metrics will also be presented in an aggregated format on SmartGrid.gov • Data will be used in DOE reports AMI Smart Meters and Customer Access to Pricing Programs

  16. Q & A Open discussion for Questions and Answers Data Hub Contact: E-mail: projects-admin@smartgrid.gov

More Related