Implementation of BI Solution for Amusement Companies
Project Duration: 2019 to present (In development currently)
Client:
The end client is a national US company focused on designing, developing and operating family oriented amusement facilities. The client has 16 wholly owned locations and 35 partner locations strategically located in over 20 states.
Annual Revenue: US$150 Million
Number of Employees: +500
Challenge:
The end client has scattered data sources, making it extremely difficult to appropriately visualize in a timely manner the issues and important metrics to identify problems and propose solutions.
Scope of Project:
Built Data Warehouse Infrastructure initiative for client using Azure and SQL Server.
Led the communication and ETL methods with client’s existing vendors and assessed future vendors.
Created ETL Infrastructure to bring data from data hubs to Power BI platform to help client have a full vision of their current situation based on metrics, study and company the market conditions of its industry, and optimize internal processes.
Created a strategic HR and IT personnel plan structured to move project from just agency-based to a hybrid agency-managed IT Department, so maintenance and future developments could be managed from in-house staff.
Created a 3-year plan to expand BI Dashboard and Reports from descriptive analytics to predictive and prescriptive analytics. This will include the implementation of Floor Planning Optimization, Trend Analysis, Image/Video Analytics, NetSuites dashboard implementation, RDBMS, Payroll, Turnover by Employee, Forecast Techniques, Machine Learning, and AI.
Solutions used: