Business Analytics Project · Advanced · 4 to 6 hours · VIP
Scope and prepare a promo effectiveness study
The founder wants to double promo spend. Your job is to frame the question correctly first: attributed vs incremental revenue, ROAS traps, and the selection bias hiding in who uses codes.
The brief
Sigla Active sells athleisure across its website, Shopee, TikTok Shop, and Lazada. The founder is about to double the discount-code budget and asks you: 'Are the promos working?' You are the analyst scoping and preparing the study. The danger here is not dirty data, it is a dirty question. Attributed revenue is not the same as incremental revenue, a free-shipping code is not comparable to a percent-off code, and the people who use promos are not a random sample of buyers. You join orders to campaigns, prepare an honest table, and, most important, tell the founder what a clean answer would actually require before a single peso more is spent.
Your role
You are the analyst scoping the promo study. Deliverable: an analysis plan that defines the metric and its limits, a prepared orders-plus-campaigns table, and a clear statement of what a causal answer needs.
The datasets
720 orders (Jan to Jun 2026); promo_code is blank when no code was used
ba-promo-orders.csv · 720 rows
Columns: order_id, order_date, customer_id, channel, gross_amount, discount_amount, net_amount, promo_code, customer_type
Five discount campaigns with their spend and run dates
ba-promo-campaigns.csv · 5 rows
Columns: promo_code, campaign_name, start_date, end_date, spend
Setup
- Download both files. Keep the raw copies and add a prep-log tab.
- Write the decision the founder faces (spend more on promos or not) and the metric that would actually inform it.
- List your assumptions about attribution before you compute anything.
VIP project
The full brief for this Business Analytics project is for VIP members
The first Business Analytics project is free for every member. The dataset, the tasks, the answer key, and the graded skills check for this one are part of the VIP tier, along with the other 8 locked projects. 5 projects stay free, one for each tool, so you can try every tool before you decide.
VIP access comes with the bootcamp. Enroll once, and every locked project opens, alongside the live sessions, the replays, and the certificate.
Work like an AI-powered analyst
The modern analyst uses AI as a thinking partner, not a shortcut that skips the learning. Try these on this project.
- Ask ChatGPT or Claude to explain the difference between attributed and incremental revenue using your exact numbers, then write the one sentence you would tell the founder.
- Describe the free-shipping code to the AI and ask why its 13x attributed ROAS is misleading next to a percent-off code.
- Have the AI design the simplest holdout experiment Sigla Active could run next quarter to actually measure promo lift.
Finished it? Put it in your portfolio.
This is exactly the kind of output the bootcamp builds with you live, with mentor feedback and an AI badge and certificate of completion at the end.