s
stevenanalytics

Steven Dawood

@stevenanalytics

Power BI Specialist , End to End Data Analytics , SQL Pipelines

Egypt
English, Arabic
About me
Hi, I'm Steven, a Data Analyst & Analytics Engineer with a CS & AI background. My approach is simple: A dashboard is only valuable if it drives action. I bridge the gap between messy raw data and clear executive metrics so you spend less time fixing reports and more time making confident decisions. How I help your business: - Interactive Power BI & Excel dashboards tailored to your KPIs - Data cleaning, merging, and automation using Python & SQL - 100% accurate reporting & data modeling Not sure where to start? Message me anytime—let's discuss the best solution for your data!... Read more

Skills

s
stevenanalytics
Steven Dawood
Offline • 

See my services

Data Dashboards
I will build power bi dashboard with python and sql pipeline
From$25 / projectMore details

Portfolio

Work experience

Self-Employed_/ Freelancer

Data Analyst & Analytics Engineer

Self-Employed / Freelancer • Freelance

Jun 2026 - Present • 4 mos

Designed interactive Power BI dashboards, built robust data models using DAX, and automated end-to-end data pipelines using Python and SQL for diverse business clients. My typical end-to-end analytics workflow covers four key stages: 1. Data Extraction, Cleaning & Transformation (Python & SQL): - Extracted and merged fragmented datasets from multiple databases, APIs, and Excel spreadsheets. - Cleaned messy records, handled missing values, resolved schema discrepancies, and removed duplicates using Python (Pandas) and SQL scripts, ensuring 100% data integrity without record loss. - Optimized Power Query workflows to prepare structured staging tables for seamless ingestion. 2. Relational Data Modeling & Advanced Calculations (DAX): - Designed normalized schemas and star-schema models to support high-performance reporting. - Authored custom, advanced DAX measures for complex business logic, including time intelligence (YoY, MoM growth), rolling averages, margin calculations, and dynamic KPI targets. 3. Executive Dashboard Architecture & UX Design (Power BI): - Built intuitive, interactive dashboards customized to match corporate visual identity and brand colors. - Implemented smart navigation, drill-through pages, bookmarks, and cross-filtering to provide both high-level executive summaries and deep operational breakdowns. - Automated report distribution and scheduled refreshes to replace repetitive manual reporting. 4. Actionable Business Insights & Decision Support: - Translated technical data metrics into clear operational insights, highlighting revenue drivers, cost leaks, and sales trends. - Empowered leadership and business owners to make confident, data-backed strategic decisions that improve profitability and operational efficiency.