Building a multidimensional database system for NorthWind and analysing it's data
-
Updated
Jan 6, 2020 - TSQL
Building a multidimensional database system for NorthWind and analysing it's data
A large-scale data framework that will enable us to store and analyze financial market data and drive future predictions for investment.
Warehouse project for aviation data from 2019 in USA. ETL process, analyze using OLAP cube, data displayed with PowerBI
Syracuse University, Masters of Applied Data Science - IST 722 Data Warehouse
db2 project : a data warehouse for modified version of "Bike Stores" db which has more than 1M data.
End-to-End BI & DW project: Data Warehousing design and modeling (MySQL), ETL (PDI) and Dashboard (Tableau)
DDL code for creating the Fudge Corp data warehouse. In partial fulfillment of the requirements for IST-722, Syracuse University, MS in Applied Data Science program.
Building an ETL workflow in SSIS for a retail data warehouse.
College assignment to create an ETL system to load a Data Warehouse.
Practice leaning data warehouse
Dedicated repository for Microsoft SQL Server functions and samples.
Dedicated repository for Microsoft SQL Server code templates and samples.
Repositório focado no curso de Business Intelligence, SQL Server e Integration Services disponível na plataforma Alura
EDW Catapult is a CLI tool to automate the deployment of the Mass Street Analytics Data Warehouse ETL Framework.
All the necessary scripts so as to set up a data warehouse with three databases.
A simplified introdocutory data analysis report to show how using SQL queries can answer questions from a data warehouse with a star schema. The report answers why server downtime happens and how it can be fixed.
Staging and de-normalized data warehouse tables, in a star schema, with a date table, dimension and fact tables designed for data analysis.
A Three Day Project about creating a Staging and an OLAP Database for the Northwind Samplefiles
This repository contains all the assignments, workshops and mini-projects of course - DAMG7370 Designing Advanced Data Architectures for Business Intelligence
Add a description, image, and links to the data-warehouse topic page so that developers can more easily learn about it.
To associate your repository with the data-warehouse topic, visit your repo's landing page and select "manage topics."