This repository showcases my work as a data analyst in the domain of supply chain management. Leveraging a diverse set of data analysis tools, including Power BI, Excel, and SQL, I have meticulously constructed a comprehensive supply chain management solution.
Supply-Chain-Management
This project showcases a dedicated effort to elevate our supply chain management through meticulous analysis of key performance indicators (KPIs). From store-wise sales to regional dominance, each KPI has informed strategic decisions, resulting in a more responsive and efficient supply chain. Our commitment to data-driven insights underscores our pursuit of operational excellence, ensuring sustained growth and success in the dynamic business landscape.
KPI 1: Store-wise Sales
-Store #799 leads with $26,335 in sales.
-Valuable data facilitates targeted analyses for informed decision-making.
KPI 2: Sales Growth
-Significant post-2020 sales downturn attributed to the pandemic.
-Recognizing the need for strategic recovery is crucial.
KPI 3: Daily Sales Trend
-Monitoring daily sales trends allows for agile decision-making.
-Identification of peak periods and areas for improvement.
KPI 4: Brand-wise Sales
-Samsung dominates with 260,000 units sold.
-Apple follows closely with strong sales of 250,000 units.
KPI 5: Gross Profit
-Substantial gross profit of $170.45 million reflects financial health.
-Gross profit as a fundamental measure of overall efficiency.
-The West leads in unique orders, showcasing high customer engagement.
-Guiding tailored marketing and customer service strategies.
KPI 11: Total Profit by Region
-The West dominates in total profit.
-Strategic decisions guide resource allocation and market expansion.
OUTCOMES
Boosting Store Performance:
Delving into store-wise sales, I've fine-tuned the operations of Store #799, strategically driving sales and enhancing overall efficiency.
Tackling Post-Pandemic Challenges:
Responding to the sales dip post-2020 due to the pandemic, I've proactively devised recovery strategies, ensuring a resilient supply chain in the face of unforeseen disruptions.
Adapting to Daily Sales Trends:
Using daily sales trend insights, I've flexibly adjusted to market shifts, making timely changes to cater to evolving customer needs in a dynamic supply chain.
Nailing Brand-Specific Marketing:
Focused on brand-wise sales, especially Samsung and Apple, my targeted marketing has hit the mark, aligning strategies with each brand's strengths for impactful results.
Mastering Regional Markets:
Leveraging data from region-wise sales and total profit, I've strategically positioned my business for regional dominance, tailoring approaches to meet the unique demands of each locale and ensure lasting profitability.