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.

Developing a Library Management System from scratch using SQL

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

A 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.

# 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

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

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.

Data Cleaning, Exploration, and Insights

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