ZMS wanted to advance their ability to monitor and report on their monitoring systems by using an agile data warehouse tool.

When you think about gambling, the images evoked are those of Las Vegas casinos, bright lights, smoky bars and the sounds of the bells and chimes of the machines being played - the big dream of gamblers who go there to win big.

This world is a far cry from the data world in which we work, but surprisingly enough, we discovered through our customer Zonke Monitoring Systems (ZMS) that the gambling industry is abundant with rich data waiting to be mined, transformed, visualised and analysed.

ZMS developed and operated central electronic monitoring systems (CEMS) for the gambling industry that allows casinos to monitor Limited Pay-out machines.

So while you are happily playing on a slot machine, their monitoring system is collecting data about how the machine is being played, how much money it has collected and how much it has paid out.

ZMS wanted to advance their ability to monitor and report on their monitoring systems by using an agile data warehouse tool – TimeXtender.

Data is meaningless without structure

Each monitoring device reports back on license information, client information and the machines’ revenue. In order to comply with the National Gambling Board in South Africa, ZMS needed to be able to correctly analyse and report on this data to gain a clear understanding of their exact revenue and pay-outs. More importantly, this was needed to ensure compliance with the Board’s regulations.

An agile data warehouse was the solution, providing ZMS with a central point for their data to be stored.

TimeXtender software was quick to install and is easy to use, enabling ZMS’s IT team to maintain it themselves.

They had already invested in Qlikview, so we wanted to provide ZMS with a stable BI environment that still allowed them to leverage off of their investment in Qlikview.

Step 1: Data was consolidated into an agile and flexible data warehouse.

By implementing timeXtender as the agile data warehouse tool​, we were able to consolidate historical system or legacy system data into this data warehouse.

In addition, we ensured that all new data produced would be funneled into this data warehouse, to ensure ZMS has the ability to access and report off of all of their data.

Step 2: We ensured that ZMS was still able to leverage off their Qlikview investment.

With TimeXtender’s Qlikview modeller and script generator, we were able to ensure that the ZMS team could still use Qlikview in conjunction with our additional analysis and reporting on their data.

Step 3: We made sure that the tool was implemented quickly in order to enable the ZMS team to report and analyse their data as soon as possible.

Zonke monitoring systems had a time constraint to get the stable BI reporting environment up and running within 6 weeks.

We implemented the solution within 4 weeks - saving ZMS time and money on a lengthy implementation.

Step 4: timeXtender allows ZMs to conduct future maintenance of the systems.

The unique design environment in TimeXtender provides drag and drop functionality that has allowed ZMS to adopt the maintenance and future development of their own data warehouse.

The user-friendly nature of the tool allows users to generate their own reports on their data.

Step 5: ZMS is now able to interpret their data.

The data is now stored in a central point, consolidating all past, present future data on an ongoing basis.

The analysis on their machine revenue data can now tell them exactly how much revenue is generated per venue, per region and per month.

This will also provide a picture of the overall income generated across all of the monitored machines across South Africa.

It’s probably not a focus ZMS’s immediate reporting project, but they would now be able to tell which day of the week is more popular with gamblers.

They could also monitor seasonal trends, , and by cross referencing this with past data in the same period, they would be able to understand gambling trends.

The data also provides license and customer information.

It indicates the amount of revenue generated by each customer’s site which is crucial for paying the relevant fees to the National Gambling Board.

Machine data also picks up whether any machines have been tampered with. In addition, trends in certain areas or venues can now be detected and corrective actions can be taken.

No matter what industry you are in, if you don’t use your data to help your business advance, you will be left behind.

ZMS were able to enhance their ability to operate in this highly-regulated industry by consolidating their data and using it to drive their business decisions.