Data Engineering on GCP and Mage AI
google-cloud-storage
fact-table
big-query
sales-analytics
dimensional-modeling
looker-studio
mage-ai
-
Updated
Mar 25, 2024 - Jupyter Notebook
#
fact-table
Here are 13 public repositories matching this topic...
This is an MSSQL Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
python
etl
pandas-dataframe
jupyter-notebook
data-transformation
microsoft-sql-server
database-schema
data-cleaning
t-sql
pyodbc
data-warehousing
extract-transform-load
dimension-tables
sql-server-management-studio
staging-area
fact-table
advanced-sql
-
Updated
Jan 13, 2024 - Jupyter Notebook
This is an Oracle DB Data Warehouse and ETL implementation on specially formatted Water Quality dataset from DEFRA, UK
python
etl
pandas-dataframe
jupyter-notebook
data-transformation
data-warehouse
database-schema
oracle-database
pyodbc
extract-transform-load
pl-sql
oracle-sql-developer
dimension-tables
staging-area
data-cleansing
fact-table
advanced-sql
oracle-21c
pl-sql-cursors
-
Updated
Dec 14, 2023 - Jupyter Notebook
Data Engineering Project - Python, PySpark & SQL - Azure Data Factory (ADF), DataBricks, Synapse Analytics, Azure Data Lake Storage (ADLS) Gen2, Power BI, Tableau and Looker Studio
python
sql
etl
azure
dimensions
pyspark
powerbi
data-modeling
azure-sql-database
azure-data-factory
star-schema
etl-pipeline
dime
azure-databricks
fact-table
azure-sql
azure-synapse-analytics
azure-data-lake-gen2
-
Updated
Oct 13, 2023 - Jupyter Notebook
A Coding Factory @ AUEB - SQL Project. - Final Project - Camping Database
-
Updated
Jun 20, 2023 - TSQL
Data Vault model for analyzing the flight activity and reservation processes of a major airline company. Provides SQL scripts, queries, and reports for gaining insights into business operations and improving performance.
-
Updated
May 18, 2023
Irish Property Price Register transformed into a data warehouse via an EtLT pipeline.
python
docker
aws
s3
data-warehouse
data-engineering
boto3
etl-pipeline
data-engineering-pipeline
fact-table
elt-pipeline
-
Updated
Feb 21, 2023 - TypeScript
Building Data Warehouse and ETL pipelines using Amazon S3 and Redshift
aws
sql
data-warehouse
data-engineering
cloud-computing
amazon-s3-storage
data-modeling
amazon-redshift
star-schema
etl-pipeline
fact-table
dimension-table
-
Updated
Dec 23, 2022 - 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…
python
postgres
sql
pipeline
etl
postgresql
jupyter-notebook
dimension-tables
etl-pipeline
fact-table
schemadesign
starschema
datamodeling
-
Updated
Oct 24, 2021 - Jupyter Notebook
Cube Creation using VIsual Studio, OLAP Reports and Power Bi
-
Updated
Oct 3, 2021
Data Warehouse creation using MySQL and R
mysql
data-mining
r
sql
parsing
xml
data-visualization
pubmed
mysql-database
dimension-tables
sql-table
summary-tables
erdiagram
fact-table
snowflake-schema
-
Updated
Aug 24, 2021
This is a business intelligence project on analyzing super market data. Check out the README file for more details.
mysql
python
machine-learning
sql
data-visualization
business-intelligence
mysql-database
olap
database-management
data-analysis
tableau
supermarket
kmeans-clustering
dimension-tables
olap-cube
kmeans-algorithm
business-analytics
fact-table
supermarket-management-system
-
Updated
May 11, 2020 - Python
Using ETL process to Extract, Transform, and Load local data into a PostgreSQL database
-
Updated
Aug 2, 2019 - Jupyter Notebook
Improve this page
Add a description, image, and links to the fact-table topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the fact-table topic, visit your repo's landing page and select "manage topics."