Designing a Data Warehouse on the Microsoft SQL Server Platform
Ever wonder how it's possible to create meaningful reports from data spread over multiple sources? This course explores how to create a data warehouse project that provides answers to the customers’ critical questions regarding their business.
What you'll learn
Data is driving everything and the need to gain insight from data continues to become more abundant. In this course, Designing a Data Warehouse on the Microsoft SQL Server Platform, you’ll gain the ability to design and implement a data warehouse solution with the components provided by SQL Server. First, you’ll discover some of the characteristics of a data warehouse project and how such a project can help your customers to have a better understanding of their business progression. Next, you’ll explore the dimensional modeling design and will learn about each step in this system in more detail. Then, you'll delve into creating a data warehouse database and building an SSIS project to load the data warehouse with information essential for data analysis. Finally, you’ll learn how to create meaningful reports on top of the solution previously created. When you’re finished with this course, you’ll have the skills and knowledge of designing a robust data warehouse on the SQL Server platform needed to create an effective solution that helps your customers by gaining insights from the data accumulated.
Table of contents
- Introduction 1m
- What Is a Hierarchy? 4m
- Drilling Down a Hierarchy 3m
- Fixed-depth Positional Hierarchies 2m
- Demo - Creating and Working with a Fixed-depth Positional Hierarchy 7m
- Variable-depth Positional Hiearchies 4m
- Demo - Creating and Working with a Slightly Ragged Hierarchy 6m
- Ragged Hierarchies 5m
- Module Summary 2m
- Introduction 1m
- Advantages of Using an ETL Tool 5m
- Overview of SSIS 9m
- Demo - Creating a New SSIS Project 5m
- Demo - Creating Connection Managers 3m
- Demo - Creating Control Flow Elements 4m
- Demo - Creating and Working with Variables 4m
- Demo - Adding Precedence Constraints 4m
- Demo - Executing a SQL Task with Parameters 5m
- Summary 1m
- Introduction 2m
- Creating a Semantic Layer 6m
- The Multidimensional and Tabular Models 3m
- Demo - Creating a Multidimensional Database in SSAS 10m
- Demo - Analyzing Data from a SSAS Database 5m
- Creating Interactive Reports 4m
- Demo - Creating and Publishing a Report in Power BI Report Server 5m
- Course Summary 2m
About the author
Ana Voicu is a seasoned data engineer with a deep passion for databases, business intelligence, and data science. She specializes in developing enterprise-level Business Intelligence solutions across diverse industries, focusing on performance optimization, pattern recognition, efficient business process analysis, and interactive visualizations. Ana thrives on tackling database performance challenges, particularly those involving high data volume applications. Beyond her technical expertise, she... more