Brand Analysis Automation

                     Brand Analysis Automation 

By: Sreekanth Rajoli Raichur

Executive Summary:

Brand Managers often spend a lot of time analyzing the growth trends of their brand. Performing and analyzing growth trends on 25 attributes which A.C Neilson data provides and sharing it with the manager or other stakeholders becomes a huge task. This project is aimed at solving this problem, automating the process of analyzing and plotting growth rates in all 25 attributes and also automating the process of sending an email with the required report, filtering out all the unnecessary raw data.

The project calculates growth rates of the selected brand in all the 25 attributes for the overall market and for the individual retailers. It generates a new sheet named “Brand Report” which has all the data in a format which enables simple comparison of growth rates across retailers and in overall market. A chart comparing the growth trends is dynamically generated based on the calculated growth rates.

Finally, the project provides an option in the ribbon using which user can send the report to anyone he wants in a single click. When you send the email it creates a copy of your report generates a new excel out of it, and sends it to the receiver as an attachment. This way we are sending only the required information i.e the Brand Report to the manager.

The logic flow consists of these primary steps:

·         Enable the user to select a Brand and push “ Generate Brand Report” button in the Ribbon

·         Calculate the attribute level growth rates for the selected brand

·         Repeat the calculation across multiple retailers

·         Create a new sheet with tables to show all the calculated growth rates

·         Create a chart which contains a trend line for each of the retailer showing the growth rates in all the attributes 

·         Enable the user to send the report via e-mail by pushing the “E-Mail Report” button in the ribbon.

·         Validate the e-mail address

·         Create a copy of the report excel sheet  and save it in a new excel workbook

·         Finally, send the mail with the attachment to the receiver.

Excel File_Brand Automation

User Manual_Brand Automation