Forum Discussion
Utilization Data
Hello amaasen,
Could you elaborate a little bit more about what you're exactly you're trying to achieve? In my organization, we have done something similar to what you're trying to achieve. A couple things for you to consider:- Time vehicles are available (e.g. are vehicles only available 8a - 5p every day? 24hrs a day?)
- Calculate all time(s) a vehicle is booked
- Utilization rate (Booked time / Available time)
You can consider building your model along the STAR schema guidelines, where you have your main fact table (vehicle booking times), a date(/time) dim table, and a vehicle dim table.
This should get you started, but let me know if there's more you're hoping to achieve
Hello amaasen,
Could you elaborate a little bit more about what you're exactly you're trying to achieve? In my organization, we have done something similar to what you're trying to achieve. A couple things for you to consider:
- Time vehicles are available (e.g. are vehicles only available 8a - 5p every day? 24hrs a day?)
- Calculate all time(s) a vehicle is booked
- Utilization rate (Booked time / Available time)
You can consider building your model along the STAR schema guidelines, where you have your main fact table (vehicle booking times), a date(/time) dim table, and a vehicle dim table.
This should get you started, but let me know if there's more you're hoping to achieve