Portfolio
Adidas
Objective
Perform a descriptive and analytical analysis to obtain information on the current panorama of a brand as recognized worldwide as Adidas, to then plan with the marketing and sales team for 2023.
Data
- Project Brief
- Data sourced from Kaggle. See the following link
Techniques Applied
- Data Cleaning : Wrangling
- Data Integrity and Quality
- Pivot Tables
- Data Grouping and Summarizing
- Calculated Fields
- Descriptive Analysis
Tools
Analysis
Adidas is the second largest sportswear manufacturer in the world. However, to stay relevant the brand needs to find
new ways to reach its target audience. In this review, we will explore and find some new marketing ideas that Adidas
could use to stay ahead of the competition.
The states that spend the most:
▪ Florida
▪ California
▪ Louisiana
▪ New York
▪ Texas
The states that spend the least:
▪ Nebraska
▪ Rhode Island
▪ Maryland
▪ Minnesota
▪ Pennsylvania
According to results already obtained, we focus on which is the medium or retail that these purchases are made more to the masses. And the graph shows us that West Gear is the one with the highest percentage except in Texas, which in this case is through Sports Direct. In addition, the first graph shows us that the product Men's street shoes is the best-selling product followed byWomen's clothing.
Project Phases And Results
Preparation
Data obtained from Kaggle and Nasdaq. Clean dataset ready to use in Python
Analysis
Creation of geographic visualizations and Linear regression performed. Time series analyzed data. Results found on My GitHub Profile
Presentation
Analysis presented on My Tableau Visualization
Limitations
- Difficulty finding a historical database: It was difficult to find a historical database to work with for this analysis, even trusted pages had no historical data for this particular company.
- Accuracy and completeness: Some data for each state was blank and missing, including some sales figures, and market share.This may have skewed the final result slightly.
Recommendations
- Taking into account the 5 states that buy the most, new and innovative strategies could be created to be able to gain more customer loyalty.
- How to create a card where for each purchase points are accumulated for future purchases.Having identified the markets where fewer purchases are made, marketing campaigns should be promoted more and these states should not be left aside, since they have the potential for this trend to rise.
- It will be necessary to develop strategies for future sales, either with celebrities or current prominent people so that potential customers feel identified, thus having a greater purchase attraction.