HR Dashboard - Excel Dashboard

Task and Problem

The HR Manager need a way to track HR Records and identify some employee segmentation and some statistics such as department, position, gender, age, etc.. to get overall understanding about manpower details of a company at a glance. All you've given is 4 raw worksheet, containing HR Data, Position Lookup, Department Lookup, and Manager Lookup. You are expected to process dirty data to clean data and submit to your teammate (Senior Data Analyst). Your task also includes for Exploratory Data Analysis (EDA), Data Viz, and provide data-driven insights.