Business Intelligence Report (Database and visualisation expert) :)

Need an analyst to complete a quick job. The project will be awarded to the cheapest bidder (Bid wisely - budget is £40 - Higher than £50 will automatically be deleted). Below is the description. Computer Science Background preferred! Goal The goal of this is to visualise, reconcile, and analyze information from (Company ABC’s) reporting logs. To complete the challenge, we provide sample data extracts from one of (Company ABC’s) platforms, gathered during the period of 1 - 7 April 2019. A description of the data extracts can be found in a PDF file attached. The data comes from three different sources on (Company ABC), and can be used to partially reconstruct and reconcile user behaviour as they interact with the Company app. Your mission, should you choose to accept it… Given the data provided with this challenge, reserve three hours and work on the following: ● Visualization: Visualize each collection. Are there patterns that you can identify? Anything unusual or noteworthy? ● Reconciliation and analysis: Reconcile the data from the three collections. Which metrics can be reconciled between the collections? Do the collections reconcile with each other? Can you identify any issues? ● Metric formulation: Think about business metrics that can be derived from the data. What would make sense to have as core KPI metrics for Company ABC? How does Company ABC do on a daily basis for those metrics? Bonus challenge: Something strange happened with advertising during this week. Can you see any changes in user behaviour on ads specifically? What do you think may have happened? What we’re looking for As part of this challenge you should... ● Document your process as well as your outcomes. What tools did you use to process the data? ● Provide visualizations and concrete examples where appropriate to back up your assertions. ● Return the challenge as either a document, zip file, online presentation, or whatever you feel comfortable with, as long as it can be easily opened. ● Include your code if you used scripts, databases etc to complete the challenge Documents and database can be found: This is a THREE HOUR WORK however, I will need the presentation by Saturday so take your time if need be. Database links you will use [login to view URL] [login to view URL] [login to view URL] Instruction link [login to view URL] - Instructions with documents