
BI Consulting to Consolidate Data of 30+ Businesses for Conglomerate-Wide Analytics
Industry
Manufacturing, Media, Retail About Our C
Technologies
Consumer Goods, Retail
About
The Client is a conglomerate running 30+ businesses worldwide, such as oil and gas, travel, FMCG wholesale and distribution, with the total revenue measuring in billions of dollars.
Challenge
Operating multiple businesses that are completely different in nature and totally independent in terms of IT infrastructure, the Client had operational data locked within each business. The absence of data integration among the businesses hindered the Client from implementing such initiatives as 360-degree customer view and a conglomerate-wide loyalty program.
Additionally, considering a potential growth, where a new business should smoothly fit into the existing IT environment, the Client needed to develop a standardized approach to integration. The Client also wanted to get bird eye view reporting that would embrace all business directions. To achieve that, the Client commissioned VolgoTechnologies to suggest a high-level architecture and a technology stack for each architecture component.
Solution
The project started with the onsite visit to the Client, where our BI consulting team had Q&A sessions with the top management of each business. During the sessions, our consultants examined as-is infrastructures and existing processes of each business, for example, sales pipelines functioning, as well as identified problems and integration gaps. Our team gathered the following stakeholder requirements for the future analytics and reporting tool: near real-time data processing, multi-dimensional data modeling, fast ad-hoc reporting and mobile view for reports.
Based on these findings, our consultants designed a high-level architecture with three technology stack options. To justify the technology selection for each architecture component (enterprise service bus, ETL, data warehouse, analytics and reporting), our team conducted deep analysis. For each component, we narrowed the focus down to four technologies, as agreed with the Client. So, the final list of technologies included 16 different tools.
After presenting the specific features of each solution to the Client and discussing their strategic business initiatives, our team came up with the final version of high-level architecture and technology stack.
Staging
Staging a Billing Portal for Viber Messenger with 1B+ Users involves creating a user-friendly interface for managing payments and subscriptions while ensuring security and scalability. Here a structured approach
Datawarehouse
Dataware House
Desktop Application

Results
At the end of the project, the Client received a top-level architecture that ensured bird’s eye view reporting and the much-needed integration among disparate businesses. The architecture allowed the business to scale easily thanks to a standardized approach to integration.
Technologies and Tools
Q&A sessions, functional decomposition, business requirements analysis, comparative analysis.