Gabriela Yordanova

From prescriptions
to pivot tables

After a decade dispensing medications and several years navigating real estate markets, I realized the thread connecting everything I loved about both careers was data. Not just numbers — but the stories they tell and the decisions they unlock.

I specialize in transforming raw, messy datasets into clean, reliable foundations — then using SQL, Python, and Power BI/Tableau to surface insights that actually move the needle.

Based in Bulgaria. Open to remote. Focused on building things that help people decide better.

10+Years in data-driven fields
4Core tools mastered
2 End-to-end platforms · 1 live · 1 in development

End-to-end data solutions

From database design to business-ready dashboards.

SQL & Databases

Complex queries, joins, window functions, and stored procedures across SQL Server, MySQL, and PostgreSQL.

SQL ServerMySQLPostgreSQLT-SQL

Python

Data cleaning, transformation, and automation — turning raw files into structured, analysis-ready datasets.

PandaspyodbcAutomation

Power BI & Tableau

Interactive dashboards and reports that turn data into clear, actionable business decisions.

DAXPower QueryTableau Public

Excel

Advanced pivot tables, formulas, and data analysis for rapid exploratory work.

Pivot TablesAdvanced Formulas

Data Modeling

Designing relational schemas and visualizing workflows for clean, maintainable architectures.

ERDdraw.ioSchema Design

Dev Tools

Modern development environment for version control, database management, and code editing.

VS CodeSSMSGitGitHub

Full-stack data projects

From raw ingestion to interactive dashboards — built end-to-end.

Flagship Project

PharmaMarket Data Platform

A four-stage end-to-end project built on a real-world pharmaceutical dataset from Bangladesh — covering the full journey from raw CSV files to an interactive Tableau dashboard.

ETL
Cleaning
EDA
Visualization
Stage 1

PharmaMarket ETL

Full ETL pipeline extracting from CSV files, parsing complex multi-value fields, and loading into a structured SQL Server database — covering drug classes, generics, manufacturers, dosage forms, and a junction table linking generics to their primary medical indications.

SQL ServerT-SQLBULK INSERTCTEsWindow Functions
View on GitHub
Stage 2

PharmaMarket Data Cleaning

Quality validation built on the ETL output. Inspects every table for NULLs, duplicates, encoding artifacts, and referential integrity issues — applying targeted fixes and documenting all findings in a separate clean database.

SQL ServerT-SQLPythonPandaspyodbc
View on GitHub
Stage 3

PharmaMarket EDA

Exploratory analysis migrated to PostgreSQL. Explores distribution, rankings, pricing, and segmentation of 21,708 medicines across 240 manufacturers and 113 dosage forms through modular analytical SQL scripts.

PostgreSQLCTEsWindow FunctionsPythonPandaspyodbc
View on GitHub
Stage 4

PharmaMarket Visualization

A two-dashboard Tableau Story covering market structure and pricing competition — KPI strips, treemaps, packed bubbles, and box plots built on 21,708 medicines across 240 manufacturers.

Tableau DesktopPostgreSQLSQLTableau Public
In Development

Real Estate Data Platform

A four-stage end-to-end project built on real estate market data — from web scraping to an interactive Power BI dashboard, with Python driving the first three stages.

Scraper
Cleaning
Analysis
Dashboard
Stage 1

RealEstate Scraper Coming Soon

Python web scraper for collecting real estate listings — prices, locations, property types and features — into a structured dataset ready for cleaning and analysis.

PythonBeautifulSoupSeleniumPandas
Stage 2

RealEstate Cleaning Coming Soon

Python-based data cleaning and transformation of scraped listings — handling missing values, inconsistent formats, outliers, and preparing a reliable dataset for analysis.

PythonPandasNumPyRegex
Stage 3

RealEstate Analysis Coming Soon

Exploratory data analysis in Python — uncovering price distributions, location trends, property type patterns and market dynamics through statistical analysis and visualisations.

PythonPandasNumPyMatplotlibSeaborn
Stage 4

RealEstate Dashboard Coming Soon

Interactive Power BI dashboard presenting key insights — price trends, location breakdowns, property type distribution and market competition across the dataset.

Power BIDAXPower Query