Q2A. If the Sales Order Data was 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?

A F G I I J 1 Sales Order ID 2 E Product Code 2004 Sales Order_Quantity_Sold 12 3 2005 4 8 7 2 8 8 9 3 7 10 11 3 2004 2002 2001 2004 2004 2004 2003 2003 2001 2005 2005 2006 2005 2004 2004 2005 12 B D Sales_Order_Date Sales_Employee_ID Customer ID 20062 2019/11/22 1007 2001 20168 2019/12/27 1007 2001 20383 2020/3/4 1007 2001 20564 2020/4/28 1007 2001 20140 2019/12/20 1006 2002 20310 2020/2/11 1007 2002 20308 2020/2/11 1006 2004 20009 2019/11/2 1006 2005 20233 2020/1/16 1006 2006 20163 2019/12/25 1006 2007 20224 2020/1/13 1006 2007 20199 2020/1/7 1007 2008 20291 2020/2/4 1007 2008 20451 2020/3/24 1006 2008 20012 2019/11/4 1006 2009 20494 2020/4/8 1006 2009 20537 2020/4/19 1007 2009 20250 2020/1/22 1006 2010 20251 2020/1/22 1007 2010 20003 2019/11/1 1006 2011 20241 2020/1/19 1007 2011 20253 2020/1/22 1007 2011 20005 2019/11/1 1006 2012 20090 2019/12/1 1006 2012 1 13 8 14 7 15 16 9 1 2 18 6 19 5 20 2004 11 8 21 22 23 2006 2004 2 2005 10 9 24 25 2006 2002 10 Sales