Data Visualization from ETL Process

 Practical 3: Data Visualization from ETL Process

Step1:

From Fields drag and drop the products_name on the canvas

Drop Unitsinstock in the same table

Step2:

Select the table on the canvas and click on the clustered column chart

Step3:

Place ProductName in axis

Place Unitsinstock in value

Step4:

Go to the settings – security – check the last box

Step5:

Right click on Unitsinstock and click sum

Step6:

Drag and drop ordersdate and total

Select line chart

Drag and drop the total from legend to values and the line chart will be generated

Step7:

Drag and drop shipcountry on the canvas