Contact person: TOPdesk Dashboard Revamp & Visualization Upgrade

Phone:Show

Email:Show

Location: Cuiabá, Brazil

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"I have a partially functional dashboard built with Streamlit that connects to the TOPdesk REST API to display selected KPIs such as operator productivity, SLA compliance, and incident trends.

While the current implementation covers core functionality, it lacks the completeness, user experience, and reporting depth that my support team needs. Several additional features still need to be developed, especially broader API integration to fetch more fields, ticket types, and metrics from TOPdesk.

I’m looking for a skilled Python developer to:
• Extend the current API coverage
• Enhance the visual interface and data exploration experience
• Build a more robust reporting layer
• Ensure the system is scalable, maintainable, and ready for production use


What I Need:
1. Revamp the interface for usability and responsiveness
The new UI should offer better navigation, full accessibility, and mobile responsiveness. Whether that means polishing the existing Streamlit layout or migrating to Dash, Django, FastAPI with React, or another modern stack is up to you. Choose a framework that’s fast to develop, scalable, and maintainable.
2. Upgrade the visual layer
I want dynamic, interactive dashboards with:
• Drill-down charts
• Time range sliders
• The ability to switch between chart types
If replacing Plotly or Matplotlib with ECharts, Bokeh, Altair, or other modern libraries improves performance and usability, I’m open to it.
3. Improve reporting functionality
• Add advanced filtering and search: category, priority, operator, and custom TOPdesk fields
• Allow saving/exporting of reusable report templates (e.g., “Weekly SLA Snapshot”, “Monthly Operator Report”) to Excel and PDF
• Provide UI for generating on-demand or scheduled reports
4. Maintain and enhance current API integrations
The system already:
• Authenticates to TOPdesk via HTTP Basic Auth
• Handles paginated responses
• Caches results
Your updates should preserve or improve these mechanisms, with an eye toward performance and robustness.
5. Deliver clean, production-ready code
• Well-structured, modular Python code with comments
• A simple setup guide (Docker or venv-based)
• A short demo (screenshots or video) of key workflows
• Automated tests for data fetching and KPI calculations (optional, but preferred)


Current System Highlights:
• Authentication via Azure AD (Microsoft Entra ID) using MSAL
• Integration with TOPdesk REST API (HTTP Basic Auth)
• Interactive dashboards using Streamlit
• Visualizations created with Plotly, Matplotlib, and Seaborn
• Report export to Excel (xlsxwriter) and PDF (pdfkit)
• KPI generation for:
• SLA breaches
• Resolution time
• Operator efficiency
• Idle incidents
• Integration with SharePoint Online to display project data
• Modular design using .env, dotenv, and other environment-based configurations


Code Architecture and Key Modules:

[login to view URL]
• Handles Azure login and user session
• Maps the authenticated email to a TOPdesk operator
• Generates operator avatars (hashlib + Pillow)
• Manages session with st.session_state

[login to view URL]
• Hosts multiple dashboard tabs with visualizations
• Tracks incident creation and resolution by date and operator
• SLA monitoring and performance rankings
• Uses @st.cache_data(ttl=60) to improve API performance
• Graphs rendered with Plotly, Matplotlib, and Pandas

[login to view URL]
• Generates custom reports and data exports
• Builds operator-level KPI summaries and SLA alerts
• Creates Excel files with multiple sheets and PDFs via pdfkit
• Uses helper functions from [login to view URL] like:
• listar_mudancas()
• correlacionar_incidentes_mudancas()
• normalizar_mudancas(), and more


Scope of Work:
1. Review and refactor the existing codebase
2. Standardize project structure and modularization
3. Implement new features, such as:
• Advanced filtering (by category, urgency, impact)
• Automatic report email delivery
• Comparative dashboards by team or group
• Fully responsive/mobile-friendly interface
4. Improve performance and security
5. Deploy the system to a secure HTTPS-enabled environment with updated documentation

You are encouraged to suggest architectural improvements or complete redesigns as long as the current functionality is preserved or enhanced.


Required Technical Skills:
• Python 3.8+
• Streamlit or equivalent (Dash, Flask, FastAPI, Django)
• Pandas, Plotly, Matplotlib, Seaborn
• REST API integration using requests
• Azure AD (MSAL) authentication
• SharePoint Online and Office365 API (office365-rest-python-client)
• Report generation (xlsxwriter, pdfkit, or equivalents)
• Secure configuration with .env and dotenv


Deliverables:
• Clean, modular Python codebase with inline documentation
• Separation between data, logic, and UI layers
• Setup and deployment documentation (basic or Docker)
• Basic user documentation for internal users
• Optional: CI/CD pipeline or deployment automation


Preferred Qualifications:
• Experience working with the TOPdesk API
• Experience migrating or modernizing Streamlit dashboards
• Familiarity with Power BI Embedded (for future integration)
• Understanding of SRE practices and ITSM reporting standards


Timeline:
Target delivery: 3 to 5 weeks, with optional weekly check-ins or progress updates.


Notes:
• The current system is partially functional and actively used internally.
• You are free to reuse, expand, or rebuild the codebase based on your technical recommendations.
• You may change the web framework and visualization libraries if that improves performance, maintainability, or UX." (client-provided description)