Icon

03 Data Visualization - Solution

Data Visualization


Learning objective: In this exercise, you'll practice data visualization.


Workflow description: This workflow expands the analysis started in the previous workflow. Creates a heatmap to show the data quality measures and produces an interactive dashboard to inspect the products.


You'll find the instructions to the exercises in the yellow annotations.

Step 1. Heatmap for data quality

  1. Open the components Overview Heatmap and complete the steps.

  2. Have a look at the view generated by the Detailed Heatmap component for the breakdown of the data quality by product category.



Handle missing values, rename and sort

The products with missing price are removed. If the brand is missing, it is replaced with the value N/A. These nodes also rename the columns and sort the rows by rating and price.

Extract values from the Product table

The nodes in this section process the product table to to extract some values from the strings, such as the product number, price, rating, etc..

Review Date and Country

The Expression node parses the Review Date and Loc column to extract the date and location of each review and store them in single columns. The Review Date is then processed to obtain a string with the yyyy-mm format.

Review Score and Review Length

The Expression node contains the expression to extract the Review Score from the string. Additionally, it creates a new column containing the review length.

Outliers handling

These nodes removes the rows with outlier values in the Price and Review Length columns respectively,

Step 2. Dashboard

Open the component and complete the steps to create an interactive dashboard and a report for the product analysis.



Sort by ratingand price
Sorter
Overview Heatmap
Extract ASINfrom Link
String Replacer
Detailed Heatmap
Product reviews
Excel Reader
Column Renamer
Parse Price
Expression
Extractyear and month
Date&Time Part Extractor
Regex extract:Review CountryReview Date
Expression
Price by category
Box Plot
Regex replace: Category,Rating, Global_Ratings
Expression
Remove outliersin Review Length
Numeric Outliers
Data Quality Profile
Data visualization
Product details
Excel Reader
Concatenateyear and month
Column Aggregator
Data Quality Profile
Remove rows with missing priceFill missing Brand with N/A
Missing Value
Domain Calculator
Review ScoreReview Length
Expression
Remove outliersin Price
Numeric Outliers
String to Date&Time

Nodes

Extensions

Links