Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the different tables table with some common fields and wants to create model to analyse the data.
Table Structures are as given below:
And the related sample created data attached in Excel file with Sheet names as Tabeles, Can you please help me to create data-model with this, please put data-model QVW to get clear understanding.
TrainingItems-TABLE | ActionItems-TABLE | Percentage-TABLE | TrainingHours-TABLE | EnterpriseReport-TABLE | EmployeeTable-TABLE |
PlanCreatedDate | PlanCreatedDate | PlanCreatedDate | TransCompleatedDate | EmpID | Company |
EmpID | EmpID | EmpID | EmpID | Type | Division |
Name | Name | Name | Name | Title | SubDivision |
DivisionParent | DivisionParent | PlanProgress | DivisionParent | TrainingProvider | Section |
Division | Division | PlanStatus | Division | Score | ID |
PlanTitle | PlanTitle | UserManagerName | Status | FullName | |
PlanTrainItem | PlanActionStep | TrainingProvider | RegisteredDate | DoB | |
PlanTrainItem_Status | PlanActionStep_Progress | TrainingType | Session_Date | Date of Join | |
TrainingTitle | Grade | ||||
Training_ID | RoleNo | ||||
TranscriptStatus | RolneBand | ||||
UserStatus | PositionTitle | ||||
TrainingHours | Supervisor |
Attached source has data aswell.
Thanks,
Ravi