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
