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

• install DBeaver
• install PostgreSQL
• doing: read up the PostgreSQL 10 documentation (get PDF)
• 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:

• restore dump to local database
• 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

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