SQL to PowerBI Service Management Reporting
Budget: $3,000 – $5,000 AUD
I need an experienced freelancer to build service management reporting from our legacy in-house SQL platform into PowerBI. The reports need to be customer-specific (50+ individual customers), based on the products they consume.
Key Products to Report:
- Managed Network
- TC4
- Voice
Minimum Reporting Requirements per Product:
- Managed Network: ITSM Processes (INC/REQ/CHG/ORD), end-to-end network availability, capacity management, and network spend.
- TC4: ITSM Processes (INC/REQ/CHG/ORD), capacity management, and TC4 spend.
- Voice: ITSM Processes (INC/REQ/CHG/ORD), concurrent calls per month, call types, number of channels, and voice spend.
ITSM Processes to Include:
- Incident
- Request
- Problem
- Change
- Order
Specific ITSM Metrics:
- Incident Summary
- Incident Descriptions
- SLA Compliance
- Include metrics on the average resolution time for incidents and requests.
- Analyze incident trends over time to identify common issues and their frequency.
Ideal Skills and Experience:
- Extensive experience with SQL and PowerBI.
- Proven track record of building intricate, customer-level reports.
- Familiarity with ITSM processes and metrics.
- Strong analytical skills to ensure comprehensive and accurate reporting.
The reports should be refreshed monthly to meet specific needs. The reports should be tailored as both interactive dashboards and static reports to match specific requirements. The interactive dashboards should have a modern and sleek look.
The data visualization preference should be both tables and graphs.
The freelancer will be provided read-only access to the SQL database to extract the required data for the reports.
Key Products to Report:
- Managed Network
- TC4
- Voice
Minimum Reporting Requirements per Product:
- Managed Network: ITSM Processes (INC/REQ/CHG/ORD), end-to-end network availability, capacity management, and network spend.
- TC4: ITSM Processes (INC/REQ/CHG/ORD), capacity management, and TC4 spend.
- Voice: ITSM Processes (INC/REQ/CHG/ORD), concurrent calls per month, call types, number of channels, and voice spend.
ITSM Processes to Include:
- Incident
- Request
- Problem
- Change
- Order
Specific ITSM Metrics:
- Incident Summary
- Incident Descriptions
- SLA Compliance
- Include metrics on the average resolution time for incidents and requests.
- Analyze incident trends over time to identify common issues and their frequency.
Ideal Skills and Experience:
- Extensive experience with SQL and PowerBI.
- Proven track record of building intricate, customer-level reports.
- Familiarity with ITSM processes and metrics.
- Strong analytical skills to ensure comprehensive and accurate reporting.
The reports should be refreshed monthly to meet specific needs. The reports should be tailored as both interactive dashboards and static reports to match specific requirements. The interactive dashboards should have a modern and sleek look.
The data visualization preference should be both tables and graphs.
The freelancer will be provided read-only access to the SQL database to extract the required data for the reports.