This is a sales report analysis of NIKE a Footwear Company. Nike is an American athletic footwear and apparel corporation headquartered near Beaverton, Oregon, United States. It is the world's largest supplier of athletic shoes and apparel and a major manufacturer of sports equipment, with revenue in excess of US$46 billion in its fiscal year 2022. This is an Excel Project which consist of the Sales and Profit comparison of NIKE Company and also analysis on Operating Profit Margin of the year 2021. This Project contains various analytical skills like Pivot Tables, Data Cleaning, various Visualization insights, Slicers, Timelines, etc. It consist of Retailer Names, Retailer ID, Invoice Date, State, City, Products, Unit Price, Quantity Sold, Total Sales, Operating Profit and Operating Margin. Based on these data this NIKE Sales Analysis Report is created.
- Identifying the Problem : Firstly understood the data and its different variables through my analytical skills.
- Data Cleaning and Processing : Converted the data into Table with Filters, removed all duplicate values, changed data type, used text to column technique to separate the columns etc.
- Performing Descriptive Analysis : Inserted different meaningful Pivot table from the processed data and generated KPI from that Pivot.
- Data Visualization : Constructed various significant insights in order to derive relevant information from Pivot Chart.
- Enhanced Formatting : Altered the format of the Charts with the help of Format Painter.
- Creation of Dashboard : Created a meaningful dashboards by compiling all the relevant charts together and also inserted additional features like Slicers, Timeline, Buttons from Developers etc.
In this project, the generated KPI is Total Sales of NIKE Company i.e. 864M, Total Profit of NIKE Company i.e. 317M and Average Profit Percent of NIKE Company i.e. 37%.
- In which month there is maximum Sale with the maximum Profit ?
- Which Product of Nike Company is more popular than others on the basis of Sales and Profit ? Which gender mostly prefer Nike Company for its Product.
- Which Retailer contributes higher Sale with the maximum Profit ?
- Which State contributes the highest Sale in the market of the Nike Company with the maximum Profit ?
- Which Zone has the maximum Sale with the maximum Profit ? Does the maximum contributing state belongs from the same Zone ?
- Which Product has the highest Operating Margin than others ?
- Which Retailer has the highest Operating Margin than other Retailers ?
- Which State has the highest Operating Margin ?
- Which Zone contributes with the highest Operating Margin ? Does the highest operating State belongs from the same Zone ?
This Dashboard consists of 2 pages operated by Buttons under Other Analysis box, these are Comparison Dashboard and Operating Margin Dashboard.
-
In this project, I have used Month Timeline Slicer, from which I derived that December month has maximum Sale of Nike product but Profit was bit lesser than maximum and in July there is maximum profit whereas in March there was the least Sale but not the least Profit, here February is the least profit month.
-
In this Line Chart, Men's Street Footwear has the highest Sale with the maximum Profit followed by Women's Apparel and Men's Athletic Footwear whereas Women's Athletic Footwear has lowest Sale with the least Profit followed by Men's Apparel and Women's Street Footwear. This means that for footwear company should focus on male members and for clothing company should focus on female members.
- In this Horizontal Bar Chart, I found that One Sports retailer has highest Sale with the maximum Profit followed by West Gear whereas Sports Hero retailer has lowest Sale with least Profit followed up by Sport Locker.
- In this Line Chart, I came to know that New York state has maximum Sales but Florida state has maximum Profit followed by California whereas Nebraska state has the lowest Sales with the least Profit than others which is almost equal followed by Minnesota.
- In this Bar Chart, I got that West Zone has highest Sales with the maximum Profit whereas Midwest Zone has lowest Sales with the least Profit than other Zones. The maximum contributing states does not belongs to the West Zone the maximum contributing zone.
- In this Pie Chart, Men's Street Footwear and Women's Apparel are equally have high Operating Margin i.e. 39% than others whereas Men's Athletic Footwear has the least Operating Margin i.e. 34% which is less than other products.
- In this Horizontal Bar Chart, I found that Sport Locker retailer has the highest Operating Margin i.e. 41% which is higher than others followed by Sports Hero whereas West Gear retailer has the least Operating Margin 33% which is lesser than others followed up by One Sports.
- In this Line Chart, I came to know that Alabama state has maximum Operating Margin i.e. 50% which is higher than others followed by Tennessee whereas Alaska state has the lowest Operating Margin i.e. 25% which is lesser than others followed by Washington.
- In this Bar Chart, I got that South Zone has highest Operating Margin i.e. 41% which is greater than others followed by Southeast Zone whereas West Zone has lowest Operating Margin i.e. 33% which is lesser than others followed up by Northeast Zone. In this both the highest operating State i.e. Alabama and Tennessee belongs from the South Zone the highest operating zone.
This Dashboard is helpful for the Nike Company and other footwear stores to in their Sales related decision. Through this we can compare between the retailers and find out the best retailer i.e. Sport Locker, also we can find the best product i.e. mostly sold is Men's Street Footwear. From this we can also analyze the additional information that which gender purchases the NIKE Footwear most then we came to know that Male gender is popular for NIKE Sale and when we talk about NIKE Clothing then Female gender is highly popular for that. We can also check for the best zone for the sale of product to acquire maximum profit margin is South Zone and the State that has maximum profit margin is itself exist in South Zone. So Company should focus in South Zone for maximum Sales in order to operate maximum profit. According to these analysis Company can plan their future maximizing profit strategy.
- @Ritika821
- Ritika - Data Analyst