Time and Labour Productivity Analysis - Dimensional Design Needed
Page 1 of 1
Time and Labour Productivity Analysis - Dimensional Design Needed
Hi,
I have a table which holds employee log-in and log-out time and have transaction table which keep all the transactions what they made with respective time. Transactions can been made during office hours say(9 AM to 6 PM) can be named as working hours and after 6 PM can be marked as non-working hours.
I have following dimension/Fact tables
Employee Table - Holds Employee Detail like Name, Ph, ID, Email, State
Employee Access Table - Holds History of Login/Logout
Employee Holiday Table - Holds Employee Vacation Schedule
Holiday Table - Holds data with respective to state where employee located.
Transaction Table - Holds transactions what he made during time period.
I want to calculate how many transactions have been made during working hours and non-working hours.
How can I design a dimensional model based on the above requirement.?
Please help me here.
Regards,
Rajkumar
I have a table which holds employee log-in and log-out time and have transaction table which keep all the transactions what they made with respective time. Transactions can been made during office hours say(9 AM to 6 PM) can be named as working hours and after 6 PM can be marked as non-working hours.
I have following dimension/Fact tables
Employee Table - Holds Employee Detail like Name, Ph, ID, Email, State
Employee Access Table - Holds History of Login/Logout
Employee Holiday Table - Holds Employee Vacation Schedule
Holiday Table - Holds data with respective to state where employee located.
Transaction Table - Holds transactions what he made during time period.
I want to calculate how many transactions have been made during working hours and non-working hours.
How can I design a dimensional model based on the above requirement.?
Please help me here.
Regards,
Rajkumar
rajkumar_n- Posts : 1
Join date : 2014-10-30
Age : 37
Location : India
Similar topics
» Time dimension design for cross time zone and custom calendar warehouse, 1min granularity
» Dimension Modeling Design challenge - Help Needed
» Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
» Kimballs design Tip#51 - Time Dimension
» ETL Design Problems for Real time
» Dimension Modeling Design challenge - Help Needed
» Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
» Kimballs design Tip#51 - Time Dimension
» ETL Design Problems for Real time
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum