Business Situation

Massage Addict is the largest and fastest growing provider of registered massage therapy in Canada. With over 65 clinics and some 650 Registered Massage Therapists, Massage Addict helps over 40,000 Canadians each month manage pain, stress, anxiety, injury, muscle tension and much more.
 
Massage Addict needed a solution to analyze the information within their internal sales application including sales, appointments, schedules, and other pertinent data. Specifically, the Massage Addict team designed a set of metrics to categorize customers into marketing segments based upon the data that was stored within in this application. 
 
While their existing sales application provided some reporting capabilities, they could not calculate these new metrics directly within the application and desired the ability to analyze the data using tools like Microsoft Excel and Microsoft Power BI. 

Technologies Used

Azure BLOB Storage
Azure Runbooks
Azure SQL
Azure Virtual Machine
Power BI
PowerShell
SSIS
  • Cloud Solutions
  • Microsoft
  • Azure
  • Power BI