Instructions

Exercise

Create a dashboard of the average profit per ticket price from Simplyk's historical data. The columns needed for the table are described in Data (below). All the necessary data are retrieved in our dummy MongoDB database (there won't necessarily be a noticeable decrease of the average tip with the evolution of the ticket price, the data are test data). Ticket prices will be grouped in $20 increments, so all tickets costing between $1 and $20 will be on the first line, and so on.

The third column is calculated using bank charges and tips.

(Bonus: bank fees change over time. It would be interesting to be able to modify the 2.9% of the bank fees by updating the data, to make life easier for SDRs).

Data

• Bank fee per transaction: 0.30$ + 2.9% of the amount of the transaction,

• Interval of 20$

• Columns: Ticket price, Number of tickets in the historical data, Average net income (in %) which corresponds to the average net income (tip minus bank fees) per transaction

• The MongoDB credentials are: mongodb://applicant:[e-mail]:27017,cluster-l6prczn1-shard-00-01.tkkuc.mongodb.net:27017,cluster-l6prczn1-shard-00-02.tkkuc.mongodb.net:27017/heroku_l6prczn1?ssl=true&replicaSet=atlas-dk2tmq-shard-0&w=majority&authSource=admin