Client needed an analysis of the effectiveness of a variety of product promotions run in an attempt to drive sales. Understanding past performance was a foundation to setting new promotions, moving certain products and gaining potential insight on moving slow moving products. Parameters of inquiry were provided by the marketing department.
We constructed a database query connecting several different tables to analyze data related to each promotion and defined the query limits to control the data outcomes. We copied the results into Excel where charts and graphs were used to present and analyze the findings so that the client could understand the resulting impact on the business.
We were able to demonstrate to the client where promotions potentially impacted sales positively. Although making a direct correlation wasn’t intuitive or directly correlated since other factors can always be at play—in this case weather is a factor. In some promotions the sales volumes picked while in others there was no change or even in one case a decline. Since this was a new approach for the business this project was a ground floor foundation for future promotions to help build the business.
“Forward thinking analysis is often more beneficial and predictive than a backwards looking approach”