2024
Power BI dashboards for IT support and sales
Two dashboards on fictional data, one for 2016–2020 IT support tickets (agent performance and satisfaction) and one for sales and customer segmentation.
Problem
Measure IT support efficiency and sales performance.
Data
Fictional data: 2016–2020 IT support tickets (tickets, employees and agents) and retail sales with customers, products and inventory.
Method
A relational model across tickets, employees and agents, Power Query transformations and DAX measures.
Result
Agent performance, satisfaction and sales KPI panels, filterable by year, type and agent.
Stack
- Power BI
- DAX
- Power Query
Context
Course: Professional Practicum I · 2024