tranthe170's Stars
konosp/dbt-airflow-docker-compose
Execution of DBT models using Apache Airflow through Docker Compose
atifferoz/Data-warehouse-and-Business-Intelligence-project-on-Tuberculosis-WHO-
Implemented Data Warehouse and Business Intelligence project using different structured and unstructured data sources of various Incidents and Mortality rates of Tuberculosis for 197 countries around the world. The aim was to analyze the trends in mortality and incidence rates in countries around the world for tuberculosis. Data was web scrapped, cleansed and loaded using ETL designed star schema and deployed OLAP cube. Non-trivial BI queries were generated. First of all the data was extracted, cleaned and transformed using R language and further injected and loaded into SSMS where dimension tables were created using Insert query task. Kimbell's bottom-up approach was used to design the star schema in SSIS. Finally the cube was deployed in SSAS. Tableau was used for visual analytics to create dashboards. Technologies used: MS SQL, SQL Server Integration Services, SQL Server Analysis Services, Tableau. Video link of execution with explanation is available.
diegoct6/Business-Intelligence-Data-Warehousing
End-to-End BI & DW project: Data Warehousing design and modeling (MySQL), ETL (PDI) and Dashboard (Tableau)
kpratikin/Business-Intelligence-and-Data-Warehousing
Business Intelligence and Data Warehousing Project
onelittlenightmusic/star-yaml
YAML format for star schema and snowflake schema
ktnsh24/DataModelling
This repo will guide you step-by-step method to create star schema dimensional model.
Via-88/Data-Modeling-with-Postgres
psycopg2 | Star Schema | ETL Pipeline | Relational Database | SQL