DWBI – Part 2-c. Data Warehouse – Architectures

Data Warehouse Architectures

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

Gathering Requirements

DWBI – Part 2-a. Data Warehouse – Planning

Data warehouse planning: 

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

Create shared data sources and datasets for your reports:

MSBI – SSAS: Tabular Semantic Models

SSAS Tabular Semantic Models: Update for SQL server 2016-

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.

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

Creating an SSIS Project and Package

SSDB – Part 16. ETL – Creating SQL ETL Scripts

Creating SQL ETL Scripts

SSDB – Part 15. ETL – Creating ETL Stored Procedures

Creating ETL Stored Procedures

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

Implementing ETL with SQL Objects

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

Connecting Foreign Keys to Surrogate Keys

SSDB – Part 12. ETL – Creating Date Lookup Tables

Creating Date Lookup Tables

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

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

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

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

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

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

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

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

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 ....

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...................

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 --------------

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 -----------------

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

Extract Transform and Load using SQL server database stored procedure.