Interactive analytics for Swiss Krono: production control not in Excel, but in real time
Swiss Krono is not just a brand, but one of the world leaders in the production of wood-based building materials.
View more
BAT Data Always at Hand: Transforming Reporting from Instability to Control
About the project
New Data Structure for BAT – Clearing the Smoke for Transparent Numbers
British American Tobacco (BAT) is a global giant operating in 180 countries. The company, uniting over 50,000 people, is known for its brands: Dunhill, Lucky Strike, Pall Mall, and Vuse. Today, BAT is undergoing a massive transformation from traditional tobacco industry to electronic cigarettes and tobacco heating systems. The leader actively invests, develops technologies, and supports sustainable development.
Client Challenges and Needs:
The client faced difficulties with reporting. The system was unstable:
- metrics were calculated with delays or inaccurately
- performance was suboptimal
- reports periodically became inaccessible
This created risks for operational processes and complicated decision-making.
The client needed a reliable tool that would provide stable, continuous access to accurate data in a business-friendly format.
How we solved the client's problem
Analytical reporting at BAT no longer brings chaos, as information is stored and processed in a multi-level system.
-
Dispatching mechanisms ensure reliable control and instant notifications in case of failures.
-
Our approach: We began with a detailed analysis of existing Power BI reports. We implemented initial corrections and partially stabilized the system’s operation. Key issues were identified in data sources and their transportation process to Power BI. Our specialists developed several solution options with data warehouse implementation using various tools.
Work results:
-
Reporting became accessible, comprehensible, and reliable, while data ceased to be a problem – now it works for the business, not against it.
-
Optimized Power BI: conducted an audit of existing reports, corrected calculation logic, improved performance.
-
Built Data Warehouse architecture: implemented a multi-level model with Bronze and Silver layers for efficient data storage and processing.
-
Set up ETL processes: automated data collection, cleaning, and transfer, minimizing risks of manual errors.
-
Implemented dispatching: created a mechanism for data quality control and loading stability with automatic notifications in case of failures.
-
Formed an infological model: clearly described all entities, their relationships, and analytics usage logic.
Project details
Key facts about the project
12 months
Project duration
Medium
Project size
Project complexity
Completed
Project status
Our team:
Project Manager
Business Analyst
2 Data Engineers
Data Analyst
More cases
Similar cases
Recommendations that sell: helped GoodWine increase conversion and sales
The GoodWine brand has long been synonymous with a huge selection of quality alcohol and healthy products.
View more
Skarbnytsia: transforming HR management into a transparent and motivational KPI system
Skarbnytsia company has been providing financial services for over 32 years. The brand has a network of 400+ branches and...
View more
Contact Us
Looking for a reliable technical partner? We are ready to join your project at any stage – from idea to launch.
Information
Fill out the form, and we will contact you to discuss the project.
Address
Senator Business Center, 32/2 Knyaziv Ostrozkykh St. Kyiv, Ukraine, 01010
Phone
+38 (044) 334 42 30
