With growing demands and cut-throat competitions in the market, a Superstore Giant is seeking your knowledge in understanding what works best for them. They would like to understand their key indicators through a web dashboard to get started.
- You've been provided a dataset containing Superstore past years transactions
- The client wants to work on three main metrics:
- Total revenue (
revenue
) - Average revenue per order (
revenue_per_order
) - Number of unique customers (
customers_count
)
- Total revenue (
- The client wants to be able to check those metrics globally ("Total" filter)
- The client wants to check the metrics broken down by State (
state
) and by month of order date (order_date
)
Here is mockup of what it should look like:
- The sample dataset is provided in this repository
- There are some metadata provided, describing the attributes
Here is a snippet of what the dataset looks like
We expect your code to be:
- Maintainable: simple, clean and easy to understand
- Performant: it must be production-ready. Pay attention to your SQL queries, consider the complexity of your algorithm
🎁 Bonus points for:
- Tests (well, we did say "production-ready")
- Applying OOP best practices
- Add a second primary dimension
year
(as a select) and display the evolution from N-1 on each metric
We ask you to package your repository as a Git bundle before sending it back to us. Here is how to do it.
cd
into your code directory.- Run
git bundle create memory-test.bundle HEAD master
(use your branch name if it differs frommaster
). - Finally, send us the
memory-test.bundle
file you just created at step 2.
Thanks for taking the time interviewing at Memory!
Good luck! 💪