Case Study
Business Intelligence provides the insights needed to guide
The client had a fragmented reporting solution, individually created for each business, in the best case, a country level. A variety of different systems and lack of internal team technical skills resulted in unmaintainable, not scalable and not robust solutions. In addition to the problems above, the client also utilised reporting tools for the ETL process, which were very cost ineffective and much slower than industry standard alternatives.
Due to increased demand, the client approached us to discuss enhancements in one of his reports as the internal team couldn't do it within the time frame required by the Board.
After a detailed analysis, we proposed to rebuild the entire UK region, which the client accepted. We explained what benefits the data warehouse will bring them.
We've also been asked to do the EMEA region as the next step of the enterprise data warehouse and group reporting solution.
The results
Our client hosts all their infrastructure and applications within Azure, and it was a natural choice to utilise Microsofts' Azure Cloud services to build desired reporting solution.
Tech Stack
01
Azure Synapse
02
Azure Logic Apps
03
Azure Blob Storage
04
Azure Data Share
05
PowerBI Service
The client has structured and semi-structured data that should be extracted and transformed into the business domain. We used Azure Synapse as a set of tools for this task, allowing us to scale on demand and process data from different sources.
We also used Azure Logic Apps as a 3rd party WebHooks handler to handle changes automatically instead of pulling on demand whenever possible.
"Jakub and the team at Endpoint have done a fantastic job on building a data warehouse and developing a BI tool for our business. The implementation of this solution has delivered significant value to our business. We are now able to drive commercial decision making far more rapidly, with far greater levels of insight, leading to better business outcomes.
As a final result, we prepared multiple ready-build reports and data marts for self-service. We provided training so all company users can build their own custom reports if required.
Data is secured by row-level security so all users within the company can see only relevant data.
Culligan Water
Our client is a large global enterprise within the drinking water industry. The company grows by acquiring smaller businesses and expanding its distribution to new territories.
Company size
4500+
Industry
FMCG
Project duration
12 months
We are trusted partner for your next project
Throughout the project lifecycle, from planning and design, through to development, maintenance and support. We are here to provide our expertise and services for your React project.
We develop and maintain high-quality solutions that reflect our core values.
Expertise and Flexibility
Benefit from our knowledge and experience, resulting in effective bespoke solutions that precisely align with your business needs.
Performance
We apply widely adopted best practices to ensure your solutions perform to the levels you require, and your assets are protected.
Quality
Our commitment to quality means we only deliver solutions that exactly meet your needs and represent our dedication to excellence.
Competitive Pricing
We offer cost-effective, high-quality, services and products that cater to businesses of all sizes and budgets.
