Let’s work together
Want to discuss potential opportunities? Pick the most suitable way to contact us.
Book a call+370 5 2 780 400
info@ba.lt
Data warehouse modernisation for the international tobacco company
McKinsey‘s Global Data Transformation report points out that enterprises dedicate an average of 30% of their time to non-value-added tasks due to data quality and availability issues.
Rising data volume and complexity drive organisations to seek innovative solutions in modernising data warehouses and adopting advanced data governance systems.
Therefore, we are excited to showcase a case study detailing the successful implementation of a data warehouse (DWH) and Business Intelligence solution for the international tobacco company – JTI Baltic. Explore the project’s key highlights and outcomes now.
Situation
Established in 1999, JTI is a prominent global tobacco company in more than 130 countries. Since its establishment, it has evolved into one of the leading global tobacco producers renowned for its diverse portfolio of tobacco brands.
Due to outdated design principles and technologies, the legacy DWH solution resulted in reliability, scalability, and performance issues. This led to poor data quality, difficulties in system maintenance, and issues with adding new data sources. As a consequence, business users could not make valuable insights on time.
Therefore, JTI Baltic sought an IT partner to solve legacy DWH issues. Having a successful partnership experience with Baltic Amadeus, JTI Baltic decided to team up again to implement its DWH modernisation.
Solution
Collaborating with the client’s team, we designed a DWH and Business Intelligence solution to enhance IT capabilities in achieving the strategic objectives of JTI Baltic. The modernised DWH was based on modern architecture and Microsoft Azure cloud technologies.
Throughout the project, we conducted thorough analysis, documented requirements, identified potential gaps, and defined architecture with existing systems. This laid the groundwork for detailed project planning and eventual implementation.
Our team, comprising a senior data engineer, data analyst, and project manager, executed the solution’s architecture and setup. We developed the DWH, including a new data structure and ETL, implemented Master Data Services, managed data migration with Azure Data Factory, and redesigned Power BI reports.
Added value
The new DWH solution enhances data governance and quality, boosting the reliability and value of analytics. Additionally, the updated architecture and cloud services provide high performance, scalability, and flexibility.
Enabled with Business Intelligence, JTI Baltic can now effortlessly access Power BI reports, offering enhanced analysis, reporting, and distribution capabilities. This allows business users to create reports by themselves and make valuable business insights faster compared to the client’s previous reporting solution.
Overall, the completed DWH modernisation simplified IT maintenance and support and significantly reduced the required effort. This improvement ensures that implementing new data analytics reports or new data sources now takes less time, contributing to a more efficient and responsive system.
Other projects
User experience services for a Norwegian communication software provider
Omnicus
Power BI solution for the global tobacco provider
JTI Lietuva
Reliable marketplace platform for used car trading
Unified IT systems for the debt company
Drupal-based CMS for a leading tobacco company worldwide
JTI Lietuva
Solar energy trading solution for the international energy company
Progress OpenEdge development and system testing services for a Swiss company
Optiwork
AWS-based automated reporting and billing solution for the US transportation company
Clever Transco LLC
Azure-based solution that cut infrastructure costs by over 4 times
ProMark
Data/API Hub solution for the international ferry service provider
TT-Line
Security assessment and InfoSec training for a global media company
Internews
Infrastructure and data migration assessment for agricultural retail provider
Lytagra
Upgraded analysis platform boosted paid user base by 43%
Börsdata
In-depth penetration testing for a specialised Lithuanian bank
General Financing Bankas
Mobile app for the fastest-growing payment solutions provider in Lithuania
ConnectPay
Mobile app development for the largest insurance company in the Baltics
Lietuvos Draudimas
Boosted sales performance for the leading digital services company in the Baltics
Bitė
Highly rated mobile app for Baltic digital services company
Bitė
Progress OpenEdge solution for the US medical billing and management service provider
Professional Billing, Inc.
Efficiency-driven ordering and billing system for large-scale military training
WilNor Governmental Services AS
High-performing eCommerce platform for one of the largest pharmacy providers in the Baltics
EUROAPOTHECA
AWS-based mobile banking solution for the financial institution
LCCU
Fully automated and scalable leasing solution for DNB Bank
DNB BANK
Ensured IT security & GDPR compliance for the international web hosting provider
Hostinger
Convenient daily banking solution for credit unions
KREDA
Mobile banking app for DNB bank
DNB bank
Performance monitoring solution for the global shipping company
Shippersys
Custom Business Intelligence solution for a global maritime company
Shippersys
Crisis management system for Norway’s educational institutions
Akershus County
eCommerce platform for the global maritime Enterprise Asset Management provider
Star Information Systems
Innovative eCommerce solution that enhanced customer experience for electricity consumers
UAB Technologijų ir inovacijų centras
Web and mobile applications for preschools to ensure children’s safety
FamWeek
Fully upgraded communication platform for the Norwegian telecoms company
SIMCOM AS
eCommerce reservation platform for the Norwegian Aviation Museum
Norwegian Aviation Museum
Data visualisation solution that highly increased business productivity
UNIPARK