Reporting on new model

[rngadam]

context

Been working on a new model schema in:

https://github.com/coderbunker/timesheet-backend/tree/report-201803

Currently completing import of data from snapshot -> incoming.

Once finished:

• will push to the cloud
• create an encrypted dump and share it

preparation tasks

• [x] install DBeaver
• [x] install PostgreSQL
• [x] doing: read up the PostgreSQL 10 documentation (get PDF)
• [x] doing: do some basic SQL exercises DBeaver -> PostgreSQL

data analyst toolboxs

• [ ] doing: Terminal bash: https://www.datacamp.com/courses/introduction-to-shell-for-data-science
• [ ] DbVisualizer Pro / DBeaver
• [ ] Git and GitHub
• [ ] Google Analystics
• [ ] Datetime/TimeZone/TimeStamp/Timedelta (.pytz)

once dump is ready:

• [x] restore dump to local database
• [x] denormalize model (join all entities together on model.entry)
• [ ] start writing additional reports and analysis + visualization

Base on the directions and questions given by Ricky and Fred:

• analyse coderbunker data following my own instincts
• report my progress regularly on "Coderbunker Residents"
• hopefully can publish reports like "Date Since Entry" and "Freelancer hours"
• invite feedback from Ricky, Fred and others

analysis tasks

• [x] reproduce "organization", "person" and "project" on python for practice
• [ ] reproduce and improve "Date Since Entry" on python for practice
• [ ] produce "Frequency of Entry" for A/B test after implementation of calendar
• [ ] produce data visualization and possibly written report on "person" and "project"
• [ ] keep answering the questions below with analysis + visualization + written report

questions

• create a view of each individual timesheet across projects
• freelancers activity on project - who's not contributing actively in the last week?
• delays in payments? currently up-to-date retainers?
• matrix last reported entry projects / freelancers

[rngadam]

You can find a denormalized version of the data in model.timesheet (all tables joined together into a view).