PCORnet Ontology to OMOP - beta!

TerraVolt Enterprise-grade SQL Data Warehouse with end-to-end ETL, Medallion Architecture (Bronze–Silver–Gold), and ERP/CRM integration. Features robust data quality, SCD-aware dimensional modeling, and BI-optimized star schemas delivering analytics-ready datasets for scalable reporting and enterprise decision intelligence.

This module enables you summarize and identify the quality of the data using concepts such as aggregation and window functions.

A modern data warehousing solution that consolidates and transforms ERP/CRM data into an analytics-ready format using medallion architecture. Implements data cleansing, integration, and modeling for actionable business insights. Includes comprehensive documentation for stakeholders and analytics teams.

The repository contains Structured Query Language (SQL) Scripts. The Multiple SQL scripts for various projects which includes data cleaning, data pre-processing, data processing, data transformation and insights gaining through Query Language.

Collection of SQL-based projects focused on end-to-end workflow of data analysis pipelines based on real-world scenerios.

This module covers how to assemble multiple tables into a dataset using SQL queries. It also introduces how to transform and clean data using SQL functions.

A collection of SQL scripts for data exploration, analysis, and reporting. The scripts cover topics like database exploration, metrics, time trends, cumulative analytics, and segmentation. Designed to help analysts quickly explore and analyze data using SQL.

The repository contains Structured Query Language (SQL) Scripts. The Multiple SQL scripts for various projects which includes data cleaning, data pre-processing, data processing, data transformation and insights gaining through Query Language.

This is a hands-on project that shows how to build a data warehouse using SQL and free tools. Starting from raw CRM and ERP data, it guides you through cleaning, transforming, and modeling it for analysis.

Exploring the COVID-19 dataset to identify the trends in cases and deaths from 2019 to 2022

This module covers performing descriptive analytics on time series data, geospatial data, complex data types (arrays, JSON, and JSONB), and text.

A comprehensive SQL Data Warehouse built from scratch using Azure Data Studio and SQL Server Express. It simulates an enterprise data pipeline using the Medallion Architecture and reflects industry best practices in Data Engineering, ETL design, and SQL-based data modeling.

Esta repositório contém projetos que utilizam SQL para análise de dados. Cada projeto explora conjuntos de dados, realizando consultas para extrair insights, transformar dados e visualizar resultados, demonstrando habilidades em gerenciamento de banco de dados e otimização de consultas.

📊 Power BI report to track real time operating status with focus on its downtime with integrated ERP systems Data

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.

This repository showcases the end-to-end process of cleaning, transforming, and visualizing COVID-19 data using Excel , SQL and Tableau. This project demonstrates practical data analytical sand business intelligence skills.

This project analyzes sales data for AdventureWorks, focusing on revenue, customer segments, and product performance. The dashboard provides insights into top-selling products, sales by region, and customer trends across multiple years. It helps in identifying sales opportunities and optimizing marketing strategies.