Data Warehouse Schema Creation for Redshift
Budget: ₹400 – ₹750 INR
I need a professional who can help me develop skills in data cleaning, transformation, and schema design by organizing raw, fragmented data into a cohesive and valid data warehouse schema suitable for Redshift.
This project focuses on a fictional large clothing company that offers both discount and luxury brands of men's and women's clothing and accessories.
Key aspects of the project:
- Data Cleaning: This is the most critical aspect of the project. The selected freelancer will need to identify and rectify data quality issues such as missing values, duplicate entries, and incorrect data formats in the provided CSV files.
- Data Transformation: Following the cleaning process, the freelancer will need to transform the data into a format suitable for schema design and storage in Redshift.
- Schema Design: The final step involves designing a cohesive and valid data warehouse schema.
The ideal freelancer for this project should possess strong skills in data analysis, data cleaning, and experience in working with Redshift. Knowledge of Python or R for data manipulation would be a plus.
This project focuses on a fictional large clothing company that offers both discount and luxury brands of men's and women's clothing and accessories.
Key aspects of the project:
- Data Cleaning: This is the most critical aspect of the project. The selected freelancer will need to identify and rectify data quality issues such as missing values, duplicate entries, and incorrect data formats in the provided CSV files.
- Data Transformation: Following the cleaning process, the freelancer will need to transform the data into a format suitable for schema design and storage in Redshift.
- Schema Design: The final step involves designing a cohesive and valid data warehouse schema.
The ideal freelancer for this project should possess strong skills in data analysis, data cleaning, and experience in working with Redshift. Knowledge of Python or R for data manipulation would be a plus.