WWI analysis(4) data analysis and power pi.pptx

dash board

1. z World Wide Imports Analysis Data Analysis & Visualization Project

2. Meet our Extended Team Hagar Mohamed Mostafa Essam Fatma Elzahraa Hamed Anwaar Raafat Amira Alhussein

3. Steps Taken

4. Agenda Objective Get Data Data Modeling Dashboard Design using Power BI KPI Calculation using DAX Data cleaning using power query

5. Objective The primary objective of this analysis was to: Clean and preprocess the dataset to handle missing or inconsistent data. Calculate key performance indicators (KPIs) to measure the efficiency of the supply chain, financial performance Provide actionable insights based on the KPIs to guide strategic business decisions.

6. z Data Modeling Designed star schema for data Created relationships between tables Optimized for reporting performance Ensured scalability of the model

7. Dashboard Design Using Power BI Two interactive dashboards were developed: Overview and Customers & Products . The dashboards include filters by City, Date, and Year for deeper analysis. The Overview dashboard presents : Key performance indicators summarized at the top (Revenue, Profit, Cost, Profitability, Monthly Sales Growth) Top 5 Sellers ranked by total profit and revenue. Revenue and Profit by State (Clustered Bar Chart) comparing performance across regions Revenue and Profit Over Time (Line and Clustered Column Chart) showing yearly sales trends from 2013 to 2016 Profitability Over Time (Line Chart) highlighting monthly profit ratio fluctuations

8. Dashboard Design Using Power BI The Customers & Products dashboard presents : Stock and Customers KPIs (Card Visuals) displaying total stock items, orders, and customers. Revenue by Package (Clustered Bar Chart) comparing sales contribution by package type. Product by Type (Donut Chart) showing share of Dry & Chiller vs. Frozen items. Stock Item Performance (Table Visual) listing products with revenue, cost, and profitability. Sales by Region (Map Visual) mapping geographic distribution of sales in North America.

9. Overview Dashboard

10. Customers and Products Dashboard

11. z KPI Calculation Using DAX Defined key performance indicators Built DAX measures for calculations Focused on sales and profitability metrics Enabled dynamic insights across dashboards

12. DAX Measures

13. DAX Measures

14. DAX Measures

15. Results & Insights The Overview Dashboard highlights key performance metrics: Revenue reached 20M with a total profit of 9.92M , reflecting nearly 50% profitability . Revenue and profit trends show growth until 2015, followed by a decline in 2016. Profitability over time remained stable around 50% , showing consistent margins. California leads revenue and profit among states, followed by Washington and Alaska. The Top 5 sellers (Hudson, Sophia, Lily, Kayla, Taj) significantly drive overall performance.

16. Results & Insights The Customers & Products Dashboard highlights key performance metrics: A strong customer base of 402 drives 3,260 repeat orders, showing high loyalty. Most of the stock (97%+) is Dry products, highlighting limited diversity in Chiller items. Certain products show negative profitability, requiring pricing or marketing adjustments. Revenue is mainly generated from unit sales (Each), while other package types contribute minimally. Customers are concentrated in specific regions, indicating room for market expansion.

17. Recommendations Address Revenue Decline in 2016 Investigate the reasons behind the sales and profit drop in 2016 and implement corrective actions (e.g., promotions, pricing strategy). Leverage High-Performing Regions Focus more resources and marketing campaigns in top-performing states like California and Washington to maximize growth. Improve Underperforming Regions Analyze customer needs in Hawaii, Nevada, and Oregon to identify opportunities for targeted promotions or product mix adjustments. Support Top Sellers Strengthen collaboration with high-performing sellers (Hudson, Sophia) while providing training and incentives to lower performers to balance contributions. Diversify Product Portfolio Since profitability margins are stable (~50%), consider expanding product categories or bundles to capture untapped markets.

18. Any Questions?

19. Thank You