Data Warehouse Repositories
-
Updated
Jan 3, 2021 - TSQL
Data Warehouse Repositories
This repository is about a project to create a datawarehouse and ETL pipeline on AWS for a music streaming app. They will define Fact and Dimension tables and insert data into new tables. At the end, I'm going to process two analytical queries to check it out the top ten artists and songs.
Here's my first project on PowerBI. The project using Power BI based on DASHBOARD, ANALYSIS, REPORTING (DAR) format to find out the insight about those Vending Machine sale issue at HCM City, data source collected on March, 2021
ETL pipeline that converts specific JSON object and seed relational database
In this project, I'll apply what I've learned on data modeling with Postgres and build an ETL pipeline using Python. To complete the project, I will define the fact and dimension tables for a star schema for a particular analytic focus, and write an ETL pipeline that transfers data from files in two local directories into these tables in Postgre…
Data Modeling and ETL with PostgreSQL for Udacity Data Engineering Nanodegree
Built an ETL pipeline that extracts their data from S3, stages them in Redshift, and transforms data into a set of dimensional tables. Load data from S3 to staging tables on Redshift and execute SQL statements that create the analytics tables from these staging tables.
Database Management System & Datawarehouse
A Sales and Product Management Dashboard created using SQL, Power BI and Microsoft Adventureworks2022 data
📊🌈🏛 This project develop a data warehouse for a bank using Amazon Redshift and DBT, following a ⭐ Star Schema architecture 🏵️
Its a PowerBI and mySQL linked Project for generating Sales Insights.
Dashboard para planejamento de vendas, com diversas visões e vários ângulos de informação, utilizando o conceito consolidado do Star Schema e Data Warehouse, muito comum em bancos de dados estruturados de grandes empresas.
This is a dataware house produced in eclipse using python code, that works with a star schema i produced in order to store sales information for a fictional stationary company.
Projeto para organização dos dados no esquema estrela
Sales & inventory data for a fictitious chain of toy stores in Mexico called Maven Toys, including information about products, stores, daily transactions, and current inventory levels at each location.
how to do snowflake schema from star schema based on postcard products
Add a description, image, and links to the starschema topic page so that developers can more easily learn about it.
To associate your repository with the starschema topic, visit your repo's landing page and select "manage topics."