About the Customer
Industry: Travel Agency
The client is a Dubai based travel agency facilitating the customer for Airlines booking, Hotel Accommodation and Hire a Car service. The travel agency had already implemented a customized ERP to serve customer requests. SPEC INDIA assisted in implementing Business Intelligence platform to analyze the data and take data driven decisions based on it.
Key Challenges
There were many static reports, already integrated with the existing ERP of client, but it was a cumbersome task for business users to view specific data by using those static reports. So, the key challenge was to review and analyze these static reports and create a visualization which will provide most of the information to users in a few clicks.
- Extract data from their existing system
- Customizing the pentaho based on business user needs
Our Solution
SPEC INDIA developed a solution using Pentaho community stack, since a quick customizing solution was the key requirement for the client.
- Analyze data sources/existing static reports and derive the key KPIs and KRAs jointly with client and SPEC INDIA team to meet the business analytics.
- Consolidate data sources (oracle 11g) in to MySQL database with Star Schema approach.
- Deploy various complex ETL jobs and transformation to integrate the historical data and live data to generate near real time analytics.
- Customize Pentaho open source platform.
- Provide features to show only specific dashboard (out of a list of dashboards) based on access rights.
- Provide the feature to view location wise data based on user rights.
- Provide the drill down feature to view detailed analysis.
- Sales Analysis
- Sales analysis to visualize the total sales category wise (airline, hotel, car).
- Visualize the sales by executive/customer/supplier/location.
- Month wise comparison of sales v/s profit for any number of years for executive/customer/supplier/airline/hotel/car/location.
- Comparison of sales for any airlines/hotel/supplier/etc by month of current year.
- Separate analysis of sales for airlines/hotel/car category.
- Location Analysis
- Visualize the location/customer category/product/supplier/executive wise sales/invoice/total booking.
- Month wise comparison of years for profit v/s ticket booking for specific location/executive/customer/supplier/airline/hotel/car/etc.
- Comparison of metrics for any airlines/hotel/supplier/etc by month of year.
- Drill down functionality to provide detailed view for each location.
- Hotel Analysis
- Visualize the Region wise/ hotel wise/ hotel chain wise spending as well as booking.
- Visualize Top 10 Supplier wise spending v/s no. of nights.
- Visualize by spending/no. of nights for Hotel Star (1/2/3/4/5 star).
- Month wise comparison for specific years.
- Drill down functionality to provide detailed view for each Region/Hotel/Supplier.
- Saving Analysis
- Visualize the Region/customer/airline/class wise Gain Savings and Missed Savings.
- Comparison for two or more years to analyze the Gain/Missed savings.
- Destination city wise Gain/Missed Savings.
- Drill down functionality to provide detailed analysis.
- Top Destination Analysis
- Visualize to view data based on selected Metric from Spending or Ticket Booking
- Analysis by Airline/Destination City/Source-Destination City/Airline class base on selected metric.
- Drill down functionality to provide analysis in detail.
- Month wise comparison for any selected year for any KPI (airline/destination city/etc).
- Export to Excel.
- Financial Analysis
- Visualize Invoice/Receipt/Outstanding amount.
- Customer Category/Customer/Location wise profit contribution.
- Customer wise outstanding/credit/debit amount.
- Drill down functionality to view detail level.
- Export to Excel.
Tools and Technologies
Business Benefits
SPEC INDIA’s successful implementation of BI Analytics Solution helped company to give answers to queries like ‘which are the most profitable airlines/hotel etc.’, ‘which is the time when most customers are using our product’. Such queries are easily answered by the solution. And by using this they can make new innovative decisions to gain more profit. It benefitted them in the following ways too:
- Centralized aggregation of data as well as centralized report in form of dashboard.
- Previously they had to open many reports to get some information. Now, they can get same information in just few clicks.
- Business team can easily target some promotional offer by analyzing the historical data.
- Get meaningful insights from historical and real time data.
- Identify performing and non-performing airline/hotel/executive/etc.
- Saiku Analytics and Self-service Dashboard Plug-in helped end users to generate the adhoc analytics and generate dashboards themselves.