This project deals with Ecomm sales data and got primary KPIs from the data as Total sales, Total profits, and Total shipping costs. and got key Insights from the data like top N countries which are giving the highest sales and top N states which are giving the highest sales and etc. And created filters through which we can see the results based on our filtered criteria.
Ecomm Data: The primary dataset used for the project is the "ECOMM DATA.xlsx" file, which contains all the information about e-commerce sales.
-
Microsoft Excel - Data cleaning
-
Power BI - Creating Dashboard reports and visualizing the Key Insights
In the initial data preparation phase, we have to perform the following tasks:
- Data Loading and inspecting the data
- Remove Unwanted or Unnecessary columns
- Data cleaning
EDA is involved in exploring the Ecomm Data to answer key questions, such as :
- What is the Total Sales Amount?
- What is the Total Profit?
- what is the Total Quantity sold?
- What is the Total Shipping cost?
- What are the top N Countries based on total sales?--(In this dashboard I choose 7 as an example)
- What are the top N States based on total sales?--(In this dashboard I choose 2 as an example)
- Which category is giving More Sales?
- what is the Market giving More sales compared to others?
- what is the sum of sales by Shipment Mode?
Data Analysis is done by connecting data from "ECOMM DATA.xlsx" to the Power BI, calculating the results from the data, and creating a dashboard report in Power BI.
- As per the results, the Total sales amount is 12.64M, the total profit is 1.47M, the total quantity sold is 178K, and the total shipping cost is 1.35M.
- The top 7 countries that are giving the highest sales are the United States, Australia, France, China, Germany, and Mexico followed by India.
- The top 2 states which are giving the highest sales are England(485.17k) and California (457.69k).
- From the Technology category we are getting high sales compared to the Furniture & Office Supplies categories.
- From Market APAC we are getting the highest no.of sales compared to all the other Markets.
- And Through the standard class shipment mode we are getting more sales compared to other shipment Modes.