A few suggestions:
First define your business case. What do you want to show? "Rate, tenure and so on" is not much like a business case. Make an inventory of the different Questions you want to answer.
Then try to define how this business logic can be implemented. For example: for the calculation of Employee Tenure, what do you need and how do you calculate its value.
Then (and not least important), decide on your timeline. Will you report by month, by Quarter, by year, by week? How far do you want to go back? 2yrs? 5 yrs? 10 yrs? 100yrs?
Based on this case description, decide on what source tables you really need, and which ones you can throw out. Then try to merge the information in these tables. By simplifying your data model, your documents and objects will be easier to design & build.
Now, import the tables your really need in an empty QVW document. Once you get here, you will face the task of tuning your LOAD statements in order to create an efficient data model. That's where we can help with specific solutions for your problems.
Best,
Peter
