Ahmed Hamada | Data Analyst | BI Developer

Ahmed Hamada

Data Analyst | BI Developer

Based in Cairo, Egypt

About

I work as a Data Analyst proficient in Python, SQL, Excel, and Power BI. My expertise lies in Statistics, Data Modeling, Data Visualization, and Data Storytelling. I specialize in the following areas: - ETL Processes, Data Modeling and Visualization in Power BI and Excel. - Data Cleansing using Power Query. - Report creation and Dashboard Design in Power BI and Excel. - Problem-solving with DAX Code in Power BI and Excel for data analysis. - Data Analysis with Python, including Data Cleansing and Exploratory Data Analysis (EDA). - Data Scraping from Websites using Python (BeautifulSoup). - Building Regression and Classification Models with Scikit-Learn. - Writing complex Queries in SQL. - Present Insights and Data Storytelling using PowerPoint, Power BI, or Jupyter Notebook.

Skills

Projects

Tech Product Sales Analysis and Dashboard

Purpose: Analyze sales data to identify trends, top-selling products, and revenue metrics for business decision-making.

Pizza Sales Analysis and Dashboard

This project involves analyzing pizza sales data using SQL queries and visualizing the insights using Power BI. The objective is to gain actionable insights into sales trends, customer preferences, popular pizza choices, and regional sales performance.

Startup Expansion Analysis and Dashboard

This project focuses on analyzing the potential expansion opportunities for a startup company. The startup has achieved initial success and is looking to grow its business by entering new markets or expanding its product/service offerings.

Walmart Store Sales Analysis and Prediction (Accuracy 96.84%)

This project aims to analysis, predict sales and demand for Walmart, a leading retail store in the US. The challenge lies in accounting for various events and holidays that influence daily sales, as well as managing unforeseen demands and stockouts.

Home Loan Approval Analysis and Prediction

The company wants to automate the loan eligibility process (real-time) based on customer detail provided while filling out the online application form. To automate this process, they have given a problem identifying the customer segments eligible for loan amounts to target these customers.

Cars Price Analysis and Prediction with Accuracy 93.43 %

This project involved conducting a comprehensive analysis of car prices using data analytics and machine learning techniques. The primary objective was to develop a predictive model capable of accurately estimating car prices based on various features and attributes.

Customer Churn Analysis

The goal of this project is to analyze customer churn patterns within a business or industry. Customer churn, where customers stop using a company's services, can lead to lost revenue. By identifying churn, businesses can take proactive steps to retain customers and enhance overall satisfaction.

Credit Card Fraud Analysis and Detection (Accuracy 99.9%)

In today’s digital world where trillions of Card transaction happens per day, detection of fraud is challenging. In this project, we will analyze data and build an ML model to detect fraudulent transactions of credit cards.