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

Course Feature

Cost

Free
Provider

Youtube
Certificate

No Information
Language

English
Start Date

2021-09-27
Learners

No Information
Duration

No Information
Instructor

Analytics with Nags

Add to Favorites

2.0

141,584 Ratings

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!

Show All

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

Go to class

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.

Show All

Recommended Courses

Data Warehouse Concepts Data Warehouse Tutorial Data Warehouse Architecture Edureka

1.5

Youtube 403,923 learners

Learn More

This Data Warehouse Concepts tutorial will help you understand what is a Data Warehouse, its architecture, different types of Data Warehouses, its components, and its advantages. This Data Warehouse Concepts tutorial from Edureka is designed to help you understand the fundamentals of Data Warehousing. It covers topics such as what is a Data Warehouse, its architecture, different types of Data Warehouses, its components, and its advantages. With this tutorial, you will gain a comprehensive understanding of the concepts of Data Warehousing and its architecture. It will also help you understand the different types of Data Warehouses and their components. Finally, you will learn about the advantages of Data Warehousing.

Microsoft SQL Server 2014 Database Administration

4.1

Udemy 10,823 learners

Learn More

This course is perfect for anyone looking to become a SQL Developer. It covers the basics of SQL Server from installing to updating data. It also covers general knowledge of what a database is, different versions of SQL Server 2014, how to install SQL Server Express 2014, create a database, create tables, add data into tables, set foreign key relationships between tables, delete data from tables, update data in tables, and backup and restore databases. With this course, you will have the necessary knowledge to become a SQL Developer. Click now to get started!

Introduction to Databases and SQL Querying

4.5

Udemy 513,515 learners

Learn More

This course is the perfect introduction to Databases and SQL Querying for anyone looking to get acquainted with the concept. With no pre-requisites, all you need is a Windows machine and you'll be guided step-by-step from setting up your environment to creating your first table and writing your first query. Structured in a way that you can follow along, you'll be comfortable writing simple queries related to Dates, String manipulation, Aggregation, etc. by the end of the course. So, if you're looking to brush up on your skills for your next analyst interview, this is the course for you.

Distributed SQL and YugabyteDB Fundamentals

4.7

Udemy 3,869 learners

Learn More

This course will teach you the fundamentals of distributed SQL and YugabyteDB. In 90 minutes, you'll learn the core concepts of distributed SQL, YugabyteDB architecture and design principles, YSQL API development, and more. Through lectures and hands-on exercises, you'll gain the knowledge and skills to configure and get started with YugabyteDB. You'll also work through a variety of exercises, such as single and multi-node cluster installs, JDBC connectivity, user management and basic security, creating objects and loading data from external files, creating and exploring a sample database, creating functions and triggers, setting up admin tools, using a Java load generator, and testing fault tolerance. Don't miss out on this opportunity to learn the fundamentals of distributed SQL and YugabyteDB!