Data warehousing is a set of techniques and technologies that aggregate data from one or more operational systems. They provide the unique ability for analyzing data from multiple sources and typically play host to relational database technologies. They consist of data that has already been integrated, but they are limited in the size and scope to what they can actually hold. Data warehouses are stored in an enterprise mainframe server that can either by physical or virtual (cloud).
Learning data warehouse skills can be a complicated process, and it’s not easy to know where to start. As a result, our editors have compiled this list of the best data warehouse tutorials on YouTube to help you learn about the topic and hone your skills before you move on to mastering it. All of the videos here are free to access and feature guidance from some of the top minds and biggest brands in the online learning community. All of the best data warehouse tutorials listed tout a minimum of 75,000 views.
Note: Don’t forget to subscribe to Solutions Review on YouTube!
Description: This data warehouse tutorial for beginners will give you an introduction to data warehousing and business intelligence. You will be able to understand basic data warehouse concepts with examples. This video covers topics like OLTP, OLAP, ETL, Data Mart, metadata, data warehouse architecture, and even a demonstration on data warehouse creation.
Description: This tutorial on data warehouse concepts will tell you everything you need to know in performing data warehousing and business intelligence. Various data warehouse concepts explained in this video include OLAP, different types of OLAP Cubes, dimensions, facts, and measures, and data warehouse schema.
Description: This video discusses ETL (extract, transform, load), data warehousing, and the purpose of it. The difference between OLTP (Online Transaction Processing System) vs. OLAP (Online Analytics Processing System) is also a key consideration. The video covers additional topics like Talend, Informatica, Amazon Redshift, and Snowflake as well.
Description: This video will help you understand what a data warehouse is using a very simple real-life example. A data warehouse is nothing more than a storeroom of your house. Data warehouses store all your enterprise data into a centralized location and are hence called enterprise data warehouses. The video also outlines various data warehouse stages and common characteristics.
Author: Pragmatic Works
Description: This video discusses the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. It also outlines how the design of our dimensional model affects an SQL Server Analysis Services solution and how the choices made during the data warehouse design phase can make or break SSAS cubes.