Introduction to Data Warehousing and Business Intelligence

Data Warehousing and Business Intelligence is one of the hottest skills today, and is the cornerstone for reporting, data science, and analytics. This course teaches the fundamentals with examples plus a project to fully illustrate the concepts.
Course info
Rating
(49)
Level
Beginner
Updated
Dec 20, 2017
Duration
1h 53m
Table of contents
Description
Course info
Rating
(49)
Level
Beginner
Updated
Dec 20, 2017
Duration
1h 53m
Description

Some of the hottest buzzwords in the IT space include data science, analytics, and machine learning. All of these are based upon a foundation of business intelligence, which rests on the shoulders of data warehousing. A solid understanding of Data Warehousing/Business Intelligence (DW/BI) is critical in order to be successful as a data professional in today's marketplace. In this course, Introduction to Data Warehousing and Business Intelligence, you'll begin with an understanding of the terms and concepts of Data Warehousing and Business Intelligence. Next, you'll see concrete examples which clearly illustrate these terms. Finally, you will see a sample implementation of a DW/BI project with SQL Server. As a DBA, database designer, or report developer the skills in this course will help you create and work with your data warehouse. If you are a project manager or business user, understanding how your data warehouse works will allow you to communicate your needs clearly with your development team to get the most from your business intelligence solutions. Finally, if you are on the road to becoming a data scientist, understanding the design of your data warehouses will aid you in being able to extract the data you need for your analytical solutions.

About the author
About the author

Robert C. Cain (arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books.

More from the author
Kusto Query Language (KQL) from Scratch
Beginner
4h 33m
20 Jun 2018
Azure PowerShell Playbook: Azure SQL
Intermediate
1h 4m
18 Jan 2018
SQL Server Reporting Services Playbook
Beginner
2h 16m
30 Jan 2017
More courses by Robert Cain
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name's Robert Cain, welcome to my course, Introduction to Data Warehousing and Business Intelligence. I am the owner of Arcane Training and Consulting and a Microsoft Data Platform MVP Data warehousing and business intelligence, or DW/BI for short, is one of the hottest skills in the market today. For IT pros, understanding the concepts will be vital as you begin to roll out your own DW/BI project. If you're a business user, project manager, or executive understanding how your data is organized will allow you to leverage it, and make the best decisions for your business. Some of the major topics that we will cover include the terms and concepts behind data warehousing and business intelligence, seeing data warehousing terms clearly illustrated with concrete examples, and looking at a full implementation of a data warehousing/business intelligence solution using Microsoft SQL Server. By the end of this course, you should be comfortable with the terminology and concepts in the world of data warehousing and business intelligence. Before beginning the course, it will be helpful if you are familiar with database terms like "Tables" and "Columns" I hope you will join me on this journey to learn data warehousing and business intelligence with my Introduction to Data Warehousing and Business Intelligence course at Pluralsight.