This repository contains all the assignments, workshops and mini-projects of course - DAMG7370 Designing Advanced Data Architectures for Business Intelligence
Designed Multi Star schema with 10 Fact & 33 Dimension tables & developed Data Integration Pipeline by ETL workflow to load all tables (380M+ rows) from multiple sources such as CSV, MySQL, MSSQL & PostgreSQL by using Talend. Implemented Data Profiling, Error Handling, Load Statistics, Cleansing and Performance Tuning to address data quality gap…
End-to-end SQL project for project/portfolio finance: schema, seed data, validation, data-quality checks, business queries, and KPI views (Power BI–ready).
Building a model data warehouse with SQL Server, Including ETL Processes, data modeling and analytics
Building a full-cycle data warehouse using Microsoft SQL Server following Medallion Architecture (Bronze - Silver - Gold) to support analytics and reporting. Applying the concepts of ETL processes, integrating CRM and ERP raw data sources, perform data cleansing and enrichment, and data transformation into business-ready data models for insights.
A comprehensive blueprint for an enterprise-grade SQL Server Data Warehouse built with a Medallion Architecture, orchestrated by Apache Airflow, and transformed using dbt (data build tool).
In this project I perform data cleaning using T-SQL, to improve the quality of a dataset containing information about houses in Nashville, Tennessee..
Add a description, image, and links to the data-quality topic page so that developers can more easily learn about it.
To associate your repository with the data-quality topic, visit your repo's landing page and select "manage topics."