A leading mattress and bedding manufacturing company wanted to establish an analytical database to deliver automated insights to key executives and support other analytic projects in an efficient manor. Their previous process required the team to spend significant time manually loading and preparing data than proactively gaining insights.

The solution contained a central analytical database with production routines to deliver standard reports to key stakeholders.

Automation was a key advantage when establishing a flexible analytical database. Numerous data systems (point of sales, web data, call center data, forecasting and other supporting data) were automatically processed. These processes validated the incoming data to ensure data accuracy preventing reports to be released with incomplete or misleading results. In addition, the base data was aggregated to support the various insight efforts for more efficient use of the analysis time.

KPI dashboard and other supporting reports were refreshed and email deployed to key stakeholders daily automatically. These reports provided numerous insights including:

• Calendar comparison between actual and forecast sales
• Promotional cycles awareness
• Store performance by media, call center and web channels
• Drill down merchandise hierarchy with current and past year comparison
• New product launch daily performance to support appropriate marketing mix

A key accomplishment was removing all the manual time and effort from the client so they can focus on analyzing the data. This freedom to perform insights allowed them to quickly uncover additional findings to proactively react to the sale cycle. Automating the standard reports provided additional efficiencies and introduced check and balances to ensure confidence in data accuracy. With the success of the analytical database, it quickly expanded to support addition initiatives for the client.