How Skizzle helped an Edutainment Company to Drive Digital Transformation with Power BI

Ideacrate Edutainment is a multi-faceted organization with a vision to create a niche in both Children’s Education & Family Entertainment industry. The company aims at operating paramount schools, nurseries, indoor/outdoor play areas, and amusement centers, which will also be a hub for the entire family in UAE and across the globe. Ideacrate has two flagship brands namely Orangewheels and Orangehub catering to various age groups of children. Orangewheels is a fun-filled, one-stop indoor edutainment venue for kids in Abu Dhabi. Orangehub has the latest, and the most loved and all-time favorite arcade games, a race car simulator by Red Bull, 2-lane ‘Highway’ bowling alleys, and a spy mission-themed Laser Tag Arena, with a food and beverage bar and dining area for the whole family.

Pain points

• Ideacrate struggle to provide their management team with insights into the performance of its individual outlets and the business units.
• Data was not trusted, meaning that any KPIs that were available did not truly drive the behavior. The business knew that accurate, available data was essential to drive their digital transformation program.
• Ideacrate needed a central digitalized management system as a solution to this problem. Such a system would use the large amounts of data being produced by operational systems at each outlet and transform it into meaningful insights with the help of visual reports, graphics, and dashboards.
• The interpretations derived by the BI tool can be used by staff for better functioning and customer engagement.

Solution

We helped Ideacrate to implement an accelerated data warehouse using SQL Server 2016, high-performance tabular models, and visually appealing Power BI dashboards. Ideacrate went with Microsoft Power BI as their business intelligence software and Microsoft Azure for cloud services. Ideacrate deployed Microsoft Azure technology to collect data from back-end operational systems of the outlets. The operational data from the systems are forwarded to business intelligence platforms like Power BI. Power BI transforms the crude information into informative visuals showing different statuses and statistics of the Ideacrate business. Services such as Azure Stream Analytics, Azure Data Lake Analytics, and Azure SQL Database are used to extract, clean, and prepare operational data in real-time.

We developed the following different kinds of reports:

• Revenue Dashboard – Total Revenue, Region wise Revenue, BU wise Revenue
• Revenue Dashboard – Daily Revenue v/s Last week same day Revenue
• Daily, Weekly, Monthly and Hourly Revenue and Average – Region-wise and Outlet wise
• Current v/s Previous (hour, day, week, month)
• Category wise Revenue – Current Year v/s Last Year

Solution Architecture

Outcome:

• The customer now has a ‘single version of the truth’, that was trusted by the whole business.
• KPIs were standardized and were instantly available via Power BI.
• Drastic efficiency savings were made.
• Senior Management and business leaders have information at their fingertips by the virtue of Power BI.