Contact Us

DiLytics Helps BayREN Reduce Greenhouse Gas Emissions with A Centralized Data Aggregation and Reporting Solution

[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_1767862074378{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1767862060990{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1767862047962{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

DiLytics Helps BayREN Reduce Greenhouse Gas Emissions with A Centralized Data Aggregation and Reporting Solution

[/vc_column_text][vc_column_text css=”.vc_custom_1767850777391{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_1767850853663{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Business Context 

[/vc_column_text][vc_column_text css=”.vc_custom_1767850979519{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]The Water Upgrades Save Program was launched in the year 2020 and aims to reduce water and energy usage to decrease greenhouse gas emissions by customers. The Program achieves this aim by installing efficient upgrades like toilets, showerheads, and aerators at customers’ homes.[/vc_column_text][vc_column_text css=”.vc_custom_1767851038589{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]The Program operates through utility companies. It funds utility companies to install water and energy efficiency upgrades at customers’ homes with little to no upfront cost to the customer. The Program targets single-family and multi-family homes and small businesses. Once the upgrades are completed, customers benefit from lower water and energy bills.[/vc_column_text][vc_column_text css=”.vc_custom_1767851074212{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]In addition to these upgrades, the Program includes an outreach initiative designed to achieve a wider impact by increasing awareness among customers. This initiative is conducted through letters and other communication channels, ensuring that people learn about the Program and its benefits.[/vc_column_text][vc_column_text css=”.vc_custom_1767851245245{margin-top: 0px !important;margin-bottom: 0px !important;}” el_class=”text-block”]Though BayREN employed a comprehensive approach and undertook a variety of activities toward achievement of the Program’s objectives, it suffered from several business and technical issues indicated below:[/vc_column_text][vc_single_image image=”15167″ img_size=”full” alignment=”center” css=”.vc_custom_1767862224438{margin-top: -5px !important;margin-bottom: 30px !important;}”][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=”” el_class=”text-block”]

DiLytics’ Solution

[/vc_column_text][vc_column_text css=”.vc_custom_1767860666816{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_1767860584473{margin-bottom: 20px !important;}” el_class=”text-block”]

1. Discovery Phase 

[/vc_column_text][vc_column_text css=”.vc_custom_1767860602794{margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics started the Discovery phase by identifying the various stakeholder groups involved in the Program and gaining an understanding of the role that they play in carrying out Program activities at the ground level. Based on this understanding, DiLytics created structured questionnaires for each stakeholder group and shared it with them well in advance of the scheduled discovery workshop date. Utilizing the structured questionnaire as the basis of the discovery workshop discussion, DiLytics elicited the required information pertaining to the various aspects of the Program from the stakeholders.  [/vc_column_text][vc_column_text css=”.vc_custom_1767860639162{margin-bottom: 10px !important;}” el_class=”text-block”]The different stakeholder groups that DiLytics held the workshops with, included: [/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1767860759411{margin-bottom: 20px !important;padding-left: 35px !important;}”]

[/rt_list_style][vc_column_text css=”.vc_custom_1767860793368{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_1767860821265{margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics utilized the insights gathered from the workshops to: [/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1767860856395{margin-bottom: 20px !important;padding-left: 35px !important;}”]

[/rt_list_style][vc_column_text css=”.vc_custom_1767861306403{margin-bottom: 20px !important;}” el_class=”text-block”]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_1767861368553{margin-bottom: 20px !important;}” el_class=”text-block”]

2. Implementation Phase

[/vc_column_text][vc_column_text css=”.vc_custom_1767861402027{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_1767861452247{margin-bottom: 20px !important;padding-left: 35px !important;}”]

[/rt_list_style][vc_column_text css=”.vc_custom_1767861481796{margin-bottom: 10px !important;}”]The solution entailed an automated data integration process that extracted data from Smartsheet 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=”15162″ img_size=”full” alignment=”center” css=”.vc_custom_1767861512943{margin-bottom: 20px !important;}”][vc_column_text css=”.vc_custom_1767861564336{margin-bottom: 20px !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.[/vc_column_text][vc_column_text css=”.vc_custom_1767861593185{margin-bottom: 10px !important;}” el_class=”text-block”]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_1767861641587{margin-bottom: 20px !important;padding-left: 35px !important;}”]

[/rt_list_style][vc_column_text css=”.vc_custom_1767861676553{margin-bottom: 10px !important;}” el_class=”text-block”]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_1767861868674{margin-bottom: 35px !important;padding-left: 35px !important;}”]

[/rt_list_style][vc_column_text css=”.vc_custom_1767861815683{margin-bottom: 35px !important;}” el_class=”text-block”]

Outcomes

[/vc_column_text][vc_column_text css=”.vc_custom_1767861846978{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_1767862013700{margin-bottom: 0px !important;padding-left: 35px !important;}”]

[/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=”.vc_custom_1767861967945{margin-bottom: 35px !important;}” 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]