To do this process, you will need to load the appropriate tables into Tableau. It is always a good idea to check the datatypes that each attribute is loaded as. For example, the Sales Order Date should have a calendar icon, indicating that this is a date field.

Q2A. If the Sales Order Datewas imported as a number, how might this cause a problem without ETL if we wanted to dig into the data by month, for example?

Q2B. Examine the datatype for Sales Order ID. What are the benefits of the datatype being imported as a text? Or a numerical field? Why will it not present a problem in our analysis to maintain this data as a text?

Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Insert Calibri (Body) 11 - = = ab General WA Ayuo 3 DX Delete v Paste B I U a-A~ V Ideas Conditional Format Formatting as Table Cell Styles Format v Sort & Filter Find & Select K10 fx A B D G H H L M N 0 P Q 1 Sales Order_ID Sales Order_Date 2 20001 2019/11/1 3 20003 2019/11/1 4 20005 2019/11/1 5 20005 2019/11/1 6 20009 2019/11/2 20012 2019/11/A Sales_Employee_ID Customer_ID 1006 2056 1006 2011 1006 2012 1006 2012 1006 2005 1006 2009 E F Product_Code Sales_Order_Quantity_Sold 2001 2006 2006 2001 2004 2005 Product_Sale_Price 10 95 8 90 9 90 8 95 3 105 1 85 7