A PowerBI dashboard to show the Fashion Data
Visualization Data virtualization is a technique for data management that allows applications to represent and depict data without forcing the technical details about the data. There are various data visualization tools as software for visualizing data. Each tool has a different function, but basically it allows data scientists to input a dataset and depict it visually. kind of these tools are:
- Google Charts
- Tableau
- Zoho Analytics
- Datawrapper
- Infogram
- Power BI
- Preparing the data
In this report, to visualize the fashion dataset, PowerBI was used. in this regard, in the PowerBI desktop, after creating new project by clicking on ‘Get Data’ on welcome window or home tab, the structure of dataset (CSV) was selected and then it was opened to show the template and data .
Figure- import data into PowerBI - Visualizing the data After selecting dataset to be loaded, one new column, called ‘rate’ was generated. In this column the integer value of rate was kept .
Figure- create rate column
After loading dataset into the PowerBI, in each sheet, one or more diagram was drawn as they are listed below: 1- A scatter chart, to show the relationship between average of rate and maximum price 2- A bar chart to depict the count of Occasions 3- A bar chart to show the count of sustainable types 4- A pie chart to show the count od closures 5- A funnel diagram to show the count of Body or Garment Size 6- A donate chart to illustrate the count of wash care types
Figure - PowerBI diagrams
7- A 100% stacked bar chart to show the count of product by Wash Care types and Occasion
8- A clustered column chart to illustrate the count of product per rates (1 to 5)
9- A treemap, to depict the diversity of using colours
Figure - PowerBI diagrams- series2
10- An area chart to show the comparison of maximum, average and minimum of price by brands
Figure - PowerBI diagrams- series3- Area Chart
11- A stacked column chart to show the counts of products per brand by their share of rates
Figure - PowerBI diagrams-series4 - Stacked column
12- A pie chart to depict the body or Garment size of all products 13- A Question & Answer box to prepare the facility for runtime queries 14- A word cloud map to show the popularity of brands
Figure 3- PowerBI diagrams- series5
Additionally, to have an advance depict, the tooltip was changed, to be shown when a brand could be passed as a parameter.in this tooltip, the brand title, count of products, distinct count of colour and average of rating were shown. Also, by a simple bar chart, maximum, average and minimum of the price of products for each brand were illustrated. However, a star card to show the rate of the brand was used.
Figure - PowerBI customised tooltip
To support this star card, a new calculated column, called ‘avg_rating_star_rating’ was created.
Figure - code to support star card 3. Publish the result Finally, the result was published in PowerBI web Version to have a better view of visualization:
