This project is an enterprise-style IT Asset and Incident Management system built using MySQL and Power BI.
The goal of the project is to simulate how organizations monitor IT assets, track incidents, and analyze operational issues through dashboards and reporting.
The dashboard provides insights into:
- Total incidents
- Open vs resolved incidents
- Incident severity trends
- Asset allocation and status
- Most common incident categories
This project was created as part of my data analytics and IT support portfolio to demonstrate practical skills in SQL, database design, data modeling, and Power BI dashboard development.
- MySQL
- SQL
- Power BI
- Data Modeling
- Data Visualization
The system uses four connected tables:
Stores employee information.
Stores IT asset details such as laptops, printers, routers, desktops, and servers.
Tracks which asset is assigned to which employee.
Stores incident records related to IT assets including severity, issue type, and incident status.
- Relational database schema design
- Realistic enterprise-style sample data
- Incident tracking analytics
- Asset lifecycle monitoring
- KPI dashboard reporting
- Interactive Power BI visuals
- Incident severity analysis
- Asset status distribution
- Monthly incident trend reporting
The dashboard helps identify:
- Critical incident patterns
- Open incident workload
- Asset health and maintenance status
- Most frequent issue categories
- Overall IT operational efficiency
IT-Asset-Incident-Management-System/
│
├── SQL/
│ ├── create_tables.sql
│ ├── insert_data.sql
│ ├── analyst_queries.sql
│
├── Dashboard/
│ ├── IT_Asset_Incident_Dashboard.pbix
│
├── Dataset/
│ ├── employees.csv
│ ├── assets.csv
│ ├── allocation.csv
│ ├── incidents.csv
│
├── Screenshots/
│ ├── dashboard_preview.png
│
├── README.md
Examples of analysis performed in this project:
- Total incidents count
- Open vs resolved incidents
- Incident severity distribution
- Asset status tracking
- Top incident categories
- Monthly incident trends
Harsh Basrani