WWI analysis(2) data analysis 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 Rafaat Amira Alhussein

3. Steps Taken

4. Agenda Objective Get Data Data Modeling KPI Calculation using DAX Dashboard Design using Power BI 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. 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

8. DAX Measures

9. DAX Measures

10. DAX Measures

11. 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. Key performance indicators summarized at the top (Revenue, Profit, Cost, Profitability) The Overview dashboard presents: Top 5 Sellers ranked by total profit and revenue. A bar chart comparing states by revenue and profit. A column chart showing yearly revenue and profit trends. A line chart tracking monthly gross rate over time.

12. Overview Dashboard

13. Customers and Products Dashboard

14. 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.

15. 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.

16. 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.

17. Any Questions?

18. Thank You