BI Solution – Hospitality Industry

Business users generally come from the non-technical background and it becomes increasingly difficult when you have to monitors your applications not only from functional but also from a technical perspective. Our client also faced a similar scenario.

Business Need

The business users wanted to cross-check whether the viewable data in BI report as well as EP planning is up-to-date. To confirm that one has to check the ETL application for Schema data as well as BI Application for Cube data. There was a technical hurdle as the users were not aware of the technologies. One has to have respective tool knowledge in order to get the status run of these tools.

The Solution

A special status run record was created which enabled the Business user to know the last run status, Date and time of the last run for BI cubes, ETL Jobs as well as some user tables.

The Benefits

The business now can check data consistency which out raising the help of the technical team for monitoring the system.

ETL Business Need

SOB-Share of Business, a KPI which the company enters in EP planning Cube directly, As SOB KPI was manual and not from the ERP system or Operational Data source, whenever there was data refresh in the cube. Other fields would change their respective position while SOB would never change respectively.

For Instance:

Supplier I was ranked as Position_1, Product Rate: 10SOB: 50% (Manual Input)

Supplier II at Position_2             Product Rate: 12SOB: 30% (Manual Input )

Supplier III at Position_3            Product Rate: 14SOB :20 % (Manual Input )

Let’s say data changes and now Ranking logic gives different ranking

Supplier II was ranked as Position_1, Product Rate: 8SOB: 50% (Manual Input )

Supplier I at Position_2             Product Rate : 13 SOB :30 % (Manual Input )

Supplier III at Position_3            Product Rate :14 SOB :20 % (Manual Input )

Thus the data for SOB would be irrelevant because it didn’t change with the respective position of its supplier.

The Solution

A Package was created in SSIS where the exported data from Cube is exported to Database and every time entire data would be refreshed including SOB at an appropriate position giving relevant and consistent information to the Business user.

Supplier II was ranked as Position_1, Product Rate: 8SOB :30 % (Manual Input )

Supplier I at Position_2             Product Rate :13 SOB :50 % (Manual Input )

Supplier III at Position_3            Product Rate :14 SOB :20 % (Manual Input )

The Benefits

Now Business can do better analysis even though the production rate of Supplier II is less still it has been given only 30 % of tenders whereas the supplier two which charging more is given the higher number of tenders or business, thus leading to right decision making.