Blog

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?

Agrawal et al. argue that intuition and hypotheses are now less important. 

Which of the following illustrate situations that will/can benefit from better machine-based predictions? Select all that apply.

What is meant by saying that machines “learn” or machine learning?

You find that the predicted probability of needing a roadbike (your positive class) at a specific time and location is 25.6%. Assuming you can only store one type of bike at this location, what do you need to know to evaluate what type of bike you should choose? 

Running a SQL query changes the underlying data. 

What must you do to have Tableau always display on the screen a number/label associated with a particular part of your visualization (e.g., display the name of each section in a pie chart)?  

Which of the following are true regarding joins? Select all that apply.

What is nearly always paired in a visualization, per our lecture notes?