Bullseye-cx
BCX's Data-Driven Success with Scaleupally
Sector
Clubs & Casinos
Services
Power BI Reports
Team Size
6
Engagement
Starting up & Scaling up
Introduction
BCX, a forward-thinking Australia-based consulting firm, specializes in providing Business Analytics services to numerous Clubs & Casinos. With a dedication to honesty and customer-centric interactions, BCX helps clubs build and scale their businesses by identifying customer patterns, selling trends, and gaming insights.
Business Objective
BCX faced challenges in evaluating data and making informed decisions due to the lack of a comprehensive data visualization tool. Their objectives included:
- Gaining valuable insights into customer patterns, market trends, and gaming insights.
- Consolidating scattered data from multiple sources into a single source for better clarity.
- Creating separate, club-specific reports and KPIs for effective communication.
- Implementing automated daily data updates for proactive decision-making.
Project Scope
The BI project scope included:
- Understanding data and APIs for data extraction.
- Designing and building a centralized database on AWS for data consolidation.
- Developing Power BI reports and dashboards for data visualization.
- Implementing schedulers for daily data refreshing.
- Conducting testing and providing training and manuals.
Data Collection and Integration
Data was collected from various sources, including gaming machines, POS machines, Excel, and others. A centralized database on AWS was established to integrate all the data into a single source.
Key Performance Indicators (KPIs)
- Total Turnover
- Non-Carded Turnover
- Carded Turnover
- Total Gaming Volume (TGV)
- Active Members
- Visits
- New Members Joining
- Active Members in Gaming, Food, and Beverage in the Next 30 Days
- TGV of New Members with Visits Over $100
- Top 10 Suburbs by New Members Joined
BI Tools and Technologies
- Power BI: Data visualization tool for interactive reports and dashboards.
- AWS RDS: Cloud-based server and database for data consolidation.
- Microsoft Excel: Used for manual data updates.
- MS Access: Database management system.
- PHP: Web development language for integration and API creation
Data Analysis and Insights
- The Power BI dashboards provided valuable insights, including:
- Gaming Scorecard Dashboard: Key metrics such as Total Turnover, TGV, Active Members, and visits are displayed with graphical representations.
- New Members Dashboard: Insights into new members’ activities, including gaming, food, and beverage preferences.
Challenges and Solutions:
- Challenges:
- Lack of data visualization tool for insights.
- Scattered data from multiple sources.
- Club-specific reporting requirements.
- Daily data updates.
Solutions:
- Developed a Power BI Dashboard for visualizing key metrics and insights.
- Created a centralized database on AWS for data integration and clarity.
- Implemented club-specific reports using Power BI.
- Utilized schedulers for automated daily data updates.
Conclusion
BCX’s collaboration with Bullseye CX and ScaleupAlly brought about a data-driven transformation in their club and casino analytics services. The Power BI Dashboard enabled BCX to make informed decisions based on valuable insights, boosting their revenue and business outcomes. Consolidating data from multiple sources and implementing schedulers improved data accuracy and efficiency. With data at their fingertips, BCX now unlocks the full potential of clubs and casinos, driving success in the ever-evolving gaming industry.
Regenerate