Data Analyst | Excel | power Bi | SQL | Looker studio |Python | Tableau |Business Analyst | Data Visualization

PRIYANSHI RAJPUT • Peerlist

Data Analytics professional at Schenider Electric having 2+ years of experience with Excel,SQL, Python,Tableau

<h2>Amazon Sales Dashboard</h2>Problem:<h2>KPIS: - profit, Revenue, Shipping days, Units Sales&nbsp;</h2><h2>Business Use cases: -&nbsp;</h2><ol><li>Analyse the profit by region&nbsp;</li><li>Analyse the profit by Countries&nbsp;</li><li>Channel Revenue Analysis&nbsp;&nbsp;</li><li>Order per year&nbsp;</li><li>Cost per year&nbsp;</li><li>Revenue and Shipment Analysis&nbsp;</li><li>Items wise revenue, profit margin, shipments, Number of units sold&nbsp;</li></ol><h2>Insights: - </h2><h2>Profit by Country: -</h2>Djibouti has Highest Profit with $58.2 million, followed by Pakistan at $46.4, Samoa at 45.6million and Mexico at $39.4 million.<h2>Profit by Region:-</h2>High Profit Regions<ul><li>Sub-Saharan Africa: $220.8M</li><li>Europe: $189.6M</li><li>Middle East and North Africa: $126.3MLow Profit Regions<ul><li>India: $11.5M</li><li>North America: $39.4M</li></ul></li></ul><h2>Revenue by Channel:-</h2>Revenue: Offline sales significantly outperform online sales.<h2>Order and Cost Per Year: -</h2><ul><li>Between 2010 and 2012, we observed an increase in order volume. Concurrently, costs decreased until 2011 and then began to rise through 2012.</li><li>A sharp decline in both order volume and costs is evident from 2012 to 2015. Furthermore, after 2016, we observe a continued sharp decrease in order volume, accompanied by fluctuations in cost.</li><li>There is a clear correlation between cost per year and orders per year, with the lowest cost per year correlating with the lowest order per year, and vice versa.</li></ul><h2>Revenue and Shipment Data Analysis: -</h2>1.Typically, an increase in shipping days correlates with a decline in revenue, whereas a reduction in shipping days leads to an increasein revenue.2. However, from 2012 to 2013, both shipping days and revenue exhibited an upward trend, indicating a potential exception to the usual pattern.3 .Conversely, from 2013 to 2014, both shipping days and revenue declined, suggesting a different operational dynamic during this period.<h2>Revenue, Profit, Unit Sold , Cost by Item: -</h2><ul><li>Cosmetics are the most profitable, highest costly product and highest selling product category.</li><li>Office Supplies and Household are the second and third highest revenue generating categories, but their profits are low.</li><li>Baby Food and Clothes have relatively high revenue, but a lower unit sold compared to other categories.</li><li>Fruits have the lowest revenue and unit sold.</li><li>The unit sold is high in the "Beverages" category compared to the profits generated.</li><li>Although office supplies and household have a low number of units sold, they rank second and third highest in cost Price.</li></ul><h2>Conclusion:-</h2>The Amazon Sales Analysis using Tableau has provided insightful data on Profit Performance on Region and Country, Revenue Chanel Analysis , Profit, Unit Sold, Cost , Revenue on Item, Order per year. Key finding include expand products in high profitable Region and Country , Focus on expanding the cosmetics items , help to know the reason of high cost of office supplier and Household, new pricing model and for fruits, check fruits quality, lowest cost per year correlating with the lowest order per year.By focusing on the insights such as decreasing order per year , Improving Item, worst Item, Highest Profitable Region Amazon can drive higher sales , higher profit , customer trust , Market demand.<h2>Thank You</h2>

Amazon Sales Dashboard

<h2>Visualization Tool :- Looker Studio</h2><h2>Zomato Dashboard Link :- <a target="_blank" rel="noopener noreferrer nofollow" class="text-green-500 rich-link break-all link-break" href="https://lookerstudio.google.com/s/om6oizkO7w0">https://lookerstudio.google.com/s/om6oizkO7w0</a></h2><h2>Problem: - </h2>Zomato is facing a decline in customer engagement, with increasing order cancellations and delivery delays. <h2>Background: -</h2> Zomato, India’s leading food delivery platform, you are tasked with addressing challenges in customer satisfaction, fluctuating delivery times, and inconsistent sales across regions. Data shows a drop in repeat customers and high cancellations. Your mission is to analyze sales, ratings, and delivery data to uncover actionable insights that enhance customer experience, improve marketing strategies, and boost operational efficiency to drive growth.<h2>Importance of Addressing the Issue</h2>1. Increase customer lifetime values,2.Increasing customer retention3. Reduced customer Acquisition Cost(CAC)4. Reducing Delivery time5.Optimizing Restaurant Recommendations<h2>KPIs: </h2>Total Revenue: 585.8K Average customer Rating: 2.97 Completed Orders: 344 Total Orders: 1000<h2>Key Insights:-</h2>• Average Delivery Time by Cities Cities like Bangalore (57.04) and Delhi (57) have the longest delivery times. Chennai (48.47) and Kolkata (47.9) seem to have relatively faster delivery times.• Total Revenue Revenue shows fluctuations, possibly due to seasonal trends or inconsistent order completion rates.• Customer Rating by All Orders Customer ratings are concentrated around lower scores, indicating dissatisfaction across many orders.• Average Order Amount by Cuisine Italian cuisine has the highest average order amount, while Chinese cuisine generates lower- order value.• Payment Method Distribution UPI and cash payments are most popular (around 50% combined), suggesting a preference for flexible payment options.• The average order distribution by payment method Indicates that customers predominantly prefer cash payments, with a total of 1,456 orders. This is followed by credit card payments, which account for 1,345 orders. Both UPI and debit card payments show relatively lower usage, with 1,323 and 1,311 orders, respectively.• Delivery Time by Order Status Delivery delays are evident for failed or canceled orders, likely contributing to dissatisfaction.• Delivery Time by Cuisine Type Certain cuisines, like Italian (10060) and Mexican (9226), have longer delivery times, potentially impacting ratings and satisfaction.<h2>Suggestions:-</h2><ul><li>Optimize Delivery Routes</li></ul>Focus on reducing delivery times in Bangalore and Hyderabad by improving route planning, increasing delivery staff, and partnering with more local restaurants, check the frequency of orders on specific delivery partner.<ul><li>Improve Customer Satisfaction</li></ul>Address issues causing low ratings through better food packaging, faster delivery, and proactive customer support.<ul><li>Monitor High-Value Cuisines</li></ul>Prioritize faster delivery for high-value cuisines (e.g., Italian, Mexican and Japanese) to retain high-spending customers.<ul><li>Enhance Payment Experience</li></ul>Offer discounts or incentives for preferred payment methods (UPI and cash) to drive more engagement and trust.<ul><li>Analyze Cancellations</li></ul>Investigate the root causes of cancellations and failed deliveries, such as restaurant delays or miscommunication with customers.<ul><li>Targeted Marketing</li></ul>Use data to run city-specific marketing campaigns that highlight faster delivery or popular cuisines to boost engagement in underperforming areas.<ul><li>Customer Feedback Loop</li></ul>Implement a robust feedback system to identify recurring issues from customer reviews and ratings.

Zomato case study

<h2>Background /Problem</h2>An online retail store has hired you as a consultant to review their data and provide insights that would be valuable to the CEO and CMO of the business. The business has been performing well and the management wants to analyse what the major contributing factors are to the revenue so they can strategically plan for next year.The leadership is interested in viewing the metrics from both an operations and marketing perspective. Management also intends to expand the business and is interested in seeking guidance into areas that are performing well so they can keep a clear focus on what’s working. They would also like to view different metrics based on the demographic information that is available in the data.<h2>KEY INSIGHTS :-</h2><ol><li> ﻿At 1.51 M , November had the highest Sum of Revenue and was 188.27% higher than February, which had the lowest Sum of Revenue at 0.52M.November accounted for 15.34% of Sum of Revenue. Across all 12 Month, Sum of Revenue ranged from 0.52M to 1.51M.</li><li>At 201k, Netherlands had the highest Sum of Quantity and was 764.73% higher than Belgium, which had the lowest Sum of Quantity at 23k. Sum of Quantity and total Sum of Revenue are positively correlated with each other. Netherlands accounted for 24.87% of Sum of Quantity. Sum of Revenue and Sum of Quantity diverged the most when the Country was EIRE, when Sum of Revenue were 136007 higher than Sum of Quantity.</li><li>At 280k, 14646(Customer ID had the highest Sum of Revenue and was 263.04% higher than 12346 (Customer ID), which had the lowest Sum of Revenue at 77K. 14646 accounted for 18.22% of Sum of Revenue. Across all 10 Customer ID, Sum of Revenue ranged from 77K to 280K.</li><li>Germany has the highest quantity, with 9,042 units, followed by France with 8,408 units, and Eire with 7,894 units. Saudi Arabia has the lowest quantity, with only 9 units.</li></ol><h2>Solution :-</h2><ul><li>Seasonal Promotions: If revenue spikes in specific months, plan promotional campaigns or product launches during those times to maximize sales.</li><li>Off-Peak Strategies: Introduce discounts, bundle offers, or loyalty programs during low-revenue months to boost activity.</li><li>Low-Quantity, High-Revenue Products: Focus on marketing these items, as they bring significant value per sale.</li><li>Product Mix Optimization: Promote a mix of high-margin and high-volume products to balance profitability and cash flow.</li><li>Expand in High-Performing Countries: Invest in localized marketing campaigns and improve shipping to further grow these markets.</li><li>Market Research in Low-Performing Countries: Investigate reasons for lower revenue (e.g., product fit, shipping issues, or low awareness)</li><li>Focus on Hotspots: Enhance delivery speed, provide localized payment options, or offer exclusive deals in areas with high sales.</li><li>Target Underperforming Regions: Consider local advertising or partnerships with regional distributors to increase visibility.</li></ul>

Online Retail Store

<h2>Problem: - </h2>BlinkIT faces challenges with inconsistent sales performance across its outlets and product categories. This project focuses on optimizing product offerings, refining outlet strategies, and aligning pricing models to maximize revenue across all locations.&nbsp;<h2>Background</h2> Welcome to the BlinkIT Corporate simulation! BlinkIT is a grocery retail chain operating across multiple cities, aiming to enhance its sales, outlet performance, and product dynamics. The objective is to analyze data using Power BI to uncover key trends and provide actionable insights that drive growth and profitability.&nbsp;<h2>Solution </h2> BlinKit KPIS Report provides key insights to Identify high- and low-performing products, trends, evaluate outlet performance to tailor strategies, improve inventory, and enhance operations, promote underperforming products and Implement data-driven pricing to maximize margins while staying competitive.<h2>KPIS :-</h2> Total Item -8515Total Sales - 18.58 MPrice Range :Min Price :- 31.29Max Price:- 266.89AVG price : - 141.01Avg Outlet Sales :- 2,18.56Avg Item Visiablity :- 0.07Medium price item sales - 4.64kLow price item sales - 2.44kHigh price item sales - 1.44 kSales by Outlet Size: -Small size has highest sales :- 48.22%Medium size has 40.24%High size has low sales :- 11.53%Highest Outlet Sales by Outlet types:-Highest in Supermarket Type1 Tier2 - 6.47M2nd highest in supermarket Type1 Tier1 :- 4.3MLowest outlet sales by outlet type:-Grocery store Tier1Grocery store Tier3Top selling Categories :-Fruit and vegetable : - highest sales at 2.8 M(15.18%)hishest visibility - 90.16Snack foods :- 2nd highest at 2.7M(14.67%)Household Items :- closely at 2.1 M(11.07%)Low selling Categories :-Seafood :- Very low at 0.1 M(0.8%)Breakfast items :- 0.2 M(1.25%)<h2>Key Insights :- </h2> tem sales by price range :-A large number of items fall in the medium price range (4.64k items), which may suggest that thestore's pricing strategy focuses on middle-market productsTop Selling Category :-Fruits and vegetables , snack foods are suggesting customer preferences , enhancing profitabilityand also shows highest item visibilitySales by outlet size :-small stores and medium stores make up the largest share of sales (48.22% , 40.24%) allowscompanies to focus their marketing and inventory strategies on these stores to maximize sales andprofitsoutlet type :-Supermarket Type 1 Tier 2 generates the highest sales at 6.47 million.Supermarket Type 1 Tier 3 follows with 4.3 million. Efforts on maximizing salesfrom focus on high-performing outletsOutlet Age :-﻿ outlet age 39 in Item Type Fruits and Vegetables made up 3.23% of Sum of Item Outlet Sales<h2>Events need Improvements :- </h2> Lowest high price sales :-Lowest number of item falling in high price range(1.44k) . Consider expandingthe premium or luxury product range to cater to higher-end customers and improveprofitability.Lowest Selling Category :-Seafood( 0.1M),Breakfast(0.2M) are needing attention to boost overall sales performance ,lead uneven revenue distributionOutlet size performance :-Analyzing underperformance outlet size and Investigate the reasons for low sales in highoutlets, such as product unsuitability, pricing issues, or competition.Outlet Type :-Investigate underperforming outlets and analyze why Grocery Store Type 1 has low sales andexplore strategies to improve performance in this segment.Low Visibility :-The item is experiencing low visibility and low sales, indicating underperformance in the outlet,which may be attributed to a lack of customer preference and potential pricing issues.<h2>Business Recommendation :-</h2><ul><li>Adjust the product offerings, pricing strategy, and target market focus to better align with customer needs and maximize sales.</li><li>By focusing marketing efforts on top-selling categories, the business can increase visibility and sales in these areas, enhancing profitability</li><li>Implement targeted promotions or bundle offers for low-selling items to boost their sales.</li><li>Refocusing efforts:</li></ul>Redirect marketing ,increase inventory and sales resources towards small and mediumoutlets with higher sales potential.<ul><li>Product Diversification:</li></ul>Introduce new products or variations within the medium outlet category to attract abroader customer base.<ul><li>Market Analysis:</li></ul>Conduct a thorough analysis to understand why high outlets have lower sales. Thiscould involve assessing market demand, competition, and pricing strategies. Identifyniche markets or specific industries that may benefit from high outlets and tailormarketing efforts to these segments.<ul><li>Resource allocation:</li></ul>Allocate resources (marketing, inventory, sales teams) strategically based on outletperformance.<ul><li>Growth potential:</li></ul>Identify opportunities to expand in high-performing segments andimprove performance in underperforming outlet