Archives for 9 Aug,2017

You are browsing the site archives by date.

Hospitality Report Catalogue

Qualex delivers hospitality-specific BI, CRM and mobile solutions that define IT strategies drive systems selections and target business process and IT infrastructure review. Qualex’s enterprise solutions include Enterprise Intelligence Platforms that integrate individual technology components into a single, unified system. This results in an information flow that transcends organizational silos, diverse computing platforms and niche tools, while also delivering new insights to drive increased value for any organization. With our iQ-Hospitality Data Model we provide consistent reporting and analytical platform for predictive analytics.

iQ-Guest™ Application

Qualex Guest Application provides the fastest and most responsive form of communication with guests ranging from hotels to restaurants. Enhance your guest loyalty by letting your guests know you care. QPA features automated targeted SMS for guest campaigns; constantly keeping them updated on activities and events of interest increases loyalty.

iQ-Guest™ insures they are informed on the latest campaigns, events and special discounts. It also lets guests know you remember them personally by sending them personal alerts such as birthday specials or anniversary offers. By offering not only bulk SMS and individual SMS sending options, QPA also schedules: automated SMS, promotional SMS, email forwarding and database integration. QPA sets the trend for a guest SMS applications.

Some of our clients include:

Hospitality Report Catalogue

Qualex projects with Seminole HardRock Hotel, Galaxy Entertainment, Grupo Punta Cana:

  • Implementing our iQ-Hospitality data model
  • Trips Report
  • Hotel Stays Report
  • Comp Report
  • Revenue Report by Geography/ Demographics
  • Inactive Guest / Past Due Report
  • Guest Due Now Report
  • Potential New Business Report
  • Incliners/Decliners Report

Qualex Solutions Include: iQ-Support™

 Qualex iQ-Support™ is an internet-driven solution for organizations that, after implementing software solutions, need additional support to maintain their system’s operation. Qualex offers bundles of consulting hours from its specialized consultants in Data Integration, Data Warehousing Construction, Business Intelligence Reporting and Sophisticated Analysis. All these services are provided at a low cost, with high quality and maximum accessibility.

Ticketing & Point of Sales Operations

Reporting & analysis that benefits Ticketing and POS Operations:

  • Arena POS per Game Report
  • F&B Sales by Store and Terminal
  • Point of Sales Map Analysis by Product
  • Ticketing Analysis Report
  • Ticketing Customer Analysis
  • Comparative Time Series by Net Revenue
  • Ticket by State Analysis
  • Owed-Price-Paid Amount Analysis

Hotel and Hospitality

Reporting & analysis that benefits Hotel and Hospitality:

  • Dashboard(s)
  • Segment Value Report
  • Total Property Value Report
  • Bookings by Source Group
  • Turn Down Tracking (web usage)
  • Daily Report Package
  • Daily Pickup Reports (by segment)
  • Weekly Revenue Report Package
  • In House Report
  • Pace Report
  • Cash vs. Comp (by month and room type)
  • Segmentation Analysis Reports
  • Market Segment Pickup Report

Marketing
Reporting and analysis that would benefit Marketing:

  • Dashboard(s)
  • Additional Campaign Response reporting
  • Marketing Response Result Reports
  • Model Results for better future performance

Accounting
Reporting and analysis that would benefit Accounting:

  • Daily Revenue Reports (showing Cash vs. Comp data)
  • Comp Revenue Report
  • Comparison of Events/Initiatives
  • Comp Report per Person per Day
  • Marketing Automation
  • Customer Retention

Qualex Solutions Include: iQ-Support™ 

Qualex iQ-Support™ is an internet-driven solution for organizations that, after implementing software solutions, need additional support to maintain their system’s operation. Qualex offers bundles of consulting hours from its specialized consultants in Data Integration, Data Warehousing Construction, Business Intelligence Reporting and Sophisticated Analysis. All these services are provided at a low cost, with high quality and maximum accessibility.

Hotel Operations
Reporting & analysis that benefits Hotel Operations:

  • POS Accounting Report
  • Hotel Data Reports
  • Hospitality Control Board Report
  • Inactive Report
  • Meters Report

Hotel Marketing
Reporting & analysis that benefits Hotel Marketing:

  • Campaign Promotion/Offer Report
  • Promotions Report
  • Monthly Hotel Analysis Report
  • Room Report
  • Guest Card Use vs. Actual Transaction Report
  • Daily Hotel Revenue Report

Guest Development
Reporting & analysis that benefits Guest Development:

  • Dashboard(s)
  • Guest Profit/Loss Report
  • Guest Revenue Maximization Tracking Report
  • POS Utilization Report
  • Top Guest Revenue Report
  • Top 5 Names/Winners/Losers Report

Service Commitment

Once an issue concerning the use of software is reported, Qualex agrees to assign a resource to verify the issue. In critical issues (High), this resource will be assigned within specific pre-determined business hours and for regular issues (Low and Medium), the resource will be assigned within one business day.

Read More

Grupo Punta Cana CaseStudy 2014

Grupo Punta Cana – Puntacana Resort & Club Company Overview: 

Puntacana Resort & Club is located in the Dominican Republic within the waters of the Caribbean Sea. Its 26 square mile resort offers countless recreation, relaxation and dining opportunities and now includes Tortuga Bay (54 rooms), The Westin Puntacana Resort & Club (200 rooms), Four Points by Sheraton Puntacana Village (125 rooms), Six Senses Spa, the Puntacana Ecological Foundation and diverse residential communities (Corales, Playa Serena, Hacienda, Hacienda del Mar, Arrecife, Tortuga Bay and The Marina), a full service marina, 8 restaurants, a shopping village (03 shops), a P.B. Dye designed golf course and 2 championship golf courses.

Grupo Punta Cana – Puntacana Resort & Club Objectives:

Puntacana Resort & Club struggled with accessing the data collected from their transaction-based, operational systems to build and develop Ad-Hoc reporting. The data was there, it was just difficult to get to it.

Qualex Solution: 

Leveraging our knowledge of hospitality operational systems, data warehousing, database marketing & analytics, Qualex implemented a solution that provided Puntacana Resort & Club’s database operational, marketing and tactical team with quick & easy access to their data. Prior to Qualex, building reports, dashboards and the analysis was a manual process and often took several days or weeks.

Overall Results:  

After this implementation, these tasks were demonstrated to be reduced to minutes. Time that is being traditionally used by the Casino staff to manually build and analyze reports and dashboards can be now used to evaluate & modify existing marketing strategies; thus, giving the property the ability to allow their data to drive strategic marketing solutions to increase traffic to the property.

Quote: 

“We didn’t know how to make the most out of all the tools we had on hands and Qualex helped us to discover that and get consolidated and useful reports with information that allows us to identify significant data, such as loyal customers. Thus, we can now create more direct and effective marketing campaigns. The iQ-Gaming Solution implementation also made us aware of inconsistent data in our Warehouse.” Ruben Tineo – SAP Competence Center Manager

Read More

Catalog of Predictive Models

Guest Segmentation Model: This model segments the population of guests using cluster analysis and decision trees. Segmentation is one of the first and most basic machine learning methods. Segmenting the population of guests into distinct segments is important because creating separate model for separate segments may be time consuming and not worth the effort. But, creating separate model for separate segments usually provides higher predictive power.

Overall Property Preference Model: This model uses logistic regression to identify whether a customer is attracted by Restaurants, Bars or Shops (or combination).

Customer Day Preference Model: This model looks at guest behavior by day and identifies the day preference for attending. This model can be extended to time of day preference. This model helps hotel managers with staffing and layout requirements when mixed with other analysis.

F&B Location Preference Model:  This model looks at carded spend across food venues to identify guest’s preference for eating. This model is useful for menu changes, and for the creation of marketing offers around F&B. For instance, it could show the steakhouse could benefit from opening earlier in the week lining up with when the big spenders are hoping to attend.

Hotel RFM Model: This model forecasts VIP guests using revenue for F&B and Entertainment as well as frequency of visits and days since last visit.

Read More

Qualex Healthcare Practice II

Project Overview:

Qualex Consulting Services, Inc. (QLX) currently provides BI solutions for one of the largest healthcare insurers in the US. QLX provides consulting and implementation expertise to develop ETL processes and BI reporting using OLAP and web technology to provide access to large amounts of data stored in the customer’s “Enterprise Data Warehouse.”

Our task was to work with the actuarial team to provide tools for analyzing up to 7 years of claim and enrollment data in a way that would allow for quick and easy analysis as well as a method for providing standard monthly reports. One of the challenges with claims and enrollment data analysis besides the massive amounts of data to be analyzed, is the non-additive nature of the data. Providing summarization of large data in a “cube” environment can become complicated when drilling into claim and enrollment data. Analysis fields like Utilization and Per Member/Per Month can present significant challenges when attempting to incorporate them into a multi-dimensional structure like OLAP Cube. For example, a common actuarial metric is the calculation of Per Member/Per Month cost, or PM/PM. The numerator in this ratio is total claims cost in dollars. The denominator is total members enrolled, including members who have no claim costs and are not represented in the numerator. This metric is a challenge in standard OLAP reporting tools because the numerator and denominator represent different populations at different levels of summation. If a user wants to look at the data across various levels of claims dimensions, such as CLAIM TYPE, the numerator will change depending on whether the user is looking at Inpatient, Outpatient, Professional or Drug claims. However, the denominator, the total population of members remains constant across these levels.

Qualex Solution:

There are several tools by the client to develop and surface OLAP cubes. To develop cubes, we used the latest technology available in the market. These tools assist the developer in defining the structure of the cube and handling big amounts of data in an effective way.

The developer defines dimensions and hierarchies, or drill paths, based on the anticipated approach an analyst might take to addressing business problems. The analysis variables or measures are also defined. To surface cubes to users there are several tools available. Each of these allows the user to analyze the data by examining slices, of the cube quickly and easily. However, Qualex can provide more than just tools. With our extensive experience using a variety of BI and ETL tools, we can not only develop a tool for analysis or reporting, but can help you better understand your data. Qualex can assist with designing data structures from the complex maze of data sources inside the typical insurers’ structure. We can work with your team to not only design a valuable reporting environment, but also provide training and expertise in a wide variety of areas.

Results:

  • Non-additive fields like Utilization and PMPM are key metrics in the health care industry to help spot trend in health care costs.
  • While actuaries have a wealth of OLAP tools available to them now to analyze the data in their organization, this important statistic is not available out of the box.
  • However, there are customizations that developers can perform to bring PMPM into the analysts’ arsenal of tools.
  • Qualex has proven experience in this area and understands the complex nature of these tasks.

Qualex Contact:
info@qlx.com
1.877.887.4727

Read More

Energy-case-study-by-qualex-consulting-services

Client Overview:

One of the largest U.S. based independent natural gas and oil producer this energy company is a pioneer and innovator in its own industry. The company’s operations are focused on North American onshore exploration and production, engaged primarily in horizontal drilling and hydraulic fracturing to produce crude oil, natural gas and natural gas liquids.

Challenges and Objectives:

One of the main challenges that this company faces is quantifying the influence that proppant has on well production. The goal was to optimize cost savings without reduction in production. The analysis showed that reducing proppant in well excavation provided the highest level of cost performance. Detailed analysis focused upon the influence of proppant types and volume in relation to production variations.

Qualex Solution:

Qualex was able to analyze over 9,000 well data sets to identify the variables with the greatest influence on well production. Qualex provided a detailed predictive analysis on the differences between best/worst performing wells, including segmenting groups/intervals within variables to explain the excessive proppant usage over a 12 month period. The resulting analytics predicted a best case scenario report which included comparison between best and worst production rates on specific targets against proppant types and volume that equated to cost saving of over $14 million on only 200 wells. Qualex also provided a report that predicted the variables that had the greatest influence on well production. Futures studies are to include environmental impact analysis.

Outcome and Results:

This Energy company gained a 30% savings on two particular regions and a county demographic analysis that provided a report on specific optimizations for well production.

Company Overview:

Qualex Consulting Services, Inc. is a technology and professional consulting company founded in 1995 has been dedicated to providing a wide range of Predictive Analytics Consulting, Information Technology and Communications related products and services.

For additional Information contact: Kevin Dillon, Director of Oil, Gas and Utility Practice.

Read More