Developing a Library Management System from scratch using SQL

Implement a simple data warehouse to store Saklia data - Create data pipelines for extract, transform and load data from source to warehouse - Retrieve data in warehouse to explore and do several analysis

These are public database and data analysis projects from the portfolio of Doug Perez

Perform a detailed analysis and create an interactive dashboard of Internet Sales to facilitate a business decision-making process.

This project focuses on building a multi-level data warehouse using SQL Server to integrate and structure data from ERP and CRM systems. It involves ETL processes and data modeling to transform raw data into a refined, analysis-ready format in the Gold layer.

Data Cleaning, Exploration, and Insights

The Compliance and Safety Analytics for Food Facilities System enhances food safety management in Sonoma County, California, by providing insights into compliance and safety standards through advanced data modeling, integration, and visualization of official inspection records.

This repository hosts an Azure Data Factory to perform the ingestion of the official COVID-19 pandemic- and vaccine-data on an Azure SQL Database, and the relevant DDL to create a data model to produce insightful analytics on PowerBI

Build a modern Data Warehouse from scratch with SQL Server, including ETL processes, data modeling and analytics.

Project developed to practice data modeling, inspired by the workflow of a production order sheet from The Fini Company.

A comprehensive data warehouse with SQL Server, including ETL processes, data modeling, and analytics.

Building a modern data warehouse with SQL server, including ETL processes, data modeling, and analytics.

Data Analytics Project: Analyzed Promotions and Provided Tangible Insights to Sales Director

Repositório criado para armazenamento do case2 da matéria de Data Collection e Storage do curso de Engenharia de Dados da Universidade Presbiteriana Mackenzie

A relational database management system for AirBnB

Building a modern data warehouse with SQL Server, including ETL Process, data modelling and analytics

This project demonstrates a complete data analytics pipeline starting from raw real-world flight data to professional visual dashboards using SQL Server and Power BI. It showcases data import, cleaning, optimization, transformation, and dynamic DAX-based visual reporting.

# CineData Trabajo práctico grupal para la materia Ingeniería de Datos I en la Universidad Argentina de la Empresa. El mismo consistió en el desarrollo de una base de datos relacional en Microsoft SQL Server Managment Studio utilizando metodología Ágil SCRUM, que se utilizó desde el relevamiento de requisitos hasta la implementación final.

Relational Database Management System for AirBnB

This project entails the creation of a database system for a fictitious retail store. It involves designing an ERD, implementing it into a relational database structure using SQL statements, and populating the database with sample data. Custom SQL queries are crafted to extract insights, showcasing proficiency in data modeling and SQL query.