console online — data analyst

Turning raw data
into insight

I'm Omar AbdElpaq. I clean the mess, model the numbers, and build dashboards that tell people what's actually happening in the business — before they have to ask.

Excel Power BI SQL Python
focus_areas.dashboard LIVE
Portrait of Omar AbdElpaq Power BI SQL Excel Python
BI
Dashboards
ETL
Data Prep
SQL
Analysis
DAX
Modeling
scroll

About Omar AbdElpaq

About

I'm an undergraduate student at Menoufia National University, Faculty of Computers and Artificial Intelligence, majoring in Internet of Things & Big Data Analytics.

I completed the Data Analytics Summer Training run by NTI in cooperation with ITIDA, and I've since taken on practical, freelance/task-based Data Analytics work — cleaning data, building BI dashboards, and turning raw datasets into decision-ready reporting.

I'm currently developing Data Engineering as an additional specialization through DEPI. What draws me to this field is simple: turning raw data into insight that people can actually act on.

UniversityMenoufia National University
FacultyComputers & Artificial Intelligence
ProgramIoT & Big Data Analytics
StatusUndergraduate Student
TrainingNTI × ITIDA Data Analytics — 92.5%
SpecializationData Engineering, via DEPI
LocationSadat City, Menofia, Egypt
Experience

Where I've applied this

Data & Business Intelligence

Voltix
Startup / BI

As responsible for Data & Business Intelligence at Voltix, I build the company's analytical foundation through dashboard development and performance and market analysis to support product and business decisions. I also contribute to content strategy and company positioning, while supporting the early operational build-out of the startup alongside a cross-functional team covering Backend, Frontend, Cybersecurity, and UI/UX.

Freelance Data Analyst

Independent
Since 2024

Practical, task-based analytics work for independent clients: data cleaning and preparation, KPI analysis, and BI dashboard development using Excel, Power BI, SQL, and Python — turning raw, inconsistent datasets into reporting people actually use.

IT and Software Development

Neom Professional Training
3 Months

Supported general IT and software development activities as part of the team, contributing to day-to-day technical and software-related operations. Gained practical exposure to supporting technical tasks and maintaining reliable software-related workflows.

Skills

What I work with

Data Analysis

Excel
Power BI
SQL
Python
Tableau

Data Preparation

Power QueryPandasData CleaningData TransformationETL

BI & Modeling

DAXPower PivotData ModelingKPI DesignDashboard Development

Databases

PostgreSQLSQL Server — Basic

Additional

Git / GitHubNumPyScikit-learnMatplotlib

Professional Skills

Analytical ThinkingProblem SolvingBusiness CommunicationData StorytellingTeam Collaboration
Projects

Featured Work

Six case studies covering operations, finance, retail, HR, and healthcare analytics.

More Analytics Projects

Customer Purchase Prediction ML

Customer Purchase Prediction ML

Egyptian National Team Power BI Dashboard

Egyptian National Team Dashboard

Steel Sales Insights

Steel Sales Insights

Attendance ETL & Analytics

Attendance ETL & Analytics

Online Shop Sales Analytics

Online Shop Sales Analytics

Gemma Analytics

Gemma Analytics

Hospital Admission Analytics

Hospital Admission Analytics

Banking Customer Credit Analysis

Banking Customer Credit Analysis

Amazon Sales Data Analysis

Amazon Sales Data Analysis

Car Market Analysis

Car Market Analysis

Udemy Course Analytics

Udemy Course Analytics

Mobile Market Analysis

Mobile Market Analysis

Laptop Sales Market Analysis

Laptop Sales Market Analysis

Tableau Data Visualization

Tableau Data Visualization

SQL Data Analysis Projects

SQL Data Analysis Projects

Additional Development Projects

Earlier web/CRM development work, built during freelance and task-based projects — shown here separately from my Data Analyst focus.

Partner CRM System

Partner CRM System

Voldemort project

Voldemort

NEOM Partner Brochures

NEOM Partner Brochures

Recommendations

A few words from people I've had the opportunity to work with.

// 05 Training & Certifications

Training & Certifications

Training & Programs

Summer Training Course of Data Analytics — NTI × ITIDA

31 August – 25 September 2025 · 120 hours (90 technical + 30 freelancing)

0%
Final Score
Currently developing

Digital Egypt Pioneers Initiative (DEPI) — Round 5

Additional specialization — Data Engineering, Microsoft Data Engineer Track

Certifications

Achievements & Participation

Services

What I can help with

Power BI & BI Dashboards

Interactive dashboards, KPIs, DAX, and reporting built around the questions your team actually asks.

Excel Analytics

Power Query, Power Pivot, DAX, PivotTables, and dashboards for teams that live in Excel.

SQL & Database Analysis

Queries, joins, aggregations, and PostgreSQL work aimed at business-focused questions.

Python Data Cleaning & ETL

Pandas-based pipelines that turn raw, inconsistent files into analysis-ready datasets.

Have data that needs to become useful? Let's talk.

Let's Talk
// 06 Contact

Let's talk about your data