With a combined history of over 100 years in Malaysia going back to 1912, British American Tobacco (BAT) prides itself with leading edge technology and efficient systems and processes employed in all aspects of its business activities. Its comprehensive distribution network spans the length and breadth of Malaysia to enable nation-wide distribution of famous tobacco brands.
As such, BAT was looking for an integrated reporting environment that could provide their organization the flexibility to generate standard & ad hoc reports tailored to their requirements. This would help enhance decision making by ensuring all districts and divisions will be able to access the same data reports designed to common standards and to incorporate the most relevant data.
The company would be in charge of preparing the ETL, Data Warehouse and BO Environment to enable its selected staff and users to prepare ad hoc reports whenever necessary. For the ETL process, .Net framework version 3.0 was required. The project would cover:
Designed and developed by ssd-tech, here’s how the BO reporting process would work:
In order to develop the Reporting Portal, Service Desk Reporting, Slicing & Dicing and Delivery Engine which would be used by BAT staff to generate their reports, ssd-tech’s key deliverables included:
Development of Reporting Portal which consists of the following:-
From delivery of the entire work scope (within 51 days) to post live support, ssd-tech has successfully delivered a BO architecture that substantially meets BAT’s extensive reporting requirements. This essentially gives BAT staff the power to utilize standard reports across districts and divisions and create custom reports containing the actionable insights and data required to make strategic business decisions.