StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries. InfoWorld’s 2023 BOSSIE Award for best open source software.

A framework for rapid reporting API development; with out of the box support for high cardinality dimension lookups with druid.

This repository is a place for the Data Warehousing course at the Information Systems & Analytics department, Santa Clara University.

Microsoft Power BI é um ferramenta de BI Self-Service que empondera o usuário a criar Relatórios e Dashboards - Aqui terá dicas de aprendizagem - DAX - Soluções

Global Cycling Company Data Warehouse! We gather data from AdventureWorks 2016, utilize tools like SSMS for efficient storage and retrieval, and employ ETL processes for seamless integration and analysis. 🚴‍♂️🛠️

Batch & streaming data pipelines built using Databricks with Pyspark and modeled the data into star schema to analyze in PowerBI, Formula-1 racing data from multiple data sources, APIs.

Source code for the Kimball-style date dimension generator dimdates.com.

This project encompasses the complete data lifecycle, from data extraction and transformation to in-depth analysis and compelling visualizations. The process is divided into three main phases

Designing a star schema data warehouse based on the Northwind database and implementing the ETL process using the SSIS tool.

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

Data warehouse design and database implementation using SQL and Tableau

EssentialMonolith

Demonstrating the core skills acquired by making use of Advanced Database Modeling.

This project documentation was developed as a free project, as a data analyst from the fictional company Sell Boardgames would do in his daily work.

The main goal of this project is building up a data warehouse as a single-source-of-truth database by integrating data from different data sources for data analytics purpose and future backend usage.

All in one slice and dice module

Construção de um data warehouse simples em PostgreSQL a partir de um banco de dados de exemplo, seguindo a lógica do modelo Star Schema.

creates postgres ETL pipeline on a star schema.