(Power BI) Superstore Sales Dataset analysis

 This dataset is accessible to anyone by this link: Superstore Sales Dataset | Kaggle.


Dataset information: Retail dataset of a global superstore for 4 years.

A glimpse of this dataset: 



Purpose of this analysis:
1. The general situation of the sales performance from 2015-2018;
2. The sales performance related to different types of customers;
3. The sales performance of different products

The dashboard is ready to be used as follows:



Data Validation and pre-processing 

1. The dataset has been checked for duplicates, null, and error values.

2. Change data type: In this dataset, "Order Date" and "Ship Date" are "text". Change it to "Date" before further exploration. 

However, since the date value in these two columns is organized in "dd-mm-yyyy", it seems not possible to change it directly to the "Date" data type. So I first separated these two columns by the delimiter "/" and then merged the separated columns into the format of "mm-dd-yyyy". By doing this, these two date columns can be successfully changed to "Date”. 

After this step, close Power Query and upload the file to Power BI. 

3. Remove the unrelated columns in the "data view" tab and format the "Order Date" and "Ship Date" columns to "Short date" for a better look. 

4. Since the revenue of different products is needed, a hierarchy needs to be created. 

After this process, the drill-down function is available to detect different categories. 




Comments

Post a Comment

Popular posts from this blog

(DA with R) The connection between people's sleep condition and daily activity

Image
This dataset is from:  https://www.kaggle.com/datasets/arashnic/fitbit Brief intro of this dataset:  This dataset is from Fitbit, a dataset of people's physical activity shared the Fitbit wearable device users. This dataset includes all the data in CSV files.  This research is designed to know whether there is  any possible relationship between people's sleep time and their daily activity. Prepare the data  Since the research purpose is to explore the possible relationship between sleep time and daily activity, therefore I  use two csv files for my research:        The "dailyActivity_merged.csv":      and the "sleepDay_merged.csv".  1. All the data stored in this dataset are in CSV files and organized in the wide  format.   2. To check the integrity of the datasets, I did the following work:       1). Import         a)Upload the related files that need to be analy...
Read more

（Data analysis with Power BI) The highest revenue moive and the highest rated movie in every decade

Image
This dataset is publicly shared on: https://www.kaggle.com/datasets/rounakbanik/the-movies-dataset Brief intro of the dataset:  "These files contain metadata for all 45,000 movies listed in the Full MovieLens Dataset. The dataset consists of movies released on or before July 2017. Data points include cast, crew, plot keywords, budget, revenue, posters, release dates, languages, production companies, countries, TMDB vote counts, and vote averages. This dataset also has files containing 26 million ratings from 270,000 users for all 45,000 movies. Ratings are on a scale of 1-5 and have been obtained from the official GroupLens website." Research purpose:  1. The highest revenue movie in every decade 2. The highest-rated movie in every decade The final dashboard is here. You may check the analysis process in the following. Data Validation Data cleaning via Power Query  1)  The data type of each column is directly shown here.  Change it if the data type is wrongly fo...
Read more