mohammad-khairy | Portofly

Data Analyst | Power BI Developer

Mohammad Khairy Rashad Fadel

Motivated Data Analyst certified with the Google Data Analytics Professional Certificate and recognized among the Top 5,000 Developers in the Build with AI program by Google & ITI. Equipped with hands-on experience in SQL, Power BI, and Excel, with a proven ability to write efficient queries, clean and transform data, and perform complex data modeling. Skilled in extracting actionable insights from large datasets and building interactive dashboards that uncover business trends. Eager to leverage my technical expertise and analytical skills to solve real-world business problems and drive data-driven decision-making

تواصل

Alexandia, Egypt

صورة Mohammad Khairy Rashad Fadel الشخصية

++++/////

Projects

Adidas US Sales Analysis

Created a three-page interactive dashboard in Power BI to analyze sales performance and trends. Processed raw data with Power Query and developed data models using DAX to compute key metrics like revenue and profit. Delivered insights that identified top-performing products and regions.

Power BIPower QueryDAX

Project link

Coffee Shop Sales Analysis

Developed a sales analysis tool in Excel to pinpoint peak sales hours and best-selling products. Leveraged Pivot Tables and Slicers to design interactive reports and performed data cleaning to ensure accuracy. Derived insights that supported business decisions and boosted sales performance.

Microsoft ExcelPivot TablesPower PivotPower QueryDaxStar Schema

Project link

Salary Dashboard Analysis

Designed an interactive salary dashboard in Microsoft Excel to evaluate income distribution and trends across various categories. Applied Pivot Tables, charts, and slicers to generate dynamic insights. Enhanced data visualization to facilitate better decision-making and emphasize key salary patterns.

Microsoft ExcelPivot TablesPower PivotPower Query

Project link

Shoppe Express E-commerce Analysis

Developed an end-to-end Power BI dashboard for Shoppe Express by transforming raw sales and customer data. Handled data normalization through Power Query, engineered a robust Star Schema model, and utilized DAX for precise metric calculations, providing clear insights into business health

Power BIPower QueryDaxNormalizationStar Schema

Project link Project Report

Skills

TECHNICAL SKILLS

Power BI (DAX, Power Query, Star Schema)Advanced Excel (Advanced Formulas, Pivot Tables, Power Pivot)ETL ProcessesData Modeling & NormalizationPythonSQL (PostgreSQL)