Python Dash with graphs and interactive table from SQLAlchemy

Starting point (where you will start your work): -) Working python app with pytest-tests on github repository Athos1972/Confluence-Task-Reporting (you need to have a github-user). -) pytest fills the database containing of 3 SQLAlchemy-ORM tables (Users, Tasks, Pages) Short description (more in Repository): App to crawl open tasks from Confluence, store in local database and provide various insights and follow-up activities on those tasks. Project scope: -) Check and understand readme -) Install the repository from github -) read [login to view URL] -) setup the app and run the tests -) Confirm app is working on your computer (by sending pytest results) -) Create Dash application showing: --) Button “Send reminder” --) 2 Dropdown-Filters (with callback) and multiple selections: for [login to view URL], [login to view URL] --) Filter “only overdue” as checkbox --) Based on the filter values: ---) Number of open tasks per space (see ctr.Reporter.task_count_by_space()) as bar graph sorted from lowest (left) to highest count (right) with different colours and name of space on hoovering over with the mouse ---) Number of overdue Tasks as Card ---) Average Age of Tasks as Card ---) Paged, filtered grid of a ORM-joined view of Task, Page und User with the following fields: Task.task_id, Task.task_description, Task.due_date, Task.second_date, User.display_name, [login to view URL], Page.page_name (hyperlinklinked to Page.page_link) with a Tick-box for the user to chose multiple entries from within the table. -) When the button “Send reminder” is clicked method ctr.Reminder.Reminder.send_reminders() shall be triggered with the chosen (Tick-box set) records from the grid. -) You’ll work in a separate branch, that will be created for you once you’ve been assigned this project. -) pytest test-coverage of your development branch must reach at least 80%. -) Classes, methods and source-code documented according to industry best practices Milestones: 1) 20% when you committed a pull request with updated [login to view URL] for Dash to Github. 2) 50% when you provide a first draft of the dash 3) 30% after testing the above mentioned scope and checks of the test-coverage as mentioned above. Other conditions: -) No payments outside of freelancer.com -) No pre-payments -) No change from hourly project to fixed price project after winning the bid -) Freelancers who can show proven experience (existing work with Dash and SQLAlchemy in their GitHub-account not forked AFTER creation of this project) have a high chance of winning. As a sign you read the message please use „DASH“ as start of the chat. Thank you and happy bidding!