Abstract: In this Data analysis project, the three main objectives of data analysis • Data Cleaning • Data Analysing • Data Visualization/ Presenting The above objectives include the following learning: • To approach a data analysis project, systematically clean data, doing Exploratory Data Analysis (EDA) with excel formulas and tables, use Power Query to combine two datasets, statistical Analysis of data. • Dashboard Creation: Insert slicers to filter data dynamically. Slicers provide interactive controls that allow users to easily filter data based on criteria such as department, location, or job title. Set up a mechanism to update data automatically or manually to ensure the dashboard reflects the latest HR information. Test the dashboard functionality and usability thoroughly. Gather feedback from stakeholders to refine and improve the dashboard based on their needs and preferences.
Read full abstract