Background

Amr Al-afifi
Portfolio

These projects include analyzing large datasets with SQL, Python, and Power BI, automating data collection through web scraping, and building interactive front-end applications using HTML, CSS, and JavaScript.

Bank Loan Analysis Using Python

This project utilizes Python to analyze loan data, calculate key metrics like total applications, funded amounts, interest rates, and debt-to-income ratios, and create visualizations showing trends, regional patterns, loan terms, purposes, and the impact of factors like employment length and home ownership.

Shopify Sales Funnel Report Using PowerBi

Second image

This project analyzes Shopify sales data in Power BI to uncover insights into transaction performance, customer purchasing behavior, and long-term customer value. It delivers an interactive dashboard that allows stakeholders to explore sales trends, customer retention, and revenue patterns dynamically. The work follows a structured approach from requirement gathering to insight generation, ensuring a business-ready analytical solution.

Blinkit KPI Analysis And Data Cleaning Using SQL

In this project, I conducted a comprehensive analysis of Blinkit’s retail sales data using SQL. The process involved importing, cleaning, and transforming the dataset, followed by generating key performance indicators (KPIs) segmented by item type, fat content, and outlet characteristics. These analyses provided data-driven insights to support strategic decision-making.

Web Scraping Automation Using Javascript

In this project, I developed an automated web scraping solution using JavaScript and HTML with Chrome Extensions and DOM scripting to extract and clean over 5,000 business records from Google Maps and similar platforms. The solution leveraged browser automation and client-side scripting to handle dynamic web content, enabling efficient and accurate data collection for downstream analysis and integration.

Frontend Password Generator

Password Generator Screenshot or Logo

In this project, I built a modern front-end password generator using HTML, CSS, and JavaScript. I made it so users can create secure, random passwords by customizing the length and selecting character types like uppercase, lowercase, numbers, and symbols. I also implemented a responsive design and added a convenient one-click copy-to-clipboard feature.

Project Preview images

Bank Analysis Bar Chart
Preview 1
Shopify Sales Report
Preview 2
Summary Query
Preview 3
Web Scraper Extension
Preview 4
Password Generator
Preview 5