You need to compute “days since last purchase.” purchase_date is currently a string like “2025-09-14”. Which of the following is the best first step?
Blog
A VP wants a table with: rows = region, columns = quarter, v…
A VP wants a table with: rows = region, columns = quarter, values = total revenue. Which of the following provides the best approach?
Using the same model: revenue = 12,000 + 4.5 * ad_spend Wha…
Using the same model: revenue = 12,000 + 4.5 * ad_spend What is the best interpretation of the intercept (12,000)?
A dataset of customer orders has 50,000 rows. The discount_c…
A dataset of customer orders has 50,000 rows. The discount_code column is missing for 70% of rows. What is the most business-appropriate initial action?
A histogram of order_value shows most orders between $10–$80…
A histogram of order_value shows most orders between $10–$80, but a long tail reaching $1,500. Which of the options provides the best interpretation?
Your transaction table should have one row for each combinat…
Your transaction table should have one row for each combination of order_id and line_item_id. In other words, multiple rows can have the same order_id, and multiple rows can have the same line_item_id; but no two rows should have the same order_id and the same line_item_id. What is the best check?
A 6.0 kg object traveling East at 18 m/s collides elasticall…
A 6.0 kg object traveling East at 18 m/s collides elastically with a 3.0 kg object traveling West at 24 m/s. What is the speed of the 6.0 kg object after the collision?
What does “last-mile delivery” refer to?
What does “last-mile delivery” refer to?
On LinkedIn, employee engagement (likes, comments, shares) c…
On LinkedIn, employee engagement (likes, comments, shares) can help increase a company’s content visibility.
On Snapchat, content disappears after a set time, which crea…
On Snapchat, content disappears after a set time, which creates urgency for users to view it quickly.