Click to call.

TALK TO US
ABOUT YOUR PROJECT

The Solution Experts

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.

Client Industry

Physical Therapy

Business Challenges

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.

Solution

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.

Services Provided

Business Intelligence and Database Reporting

Technologies Used

ASP.NET, SQL Server, Millennium SDK

We build effective professional websites for corporations and businesses that meet the challenges of the changing online landscape.

We have engineered a variety of products and services that have enriched the businesses of our clients. See some samples of our work.

PHP frameworks | Microsoft technologies | Front end development | CMS applications