Elian Maycock

Elian Maycock

Data Analyst | Software Developer

View My Projects

About Me

Analytical and results-oriented Data Analyst with three years of experience leveraging SQL, Python, and data visualization tools to extract insights and drive decision-making. Skilled in data cleaning, analysis, and reporting, with a strong ability to translate complex data into actionable insights. Proven track record in improving data accessibility and reporting efficiency, and adept in using visualization tools to support data-driven strategy.

Skills

SQL
Python
Tableau
Excel
Machine Learning
Data Visualization
Data Cleaning
Statistical Analysis

Projects

Bike Sales Data Analysis

This project involved cleaning, analyzing, and visualizing a bike sales dataset...

Key tasks included removing duplicates, handling missing values, and creating a dashboard that provides insights into bike purchases across various age groups, income levels, and commute distances. The final product is an intuitive, interactive dashboard that highlights key trends in customer behavior.

View Project

Vehicle Data Analysis and Dashboard

This project analyzes a vehicle dataset using Python and Tableau...

After cleaning and transforming the data with Python and Pandas, I created an interactive dashboard in Tableau to visualize key metrics such as vehicle make, model, year, quantity, location, and MSRP. Additional metrics like battery type, battery range, and type of fuel were also analyzed, providing insights into vehicle energy efficiency and market trends.

View Project

T-Shirt & Hoodie Sales Data Analysis and Visualization

This project analyzes and visualizes sales data for t-shirts and hoodies.

By integrating and analyzing data from three distinct databases—Sales Data, Product Data, and Customer Data the project identifies valuable insights to help the company optimize profits and understand the value of its offerings. The workflow includes data cleaning, joining datasets, conducting detailed analysis, and building interactive dashboards to provide actionable insights.

View Project

Contact Me

If you’d like to connect, feel free to reach out via email or LinkedIn!