starschema
Here are 31 public repositories matching this topic...
data modeling, design and ETL to create sparkify data warehouse on Postgressql
-
Updated
Jun 13, 2019 - Jupyter Notebook
Data Modeling and ETL with PostgreSQL for Udacity Data Engineering Nanodegree
-
Updated
Oct 16, 2019 - Jupyter Notebook
ETL pipeline that converts specific JSON object and seed relational database
-
Updated
Aug 1, 2020 - Python
Data Warehouse Repositories
-
Updated
Jan 3, 2021 - TSQL
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.
-
Updated
May 26, 2021 - Python
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…
-
Updated
Oct 24, 2021 - Jupyter Notebook
Using an xml document to extract the data and load into the table using XPath, node based xml parsing, MySQL
-
Updated
Dec 23, 2021
Projeto para organização dos dados no esquema estrela
-
Updated
Jan 7, 2022
This repository is about a project to create a database and ETL pipeline in PostgreSql for a music streaming app. They will define Fact and Dimension tables and insert data into new tables.
-
Updated
Mar 2, 2022 - Jupyter Notebook
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.
-
Updated
Apr 9, 2022
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.
-
Updated
Jun 10, 2022 - Python
Its a PowerBI and mySQL linked Project for generating Sales Insights.
-
Updated
Aug 17, 2022
-
Updated
Dec 17, 2022
-
Updated
Dec 17, 2022
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.
-
Updated
Jan 5, 2023
Creating erd using MySQL Workbench, Forward engineering, Dimensional data model, Tableau visualisation
-
Updated
Feb 27, 2023
Database Management System & Datawarehouse
-
Updated
Feb 28, 2023
Power BI report created for Job application tracking(HR analysis) under certain requirements. note: Flat file converted into Star Schema(Data modelling).
-
Updated
Apr 5, 2023
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
-
Updated
Apr 25, 2023
Improve this page
Add a description, image, and links to the starschema topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the starschema topic, visit your repo's landing page and select "manage topics."