How YCH Tapped
their Data for Growth
A journey into their new craft Enterprise
Data Warehouse
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.
Client Objective
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.
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 YCHBusiness
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.
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.
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
YCH now has access to 6 distinct business units’ data in a scalable, measurable, and controllable environment.
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.
YCH Data
Admin Manager
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
- Increase in virtual assistant coverage
- Reduction of operating time of the Call Center
- Reduction of operating costs
- Increased customer satisfaction
The Importance of
Discovery Workshops
Understand. Plan. Align. Execute.
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.
Client Objective
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
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.
David Nelson
RahRah! Solutions
CEO & Founder
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 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
- Scalable platform agilely adapted to the expansion of operations in Uruguay, Paraguay and Brazil, among other markets.
- Very satisfactory customer experience for more than 6000 active users.
- Platform ready to accompany the business growth.
- Platform launch faster than expected due to the methodology of work used.
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
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
- Greater visibility of risks and more information for decision-making processes.
- Greater awareness for industrial and corporate cybersecurity areas.
- Increased control over user’s access to applications.
- Confidential information permits databases
- Automation and optimization of the processes in the Government, Risk and Compliance areas.
- Know-how related to the execution of ethical phishing practices.