SQL based data profiling & data quality checks, which will help you to perform data profiling & data quality checks on SQL database at table & database level.
-
Updated
Apr 15, 2022 - TSQL
SQL based data profiling & data quality checks, which will help you to perform data profiling & data quality checks on SQL database at table & database level.
Repository for tutorials, information, notes and projects about data engineering.
Data Warehouse Project: A structured Data Warehouse using Bronze, Silver, and Gold layers for efficient data ingestion, transformation, and analytics with SQL Server.
This Data Warehouse project is built on a Medallion Architecture design to manage and process information from CRM and ERP systems.
A complete, production-ready SQL Data Warehouse project implementing the medallion architecture (Bronze, Silver, Gold) featuring robust T-SQL ETL, star schema data modeling and a unified data catalog for analytics and business intelligence.
I created this project to practice and demonstrate my knowledge and skills in creating functional pipelines in the field of Data Engineering to process raw data and store it with best practices and guidelines, as demonstrated in the project documentation.
An End-to-End Business Intelligence project that analyzes product and category profitability to uncover high-impact insights and drive smarter business decisions.
A scalable and optimized data warehouse solution designed for efficient data integration, transformation, and analytics. This project demonstrates ETL workflows, dimensional modeling, and query performance tuning using modern data warehousing practices.
I created this project to demonstrate my knowledge and skills in creating functional pipelines in the field of Data Engineering to process raw data and store it with best practices and guidelines, as demonstrated in the project documentation.
A comprehensive SQL Data Warehouse project demonstrating dimensional modeling, ETL processes, and analytics for structured data management.
A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.
This repository provides a comprehensive guide for building production-ready data warehouses using SQL Server. It walks through the complete process of implementing a modern data warehouse using Medallion Architecture (Bronze, Silver, Gold layers) with practical code examples and detailed.
Restaurant Management System, facilitates user tasks and enables customers to reserve preferred areas. This database includes employee, customer, table, and service information. It assists restaurant staff in managing clients, orders, and quickly identifying available tables.
Building a modern data warehouse with SQL server,including ETL processess, data modeling, and analytics.
O projeto consiste em desenvolver uma solução para a migração de dados de uma fonte com muitos arquivos para uma base de dados hospedada em ambiente Cloud.
Add a description, image, and links to the dataengineering topic page so that developers can more easily learn about it.
To associate your repository with the dataengineering topic, visit your repo's landing page and select "manage topics."