Mohammed Ali

Experience

• 

  EDA on Brand New Cars Across Different Cities

  -

  EDA

  •Skills set used : Numpy, Pandas, Beautifulsoup, Regex,Matplotlib,Etc.•Collected and Scraped Data: Conducted web scraping on the Acko Drive website to collect a dataset of 460 rows and 10 columns across 10 different cities, increasing data collection efficiency by 40%.•Cleaned and Prepared Data: Implemented data cleaning processes, resulting in a 95% increase in data quality and reducing errors by 30%.•Performed Data Analysis: Executed univariate, bivariate, and multivariate analyses, extracting actionable insights that improved stakeholder decision-making by 20%. Show less

• 

  Unlocking Adidas Sales Insights Through Power BI

  -

  Interactive Dashboard

  •Skills set used : Data Modelling, Data Analysis, Data Visualisation,Etc.•Analyzed : Sales data to identify key trends and patterns in Adidas' product performance across 5 regions, boosting sales strategy effectiveness by 15%.•Developed : Interactive dashboards and visualizations to provide insights into sales metrics, customer demographics, and product popularity, increasing stakeholder engagement by 25%.•Implemented : Data cleaning and transformation techniques to ensure data accuracy and reliability, improving business analysis quality by 20%. Show less

• 

  Interactive Dashboard for Vehicle Data Insights Using Power BI

  -

  Interactive Dashboard

  •Skills set used : Data Modelling, Data Analysis, Data Visualisation,Etc.•Analyzed : Vehicle data across 10 cities, enhancing data-driven decisions by 25%.•Created : Interactive dashboards and visualizations, increasing report accessibility by 30%.•Implemented : Data cleaning processes, ensuring data accuracy and improving analysis efficiency by 20%.

• 

  SQL Database for Library Management System

  -

  SQL Database

  •Skills set used : Basic SQL Queries, Joins, Sub queries,Aggregate Functions,Etc.•Database Design : Created a SQL database with 7 tables, ensuring robust foreign key constraints and autoincrementing primary keys, which reduced data redundancy by 20%.•Data Manipulation : Executed complex queries for date formatting and inventory analysis, improving data accuracy by 95% and reducing query processing time by 25%.•Insightful Analysis : Generated actionable reports on book copies and borrower activity, which increased library operational efficiency by 30%. Show less

• 

  Globetel Technologies

  Apr 2018 - Nov 2023

  Supervisor