I am a fresh BI developer aiming to start my career in the data analytics field. I am skilled in data extraction and manipulation using SQL, and have good knowledge of databases, data warehousing, ETL, Python, and statistical methods. Familiar with data analysis and reporting tools such as SSRS, I develop Ad-hoc reports and transform raw data into relevant reports and dashboards using Power BI and Tableau to provide actionable insights for businesses. I am dedicated to utilizing my analytical talents and a proactive learning approach to contribute to data-driven decision-making.
Information Technology Institute (ITI) | May 2024 β Present, Egypt
- Developed experience in designing and building databases and data warehouse models.
- Created interactive dashboards using MS Power BI and Tableau.
- Designed ETL and data pipelines using SSIS.
AdventureWorks-OLTP Sales Overview here
This Power BI project demonstrates the comprehensive process of extracting, modeling, and analyzing sales data from the Adventure Works database. Key points include:
- Data Source: Utilized the Adventure Works OLTP database with Direct Query.
- Data Extraction: Retrieved data from essential tables, views and function.
- Date Table Creation: Implemented an M language script to generate a comprehensive date dimension table for enhanced time-based analysis.
- Data Transformation: Cleaned and prepared the dataset by renaming tables and columns and removing unused data.
- Data Modeling: Structured data into a star schema for efficient querying and analysis.
- Measures: Created a set of critical measures for analysis, including the use of USERELATIONSHIP function to manage Inactive Relationships in a Role-Playing Dimension.
- Visualization: Developed insightful dashboards to highlight trends, sales performance, and key business metrics.
Bingo Sales here
- Data Analysis & Visualization: Utilized Excel to analyze retail invoice data, creating pivot tables and performing calculations to draw insights.
- Database & ETL Development: Designed a star schema model using SQL Server and developed an ETL pipeline with SSIS to populate a data warehouse.
- Business Intelligence Reporting: Crafted a descriptive analysis dashboard in Power BI, focusing on aesthetic design and insightful data presentation.
KPMG AU Data Analytics Job Simulation on Forage here
- Completed a simulation focused on advising a client on customer targeting with the Data, Analytics & Modelling team
- Assessed data quality and completeness in preparation for analysis
- Analysed data to target high-value customers based on demographics and attributes
- Developed dashboards to communicate findings with visuals
Data Analysis Project - AdventureWorks here
- Analyzed sales performance using the Adventure Works dataset.
- Used SQL to build a data warehouse and perform queries for data cleaning and exploration.
- Used Power BI to analyze data and create a dashboard.
Cyclistic Bike-Share Case Study here
- Analyzed customer behavior for a bike-share company as part of the Google Data Analytics Course.
- Applied descriptive statistics to answer business questions and provide recommendations.
- Conducted data extraction, cleansing, and analysis using Python and Power BI to create a dashboard.
Super Store Tableau Project here
- This project involves creating various visualizations and reports using Tableau to analyze sales and profit data.
- The tasks include generating detailed reports, forecasts, and interactive dashboards.
- Microsoft Certified: Fabric Analytics Engineer Associate | Jun 2024 β Jun 2025
- Microsoft Power BI Data Analyst Professional Certificate | Sep 2023 β Apr 2024
- Google Data Analytics Professional Certificate | Jul 2022 β Aug 2023
- Google Advanced Data Analytics Professional Certificate | May 2023 β Aug 2023
- Data Analysis Professional Nanodegree Program - FWD Scholarship | Feb 2021 β Mar 2021
- High Education Initiative Scholarships, The USAID and AmidEast | Sep 2015 β Nov 2020, Egypt
- Bachelor of Science: Chemistry, Assiut University | Sep 2015 β Feb 2020, Assiut, Egypt
- Student Exchange Program, University of Nebraska -Lincoln | Jun 2018 β Aug 2018, Nebraska, USA
- Excel, Microsoft SQL Server, SQL, Database, Data Warehouse, SSIS, SSRS, SSAS, Microsoft Fabric, Power BI, Tableau, Python, Data Analysis, Communication Skills, Problem-Solving
- Email: [email protected]
- LinkedIn: AbdEl-Rhman Ashraf Mohamad
- Phone: 01210234321
- NovyPro: NovyPro Portfolio
- Kaggle: Kaggle Portfolio