Introduction to DW · Microsoft Data Technology · Relational Data Warehouse

DWBI – Part 2-c. Data Warehouse – Architectures

Data Warehouse Architectures

Introduction to DW · Microsoft Data Technology · Relational Data Warehouse

DWBI – Part 2-b. Data Warehouse – Gathering Requirements

Gathering Requirements

Introduction to DW · Microsoft Data Technology · Relational Data Warehouse

DWBI – Part 2-a. Data Warehouse – Planning

Data warehouse planning: 

Microsoft Data Technology

MSBI – SSRS – Create shared data sources and datasets for your reports

Create shared data sources and datasets for your reports:

Microsoft Data Technology

MSBI – SSAS: Tabular Semantic Models

SSAS Tabular Semantic Models: Update for SQL server 2016-

Introduction to DW · Relational Data Warehouse

DWBI – Part 1-a. Data Warehouse – Introduction to Business Intelligence

Introduction to Business Intelligence: https://youtu.be/dNQUF_6cLzM Creating ETL Stored Procedures:  https://youtu.be/dNQUF_6cLzM Note: Microsoft is the owner of the content and video in this blog post.

ETL using SSIS · Microsoft Data Technology · Microsoft SSIS

SSIS – Part 1. ETL – Creating an SSIS Project and Package

Creating an SSIS Project and Package

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 16. ETL – Creating SQL ETL Scripts

Creating SQL ETL Scripts

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 15. ETL – Creating ETL Stored Procedures

Creating ETL Stored Procedures

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 14. ETL – Implementing ETL with SQL Objects (VIEWS)

Implementing ETL with SQL Objects

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 13. ETL – Connecting Foreign Keys to Surrogate Keys

Connecting Foreign Keys to Surrogate Keys

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 12. ETL – Creating Date Lookup Tables

Creating Date Lookup Tables

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 11. ETL – Redefining Nullable Values for Enhanced Reporting

Redefining Nullable Values for Enhanced Reporting: CLICK to Continue Reading.......

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 10. ETL – Combining Data from Multiple Tables

Combining data from multiple tables: CLICK to continue reading....

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 9. ETL – Reformatting Data to Make it More Readable

Reformatting Data to Make it More Readable.....CLICK to Continue reading..........

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 8. ETL – Converting Data types for consistency

Converting Data Types for consistency:......... READ/VIEW VIDEO.................

Microsoft Data Technology · Microsoft SSDB · Transact SQL

TSQL – Part 1(d) – Working with NULLS

NULL is used to indicate an unknown or missing value. NULL is not equivalent to zero or an empty string. Arithmetic or string. CLICK to READ ....

Microsoft Data Technology · Microsoft SSDB · Transact SQL

TSQL – Part 1(c) – Data Types

Transact-SQL supports a wide range of data types, which can be broadly categorized as exact numeric, approximate numeric, character, date/time, binary, and other. CLICK TO READ...................

Microsoft Data Technology · Microsoft SSDB · Transact SQL

TSQL – Part 1(b) – SELECT statement

Use the SELECT statement to retrieve a rowset of data from tables and views in a database.. CLICK TO READ --------------

Microsoft Data Technology · Microsoft SSDB · Transact SQL

TSQL – Part 1(a) – Introduction to Transact SQL

Transact-SQL is an essential skill for database professionals and developers working with Microsoft SQL Server. CLICK to READ -----------------

Data Warehouse · ETL using SSDB · Microsoft Data Technology · Microsoft SSDB · Microsoft SSIS

SSDB – Part 4. ETL – Slowly Changing Dimension SCD Type 2 and 3

Extract Transform and Load using SQL server database stored procedure.