[vc_section full_width=”stretch_row” css=”.vc_custom_1532085157436{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1765866608185{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1765866316921{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1765866368998{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

DiLytics Powered BayREN’s Efforts to Improve Energy Efficiency and Compliance with Building Energy Codes by Implementing a Cloud Based Data Aggregation and Reporting Solution

[/vc_column_text][vc_column_text css=”.vc_custom_1765863292612{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The Bay Area Regional Energy Network (BayREN), founded in 2013, is a collaborative effort of the nine counties that make up the San Francisco Bay Area. It operates in the Environmental Services industry and is overseen by the Association of Bay Area Governments (ABAG). BayREN’s mission is to implement successful regional energy-saving programs, leveraging the knowledge and experience of local governments in the Bay Area. BayREN achieves this by developing and administering programs that promote climate protection, resource conservation, and sustainability. [/vc_column_text][vc_column_text css=”.vc_custom_1765866735415{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Business Context 

[/vc_column_text][vc_column_text css=”.vc_custom_1765863433922{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]One of the six programs that BayREN currently runs is called the ‘Codes and Standards Program’. The Codes and Standards Program, running since 2013, aims to improve building performance by enhancing compliance with energy codes. It achieves this by providing training for building department staff on various aspects of energy codes, including new construction, alterations, and specific technologies like heat pump water heaters. Additionally, it also offers permit guides, best practice documents, and other resources to streamline the code compliance process.[/vc_column_text][vc_column_text css=”.vc_custom_1765866432674{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]Though BayREN employed a very comprehensive approach and undertook a variety of activities toward the achievement of the Codes and Standards Program’s objectives, it suffered from several business and technical issues indicated below:[/vc_column_text][vc_single_image image=”15176″ img_size=”full” alignment=”center” css=””][vc_column_text css=”” el_class=”text-block”]To address these challenges, BayREN identified the need to implement a data analytics solution that will source data from multiple sources, store it in a persistent form in a centralized location, enable its analysis from different stakeholders’ perspectives and present it to users in a visually appealing manner.  Through a competitive bidding process, BayREN chose DiLytics as its partner to implement such a solution. [/vc_column_text][vc_column_text css=”.vc_custom_1765866476187{margin-bottom: 35px !important;}” el_class=”text-block”]

DiLytics’ Solution 

[/vc_column_text][vc_column_text css=”.vc_custom_1765866501238{margin-bottom: 20px !important;}” el_class=”text-block”]DiLytics went about the task of implementing the solution in a phased manner which comprised the following phases: [/vc_column_text][vc_column_text css=”.vc_custom_1765866555392{margin-bottom: 20px !important;}” el_class=”text-block”]

1. Discovery Phase 

[/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1765864064062{margin-bottom: 20px !important;padding-left: 35px !important;}”]

• Program Lead: Possesses overall responsibility of the Codes & Standards program across the region
• Implementer: Manages day-to-day operations, customer service, and event coordination
• County Representatives: Acts as the link between the program and their respective counties. Their responsibilities include ensuring their county’s needs are addressed, facilitating collaboration among local government staff, and promoting the program through outreach efforts within their county

[/rt_list_style][vc_column_text css=”.vc_custom_1765864173797{margin-bottom: 20px !important;}” el_class=”text-block”]DiLytics also conducted a thorough review and analysis of the Program’s existing IT architecture, processes, data flow, and technical design. Leveraging its extensive experience in Data Warehousing, Data Integration, and Analytics, DiLytics evaluated BayREN’s current platform, identified issues, gaps, unrealized opportunities, and technology deficiencies.  [/vc_column_text][vc_column_text css=”.vc_custom_1765864142311{margin-bottom: 10px !important;}”]DiLytics utilized the insights gathered from the workshops to: [/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1765866785734{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Understand the current state of the Program
• Draw the future state desired by various Stakeholder groups
• Identify strategies to take the Program from its current state to the future state
• Create a roadmap for implementing the identified strategies

[/rt_list_style][vc_column_text css=”.vc_custom_1765864317123{margin-bottom: 20px !important;}”]The output of the discovery phase was a comprehensive report that captured the findings related to the current state of the Program and the future state desired by stakeholders; analysis of those findings; recommendations about the proposed solution, its architecture, tools for various architecture components; and the roadmap to implement the solution. [/vc_column_text][vc_column_text css=”.vc_custom_1765866535491{margin-bottom: 20px !important;}” el_class=”text-block”]

2. Implementation Phase 

[/vc_column_text][vc_column_text css=”.vc_custom_1765864451972{margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics went about implementing the solution by leveraging its established methodology that comprised of the following phases: [/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1765864492412{margin-bottom: 20px !important;padding-left: 35px !important;}”]

• Solution Design
• Solution Development
• Key User Training
• User Acceptance Testing
• Solution Deployment
• Post Go-Live Support

[/rt_list_style][vc_column_text css=”.vc_custom_1765864526180{margin-bottom: 20px !important;}” el_class=”text-block”]The solution entailed an automated data integration process that extracted data from the flat files application; consolidated the data into a cloud-based data warehouse on Snowflake; and disseminated insights to users via a data visualization tool, Tableau. A high-level architecture of the solution is depicted in the schematic below:[/vc_column_text][vc_single_image image=”20891″ img_size=”full” alignment=”center” css=”.vc_custom_1773027639799{margin-bottom: 20px !important;}”][vc_column_text css=”.vc_custom_1765864612917{margin-bottom: 10px !important;}” el_class=”text-block”]The solution enabled a series of interactive reports that offer a visual representation of key metrics across various aspects of the Program, allowing for easy interpretation and analysis.  

 

Some of the key reports that the solution provided include: [/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1765864591264{margin-bottom: 20px !important;padding-left: 35px !important;}”]

• Quarterly Forum Reporting: This report possesses registration and attendee information for each forum.
• County Dashboard: This report contains an ongoing and updated list of all attendees and their associated data (jurisdiction, profession, contact info, etc.) and a pivot table outlining the jurisdictions present in each training/forum, as well as the number of city/county staff present at each training/forum.
• Quarterly Training Reporting: This is an ongoing and updated schedule of all training events, on-demand training views, a running list of all registered attendees and actual attendees, and the evaluation (survey) data for each training.
• Annual Forum Reporting: This report contains the registration and attendee information for each year’s forums, split between quarters.
• Annual Training Reporting: This report is an ongoing and updated schedule of all training events, on-demand training views, a running list of all registered attendees and actual attendees, and the evaluation (survey) data for each training.
• Training Report Calculation Master: It is an ongoing and updated list for a given year’s training metrics. It includes all the information needed to create the annual training report.
• Training Report Master: This report is sent to the client in tandem with the Training report. This spreadsheet must remain clean, complete, and client ready.
• C+S Metrics Reporting: It’s a 2023 report template that will be utilized for Quarterly Value Metrics.
• Quarterly and Annual Metrics Reports: These reports are prepared for each quarter and for each year and contain all required CPUC metrics.

[/rt_list_style][vc_column_text css=”.vc_custom_1765864634527{margin-bottom: 10px !important;}”]Some of the KPIs that the solution enabled included:[/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1765864785180{margin-bottom: 35px !important;padding-left: 35px !important;}”]

• Training: Number of training events organized
• Registrant: Number of registrations that have occurred for a training event
• Attendees: Number of people who attended the training event
• Unique Attendees: Number of people who participated in the training event
• % Reg who attended: Percentage of people who completed registration and participated in the training session
• Local Govt Staff: Number of local government representatives who attended the training events
• Number of Surveys: Number of surveys that have been completed or submitted
• Number of Local Government Staff Indicating Increased Knowledge: Number of local government staff who indicated that the training effectively increased their knowledge
• Percentage of Survey Indicating Increase in Knowledge: Percentage of surveys where participants reported an increase in knowledge

[/rt_list_style][vc_column_text css=”” el_class=”text-block”]

Outcomes 

[/vc_column_text][vc_column_text css=”.vc_custom_1765866055163{margin-bottom: 10px !important;}” el_class=”text-block”]The solution resulted in the achievement of the following outcomes for BayREN: [/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1765866227812{margin-bottom: 0px !important;padding-left: 35px !important;}”]

• Deeper and Accurate Understanding of the Program’s Performance: Automation of the data integration process and creation of a centralized data repository enabled efficient data access and analysis, reduced manual effort significantly, and eliminated data inconsistencies. In addition, the implementation of interactive data visualization tools, such as charts and graphs, enabled stakeholders to quickly grasp complex data and make better decisions based on it. All these led to the delivery of efficient, reliable, and accurate insights into various aspects of the Program.
• Optimization of Training Delivery and Outreach Strategies at the Program and County Levels: Insights into the number of training sessions held, attendees, feedback scores received post-training, total resources allocated for sessions, duration or total hours of sessions enabled optimization of training delivery and outreach strategies, thereby enhancing participant engagement, attendance, and satisfaction.

[/rt_list_style][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1684237429473{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 35px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”” el_class=”text-block”]

DiLytics Delivers

[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column css=”.vc_custom_1661424713241{margin-bottom: 25px !important;}”][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row]