🌤 Create a cloud data warehouse on AWS Redshift

Assignments for CSCI 5408 - Data Management, Warehousing and Analytics

TP - Sistemas de Informação II

A simple web app that mines data from Spotify Web API using a csv list of track IDs

This project is aimed at improving the overall performance of a company specializing in selling bikes, biking accessories, clothing, and gear. At the beginning of the project, we were provided with the company’s dataset which we converted to a data warehouse. We came up with key performance indicators and created a Tableau dashboard for the same.

Emergency services casuistics from a national hospital

All about data

GitHub repository for Toronto Transit Commission Data warehousing project

A web application that aggregates and returns AirBnB data of New York City based on OLAP queries. In partial fulfillment of the course Advanced Database Systems (STADVDB) in De La Salle University-Manila.

Data Engineer Training Using Google Cloud Platform

Creation of data pipeline using Jupyter Notebook, PostgreSQL, and Apache Airflow.

Projects in Data Engineer Nanodegree by Udacity

We help start- ups & SME’s tackle complex problems, automate tasks, and address recurring issues.

Data Warehousing with AWS

Mines for VTU semester results and stored in warehouse. Data later used for analysis and training models using Regression and Gradient Descent

This contains the codes for Data Warehousing and Management Practical Session for Semester 6

Universidade do Minho - 4º ano

Data Warehousing project storing DB schemas for book store management system.

This project is implemented in Python and uses Airflow, MySQL Workbench, Apify and Power BI.

Built a data pipeline by creating tables in MySQL DB, ingested tables to Hadoop for data warehousing and built HiveQL views. Hive views in Linux VM were connected to Power BI application in Windows to create visualizations.