[[ 3 HOURS ]] Data Warehouse Complete Tutorial - SQL + SSIS + SSAS + Power BI - [ End to End ]

Learners: 141,584

Instructor: Analytics with Nags

Duration:

This 3-hour course is a comprehensive guide to Data Warehouse concepts, architecture, terminologies, design, implementation, and more. It covers topics such as SQL Server, SSIS, SSAS, and Power BI, and provides hands-on experience with the Adventure Works OLTP Database and AWN Data Warehouse Database Scripts. With this course, you will learn how to install SQL Server and SSDT SSMS, create Power BI reports, and deploy SSIS packages and SQL Agent Schedules. Get the skills you need to become a Data Warehouse expert today! ▼▲

Course Feature Course Overview Course Provider Discussion and Reviews

Go to class

Course Feature

Cost:

Free

Provider:

Youtube

Certificate:

No Information

Language:

English

Start Date:

2021-09-27 00:00:00

Course Overview

❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [July 21st, 2023]

This 3-hour course provides an end-to-end overview of Data Warehouse concepts, architecture, terminologies, design, implementation, and reporting. It covers topics such as SQL Server, SSIS, SSAS, and Power BI. The course begins with an introduction to Data Warehouse and its architecture. It then covers Data Warehouse terminologies and a business case study. It then moves on to Data Warehouse designing and implementation. It also covers SSIS, surrogate key, and slowly changing dimension. It also covers adding data to dimension and incremental load, deploying SSIS package and SQL agent schedule, SSAS tabular model, and creating Power BI reports. The course also covers installing SQL Server and SSDT SSMS, and downloading the Adventure works OLTP Database and AWN Data warehouse Database Scripts.