I need a VBA expert -- 2

Case: 1: File to be used: [login to view URL]

1. Consolidate all the three sheets into a database or excel, there might be some misalignment in column names or data within, you will have to take care of that while writing your code/query

2. Prepare a dashboard to show :

a. Number of Employees under each supervisor

b. Count of employees under each level

c. Split of employees by region/country

d. Any movement in employee count by month

e. Any metrics on new or old employees

3. Please add charts or metrics based on its relevance to the dashboard

Case: 2 => File to be used: [login to view URL]

The dataset is a text file with dummy payroll data. Although this is a small datasets sample, assume that it is a big dataset and this is a manual task for the Payroll team for every month.

Taking the size and frequency into consideration please perform the below tasks on the data:

1. Read the data using any of your preferred tool

2. Clean any unwanted columns/rows

3. Map the headers and data in the dummy file to a output template as explained below:

Dummy Txt file Output Template

EE Name EMP Name

RG HRS REG Hours

RG ERN : REG Earnings

OT HRS : OT Hours

OT ERN : OT Earnings

Any HRS code (such as 'HRS 3/4 PH', 'HRS 3/4 P3', 'HRS 3/4 P5', etc) The HRS codes should be mapped to this column: Other Hours Code

Any value in the respective HRS code (such as 'HRS 3/4 PH', 'HRS 3/4 P3', 'HRS 3/4 P5', etc): Other Hours Amount

Any ERN code (such as 'ERN 3/4 N', 'ERN 3/4 PH', 'ERN 3/4 P3', etc) :

Other Earnings Code

Any value in the respective ERN code (such as 'ERN 3/4 N', 'ERN 3/4 PH', 'ERN 3/4 P3', etc):

Other Earnings Amount

4. Exclude the remaining fields in the dummy file from the Output Template

5. As a final step use the output template file to create few meaningful visualization using Excel

Excel Visual Basic Xử lí dữ liệu Tableau Excel VBA

ID dự án: #29472705

Về dự án