# Ecommerce_sales_dashboard_Power_BI

![image](https://github.com/umatuteja/Ecommerce_sales_dashboard_Power_BI/assets/146737480/4ca2fcb5-5818-42e5-a085-b8dae7cf2f51)

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

