探索

0.0

(0条评论)

您正在关注

关注用户错误。

该用户不允许他人关注他们。

您已经关注了这个用户。

您的会员计划仅允许0个关注。升级在此。

成功取消关注

取消关注用户错误

您已成功推荐

推荐用户错误。

出问题了，请刷新页面并重新尝试。

电子邮箱已成功验证。

Mahmoud N.

@Mahmouda28

0.0

0

0.0

0.0

0%

Data Analyst

$20 USD / 小时

・

Egypt (2:24 上午)

・

加入于八月 8, 2024

$20 USD / 小时

・

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.

验证

接受率

100%

查看所有Python Developers在Egypt

文件夹

文件夹

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

修改已保存

0.0 · 0 Reviews

评论

这里没有评论！

Helwan University Cairo

2020 - 2024

•

4 年

3.74

Egypt

2020 - 2024

•

4 年

邀请已发送成功！

谢谢！我们已通过电子邮件向您发送了索取免费积分的链接。

发送电子邮件时出现问题。请再试一次。

加载预览

授予地理位置权限。

您的登录会话已过期而且您已经登出，请再次登录。