The business intelligence solution is developed for travel agency facilitating the customer for Airlines booking, Hotel Accommodation and Hire a Car service. With this solution, the company can give answers to the queries like ‘which are the most profitable airlines/hotel’, ‘which is the time when most customers are using our product’ etc and based on this, the company gains meaningful insights and real-time data.
The solution developed using the Pentaho community stack which analyzes the data and makes the data-driven decisions for the organizations which increases the work productivity
Analyzes data sources & the existing static reports to derive the key KPIs and KRAs
Consolidate data sources (Oracle 11g) into 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
Display specific dashboards based on access rights
View location wise data based on user rights
Drill down feature to view the detailed analysis
Dashboard Screens :- Sales Analysis, Location Analysis, Hotel Analysis, Saving Analysis, Top Destination Analysis, Financial Analysis
We have worked with some of the best innovative ideas and brands in the world across industries.