RAFAŁ KARPOWICZ

Performed exploratory data analysis on ~49,000 Airbnb listings in New York City to uncover insights on pricing trends

• Exploratory data analysis of ~49,000 Airbnb listings in New York City
• Executed data cleaning, handled missing values, and analysed outliers to enhance data quality for further analysis
• Analysis of the impact of neighbourhood and room type on pricing
• Created data visualisations using Python, Matplotlib, and Seaborn to effectively communicate findings and trends

Designed data models using a star schema to optimise query performance

• Developed DAX measures for year-to-date, year-over-year, margins, and rankings, enabling comprehensive performance insights
• Created Power BI and SSAS Tabular models for Adventure Works, enhancing data accessibility for analysis
• Interactive Power BI reports

Conducted data preprocessing and feature analysis to enhance model accuracy

• Compared performance of machine learning models, including Random Forest, XGBoost, and KNN, to identify optimal predictive approach
• Developed machine learning model for rainfall prediction
• Analysis of weather data stored in SQL Server

• Performed selection and engineering calculations of industrial automation components, including electric motors, servo drives, pneumatic systems, sensors, and actuators to ensure project specifications were met
• Designed machinery and automated production lines to optimise processes in FMCG industry
• Collaboration with electrical engineers, automation engineers, and the production department to implement projects
• Participation in commissioning and prototype testing during project implementation
• Prepared technical documentation in compliance with applicable standards to support project implementation