Abdulrahman Samhan

Data Analyst

About Me

Are you looking for a data analyst with a unique mindset across diverse business domains like sales, marketing, finance, e-commerce, and supply chain and so on? You’re in the right place.
I'm Abdulrahman Samhan, a data analyst who can help you use your data accurately to grow confidently more than once. I'm an SQL ,Python , Excel , Power BI expert who can complete complex projects.

30th November 2024

GYM Preformance

(Click here to show more)
This project aimed to provide a clear view of sales performance and uncover key insights to support strategic decision-making.

Key Achievements:

- Data Extraction: Pulled data directly from SQL Server with custom queries, ensuring accuracy and real-time data.

- Data Cleaning: Used Power Query for data cleaning and transformations, merging tables for consistency and accuracy.

- Data Modeling: Implemented a star schema to optimize performance and streamline analysis between sales, customers, and products.

- Custom DAX Calculations: Developed DAX measures to calculate crucial KPIs like revenue, profit, customer count, and order quantities for deeper business insights.

Analysis Highlights:

1. Customer Segmentation: Analyze purchase behavior and churn rates to understand customer trends.

2. Product Performance: Identified top-performing products and areas needing improvement.

3. Location Insights: Explored sales patterns by region to find best-performing areas.

4. Time Analysis: Tracked seasonal trends and forecasted future sales performance.

5. Return Analysis: Investigated product returns to refine strategies and reduce losses.

Dashboard:

Created an interactive dashboard displaying key KPIs and sales trends, with dynamic filters to drill into data by location, time, and product categories.

Final Results:

The analysis provided a comprehensive view of the company’s performance, highlighting profitable products, engaged customers, and top regions, empowering data-driven decision-making.

22nd September 2024

Cost Analysis

To watch this video, scroll down this video to show a project for analyzing revenues, profits, costs and customers.

22nd September 2024

Profit Analaysis

To watch this video, scroll down ,this video to show a project for analyzing revenues, profits, costs and customers.

22nd September 2024

Customers Analysis

To watch this video, scroll down ,this video to show a project for analyzing revenues, profits, costs and customers.

22nd September 2024

Revenue Analysis

To watch this video, scroll down ,this video to show a project for analyzing revenues, profits, costs and customers.

22nd September 2024

Revenue Analysis

This project involves creating an interactive dashboard using Excel to display and analyze Revenue data.

Project breakdown
Data Extraction: Pulled data from multiple sources to start the analysis journey.
Data Cleaning & Preparation: Used Power Query to clean and transform the raw data.
Data Modeling: Built a powerful data model using Power Pivot to link different data tables.
Data Visualization: Designed an interactive Dashboard in Excel to visualize the insights and answer key business questions.
This task further honed my skills in data analysis, data modeling, and creating impactful dashboards. I’m eager to take on even more complex data challenges! 🚀

🚀 Excel Dashboard: Revenue Analysis
Here’s a snapshot of a dashboard I recently created as part of my ongoing data analysis tasks. This dashboard offers an in-depth look at revenue, profit, costs, and other key metrics across various regions and channels.
🔹 Features Highlighted:
Revenue by Channel and Region
Cost Analysis by Channel and Region
Profit % and Revenue Trends
Product Category and Manufacturer Insights
This dashboard has been a fantastic way to visualize complex data, and I'm proud of the insights it provides!

22nd September 2024

Sales Dashboard

The goal of the analysis is to understand the company's sales volume from the year 1900 to 1922 for comparison with the current years. After the analysis, it was found that the company achieved revenues amounting to 100.51 million, with the highest revenue year being 1900 at 84.51 million. The analysis revealed that the month of January in that year had the highest revenue, reaching 39 million, with the sale of 2743 units. Furthermore, the most selling region was the state of California, with 1751 units sold, generating revenues of 19.36 million.
The project went through several stages, starting from preparation and cleaning, progressing through modeling, analysis, and visualization. Using Power BI capabilities, this analysis was designed and implemented effectively to provide a comprehensive overview of sales performance over the specified years.

22nd September 2024

Sales Dashboard

This project aims to analyze sales data in order to understand and improve business performance and make smarter strategic decisions.
Specific objectives of the project:
1. Deep understanding of sales patterns and the factors affecting them.
2. Analyze the performance of products or services based on the data collected.
3. Identify opportunities and challenges in the market and guide marketing strategies.
4. Improve the direction of efforts and achieve efficiency in the distribution of products or services.
5. Make data-driven strategic decisions to increase profitability and achieve business goals.
The project includes a sales analysis for someone I applied everything I learned, the project went through several stages, including
1- preparation
2- cleaning
3- modeling
4- analysis
5- visualization
using by Power BI