EXPLORE

0.0

(0 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

Mahmoud N.

@Mahmouda28

0.0

0

0.0

0.0

0%

Data Analyst

$20 USD / Hour

・

Egypt (2:33 AM)

・

Joined on August 8, 2024

$20 USD / Hour

・

Dedicated Business Information Systems student with professional experience in AI training, property consultancy, and financial systems. Skilled in data analysis, business intelligence, and advanced visualization tools, with a strong foundation in technology and a commitment to continuous learning.

Verifications

Accept rate

100%

See all Python Developers in Egypt

Portfolio

Portfolio

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

I used Power BI and DAX to analyze and derive insights from marketing data in this project. This is Part 1 of this project, and here's a quick overview:

1️⃣ Data Preparation:

I utilized Power Query to clean and transform the raw data, ensuring it was ready for analysis.

2️⃣ Statistical Calculations and KPIs:

I applied DAX to perform various statistical calculations and generate key marketing KPIs such as CTR, Conversion Rate, and Conversion Value per Click to uncover actionable insights.

Marketing Analysis Dashboard

I used Power BI and DAX to analyze and derive insights from marketing data in this project. This is Part 1 of this project, and here's a quick overview:

1️⃣ Data Preparation:

I utilized Power Query to clean and transform the raw data, ensuring it was ready for analysis.

2️⃣ Statistical Calculations and KPIs:

I applied DAX to perform various statistical calculations and generate key marketing KPIs such as CTR, Conversion Rate, and Conversion Value per Click to uncover actionable insights.

Marketing Analysis Dashboard

12388387

Project description. Analyzing sales data (2011–2020) using Power Query and Power Pivot in Excel.

1️⃣ Data Collection and Cleaning: I imported raw sales data via Power Query, ensuring accuracy by removing duplicates, fixing errors, and standardizing data types.

2️⃣ Modeling and Analysis: Using Power Pivot, I built relationships between data tables and conducted complex calculations for deeper insights.

3️⃣ Visualizations: I created dynamic charts and pivot tables, incorporating Slicers for user-friendly filtering. This interactive dashboard provided adaptable and insightful reporting tailored to various needs.

Sales Analysis Dashboard

Project description. Analyzing sales data (2011–2020) using Power Query and Power Pivot in Excel.

1️⃣ Data Collection and Cleaning: I imported raw sales data via Power Query, ensuring accuracy by removing duplicates, fixing errors, and standardizing data types.

2️⃣ Modeling and Analysis: Using Power Pivot, I built relationships between data tables and conducted complex calculations for deeper insights.

3️⃣ Visualizations: I created dynamic charts and pivot tables, incorporating Slicers for user-friendly filtering. This interactive dashboard provided adaptable and insightful reporting tailored to various needs.

Sales Analysis Dashboard

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

Project using Power BI to analyze sales data for a company from 2009 to 2012.
Data Transformation & Cleaning
I utilized Power Query to transform raw data into a clean, structured format, ensuring accuracy and readiness for analysis.

2️⃣ Advanced Calculations with DAX
Using DAX, I created dynamic measures and performed statistical calculations to reveal deeper insights into sales trends and performance metrics.

3️⃣ Interactive Dashboards
I designed multiple interactive Power BI pages, each with a unique focus:
- Main Dashboard: Highlights KPIs across four years with a slicer for year-specific analysis, dynamically impacting all other pages.
- Product Page: Examines the relationship between sales and individual products.
- Profit Page: Explores the correlation between profit and product categories.
- Regional Insights: Analyzes average delivery times, profit margins, and product diversity by region.
- Customer Segment Analysis: Maps customer segments to key performance indicators f

Data Analysis using Power BI

I used Power BI and DAX to analyze and derive insights from marketing data in this project. This is Part 1 of this project, and here's a quick overview:

1️⃣ Data Preparation:

I utilized Power Query to clean and transform the raw data, ensuring it was ready for analysis.

2️⃣ Statistical Calculations and KPIs:

I applied DAX to perform various statistical calculations and generate key marketing KPIs such as CTR, Conversion Rate, and Conversion Value per Click to uncover actionable insights.

Marketing Analysis Dashboard

I used Power BI and DAX to analyze and derive insights from marketing data in this project. This is Part 1 of this project, and here's a quick overview:

1️⃣ Data Preparation:

I utilized Power Query to clean and transform the raw data, ensuring it was ready for analysis.

2️⃣ Statistical Calculations and KPIs:

I applied DAX to perform various statistical calculations and generate key marketing KPIs such as CTR, Conversion Rate, and Conversion Value per Click to uncover actionable insights.

Marketing Analysis Dashboard

12388387

Project description. Analyzing sales data (2011–2020) using Power Query and Power Pivot in Excel.

1️⃣ Data Collection and Cleaning: I imported raw sales data via Power Query, ensuring accuracy by removing duplicates, fixing errors, and standardizing data types.

2️⃣ Modeling and Analysis: Using Power Pivot, I built relationships between data tables and conducted complex calculations for deeper insights.

3️⃣ Visualizations: I created dynamic charts and pivot tables, incorporating Slicers for user-friendly filtering. This interactive dashboard provided adaptable and insightful reporting tailored to various needs.

Sales Analysis Dashboard

Project description. Analyzing sales data (2011–2020) using Power Query and Power Pivot in Excel.

1️⃣ Data Collection and Cleaning: I imported raw sales data via Power Query, ensuring accuracy by removing duplicates, fixing errors, and standardizing data types.

2️⃣ Modeling and Analysis: Using Power Pivot, I built relationships between data tables and conducted complex calculations for deeper insights.

3️⃣ Visualizations: I created dynamic charts and pivot tables, incorporating Slicers for user-friendly filtering. This interactive dashboard provided adaptable and insightful reporting tailored to various needs.

Sales Analysis Dashboard

Changes saved

0.0 · 0 Reviews

Reviews

No reviews to see here!

Helwan University Cairo

2020 - 2024

•

4 years

3.74

Egypt

2020 - 2024

•

4 years

Invite sent successfully!

Thanks! We’ve emailed you a link to claim your free credit.

Something went wrong while sending your email. Please try again.

Loading preview

Permission granted for Geolocation.

Your login session has expired and you have been logged out. Please log in again.