Blog

If you want to identify which customers do not have orders, you should use an inner join. 

What delimiter is recommended by the AICPA in its Audit Data Standards as a preferred delimiter for files provided to auditors?

There are several ways to administer an SVN treatment to a patient. Which way is NOT recommended for any patient population?

Which of the following statements regarding unique identifiers are true? Check all that apply. 

When using the Summarize tool, only one variable can be designated as the “group by” variable.  

What are various ways the the data cleanse tool can be used within Alteryx? Select all answers that apply. 

In ICE #9, If we “full join” KMPG’s Sales Order file with Shipments file using Sales Order ID, we keep the records (observations) that are only in both Sales Order file and Shipments file.

In the KPMG revenue case (ICE #9), we first filtered observations for shipments made in 2017 and the “aggregated” sales transactions by TerritoryID, Shipping Month, and whether the sale is related to the new product (#7123).  We then outputted this data as a csv file. The grouped data has 5*12*2 = 120 observations.

In ICE#9 “join4” we combine the join3 table and the customer master table using the variable CustID and an inner join. This results in a table with 1,168 observations. If we instead link this tables using a left join and the TerritoryID variable, we get a table with 18,937 observations. This increase in observations happens because TerritoryID does not uniquely identify observations in the customer master table. 

What information would be helpful (and feasible) in predicting how well a sports team will do during the upcoming season?