Data Analyst with 2+ years in Data Analysis & Business Intelligence
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with hands-on experience in data cleaning, data modeling, and dashboard development using Power BI, SQL, Excel, and Python. Skilled in building Star Schema models, creating DAX measures, and transforming raw data into actionable business insights. Developed end-to-end analytics projects involving ETL, data visualization, KPI tracking, and performance analysis.
Tanta University
Bachelor of law
August 1, 2020 – June 30, 2024
Olist E-Commerce Sales Dashboard
June 1, 2024 – June 1, 2026
Cleaned and transformed data from 9 tables using Power Query, including merging, aggregation, and data modeling preparation. Built a Star Schema data model with Orders as the central fact table and multiple dimension tables. Created a Date Table and developed DAX measures for Revenue, Orders, Customers, Delivery Rate, Purchase Frequency, and Review Score. Resolved one-to-many relationship issues by aggregating Payments and Reviews data at the order level. Designed interactive dashboards with KPIs, Revenue Trends, Geographic Analysis, Order Status Tracking, and Top/Bottom Performance analysis. Developed custom regional segmentation using DAX to improve sales analysis and executive reporting.
Sales Performance Dashboard
June 1, 2024 – June 1, 2026
Cleaned and transformed sales data using Power Query. Designed a Star Schema data model with DAX Calendar Table. Implemented active and inactive relationships for time-based analysis. Created DAX measures for Sales, YTD Sales, Average Sales, and Max Sales. Built interactive Power BI dashboards with KPIs, Charts, Maps, and Drill-Down Analysis. Analyzed sales performance across products, regions, states, and cities.
Retail Sales Analytics Dashboard
June 1, 2024 – June 1, 2026
Cleaned, transformed, and modeled sales data using Power Query and Star Schema design. Created DAX measures and KPIs including Sales, Profit, Profit Margin, Returns, Orders, and YoY Growth. Built a Date Table and implemented time intelligence with active and inactive relationships. Developed interactive dashboards using Power BI (Cards, Maps, Treemap, Matrix, Line & Bar Charts). Analyzed sales performance by region, store, product, and brand to identify business trends and opportunities.
Data Analysis Training (90 Hours)
Tanta University
June 1, 2026 – Present
Google Data Analytics Professional Certificate
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's projects are all personal and focused on sales analytics, demonstrating a clear interest and self-driven learning in the data analysis domain. The certifications from Google and Tanta University further support a proactive learning attitude. While the projects are similar in nature, they showcase a consistent application of core data analysis skills. The lack of professional experience or diverse project types limits the assessment of broader cultural fit aspects like collaboration within a team or adapting to different business contexts.
Soft Skills & Operational Fit
The candidate's resume highlights soft skills such as Problem Solving, Analytical Thinking, Attention to Detail, Communication Skills, Teamwork, and Time Management. These are crucial for a Data Analyst role, indicating a good operational fit. The project descriptions demonstrate practical application of these skills in data manipulation and insight generation.