Ecommerce_sales_dashboard_Power_BI

Ecommerce_sales_dashboard_Power_BI

Dashboard link(need access to view) :https://app.powerbi.com/links/sb0NQH-qzF?ctid=9aee26d8-97c2-4fad-8900-96735f6dc73f&pbi_source=linkShare

Created a Ecommerce_sales_dashboard for US Based Ecommerce Sales Company using Power BI showing information of YTD Sales and generate insights.

Requirements: A US Based Ecommerce Sales Company wants us to create a Sales Dashboard showing information of YTD Sales and generate insights for below scenarios-

• Create a KPI Banner showing YTD Sales, YTD Profit, YTD Quantity sold, YTD Profit Margin
• Find Year on Year growth for each KPI and show a YTD sparkline for each measure in the KPI to understand the monthly trend for each fact. • Find YTD Sales, PYTD Sales, YoY Sales growth for different customer category. Add a trend icon for each category.
• Find YTD Sales performance by each State
• Top 5 and Bottom 5 Products by Sales
• YTD Sales by Region to know best and worst performing region all over country
• YTD Sales by Shipping Type to get the best shipping type percentage

Note : Data files attached ecommerce_data.csv and us_state_long_lat_codes.csv