Implement a MS SQL Server Data Warehouse & Power BI Solution

What you will learn

Describe the key elements of a data warehousing solution

Describe the main hardware considerations for building a data warehouse

Implement a logical design for a data warehouse

Implement a physical design for a data warehouse

Create columnstore indexes

Implementing a MS SQL Server Data Warehouse

Describe the key features of SSIS

Implement a data flow by using SSIS

Implement control flow by using tasks and precedence constraints

Create dynamic packages that include variables and parameters

Debug SSIS packages

Describe the considerations for implement an ETL solution

Implement Data Quality Services

Deploy SSIS projects

Implement a Master Data Services model

Describe how you can use custom components to extend SSIS

Describe BI and common BI scenarios

Create a data warehouse with Microsoft SQL Server

Implement ETL with SQL Server Integration Services

validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.


A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are intended to perform queries and analysis and often contain large amounts of historical data. The data within a data warehouse is usually derived from a wide range of sources such as application log files and transaction applications.

A data warehouse centralizes and consolidates large amounts of data from multiple sources. Its analytical capabilities allow organizations to derive valuable business insights from their data to improve decision-making. Over time, it builds a historical record that can be invaluable to data scientists and business analysts. Because of these capabilities, a data warehouse can be considered an organization’s “single source of truth.”

Data warehouses offer the overarching and unique benefit of allowing organizations to analyze large amounts of variant data and extract significant value from it, as well as to keep a historical record.

A typical data warehouse often includes the following elements:

  • A relational database to store and manage data
  • An extraction, loading, and transformation (ELT) solution for preparing the data for analysis
  • Statistical analysis, reporting, and data mining capabilities
  • Client analysis tools for visualizing and presenting data to business users
  • Other, more sophisticated analytical applications that generate actionable information by applying data science and artificial intelligence (AI) algorithms, or graph and spatial features that enable more kinds of analysis of data at scale.

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want.

Power BI consists of several elements that all work together, starting with these three basics:

  • A Windows desktop application called Power BI Desktop.
  • An online SaaS (Software as a Service) service called the Power BI service.
  • Power BI mobile apps for Windows, iOS, and Android devices.




Microsoft SQL Server Setup


Please Read

What is SQL Server

SQL Server Editions

Hardware | Software Requirements

SQL Server Download

SQL Server Installation

Install SSMS

SQL Server Configuration Manager

Connecting SSMS to SQL Server

Database Concepts

Installing Sample Databases

Installing Adventureworks 2014

Installing Adventureworks 2016

Installing AdventureworksDW 2016

Installing World Wide Importers

Installing World Wide ImportersDW

SQL Server Data Files

Microsoft Visual Studio Setup

What is Visual Studio

Minimum Installation Requirements

Installing Visual Studio

visual Studio workloads

Install SQL Server Data Tools

Installing SSDT Templates

Introduction to Data Warehousing

What is Data Warehouse

Data Warehouse vs Enterprise Data Warehouse

Data Warehouse Vs Database

Data Warehouse Requirements

Hardware Requirements

Enabling SQL Server Agent

Database Configurations

FTDW Sizing Tool ( Already Downloaded)

FTDW Sizing Tool

Designing a Data Warehouse

Logical Design of Data Warehouse

Physical Design of Data Warehouse – Part 1

Physical Design of Data Warehouse -Part 2

Designing Dimension Tables

Creating an ETL Solution

Get Instant Notification of New Courses on our Telegram channel.

What is ETL

What is SSIS

Introduction to ETL with SSIS

Creating a new SSIS Project

Exploring Source Data : Part 1

Exploring Source Data : Part 2

Implementing Control Flow & Data flow in an SSIS Package

Introduction to control flow: Part 1

Introduction to control flow: Part 2

Implementing data flow – Part 1

Implementing data flow – Part 2

Debugging and Troubleshooting SSIS Packages

Debugging SSIS Package : Part 1

Debugging SSIS Package : Part 2

Logging SSIS Package Events

Handling errors in an SSIS Package

Implementing an Incremental ETL Process

Introduction to incremental ETL Process

Extracting modified data: Part 1

Extracting modified data: Part 2

Extracting modified data: Part 3

Extracting modified data: Part 4

Loading modified data: Part 1

Loading modified data: Part 2

Working with changing dimensions

Deploying and Configuring SSIS Packages

Integration services catalogs

Deploying SSIS Solutions

Execute a package with SQL Server Agent

Configuring advanced SSIS Settings

Enforcing Data Quality in Data Warehouse

Installing Data Quality Services

Cleansing data with data quality services

Find duplicate data : Part 1

Find duplicate data : Part 2

Using data quality services in SSIS data flow

Consuming Data in a Data Warehouse

Introduction to Business Intelligence

Creating a new SSRS Project in VS 2019

Using SSRS in Data Warehouse: Part 1

Using SSRS in Data Warehouse: Part 2

Creating a new SSAS Project

Data Analysis with SSAS : Part 1

Data Analysis with SSAS : Part 2

Microsoft Power BI Setup

Office 365 Setup

What is Power BI

What is Power BI Desktop

Installing Power BI Desktop

Power BI Desktop Tour

Power BI Overview

Power BI Overview : Part 1

Power BI Overview : Part 2

Power BI Overview : Part 3

Components of Power BI

Building blocks of Power BI

Exploring Power BI Desktop Interface

Exploring Power BI Service

Power BI Apps

Data Analysis & Visualisation with Power BI

Connecting to web based Data

Cleaning & transforming data – Part 1

Cleaning & transforming data – Part 2

Combining Data Sources

Creating visuals in Power BI – Part 1

Creating visuals in Power BI – Part 2

Publishing Report To Power BI Service