Introduction to Data Warehousing and Business Intelligence

What you'll learn

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.

Table of contents