Skip to content

Inthememory/memory-tech-challenge

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

👩‍💻👨‍💻 Full-Stack Software Engineer Technical Test

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.

🎯 Your mission

  • 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)
  • 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:

dashboard mockup

💾 About the dataset

Here is a snippet of what the dataset looks likesnapshot

🧠 Guidelines

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

How to hand in the test

⚠️ Please, DO NOT host your project on public repositories! ⚠️

We ask you to package your repository as a Git bundle before sending it back to us. Here is how to do it.

  1. cd into your code directory.
  2. Run git bundle create memory-test.bundle HEAD master (use your branch name if it differs from master).
  3. Finally, send us the memory-test.bundle file you just created at step 2.

Thanks for taking the time interviewing at Memory!

Good luck! 💪

About

Memory Software Engineer Technical Challenge

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published