SSIS/SSAS/SSRS – Envisa We enable success. Wed, 28 Sep 2016 18:02:43 +0000 en-US hourly 1 Yale Improves Service with BI Solution Sun, 01 May 2016 01:26:32 +0000

Maintaining their signature high level of service at every point along the purchase life cycle is a top priority for Yale Appliance, but lack of visibility into customer behavior and buying habits limited their ability to continue delivering a top-quality personalized experience for every customer.

The Envisa Solution

Envisa designed and developed a custom data warehouse and customer analytics solution that integrated in store and online data from their ERP solution. The solution also included custom integration with their email marketing and marketing automation solution. By implementing a data warehouse, Yale Appliance has been able to dramatically improve their customer service, which is a critical competitive differentiator in the high-end household appliance industry.

The Results

Enabled Targeted Marketing and Communications

Envisa’s data warehouse solution has enabled Yale Appliance to analyze their customer preference, purchase history and brand preference information to produce targeted marketing and communications campaigns, including automated outbound email campaigns, service touch points, delivery notifications and customer satisfaction surveys.

Improved Sales Reporting

Yale has improved overall sales by better understanding product performance by sales representative.


Improved Operational Efficiency with Automated Reporting

The Envisa solution eliminated manual report development by creating automated operational reports that are delivered each morning to key decision-makers.

Work ‘N Gear Unlocks the Power of Data Wed, 09 Mar 2016 15:46:38 +0000

Work ‘N Gear is proud to provide the widest selection of the very best brands of work apparel and work footwear designed and manufactured for use in the most demanding service, security, and industrial environments.  What they needed was a business information solution to support their growing multi-channel enterprise that was as robust as their workwear, and they turned to Envisa to provide it.

The Envisa Solution

Using the Microsoft Business Intelligence solution (SSRS, SSAS, SSIS), Envisa designed and developed and enterprise-wide data warehouse with dozens of custom reports and OLAP cubes. Because of the flexible technical design, Envisa was able to build a solution that would provide uninterrupted end-user access for nearly ten years, even amidst multiple upgrades and a complete replacement of the underlying ERP system.

The Results

Improved Inventory Management and Forecasting

With the Envisa business analytics tool, Work ‘N Gear gained visibility into the store and warehouse inventory, customer buying behaviors and trends and other metrics that enabled more robust forecast reporting.

Quick Answers to Ad-Hoc Questions

Using OLAP cubes, Work ‘N Gear managers have been able to quickly answer ad-hoc queries, leading to improved operations management and customer support.

Targeted Marketing Campaigns

Leveraging integrated customer analytics, Envisa enabled Work ‘N Gear to initiate data-driven, targeted on-line and off-line marketing campaigns to boost sales.