dimension-table

Complete materials for "Data Warehousing and Modeling" uni course: lectures (Inmon, Kimball, Dimensional Modeling, NoSQL), PostgreSQL labs (Star Schema), exam questions, and practical SQL solutions.

go-cardinality is a Go library that calculates the cardinality and distinct count of values in a dataset, providing efficient and accurate estimations.

SQL-based data analysis project using a large Swiggy food delivery dataset to explore restaurant distribution, pricing patterns, customer ratings, food categories, geographic trends, and customer engagement through data validation and structured SQL analysis.

Building Data Warehouse and ETL pipelines using Amazon S3 and Redshift

Proposta de implementar um sistema ETL robusto na Super Store para otimizar a gestão de dados desestruturados, melhorar a tomada de decisões e fortalecer a vantagem competitiva.

Create a time dimension table and populate it