Alam Ozuna's Work | ContraWork by Alam Ozuna
Alam Ozuna

Alam Ozuna

Building data stories that drive smarter business decisions.

New to Contra

Alam is ready for their next project!

Cover image for Executed a comprehensive data cleaning
Executed a comprehensive data cleaning process on a global layoffs dataset utilizing advanced SQL techniques, including Common Table Expressions (CTEs), window functions, and complex self-joins. Successfully eliminated duplicates, standardized data formats, and populated missing values to transform raw information into a highly reliable database ready for exploratory analysis.
2
9
Cover image for Developed a dynamic Tableau dashboard
Developed a dynamic Tableau dashboard to analyze extensive Airbnb listing data, visualizing key metrics such as pricing fluctuations, location profitability, and occupancy rates. This project utilizes advanced data visualization techniques to transform complex property datasets into actionable market insights for strategic real estate investment and property management.
1
12
Cover image for Designed an interactive Power BI
Designed an interactive Power BI dashboard analyzing survey data from data professionals to visualize global salary trends, tool preferences, and job satisfaction metrics. This project highlights proficiency in data modeling and DAX manipulation, successfully transforming raw survey responses into dynamic, actionable career insights for the industry.
1
14
Cover image for Engineered an interactive Excel dashboard
Engineered an interactive Excel dashboard analyzing the demographics of 1,000 potential customers to identify key drivers in bicycle purchases. The project involved rigorous data cleaning and pivot table segmentation to visualize sales trends and provide actionable insights for targeted marketing.
1
15