BAT ITAM DWH & BO Reporting

THE CHALLENGE

British American Tobacco (also known informally as BAT) is a British multinational tobacco company head quartered in London, United Kingdom. It is the world’s second largest company by sales, with a market-leading position in over 50 countries and operations in around 180 countries.

 

To stay leading-edge in terms of its technology applications and operational efficiency, BAT was looking for a solution that could centralize and monitor its overall IT assets globally. Although BAT already had a local monitoring system in place, bringing all their information into a central server would help the entire organization get an overall picture of its IT assets.

 

This central server would allow IT managers to decide upon the technology or equipment required for each organization. They would know what key applications to employ and upgrade for the common good of BAT’s worldwide staff.

THE SOLUTION

SSD-TECH took charge of preparing the ETL, Data Warehouse and BO Environment which would enable BAT’s selected staff and users to prepare ad hoc reports whenever necessary.For the ETL process, .Net framework version 2.0 was required. The project would cover:

  • AeA Dash Board
  • Global Management Dashboard
  • Regional Management Dashboard
  • Key Application Installed Report
  • Laptop, Server, Desktop Details Report
  • IT Equipment Report (Network Hardware, Voice Circuit, Wan Circuit)
  • IT Equipment Report (Monitors, Mobile Devices, Projectors)
  • Domain & Lotus Notes Users Report

Designed and developed by ssd-tech, here’s how the BO reporting process would work:

  • The Data Source would be provided by BAT. ETL Process would upload the data onto the Data Warehouse.
  • The BO Universe would be based on the Data Warehouse.
  • From the Universe’s predefined formatted reports, datasheets and dashboards would be provided. Users could also create their own customized reports from the Universe.

KEY TECHNOLOGIES & DELIVERABLE S

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 deliverable s included:

 

Development of Reporting Portal consisting of the following :-

  • Standard & Ad Hoc Reports
  • Fixed Standard Report
  • Customized Reports that can be created on the fly from the portal itself
  • Data Layer: This layer is segregated from the database, and is used by advanced users to design their own reports.
  • Master Data Management: The Master Data can be updated via the portal and must go through an approval process before being activated.

Development of Delivery Engine

  • Users would be able to schedule reports based on their specific time zones. Generated reports will be delivered according as scheduled.
  • Users would be able to schedule the same report using their own report parameters.
  • Users would be able to schedule the report as an email attachment

THE OUTCOME

With a central server and reporting system in place, BAT was able to have an eagle eye view over the various IT applications and assets employed throughout its worldwide operations. With ‘big picture’ knowledge, the organization’s IT managers could select the right technologies to employ, upgrade on outdated systems, and help improve the organization’s operational efficiency – helping BAT maintain its longstanding position as the world’s leading edge tobacco company.

[feather_share size="24" show="twitter, google_plus, facebook, linkedin, mail " hide="reddit, pinterest, tumblr"]

We love to hear from you