Projects
Capstone projects
Finance at a small online shop
Close the month for an online shopFinance closes the month from three exports: order lines, customer master data and payments. Last month's report double-counted refunds and dropped orders from customers who signed up late.
4 graded checkpoints · about 2 hours
Customer operations after a platform migration
Merge the CRM and the web shop customer listsThe company moved its web shop to a new platform. Customers now exist in the CRM and in the shop with different ids, inconsistent emails and spelling variants of names.
4 graded checkpoints · about 1.5 hours
Customer support leadership
Prepare support tickets and surveys for a dashboardSupport leadership wants a dashboard of tickets by channel and satisfaction scores per question. Channels are typed by agents, and the survey export has one column per question.
4 graded checkpoints · about 1.3 hours
Purchasing at a retail chain
Validate a supplier inventory feedA supplier sends weekly inventory files with quantities, prices and country codes, plus monthly files that have changed format twice this year.
4 graded checkpoints · about 1.5 hours
Operations team monitoring field devices
Quality report for device readingsField devices send timestamps, some without an offset, and monthly meter readings where a missing month and a zero reading look alike in the current dashboard.
3 graded checkpoints · about 1.5 hours
Data science team predicting customer churn
Build a leak-free training table for a churn modelThe data science team's last churn model looked excellent offline and failed in production. Review found that gaps were filled with statistics computed on all rows, extreme but real values were deleted, and dates were parsed with the wrong day/month order for UK customers.
4 graded checkpoints · about 2 hours
Finance reconciling billing and the data warehouse
Reconcile subscription revenue across systemsThe warehouse revenue total is higher than the billing system's. Order lines were re-sent with new versions, account updates arrived from several systems, some payments reference unknown accounts, and amounts in different currencies were added together.
4 graded checkpoints · about 2 hours
Marketing team sending a product announcement
Prepare a consented audience for an email campaignMarketing wants to send an announcement to opted-in members in two segments. The member export has padded emails, opt-in answers in many spellings, customer keys that are blank for some orders, and regions left empty.
4 graded checkpoints · about 1.5 hours