Case Study

A Casino contacted Idea Entity to help with a time consuming and labor-intensive monthly financial reporting challenge they were facing.  They wanted to identify a quick way to report key revenue indicators to Casino stakeholders, and to use the information to make quick decisions about the games on the floor. Their process for data retrieval, analysis, and reporting took about a month.  Therefore, the financial report was always a month delayed – and this hampered the Casino in making any quick decisions.  This inability to respond quickly directly impacted revenue generation.

The Idea Entity team first engaged Casino Subject Matter Experts (SMEs) in an initial conversation to understand their overall business goals, and understand current business processes and challenges.  Our team then outlined current and future business processes, and prioritized and scoped the work to exactly match the Casino’s immediate business needs.  The solution involved integrating manufacturer data inputs into a Microsoft Access database, and developing a data transformation model to support their revenue reporting by manufacturer. Our team then built a final revenue report by creating a complex set of business steps in SQL to generate all of the required data in an aggregate fashion when given a date range.  This resulting report can be generated in less than 45 minutes (as compared to a month), and has empowered data-driven “live” decision making for the Casino.