This project was to review a client's (TATA Online Retail business) data and provide insights that would be valuable to the CEO and CMO. Particularly to analyze the major contributing factors to the revenue so they can strategically plan for next year.
I was able to:
- Complete a simulation involving Data transformation, and creating data visualizations for Tata Consultancy Services.
- Prepare questions for a meeting with client senior leadership.
- Create visuals for data analysis to help executives with effective decision-making.
- Which months generated the most revenue? Is there a seasonality in sales?
- Who are the top customers and how much do they contribute to the total revenue? Is the business dependent on these customers or is the customer base diversified?
- What revenue is being generated from the customers who have ordered more than once?
- Analyze the monthly trend of revenue, which months have faced the biggest increase/decrease?
- What is the percentage of customers who are repeating their orders? Are they ordering the same products or different?
- Who are the customers that have repeated the most? How much are they contributing to revenue?
- Created clear and informative visualizations to effectively communicate key findings.
- Address missing and negative data values, inconsistencies, and irrelevant data points.
- Identify patterns and relationships within the data using visualizations.
- Identify opportunities that would lead to growth and generate more revenue in the future.
- Identify the visual that would explain the data and insights in the simplest possible manner.
Folder containing project analysis documents
This project demonstrates my skills in Data analysis and transformation, Visualization, Storytelling, and Presentation relevant to Marketing and Sales for Businesses.