Massage Envy, LLC provides therapeutic massage services. The Company offers a range of services for men and women including full-body and partial-body massage therapies and facial skin treatments.
Massage Envy was required to produce data about thousands of their customers. This data needed to be produced by an independent source that had an expert knowledge of the Millennium back-end database structure. Based on Plego’s expertise with Millennium, Massage Envy engaged Plego to produce the data requested.
Plego had to filter through thousands of records and transactional data to provide Massage Envy their required information.
Through the use of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), Plego generated multiple reports for Massage Envy. These reports had a wide range of tables that were required, relationships that had to be created, and multiple databases that had to be merged.
Reports included informational requests such as:
Cancelled memberships that lost rights to prepaid massages.
Aggregate value of massages forfeited due to cancellation.
Aggregate value of massages forfeited due to member account in arrears.
Data regarding members in arrears.
Data regarding members who canceled their membership.
Members in California who were on auto-renew but then terminated or suspended their membership.
Through the user of SQL Server Data tools and Management Studio, Plego was able to analyze the Massage Envy Database through an impartial point of view. The data Plego provided was used by multiple parties for various reasons including arbitration, customer service, and compliance.
Because of Plego, Massage Envy was able to deliver their information efficiently and accurately.
Business Intelligence and Database Reporting
ASP.NET, SQL Server, Millennium SDK