Fix the export before Monday's review
The brief
Haldi & Co., a skincare brand that sells online, has an investor review on Monday. Its analyst has left, and the founder has the quarter's order export: website and WhatsApp orders together, with the problems real exports have.
Clean it so the numbers can be trusted, keep a log of every problem you find, and answer the founder's five questions. Your file is your own: nobody else has the same one, so the answers are yours to work out.
Use whatever you like: Excel or Google Sheets, SQL, or Python.
When you start, you get the company's files to download, made for you: nobody else has the same numbers.
What to hand in
- Your five answers, in the boxes on this page
- An issue log: each problem, how many rows it touched, and what you did about it
- The cleaned file, and your steps or script, so someone else could do it again
- A short note to the founder on what she can and can't trust
You hand it in as a project on Wooble: what you made, shown working, and a written account of how you made it. A link on its own is not enough.
Free, and always open. Start when you like and hand in when it is ready.