Identified Metrics
Brainstormed and listed down all metrics relevant to understanding the rhythm of business.
Shortlist the key metrics based on data availability and the audience to whom the final deliverable caters.
Prepared Dataset
Worked with stakeholders and identified the multiple data sources where the required data resided.
Did an Exploratory Data Analysis on datasets, identified multiple business scenarios, and clarified them clarified through multiple sessions with stakeholders.
Built logics and calculated the business metrics for newsletter.
Designed Newsletter
Brainstormed and fixed the storyline and flow of the newsletter.
Decided on the appropriate visual representations to present multiple data points sliced and diced by different business parameters.
Created the newsletter and shared it with stakeholders working in different departments.
The newsletter provided equal visibility to all stakeholders about the current status of the program.
The newsletter received a great response from stakeholders across multiple departments; the client decided to create and distribute monthly versions of the newsletter moving forward.