Passant Olama

Power BI & Excel Dashboards for HR and Business I

Category : Business management

I help organizations turn raw data into clear, actionable insights through custom Power BI dashboards and advanced Excel solutions. With strong expertise in Power Query, DAX, Power Pivot, and data visualization, I design dashboards that make decision‑making faster and more effective.
What I deliver:

** Interactive Power BI dashboards with slicers, KPIs, and charts

** Excel data cleaning & modeling for accurate reporting

** HR analytics dashboards (employee performance, turnover, recruitment pipeline)

** Financial & organizational KPI reports tailored to your business goals

** Step‑by‑step guidance if you want to learn Power BI basics

Why choose me:

** Certified in Power BI (AUC) and experienced in Excel training

** Professional background in HR, recruitment, and organizational performance analysis

Teaching experience as a University Assistant & Excel trainer, ensuring clarity and accuracy in every deliverable

Fast turnaround: basic dashboards within 24–48 hours

Delivery formats:
** Power BI files (.pbix)

**Excel workbooks (.xlsx)

** Exported reports (PDF, PPT for presentations)

Show phone number + email

Portfolio

View All

Working hours

Monday:08h00 To 18h00
Tuesday:08h00 To 18h00
Wednesday:08h00 To 18h00
Thursday:08h00 To 18h00
Friday:08h00 To 18h00
Saturday:Not available
Sunday:Not available

Experiences

Organizational Performance & data anlytics Johnson & Johnson 20/02/2021 - Today

I provide data analysis and dashboard solutions using Power BI and Excel to help organizations track performance, HR metrics, and KPIs. My services include data cleaning, modeling, and visualization to deliver clear, actionable insights for better decision‑making.

Education

Master Degree Arab Academy for maritime . transport & technology 2021 - 2029

Bachelor of Information Systems (BIS) — Graduated with Excellent with Honor Roll, giving me a strong foundation in databases, analytics, and business systems.

Power BI Certification (AUC) — Certified in advanced dashboard creation, data modeling, and visualization.

Master’s in Project Management (AAST) — Currently pursuing, with focus on organizational performance and strategic planning.

Professional Experience — Over 3 years in HR, recruitment, and organizational development, plus hands‑on work as a Data Analyst using Excel (Power Query, DAX, Power Pivot) and Power BI.

Teaching & Training — Excel trainer and university teaching assistant, ensuring clarity and accuracy in delivering technical concepts.

Certificates

Data Analytics & Power BI 06/12/2026
Power BI Certification – American University in Cairo (AUC)
Completed the Data Analysis & Power BI Certification at AUC, covering advanced Excel techniques, Power Query for data cleaning, DAX and Power Pivot for modeling, and Power BI for interactive dashboards. This certification strengthened my ability to transform raw data into actionable insights, build KPI dashboards, and support organizational performance with data‑driven decision making.