销售数据仪表盘-PowerBi

Case：

An e-commerce site where various products can be purchased across the globe. The business has been growing a lot and expands to different markets. Every day, a great number of online shoppers purchase clothes, wine, and other goods from all over the world. You as a BI data analyst need to prepare a management report to the management team and explain the sales performance across different markets, top-selling products and sales development. How would you like to proceed with this?

项目背景：

一家电商公司业务范围横跨全球，每天有大量来自全球的衣物、酒、其他商品等销售数据。你作为BI数据分析师需要为管理团队提供不同市场的销售数据分析、热卖商品和销售增幅。你会怎么做？

There are two datasets in the attached Excels:

- Dimensions contain various information about products, Geography, Calendar.

- Sales Figures folder contain the detailed sales data for different markets.

数据源：

1、产品、地理、日期等维度。

2、不同市场的销售数据。

You will have to complete the following tasks

- Share the insights and interesting finds in a storytelling manner after the datasets are

analyzed

- Time intelligence: Calculate YTD (Year To Date) Sales, MTD (Month to Date)

Sales, SPLY (Same Period Last Year) Sales

- Calculate the SalesAmountByOrderDate and SalesAmountByPaymentDate

- Calculate Discount % based on actual sales amount and List price

- Calculate ASP (Average Sales Price)

你需要完成的任务：

1、以维度计算年累计销售额、月累计销售额、同比销售额。

2、计算以订单日期为准的销售额和以支付日期为准的销售额。

3、计算实际销售金额和标价的折扣。

4、计算平均售价。