+254 704 052992

Data Preparation

Data_Set: cust_prod_details.xlsxDownload cust_prod_details.xlsx

Data_Source: Tableau course: Download practice datasets (2018, Dec 03). In SuperDataScience.

Load the Amazon_Order_Data into the Tableau desktop & perform the following on respective data tables and save it.

  1. (2 points) Change the Order ID Column name to OID (Order_Breakdown).
  2. (2 points) Convert the datatype of profit from Number (whole) to Number (decimal) (Order_Breakdown).
  3. (2 points) Split the Order ID with default (-) (Order_List1).
  4. (2 points) Convert the Ship Date datatype from Date to Date&Time (Order_List1).
  5. (2 points) Convert the Order Date datatype from Date to String. Then, split it & rename those columns accordingly (Order_List1).

Save the workbook as M2AQ1.twbx.

Question-2: (10 points)

Load the Amazon_Order_Data into the tableau desktop & perform the following.

  1. (2 points) Construct a right join between Order_List1 & Order_Breakdown and save the workbook as M2AQ2_1.twbx.
  2. (2 points) Construct an inner join between Order_List2 & Order_Breakdown and save the workbook as M2AQ2_2.twbx.
  3. (2 points) Construct a union between Order_List1 & Order_List2 and save the workbook as M2AQ2_3.twbx.
  4. (4 points) Construct a relationship between Order_Breakdown & Order_List1 with many to many cardinalities and a relationship between Order_Breakdown & Order_List2 with one to many cardinalities and save the workbook as M2AQ2_4.twbx.

  5. This is to be done in Tableau
admin