Slide

How YCH Tapped
their Data for Growth

A journey into their new craft Enterprise
Data Warehouse

 
Client
Image
Industry
Largest distributor of premium quality hops in the US
 

Business Problem


Yakima Chief Hops
has offices around the world and data needed to be updated frequently to reflect the current-location, allocation, quality, and quantity of their products. YCH wanted to be able to take their systems to the next level and enable their sales teams to make more competitive deals, while also enabling the executive team to make stronger strategic decisions and grow the business.
Image
 
 

Client Objective

To create a reporting environment
 
 
 
that allows data analysis in near real time, rapidly scale their analysis capabilities to support new business areas and integrate historical data for predictive analysis.
 
 
Image

Fueled By

We brought an executive level of understanding to the table, starting with their sales team and extending through every technical asset they placed on the team. Baufest earned trust and ultimately the business by asking hard questions, learning the underlying business before proposing solutions, and setting appropriate and achievable expectations for the project outcome.
 
 

Solution Developed

A visit to YCH’s office was arranged between our client representative and a Data expert to understand firsthand their needs and work done to date. There was a significant amount of work done by YCH that needed to be considered before revamping their solution.

According to our co-creation way, Baufest recommended a series of steps to allow for YCH BI team to make informed decisions for their journey into the new Enterprise Data Warehouse solution.

Image
 
We generated the following artefacts
 
  A Technology Decision Matrix so that YCH can compare the main features of Azure offers for EDW and decide with objective parameters the most suitable choice for their needs.
  An architecture diagram, resulting from the technology chosen,
  A suggested, phased Roadmap with clear deliverables to implement and evolve the solution,
  And the description of typical EDW project Roles adapted and suggested for YCH
 
 

Business

 
 
A.

YCH BI team had developed several reports in Power BI, supporting 150 users in the last 2 years. Realizing that the existing platform could not support requirements such as intraday updates and historical information for tendency analysis and prediction capabilities, YCH IT & BI teams envisioned an Enterprise Data Warehouse solution.

B.

With historical production and sales data readily available, the data science team could build a model to predict the probability of over/under inventory levels, proactively freeing up inventory for additional sales.

 
Technology Leveraged
Image

Data Ecosystem

 
Data Warehouse
 
 

environment is proposed using schemas inside a single Azure SQL Database. Schemas include:

  Dimensional Layer: to unify and encapsulate business logic in a single layer optimized for intuitive data access to allow for Self Service BI in the reporting tool.

  Atomic Layer: consolidated 3rd normal form relational model, including business rules.

  Staging area: cleansed data with technical validation rules and record counts.

  Raw data: Depending on origin source type. Json files can be stored in Cloud Storage to keep original format.

  Data Science Sandbox can be extended using an additional Schema on Azure SQL Database, extracting information from Atomic Layer or Staging Area depending on the need, or adding additional data types (such as json), including external ad-hoc sources.
 
 
Data integration layer
 
 
SSIS is the most suitable choice in terms of current volume needs.

  Azure Integration Runtime to orchestrate executions
 
 
Visualization Layer
 
 
Power BI as visualization tool

  Connect with Dimensional Layer via DirectQuery. This allows to build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation. DirectQuery reports always use current data.
 
 

Results

 
 
A.

YCH now has access to 6 distinct business units’ data in a scalable, measurable, and controllable environment.

B.

With the creation of the EDW at YCH we were able to create a single source for information eliminating the need to query multiple sources. This also enabled the business to focus on analysis rather than operational tasks to gather and cleanse data, ensuring consistency, quality controls and timeliness.

 
 

Real talk

It takes time to experience long term effects and benefits. The greatest immediate gain is the access of information to their entire organization and company, from executives to daily personnel. How an organization uses that information is up to them and with the right strategy can improve revenue by 5%-10% by proactively releasing overstock inventory instead of letting it build up over any extended period.
Image
 

YCH Data
Admin Manager

 
 
Want to learn how Baufest can help to identify opportunity for business impacts through their Discovery workshop?
Click here to learn more!

    Name*

    Email*

    ×
     

    Smart assistant for banks: valuable interactions suited to the needs of each customer

    Commercial and financial services bank founded in 1968. Headquartered in Buenos Aires and present in 22 provinces, it is the leading private bank in the Argentine financial system in terms of savings and credit volume. This organization has 334 branch offices, more than 2.5 million clients and more than 6,500 employees.

    THE CHALLENGE

    The Company needed to improve the effectiveness of its virtual assistance to decrease the number of calls to the Call Center, and provide the customer with greater autonomy and agility to solve their concerns.

    THE SOLUTION

    We defined a methodology for the incorporation of new businesses, identifying the users’ needs and making available the different channels of communication to improve their experience when using the virtual assistant. In order to provide more information and a personalized response according to each customer’s requirements, we incorporated the areas of Salaries, Short-term default and Long past due. Lastly, we defined a methodology along with the development of components that help to continuously improve the assertiveness of the virtual assistant.

    BENEFITS

    Slide

    The Importance of
    Discovery Workshops

    Understand. Plan. Align. Execute.

     
    Client
    Image
    Industry
    Fundraising Technology in support of local children's activities.
     

    Business Problem


    RahRah! Solutions
    noticed a sharp drop in application usage soon after download coupled with a challenged subscriber retention rate. Low renewal rates and lack of application engagement equate to less support of children and their school and team activities.
    Image
     
     

    Client Objective

    Increase annual subscription renewals while widening their subscription base
     
     
     
    RahRah! Solutions provides a digital fundraising platform for local community and school activities on a subscription basis, all from the convenience of a smartphone. RahRah! Solutions strives to create a product that delights customers elevating an archaic activity into the 21st century. RahRah! Solutions is focused on creating a positive user first experience to encourage
    on-going support for children, coaches, parents, and subscribers through their fundraising app. RahRah! Solutions was looking for a team to partner their skills with to strengthen their application, improve their subscription numbers and provide professional feedback and guidance with a vested interest in their success.
     
     
    Image

    Solution Developed

    Baufest partnered with RahRah! Solutions to help them achieve their goals. Through Baufest’s proven Discovery workshop process, data driven functionality gaps were identified and able to be prioritized to maximize positive impact. Using stakeholder, users, and employee interviews, Baufest was able to understand usages, expectations and identify gaps in features, usability, and user management. Baufest developed usability maps and determined how changes to user experience would deliver the expected business outcomes and help solve their identified opportunities.
     
     

    Technology Leveraged

    MiroBoards were used to collaborate, mapping customer journeys, plot user feedback, and prioritize opportunities. Adobe XD was used to create a low resolution mock ups, and SurveyMonkey was used for initial user feedback.
     
     

    Business Impact

    As a result of the Discovery workshop process with Baufest, RahRah! Solutions can now be confident the identified changes and prioritization of those features will help them to reach their goal of increasing their subscription renewals by 20% within the next 12 months.
     
    Image
     

    David Nelson
    RahRah! Solutions
    CEO & Founder

     
     
    Want to learn how Baufest can help to identify opportunity for business impacts through their Discovery workshop?
    Click here to learn more!

      Name*

      Email*

      ×
       

      Service digital transformation

      THE COMPANY

      One of the leading glass manufacturing companies in the world; The most important one in the western world and the main glass producer in Mexico. With offices located in America, Europe and Asia, it produces, processes, distributes and commercializes a broad range of glass products, which are part of the daily life of millions of persons.

      THE PROBLEM

      With the support of the Internal Technology Area, the customer was looking for a more agile, modern and easier user experience when acquiring their services.

      THE SOLUTION

      We designed the user experience for the MVP of a digital tool by using customer-focused design techniques and validating prototypes with the end users. During the second stage, we built the technological architecture adapted to the needs of the customer, in such a way that it could evolve and be used as a reference, under an Agile-based process and tools. Lastly, we accompanied the customer during the execution of the application, knowledge-transfer, product feedback and new improvement ideas for the next stages.

      Through this new digital channel, the user can request an appointment from home for the replacement and repair of the car glass and manage payment for the service.  

      BENEFITS

      • Sales increase, reaching a largest target audience and facilitating the purchasing process.
      • Infrastructure cost reduction in branches.
      • Optimization of the refund process before the insurance companies.
      Bitcow plataform

      Bitcow Platform

      THE COMPANY

      OpenBit is a technology business founded in 2018 with the aim of democratizing access to different businesses that present high entry barriers due to their need for capital, information and knowledge. Its objective is to promote the financial inclusion through the tokenization of real assets traded on the digital platform, and to track the investments performed. Likewise, it seeks to become an investment and savings alternative, since it allows to participate in a greater business with small amounts.

      THE PROBLEM

      The company sought to develop an investment alternative for savers wishing to diversify their assets in a safe and efficient manner, facilitating their access to the livestock sector, a business that requires knowledge, time and economic resources. With a clear business model, OpenBit needed a digital platform that could support future growth and the possibility to develop new digital tokens.

      THE SOLUTION

      With the aim of understanding the business in depth, we performed a benchmark of digital products offered by the agribusiness industry and performed an analysis of the cryptocurrency industry. In addition, so as to get to know the needs of future users, we analyzed their behavior with the product, conducted interviews, observations and workshops of co-creation along with the customer. ​

      Once the digital product capable of meeting the expectations of potential users was defined, we created a platform using microservices in .NET on a front end developed in Angular, all hosted in the Microsoft Azure cloud.

      BENEFITS

      Automation of people centered processes

      THE COMPANY

      Transportadora de Gas del Sur is the widest reaching gas transport company in Latin America. It transports 60% of all the natural gas consumed in Argentina, where at Vaca Muerta it is the primary midstreamer, and is a direct supplier of both distributors and industries. It is also a leader in the liquefaction of natural gas.

      THE PROBLEM

      The company sought to increase internal user satisfaction by delivering valued products and services.​

      THE SOLUTION

      We worked together with the leaders of the IT team on an innovation process designed to make them the protagonists of a cultural change in the evolution of their service. We held diverse training workshops on new methodologies and accompanied the team leaders during the execution of a user survey so as to place them in the center of their processes.​

      BENEFITS

      • Automation of manual processes in 5 areas of the company
      • Traceability in audit management
      • Monitoring of approvals
      • Automated management of payments
      TGS

      Ethical Hacking: Corporate cybersecurity and risk management

      THE COMPANY

      Leading company in the supply of tubes and services related to the worldwide energy industry. Among its clients, we can find the main international oil companies, as well as engineering companies engaged in the construction of extraction, transportation and processing of oil and gas. The company has 4 Research and Development centers, over 2,500 clients and 23,000 employees.

      THE PROBLEM

      The client wanted to optimize the information protection measures and improve its analysis and safekeeping. To do so, it needed a group of consultors able to solve operating issues related to the applications’ security, DLP solutions and vulnerabilities analysis. Another of its requirements was to draft documentation for Government, Risk and Compliance areas.

      THE SOLUTION

      Baufest put together a team to work with the client’s applications security, risks and solutions areas of Ethical Hacking. Firstly, we performed the analysis of vulnerabilities and risks, and then, we updated and extended the Data Loss Prevention Policy (DLP) for the whole of Latin America, Europe and the Middle East. Furthermore, we implemented an Ethical Phishing policy to work on raising awareness among the users, and a CASB solution to strengthen the Shadow IT.

      BENEFITS