Passo a passo de como fazer um projeto de BI (Business Intelligence) do planejamento aos testes de dashboards.

Ensias TP about data warehouses using SQL Server and Docker

A sandbox application for all things SQL Server, Power BI and SSDT

Starter project for building an ETL pipeline using SSIS in Visual Studio 2019

Presentation Slide Decks & Demos

This repository contains a real example of an Extract, Transform, Load (ETL) process using SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), and AdventureWorks2012 data. The objective is to load data into our LightAdventureDW data warehouse.

SQL and T-SQL for the project from the data warehouse classes

By using AdventureWorks2022 Dataset I have built a Sales Data Mart using (SQL Server Integration Services SSIS) SQL Server involves leveraging the capabilities of Integration Services (SSIS) and the Modeling of SQL Server, This Data mart offers several benefits, making them valuable components in the main purpose of data management and analytics wi

Design and Implementation of a data warehouse on the "Northwind" database.

Dive deep into Slowly Changing Dimensions (SCD) ETL in action with this comprehensive tutorial! In this video, we'll explore how to effectively manage changing data using SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).

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

Integration Services, Analysis Services e Reporting Services - Do zero ao Datawarehouse com ETL e Cubos

MSBI Couse SSIS learn it apply it view the result

Practica con mayor rango de dificultad relativa, desarrollada en visual studio SSIS, ETL, Microsoft Office 2016, Sql server 2016

Automated data extraction using APIs, AWS functions to build ETL pipelines, and data modeling in SSIS. Performed data manipulation, profiling, cleansing, integration, and price history tracking.

Using SQL and SSIS, I extracted COVID data from a .csv file and loaded it to a table in SQL Server. You can also find SSIS files with some transformations.

Đồ án Kho dữ liệu - SSMS SSIS SSAS SSRS - Việt Hàn (VKU)

Antenna Distribution is a project that shows how to run business analysis tools on a set of a data.

Business Intelligence Workshops