Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Eletrodeutsch Data Quality Implementation And Analysis
Project Type
Data Quality Analysis
Date
January 2026
Tools/skills
#Python #SQL #GreatExpectations #DataWarehouse
#DataQuality #DataModeling #DimensionalModeling
#DataValidation
Access the project here
This project presents the implementation of a Data Quality framework within a Data Warehouse for an omnichannel retail company.
The analysis was conducted through a thorough understanding and tracing of the conceptual, dimensional, and logical data models.
Based on this mapping, data quality rules were defined in alignment with business requirements and constraints.
Validations were automated using Great Expectations, enabling continuous monitoring and the generation of auditable reports.
The result is a reliable, governable data foundation ready to support strategic decision-making and advanced analytics initiatives.
π ELETRODEUTSCH DATA QUALITY PROJECT
βββ π Project Complete Documentation [Data Analysis Complete Project.pdf]
βββ π Data Quality Framework Documentation [Data Quality Framework Deployment and Execution.pdf]
βββ ποΈ Physical Data Warehouse Model [02-physical-model-project-eletrodeutsch.sql]
βββ π ETL Implementation Scripts [03_etl_project-eletrodeutsch.sql]
βββ π³ Docker Container Setup [container_docker-creation.txt]
βββ π» Data Quality Validation Script [validation.py]
βββ βοΈ Project Dependencies [requirements.txt]
βββ π Data Quality Validation Reports
β βββ [validation_report_dim_customer.html]
β βββ [validation_report_dim_product.html]
β βββ [validation_report_dim_channel.html]
β βββ [validation_report_fact_sales.html]
βββ π₯ Project Overview Video [report-overwie.mp4]

