sales data for an e-commerce

A new project using Microsoft Excel for sales data for an e-commerce company specialized in selling office products, furniture and stationery. The data includes detailed information about each order such as order date, shipping date and shipping method, which indicates the company's focus on providing diverse shipping options. It also contains customer data such as customer name and geographic location, which helps in analyzing the market and understanding customer trends. Products are classified into main and sub-categories such as furniture and stationery, which indicates the company's specialization in providing office supplies. The data includes details about the sales volume and profits for each order, which reflects the company's interest in tracking the financial performance of each sale.

?I conducted data analysis using pivot tables and DAX language

?This made us aware of the most important strengths and weaknesses, areas of increasing sales and the rate of increase by location, customers, customer type and products, which enabled us to make decisions that guarantee us further development in profits in the future.