QlikView Microfinance Institution

This websit is under construction

QlikView Hospitality Analysis

Click to edit table header
Introduction
There has been a worldwide competition to show off awesome QlikView Mobile App skills to QlikView Global Partner Network and all of QlikTech.

The contest runs from January 10th 2012 through March 15th 2012. Five winners will be selected from all entries to show the killer apps at Qonnections 2012, April 22-25, 2012.

And at that time I am so proud of my QlikView mobile killer app, “2012 QlikView Hospitality” made it through a rigorous review by the QlikTech panel of judges who selected the Top 20 apps for the competition. Apps were judged on many criteria and the top 20 selections were most heavily based on the apps being:
     - Innovative
     - Exciting & Eye Catching
     - Simple & Intuitive
     - Professional
     - Strong Mobile Design Quality
     - Clear Mobile Use Case and Value Proposition

My QlikView application has been selected by popular vote as one of the Top 5 eligible to compete for the grand prize, live and on stage at Qonnections 2012 in Miami.  This is a resounding “thumbs up” for my contest entry, my QlikView skills, and my creativity that comes exclusively from my peers in the QlikView partner ecosystem.
Click to edit table header
Customer Pain Point
The organization that do have Standard ERP, Customized ERP, CRM, Legacy System or combination of any of these have some frequent reports built in the system as well as they have a team which can modify the GUI of existing report or can create an entirely new report as on demand of management and end-users.

It is easy to say that we do have a team and we can create our new report by using some GUI editor software (Most of them are using Crystal Reports). But when those report which are Ad-hock in nature are very frequent or demand for those reports are high then normal practice is to bring data in excel. When use of excel is there then it increase pressure on IT-Team and most worsen situation comes when functional user starts making report in excel. It has two consequences first is that it is totally wastage of highly paid skill sets in development of reports second the truth may be altered while presenting these report to management team.

Thus in Hospitality Business, we found some of pain point as below:
1. IT Team
     a. It very difficult to integrate all of those ERP systems for one report.
     b. Data from other sources cannot be combined with existing ERP data for combined reports (Excel, Sybase, and SQL Server).
     c. Not easy to combine reports with graphs and charts – difficult to visualize information (by using Crystal Report tool).
     d. Cannot work with report in offline mode. When network down then get stuck with generate reports.
     e. Don’t have full control up to data source level, cannot easily add or delete a dimension.
2. Management Level
     a. Standard reports not sufficient for analysis and decision making.
     b. Sometime take too long to view one analysis report (up to 25 minute).
     c. Take too long time to get one request report from Mr. IT (up to 3 weeks for analysis reports).
     d. It is not stable to control business and reports during oversea trip (connect to the office through VPN not stable).
     e. Difficult make marketing strategy – where we should start for brand marketing (advertisement). By using QlikView they can know which point
         where can start.
     f. The existing reports (Crystal Report) have no compatible with new technology such as iPad, iPhone, Tablet…They cannot see it with their
         smart devices.
     g. Hard to define key account / travel agents for incentive.
     h. Didn’t get any idea for reservation / forecasting base on existing key in data.
     i. Planning, Marketing and Actual reports are not in one screen for analysis and decision making.
Click to edit table header
Application Overview
This application will solve all business issue as mention in “Customer Pain Point” and lets the users especially management level to analyze their business base on hospitality data with the right information, at the right time, in the right place and enabling them to make better business decisions.

The purpose of the application is to improve room production, utilization and reduce cost. This will be achieved by enabling the users to analyze this and other important measures and KPI’s across many different dimensions.

The application is developed towards three (3) different user categories.
     1. High Level Executives (High level with drill down capabilities)
     2. Front Office Manager.
     3. Reservation Manager.
Click to edit table header
Dashboard
Dashboard sheet can be used to analyze business performance across several different dimensions and comparing this year to date, quarter to date and month to date versus last year.

Users can ask questions like:
     1. What is the overall sale revenue YTD vs. LY YTD?
     2. What is the overall sale revenue YTD vs. Quota?
     3. What is the overall sale revenue for Current Select Year vs. Last Year?
     4. What is the overall PAX Current Select Year vs. Last Year?
     5. What is the overall PAX YTD vs. LY YTD?
     6. What is the sale revenue by month for specific select year?
Click to edit table header
KPIs - Sales
KPIs sheet provides users with trend information for Sales Revenue and PAX by clicking on each button <Sales KPI> and <# of PAX KPI>. This information can also be analyzed by a number of dimensions such as Room, Source, Travel Agent and Nationality.

Sales KPI - Users can ask questions like
     1. What is the Sales Revenue trend for the YTD vs. Last YTD for Room type DLXR?
     2. What is the Sales Revenue variance for the YTD vs. Last YTD for Source A?
Click to edit table header
KPI - # of PAX
Users can ask questions like
     1. What is the number of PAX trend for the YTD vs. Last YTD for Travel Agent A?
     2. What is the number of PAX variance for the YTD vs. Last YTD for Nationality A?
Click to edit table header
Sales Performance
Sales sheet provides users with information Top Five Sales Revenue and number of PAX indicated in dollar and number and percentage using cyclic group by Room, Source, Travel Agent and Nationality. These measures can be analyzed on Sale Revenue vs. Quota drill down by Year --> Quarter --> Month.

Users can ask questions like:
     1. What are the top five revenues from nationalities A?
     2. What is the percentage for each top five nationalities A?
     3. How many percentages/dollar for Sales vs. Quota for specific period?
Click to edit table header
PAX Analysis
Users can ask questions like:
     1. What are the top five PAX from nationalities A?
     2. What is the percentage for each top five nationalities A?
     3. What is the total PAX for specific period?
Click to edit table header
Reservation
Reservation sheet contains information about the hotel reserve for the incoming PAX. All this information will enable users to see what happened in next 1, 3, 6 and 13 weeks. These measures can be help users to speed up their marketing activities and other operation to reach the quota in monthly basis.

Users can ask questions like:
     1. What is the performance for Reservation vs. Quota for next 1, 3, 6 and 13 weeks?
     2. What is the overall Forecast vs. Quota?
     3. What is the overall Reservation vs. Forecast?
     4. How many incoming PAX?