Project · 2023
Plataforma de Dados & Marketing Analytics
Production data platform on Microsoft Fabric — from lakehouse to the marketing funnel (from click to enrollment), with PySpark, Power BI and DataOps.
Designed and operate, end to end, a production data platform on Microsoft Fabric for a higher-education institution's academic area.
Medallion-architecture lakehouse (bronze/silver/gold), with automated and sanitized PySpark ingestion from 4+ databases (on-premises Oracle and SQL) plus the Meta and Google Ads APIs.
Full marketing-analytics funnel — from ad click to enrollment — computing CPC, CAC and ROAS, integrated with WhatsApp via API.
Real-time analytics with Eventhouse/KQL, semantic models and Power BI dashboards, with Git versioning and deployment pipelines (DataOps).
Stack
Microsoft FabricPySparkPower BIAzureKQLDataOps