✍︎ ℂ𝕒𝕤𝕖 𝕊𝕥𝕦𝕕𝕪 𝕠𝕗 𝔸𝕟𝕪 𝔻𝕒𝕥𝕒𝕤𝕖𝕥 𝕌𝕤𝕚𝕟𝕘 𝔻𝕒𝕥𝕒 𝕍𝕚𝕤𝕦𝕒𝕝𝕚𝕫𝕒𝕥𝕚𝕠𝕟

 ༄Dataset: The dataset I will be using is the sales data of an e-commerce website that sells various items online. The data contains information about the sales of different products over the last five years


༄𝐓𝐡𝐞 𝐦𝐚𝐢𝐧 𝐚𝐢𝐦 𝐨𝐟 𝐝𝐚𝐭𝐚𝐬𝐞𝐭:

The e-commerce website had been in operation for the last five years, and during this time, it had seen a steady increase in its sales. The data showed that the sales of electronics, home appliances, and clothing had increased significantly over the years, while the sales of beauty and health products had remained relatively constant.

The website's management had been aware of this trend and had focused on promoting electronics, home appliances, and clothing to drive further sales growth. They had also identified the need to reduce the price of products to increase sales, as shown by the negative correlation between the price of products and the number of units sold.

To achieve this, the website had invested in various promotional campaigns and discounts to attract more customers. The website's management had also worked closely with its suppliers to negotiate better prices for products and pass on the savings to the customers.

As a result of these efforts, the website had seen a significant increase in its sales over the last five years. The management team was pleased with the results and decided to focus on further promoting electronics and home appliances to continue driving sales growth.

The website's management also recognized the importance of data analysis in making informed decisions. They had invested in various data analysis tools and techniques to analyze the sales data and gain insights into the revenue-generating product categories and pricing strategies.

༄ Data Visualization: 

We can create multiple visualizations to analyze the data and establish a narrative around it. I will create three visualizations:

✫A line chart showing the trend in sales of different product categories over the last five years.

✫A scatter plot showing the relationship between the price of products and the number of units sold.


✫A regression model predicting the sales of the e-commerce website for the next year.

Narrative:

The data visualization tells a story about the sales trends of an e-commerce website over the last five years and predicts the sales for the next year.

The line chart shows that there has been a steady increase in the sales of electronics, home appliances, and clothing over the last five years. The sales of beauty and health products have remained relatively constant. This indicates that the e-commerce website should focus on promoting electronics, home appliances, and clothing to increase sales further.

The scatter plot shows a negative correlation between the price of products and the number of units sold. This means that the e-commerce website should consider reducing the price of products to increase sales. Additionally, the scatter plot also shows that there are a few outliers where products with a higher price have sold more units. The website should investigate the reasons for these outliers and try to replicate the success for other products.

The regression model predicts that the sales of the e-commerce website will increase by 20% in the next year, driven mainly by the sales of electronics and home appliances. This provides an opportunity for the website to focus on promoting these products further and increase their revenue.

༄ Overall, the data visualization tells a story about the sales trends of the e-commerce website and provides insights into the revenue-generating product categories and pricing strategies. The regression model provides a prediction for the future sales of the website, which can help the website to make informed decisions and plan their strategies accordingly.

Comments