Uncategorized

Retail Analytics Model Catalogue

Business Challenges: 

Small and mid-sized enterprises (SMEs) have a greater need for predictive capabilities, and less margin for error. The ability to project what will happen—and make decisions that change those trends for improved revenues and margins—is key. Qualex uses predictive analytics to:

  • Make real-time offers
  • Drive product recommendations
  • Improve sales forecasts
  • Increase profitability
  • Optimize marketing campaigns
     

Qualex leverages the power of predictive analytics accessible to SMEs in real-time. We provide customers with powerful and actionable insights, combining the latest technologies and third-party data to support scenarios such as better sales forecasting, improved anticipation of demand and better predictability across the business.

Qualex offers a complete predictive analytics solution and a modern analytics development platform, packaged specifically for SMEs.

Benefits: 

Qualex fuels digital transformation across the business with predictive analytics:

  • Customer Churn. For small businesses, losing customers and the resultant revenue can be very expensive, particularly when it comes to replacing the customer. Predictive analytics can help identify characteristics related to customer churn and use that information to address issues like dissatisfaction or product quality and make the changes required to protect that revenue and keep customers happy.
  • Product Propensity. Companies can leverage data outside their organization (for example, online behavior metrics like social media and product sentiment) and combine it with operational data and customer purchasing patterns to gain significant competitive advantage. This approach can help companies predict which products customers are likely to buy and devise new ways to maximize those channels.
  • Logistics & Operations. Leveraging historical data and training predictive models to identify risk (particularly with IoT data) can help companies move from monitoring operations to predicting future events before they impact them and help them to improve logistics.
  • Finance. The ability to forecast at a fine-grained level to gain a clearer view of orders, revenue, and inventory demand can introduce more accurate predictions that can improve the bottom line.
Read More

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

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

Qualex Sports & Entertainment

Qualex delivers sports-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-Sports Data Model we provide consistent reporting and analytical platform for predictive analytics.

iQ-Fan™ Application

Qualex Fan Application provides the fastest and most responsive form of communication with fans ranging from venues to their own homes. Enhance your fan loyalty by letting your them know you care. QPA features automated targeted SMS for fan campaigns; constantly keeping them updated on activities and events of interest increases loyalty.

iQ-Fan™ insures they are informed on the latest campaigns, events and special discounts. It also lets fans 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 fan SMS applications.

Some of our clients include:

Qualex Gaming & Hospitality

Qualex projects with Major League Soccer, Golden State Warriors, New York Mets:

  • Implementing our iQ-Sports data model
  • Fan Analytics – 360⁰ degree view of the fan
  • Upsell
  • Cross sell
  • 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.

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

Sports Marketing 

Reporting & analysis that benefits Sports Marketing:

  • Campaign Promotion/Offer Report
  • Daily Revenue Report
  • Email Ticket Conversion Report

Fan Development

Reporting & analysis that benefits Fan Development:

  • Dashboard(s)
  • Fan Profit/Loss Report
  • Fan Revenue Maximization Tracking Report
  • Customer Acquisition Source Report
Read More

iQ-SPORTS™ Analytic Model Catalog

1. Pattern Discovery

  • Fan segmentation models including preferences (price, seating, opposition, number of games) and overall value (similar to an RFM).
  •  Association analysis including:
  1. Market basket analysis: this model identifies what games go together for fans with a view to tailoring season ticket packages to the right offering of matches.
  2. Sequence analysis: This model can help enhance the knowledge of customer behavior by knowing what their likely next move is. For instance, the team using a time identifier can track how fans have gone through the system i.e. fans who start as 3 game holder move to 15 games then Class A season before going Platinum.
  • Novelty detection: This model is produced using historical fan behavior.  It makes it easy to identify particular behavior that indicates what has happened is out of the ordinary. For instance, it can help identify when a fan has statistically exceeded their time between attending matches.

2. Forecasting Models

  • These models forecast anything and everything that might be of use to the team. Subjects like crowd number; food sales etc….these forecasting models can be further enhanced by introducing exogenous variables/series e.g. weather, opposition win pct, team win pct, and so on.
  • If the data is available, these models could be enhanced by including: game spend on F&B, merchandise, as well as other purchases through the online merch store and physical merch store(s).

3. Prediction Models

  • Fan churn model for likelihood of ticket holders not renewing
  • Fan propensity model to predict response to marketing campaign
  • Predicting season value of a fan spend within the venue as a dollar figure
Read More