Publier un projet

EXPLORER

0,0

(0 commentaires)

Photo de couverture du profil

Vous suivez désormais

Erreur de suivi de l'utilisateur.

Cet utilisateur n'utilise pas les utilisateurs à le suivre.

Vous suivez déjà cet utilisateur.

Votre plan d'adhésion ne permet que 0 suivis. Améliorez ici.

Ne suit désormais plus

Erreur lors de l'arrêt du suivi de l'utilisateur.

Vous avez désormais recommandé

Erreur lors de la recommendation de l'utilisateur.

Une erreur a eu lieu. Veuillez rafraîchir la page et réessayer.

E-mail désormais vérifié.

Mahmoud N.

@Mahmouda28

0,0

0

0,0

0,0

0%

Data Analytics

$20 USD / Heure

・

Egypt (3:29 AM)

・

Inscrit depuis le août 8, 2024

$20 USD / Heure

・

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.

Vérifications

Voir tous les Python Developers en 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

Modifications enregistrées

0.0 · 0 Reviews

Commentaires

Aucun commentaire visible ici !

Helwan University Cairo

2020 - 2024

•

4 ans

3.74

Egypt

2020 - 2024

•

4 ans

Invitation désormais envoyée !

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.

Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.

Chargement de l'aperçu

Permission donnée pour la géolocalisation.

Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.