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.
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.
Author Name: Ana Voicu
Author Description:
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
Table of Contents
- Course Overview
2mins - Understanding the Fundamental Concepts of a Data Warehouse
26mins - Dimension Table Techniques
31mins - Creating and Working with Hierarchies
33mins - Implementing Fact Tables
35mins - Loading Data in a Data Warehouse
33mins - Setting up an ETL Project with SSIS
41mins - Loading a Data Warehouse with SSIS
34mins - Visualizing Data from the Data Warehouse
36mins
User Reviews
Be the first to review “Designing a Data Warehouse on the Microsoft SQL Server Platform”
Related Products
Data Preparation and Modeling
Learn how to prepare and model data for analysis and visualization.
Preparing and Modeling Data with Power BI Fluency
Learn advanced techniques for preparing and modeling data within Power BI.
Data Modeling Fluency
Master the concepts of data modeling and database design for efficient data management.
Preparing and Modeling Data with Power BI
Master the skills for data preparation and modeling in Power BI.
Understanding and Applying Financial Risk Modeling Techniques
Financial risk modeling is at the intersection of two hot trends: Fintech and Big Data. This course covers three financial risk modeling techniques: covariance matrices, factor models, and value-at-risk.
Data Modeling
Learn how to build effective data models for databases and business applications.
There are no reviews yet.