Customer Success: Magic Bus

Power BI KPIs, Reports and Dashboards

Magic Bus worked with CloudFronts to deploy robust analytics on the Power BI platform for driving decision making across the organization.

Download the Case Study

Magic Bus Foundation: A Leading Non-Profit Organization

About Magic Bus:

Magic Bus, founded in 1999, is a non-profit organisation working with 400,000 children and 9000 volunteer mentors every week from marginalised communities in India. Their sports and activity-based approaches promote mentoring to the children on a journey from childhood to Livelihood. Their vision is to empower the children and youth socially and economically. You can read more about Magic Bus at www.magicbus.org.


Nitin Aurora, Director of Technology, Magic Bus
Raghunandan Hegde, Senior Project Manager, Magic Bus

Business Requirement:

Magic Bus Foundation approached CloudFronts with the following requirements –

  1. Reports from Magic Bus OASYS (SQL Server) and Sixer Class (Email Attachments) Data.
  2. Help them receive mobile SSRS Reports.

Solution Delivered:

Having understood and analysed Magic Bus working model, the CloudFronts team first considered the Magic Bus operational processes to get an understanding of the key data points for developing KPIs and dashboards. After sufficient brainstorming, our team then came up with a solution to develop a dashboard on top of Power BI and provide SSRS report. The CloudFronts team developed the reports from Magic Bus OASYS (SQL Server) and Sixer Class (Email Attachments) Data. This data visualization along with deep analytics will provide a critical understanding of their everyday operations across all their hierarchies.

“We had a positive experience with CloudFronts. The team was engaged, committed and worked hard to deliver a quality product, on-time. The team has delivered the solution along expected lines. It was easy to coordinate with the delivery team and since both the developers were working out of our office, it made the interaction and coordination easier.”

— Raghunandan Hegde, Senior Project Manager, Magic Bus

Key Features:

Key Features:

  • Real-time access to Key Performance Indicators across their operations.
  • Deep insights into operations across all hierarchies.
  • Ability to develop Predictive Analytics for improving productivity of Volunteers.

Key Technologies:

Key Technologies:

  • Power BI
  • SSRS Mobile Reporting
  • Custom Visuals

Post Go Live:

Post Go Live:

Magic Bus went live with the phase 1 of their dashboards on 03 July, 2018 and their second phase was completed on 2 August, 2018. Post Go-Live, the Magic Bus team is enabling every stakeholder to get a view of the operational team’s performance in an easy, transparent and near-real time manner. Additionally, it is also helping them in delivering better Social ROI to their investors.

Why CloudFronts? CloudFronts is a Dynamics 365, Power BI and Azure focused Microsoft Certified Gold Partner. We help companies around the globe deploy their business processes on the Microsoft Dynamics 365 platform.

Connect with us!
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.