Please use Elixir and/or Phoenix to complete the test. We would like a rough estimate of how long this task took you, but we would much prefer you submit something you are proud of and can easily talk about, rather than something done quickly.
The exercise requires you to build a simple web application which fulfils the following criteria:
- Ingests a few simple CSV files - Use the URL here to access the open Police Data website. Use the Downloads section to create a reasonable sized data set in the order of 50k-100k rows, which should download in the form of a folder containing several CSV files. We recommend you stick to one police force, and somewhere between 6-9 months; bear in mind that this will be thousands, if not tens of thousands of rows. You should import the generated CSV files into a database of your choice, and store them however you see fit.
- Shows the data on a page - Create a simple page in your framework of choice that we can visit to view the data in a reasonable manner. Do not worry about fancy styling or layouts - this is not what we are trying to assess.
- Allow simple sorting and filtering - Create a way to sort the data by one of the fields, and also filter them using some mechanism. What you choose to search or sort on is up to you; all we would like to see is your approach.
- Shows an understanding of unit/integration testing - Show that you are familiar with TDD (test-driven development), and show us an example of how you would choose to test your implementation.
Do not worry about:
- Styling or layout