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.

DWH
JTI-DWH

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.

JTI-data-warehouse

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

     privacy policy

    Other projects

    Drupal-based CMS for a leading tobacco company worldwide

    JTI Lietuva

    Reliable marketplace platform for used car trading

    Unified IT systems for the debt company

    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

    Get a free quote!

    We will be glad to answer all your questions. Contact us and get a free quote in 24 hours. CONTACT US >