Level 1: Newcomer
0 points
Sign in to save your progress across devices.
Work in the tool while you explain your decisions.
Choose a role and level. Each interview has a new task, follow-up questions and a report that checks your work and your explanation.
Speak or type. Sign in to save your results across devices.
Questions are drawn from a bank of 36. Your report includes a skill breakdown and lessons to practice next.
Junior tasks cover the fundamentals. Mid and senior tasks add debugging, changing requirements and review decisions.
10 interviews
Clean the Dispatch ticket keys so repeated exports of a ticket can be consolidated. Keep Owner and Hours and describe the proposed key normalization.
Convert Rating to Decimal Number in Ratings. Inspect nonnumeric entries and explain a policy for sites whose score was not captured.
Reshape Capacity into one row per Site and month. Name the generated columns Month and Units and make Units numeric.
Add the owner from Directory to each Dispatch depot. Explain the intended join population before merging.
Combine the Dispatch and Late shipment files and summarize Packages by Carrier into Total packages.
Add a Margin rate column in Margin using Revenue and Cost. Explain how you would handle a product that has cost but no revenue.
Investigate the broken Dispatch calculation after Units was renamed. Explain where the dependency failed and how you would repair it.
Build Open units by Team from Dispatch. Explain which parts of the source you would reduce before grouping and why.
Compare Stock SKU keys with Master and prepare an audit output. Explain the population the auditor should see.
Normalize the grouped Roster sheet and produce Total hours per Team, retaining the staff whose team labels were blank in the source.
The Interview Hub is included in All Access. Choose a plan or sign in to your account to continue.