Objective: To consolidate and prepare employee data from multiple Excel files for analysis in Tableau.
- Data Acquisition:
- Downloaded three Excel files from Tableau Public:
- "Employee names"
- "Employee data"
- "Employee travel responses"
- Downloaded three Excel files from Tableau Public:
- Data Preprocessing:
- Utilized data preprocessing techniques to:
- Clean and standardize data within each Excel file.
- Merge or join the data from the three Excel files based on common identifiers (e.g., employee IDs).
- Transform data into a suitable format for Tableau analysis.
- Handle any inconsistant data.
- Create any calculated fields, if needed.
- Utilize concepts like joins, unions and relationships to combine multiple data sources into one single source for enhanced analysis.
- Utilized data preprocessing techniques to:
- Data Consolidation:
- Created a single, consolidated dataset containing:
- Employee IDs
- Employee names
- Hire dates
- Country
- State
- Zip Code
- Other relevant employee information.
- Created a single, consolidated dataset containing:
- Data Output:
- Saved the processed and consolidated dataset in a format compatible with Tableau.
- Data Storage:
- The original source files and the resulting processed data have been attached.
- Employee IDs
- Country
- State
- Zip Code
- Employee names
- Travel survey responses
- Other employee related information
This project was completed as part of the Introduction to Tableau course on Coursera.