Data Analyst Portfolio
Yvonne M-Gatere
Expert in Medallion Architecture, SQL Server, and Power BI. I specialize in building end-to-end data pipelines that transform raw business data into actionable executive insights.
Expert in Medallion Architecture, SQL Server, and Power BI. I specialize in building end-to-end data pipelines that transform raw business data into actionable executive insights.
A full-cycle data refinery process transforming raw ERP sources into high-performance reporting. This project demonstrates database normalization, Star Schema modeling, and advanced DAX visualization.
View Full Repository
Clean T-SQL used to join 1M+ rows of sales and customer data into a performant Gold-layer view.
Star Schema implementation ensuring 1-to-Many relationships for efficient DAX and accurate filtering.
High-level KPI tracking highlighting revenue trends and a 47% improvement in delivery logistics.
Interactive mapping of global market penetration and regional profitability analysis.
Advanced data cleaning project resolving duplicates and standardizing global datasets for trend visualization.
View ScriptsInteractive dashboards to track inventory and revenue trends for a retail coffee business.
View DashboardExploratory data analysis (EDA) to identify top-performing branches and seasonal sales spikes.
View Python NotebookDesigning a scalable warehouse structure focusing on normalization and ETL schema design.
View SchemaA time-series analysis of 50 years of LEGO set data using Pandas and Matplotlib.
View CodeScan the code below to email me directly or click the button.