Hello, I'm

Ahmed
Ramadan

Data Analyst & BI Specialist

Transforming complex datasets into interactive dashboards and data-driven decisions.

My Portfolio Contact Me
Ahmed Ramadan

About Me

I am a Business Intelligence Specialist and Data Analyst with hands-on experience in reporting, dashboard development, and technical training. I am highly skilled in designing KPI dashboards, optimizing data models, and delivering advanced analytics solutions. My core expertise lies in using Power BI, SQL, and Python to perform exploratory data analysis (EDA) and develop interactive dashboards that support business performance tracking and data-driven decision-making.

My Skills

Programming

SQL Python

Visualization

Power BI Tableau

Tools

Microsoft Excel DAX / Data Modeling

Methods

EDA Business Analysis Statistics

My Experience

Ongoing

Workforce Analyst

Workforce Analytics

  • Created interactive dashboards to track and analyze KPIs across business units.
  • Managed workforce planning, shift schedules, weekend coverage, and break rotations.
  • Monitored employee performance, attendance, working hours, and overtime metrics.
May 2022 – Mar 2023

Tech Support Team Leader

Telecom Company

  • Led a team of 19 customer service agents to deliver high-quality technical support.
  • Handled DSL internet issues, including troubleshooting connectivity and performance problems.
  • Created interactive dashboards to track and analyze KPIs across company branches.
  • Monitored team performance and ensured service level targets were consistently met.
  • Designed reports to meet regional managers' needs and support data-driven decisions.
  • Provided coaching and training to team members on technical and communication skills.

My Education

2023 – 2027

Mechanical Engineering

Faculty of Engineering

Industrial & Production Engineering.

My Projects

01

SuperStore Sales Dashboard

Power BI Dashboard • Data Analysis

An interactive Power BI dashboard built to analyze the SuperStore dataset — a global retail store's sales data spanning multiple years, categories, and regions. The project involved full end-to-end analysis: data cleaning, building a star-schema data model, and creating multi-page dashboards with actionable KPIs.

13M

Total Sales

1.47M

Total Profit

25K

Orders

178K

Quantity Sold

Dashboard Page 1 Dashboard Page 2 Data Model
SuperStore Dashboard

Key Insights

  • Technology leads in sales, while Copiers & Phones drive the highest profit
  • Sales grew consistently from 2.3M (2011) to 4.3M (2014)
  • Top customers like Tom Ashbrook contributed 40K+ in sales
  • EU and APAC markets showed strong performance

Tools & Techniques

Power BI DAX Star Schema Data Modeling KPI Cards Data Cleaning

Curriculum Vitae

My Resume

Want to know more about my experience and skills? You can view or download my complete CV below.

Download CV

Let's Connect

Interested in working together or have a question? Feel free to reach out.

Email

Ahmed01121064395@gmail.com

Phone

01020090717
01129975985

WhatsApp

01020090717

Telegram

@Ahmmo2

LinkedIn

Ahmed Ramadan

Upwork

Ahmed Ramadan

Location

Fayoum, Egypt