This project demonstrates a structured approach to modeling operational IT data using a star schema design. The goal is to transform raw operational system data into a structured format suitable for reporting and analytics.
The model is based on a typical IT operations environment, where user activity, system usage, and incident data are captured and analysed to support decision-making.
- Design a dimensional data model for IT operations
- Structure raw operational data into fact and dimension tables
- Enable reporting and analytical use cases
- Apply star schema principles in a practical scenario
- fact_it_operations
- dim_user
- dim_department
- dim_date
- dim_system
- dim_incident_type
- SQL
- Data Modelling (Star Schema Design)
- Relational Database Concepts
- Dimensional modelling
- Fact vs dimension design
- Data normalization concepts
- Operational reporting structure
This model supports analysis of:
- System usage patterns
- User activity trends
- Incident and support tracking
- Operational efficiency metrics
A structured, scalable data model that transforms operational IT data into a format suitable for reporting and analytics.
Hlekane Ngobeni – IT & Data Professional transitioning into Data Engineering