Data Warehouse Architectures
DWBI – Part 2-c. Data Warehouse – Architectures
Data Warehouse Architectures
Data is everywhere & Data is everything – Bring them together to make it meaningful!
Data Warehouse Architectures
Gathering Requirements
Data warehouse planning:
Create shared data sources and datasets for your reports:
SSAS Tabular Semantic Models: Update for SQL server 2016-
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.
Creating an SSIS Project and Package
Creating SQL ETL Scripts
Creating ETL Stored Procedures
Implementing ETL with SQL Objects
Connecting Foreign Keys to Surrogate Keys
Creating Date Lookup Tables
Redefining Nullable Values for Enhanced Reporting: CLICK to Continue Reading.......
Combining data from multiple tables: CLICK to continue reading....
Reformatting Data to Make it More Readable.....CLICK to Continue reading..........
Converting Data Types for consistency:......... READ/VIEW VIDEO.................
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 ....
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...................
Use the SELECT statement to retrieve a rowset of data from tables and views in a database.. CLICK TO READ --------------
Transact-SQL is an essential skill for database professionals and developers working with Microsoft SQL Server. CLICK to READ -----------------
Extract Transform and Load using SQL server database stored procedure.