Data analysis project using Power Bi

Analysis of the e-commerce project in the period from 2003 to 2005

Using Power Bi

Conclusion

- Number of production lines 7 production lines with a total number of

customers 92 customers

with a total sale of 10.03M and a quantity of orders up to 99K orders over

two years

-The largest customers in achieving sales during two years euro shopping channel with in Spain

- The city of Madrid with total sales of 912K or 30.87% of the total sales

- The largest countries achieving sales in two years are USA with a total of

3.63M or 42.14% of the total sales

- Best selling production lines Classic Cars = 3,9M

- Total quantity ordered = 34K

- The product line that achieves the large

Deal Size From Total Sales Classic Cars

- Cancellation of applications grows by 50%

from Oct 2003 to Apr 2004

- Total quantity ordered by Large deal size

7k order

- The Most of orders that arrived from the

total quantity 92,26%

- The Most of orders that arrived from the

total sales 92,61%

- Most of the country in quantity ordered

USA 36K

- Most of the cities in quantity ordered

Madrid 11K