HR Analytics & Workforce Dashboard

1. Bike Sales Dataset — Bike_Sales.xlsx

The project focused on cleaning and preparing mountain bike sales data for December 2021. The dataset contained inconsistencies in country names, missing values, invalid prices, and duplicate records. Using Power Query, the data was cleaned, corrected, and validated to ensure accurate sales, cost, revenue, and profit calculations.

2. Electronics Laptop Prices Dataset — uncleaned_electronics_Price.xlsx

This project aimed to transform raw laptop pricing data into a reliable, analysis-ready dataset. The data contained duplicate and empty rows, inconsistent formats, missing values, and combined technical specifications. Power Query was used to clean the data, standardize measurements, separate product specifications, and structure the information for meaningful analysis.

3. Online Courses Dataset — online_courses.xlsx

This project involved cleaning and organizing online course data to make it suitable for analysis. The dataset included inconsistent categories, missing values, duplicate records, formatting issues, and combined course details. Power Query was used to standardize text, convert ratings and reviews into numerical values, extract course attributes, and improve overall data quality.