Granted Patent B2

US 12,387,159 · App. 17/592,419 · Granted Aug 12, 2025

Inventors: Michael Roy Hartwig (Las Vegas, NV); Ashley Brooke Fiumara (Las Vegas, NV); Thomas Rafferty (Las Vegas, NV)

Assignee: OPTX SOLUTIONS, LLC

G06Q10/0637G07F17/3234G07F17/3239

Abstract

Claims (53)

1. A system comprising:

at least one database associated with a service business;

a dashboard configured to display real-time information associated with assets and games located at a property associated with the service business; and

at least one computing device in communication with the at least one database and the dashboard, the at least one computing device configured to:

extract, from the at least one database, data associated with a set of asset interactions associated with at least one game over a period of time, wherein the data is in disparate formats, and wherein the data is extracted using at least one of Change Data Capture (CDC) or slowly changing dimensions (SCD);

stage the data in disparate formats in a staging database, the staging database separated from the database associated with the service business by a protective firewall;

write integration jobs, the integration jobs configured to convert the data staged in the staging database into a single format;

integrate at least a portion of the data indicative of an asset interaction into a single format and store the data indicative of the assets in the single format in the at least one database using the integration jobs;

receive, from the at least one database, the data indicative of the assets in the single format;

receive, at a first time, via the dashboard, a first indication to turn on at least a user interface element among a plurality of user interface elements, but not a second user interface element among the plurality of user interface elements, wherein the first indication is indicative of a selection of at least one criteria, and wherein the at least one criteria is selected by an operator associated with the service business;

in response to receiving the first indication, generate, based on the asset interaction and the selection, an interactive floor map comprising a location of each game on the property and a visualization of at least one criteria associated with each game;

receive, at a second time occurring after the first time, a second indication to turn on the second user interface element among the plurality of user interface elements;

in response to receiving the second indication and without retrieving additional data from the at least one database, populate the second user interface element with at least a second portion of the data in the single format; and

update the interactive floor map based on a new asset interaction with at least one game.

2. The system of claim 1 , wherein the criteria is at least one of a game utilization, a game profitability metric, a time of play, and a variance associated with the information displayed via the dashboard.

3. The system of claim 1 , wherein the visualization comprises at least one of a heat map and an animation of trends associated with the at least one criteria over a second period of time.

4. The system of claim 1 , wherein the at least one computing device is further configured to update the interactive floor map based on manual input modifying at least one of: a game location, a time period, and a targeted asset.

5. The system of claim 1 , wherein the at least one computing device is further configured to generate a prediction for at least one of occupancy, optimization, and utilization for at least one game, based on a modification to the interactive floor map.

6. The system of claim 1 , wherein the information associated with assets comprise at least one or a market associated with each guest, a state associated with each asset, a tier status associated with each asset, a quantity of days since last contact associated with each asset, a zip code associated with each asset, one or more traits associated with each asset, a last contact date associated with each asset, one or more preferences associated with each asset, a last play date associated with each asset, and a birthday month associated with each asset.

7. The system of claim 1 , wherein the information associated with assets comprise at least one total theoretical profit associated with each asset, total actual profit associated with each asset, total average daily worth (ADW) associated with each asset, total average daily theoretical (ADT) associated with each asset, and total play days associated with each asset.

8. The system of claim 1 , wherein the information associated with games comprise at least one of theoretical profit associated with each game, actual profit associated with each game, average daily worth (ADW) associated with each game, average daily theoretical (ADT) associated with each game, and play days associated with each game.

9. A computer-implemented method comprising:

extracting, from at least one database, data associated with a set of asset interactions associated with at least one game over a period of time, wherein the data is in disparate formats, and wherein the data is extracted using at least one of Change Data Capture (CDC) or slowly changing dimensions (SCD);

staging the data in disparate formats in a staging database, the staging database separated from the database associated with a service business by a protective firewall;

writing integration jobs, the integration jobs configured to convert the data staged in the staging database into a single format;

integrating at least a portion of the data indicative of an asset interaction into a single format and storing the data indicative of the assets in the single format in the at least one database using the integration jobs;

receiving, from the at least one database, the data indicative of the assets in the single format;

receiving, at a first time, via a dashboard, a first indication to turn on at least a user interface element among a plurality of user interface elements, but not a second user interface element among the plurality of user interface elements, wherein the first indication is indicative of a selection of at least one criteria, and wherein the at least one criteria is selected by an operator associated with the service business;

in response to receiving the first indication, generating on the dashboard, based on the asset interaction and the selection, an interactive floor map comprising a location of each game on the property, and a visualization of at least one criteria associated with each game;

receiving, at a second time occurring after the first time, a second indication to turn on the second user interface element among the plurality of user interface elements;

in response to receiving the second indication and without retrieving additional data from the at least one database, populating the second user interface element with at least a second portion of the data in the single format; and

updating the interactive floor map based on a new asset interaction with at least one game.

10. The computer-implemented method of claim 9 , wherein the criteria is at least one of a game utilization, a game profitability metric, a time of play, and a variance associated with the information that is displayed via the dashboard.

11. The computer-implemented method of claim 9 , wherein the visualization comprises at least one of a heat map and an animation of trends associated with the at least one criteria over a period of time.

12. The computer-implemented method of claim 9 , further comprising updating the interactive floor map based on manual input modifying at least one of: a game location, a time period, and a targeted asset.

13. The computer-implemented method of claim 9 , further comprising generating a prediction for at least one of occupancy, optimization, and utilization for at least one game, based on a modification to the interactive floor map.

14. The computer-implemented method of claim 9 , wherein the data indicative of an asset interaction with a game comprises at least one total theoretical profit, total actual profit, total average daily worth (ADW), total average daily theoretical (ADT), and total play days.

15. A non-transitory computer-readable medium storing instructions that, when executed, cause

extracting, from at least one database, data associated with a set of asset interactions associated with at least one game over a period of time, wherein the data is in disparate formats, and wherein the data is extracted using at least one of Change Data Capture (CDC) or slowly changing dimensions (SCD);

staging the data in disparate formats in a staging database, the staging database separated from the database associated with a service business by a protective firewall;

writing integration jobs, the integration jobs configured to convert the data staged in the staging database into a single format;

integrating at least a portion of the data indicative of an asset interaction into a single format and storing the data indicative of the assets in the single format in the at least one database using the integration jobs;

receiving, from the at least one database, the data indicative of the assets in the single format;

receiving, at a first time, via a dashboard, a first indication to turn on at least a user interface element among a plurality of user interface elements, but not a second user interface element among the plurality of user interface elements, wherein the first indication is indicative of a selection of at least one criteria, and wherein the at least one criteria is selected by an operator associated with the service business;

in response to receiving the first indication, generating on the dashboard, based on the asset interaction and the selection, an interactive floor map comprising a location of each game on a property, and a visualization of at least one criteria associated with each game;

receiving, at a second time occurring after the first time, a second indication to turn on the second user interface element among the plurality of user interface elements;

in response to receiving the second indication and without retrieving additional data from the at least one database, populating the second user interface element with at least a second portion of the data in the single format; and

updating the interactive floor map based on a new asset interaction with at least one game.

16. The non-transitory computer-readable medium of claim 15 , wherein the criteria is at least one of a game utilization, a game profitability metric, a time of play, and a variance associated with the information that is displayed via the dashboard.

17. The non-transitory computer-readable medium of claim 15 , wherein the visualization comprises at least one of a heat map and an animation of trends associated with the at least one criteria over a period of time.

18. The non-transitory computer-readable medium of claim 15 , further storing instructions that, when executed cause updating the interactive floor map based on manual input modifying at least one of: a game location, a time period, and a targeted asset.

19. The non-transitory computer-readable medium of claim 15 , further storing instructions that, when executed cause generating a prediction for at least one of occupancy, optimization, and utilization for at least one game, based on a modification to the interactive floor map.

20. The non-transitory computer-readable medium of claim 15 , wherein the data indicative of an asset interaction with a game comprises at least one total theoretical profit, total actual profit, total average daily worth (ADW), total average daily theoretical (ADT), and total play days.

Assignments (1)

Continuity (2)

References Cited (111)