We may earn an affiliate commission when you visit our partners.
John Savill
This course looks at the components in Microsoft Azure that can be used as part of a data warehouse solution, as well as common architectures for a data warehouse implementation.
Read more
This course looks at the components in Microsoft Azure that can be used as part of a data warehouse solution, as well as common architectures for a data warehouse implementation.
Read more
This course looks at the components in Microsoft Azure that can be used as part of a data warehouse solution, as well as common architectures for a data warehouse implementation.
Organizations want answers and many of those answers come from data analysis, but that can be challenging with the vast amount and variety of data in a modern organization. In this course, Plan for Data Warehousing with Microsoft Azure, you will learn foundation knowledge of data warehousing and core components in Microsoft Azure that can be used to solve this problem. First, you will examine the fundamentals of data warehousing and identifying requirements. Next, you will explore key Microsoft technologies that will form part of the complete data warehouse solution. Finally, you will discover common architectures for a complete data warehouse solution. When you’re finished with this course, you will have the skills and knowledge of data warehousing to design an architecture in Microsoft Azure.
Register for this course and see more details by visiting:
OpenCourser.com/course/0hdwwc/plan
What's inside
Syllabus
Course Overview
Understanding Data Warehouse Core Concepts
Designing Data Warehouse Solutions in Azure
Reference Architectures
Read more
Syllabus
Course Overview
Understanding Data Warehouse Core Concepts
Designing Data Warehouse Solutions in Azure
Reference Architectures
Read more
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Explores standard industry concepts and practices
Develops core data warehousing solutions in Microsoft Azure
Examines common architectures for complete data warehouse solutions
Teaches foundational knowledge of data warehousing
Taught by John Savill, a recognized expert in Microsoft Azure
Save this course
Save Plan for Data Warehousing with Microsoft Azure to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Plan for Data Warehousing with Microsoft Azure with these
activities:
Review Course Materials
Show steps
This activity will help you get a head start on learning the fundamentals of data warehousing.
Show steps
-
Review the course syllabus.
-
Skim through the course textbook.
-
Watch online videos about data warehousing.
Read "Data Warehousing Fundamentals" by Ralph Kimball
Show steps
This book will give you a solid understanding of the concepts and technologies involved in data warehousing.
View
The Kimball Group Reader
on Amazon
Show steps
-
Read Chapter 1: Introduction to Data Warehousing.
-
Read Chapter 2: The Data Warehouse Architecture.
-
Read Chapter 3: Data Warehouse Design.
-
Read Chapter 4: Data Warehouse Implementation.
-
Read Chapter 5: Data Warehouse Management.
Complete the Microsoft Azure Data Warehouse Fundamentals tutorial
Show steps
This tutorial will teach you how to create and manage a data warehouse in Microsoft Azure.
Show steps
-
Go to the Microsoft Azure Data Warehouse Fundamentals tutorial.
-
Follow the instructions in the tutorial.
-
Complete the exercises in the tutorial.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Join a study group for this course
Show steps
This activity will give you the opportunity to learn from and collaborate with other students.
Show steps
-
Find a study group for this course.
-
Attend study group meetings.
-
Participate in discussions.
-
Work on projects together.
Create a data warehouse in Microsoft Azure
Show steps
This activity will give you hands-on experience with creating and managing a data warehouse in Microsoft Azure.
Show steps
-
Create a new Azure resource group.
-
Create a new Azure Storage account.
-
Create a new Azure Data Warehouse.
-
Load data into your Azure Data Warehouse.
-
Query your Azure Data Warehouse.
Design a data warehouse architecture for a specific business scenario
Show steps
This activity will help you apply your knowledge of data warehousing to a real-world scenario.
Show steps
-
Identify the business requirements for the data warehouse.
-
Design the data warehouse architecture.
-
Create a prototype of the data warehouse.
-
Evaluate the performance of the data warehouse.
-
Write a report on your findings.
Build a data warehouse for a non-profit organization
Show steps
This activity will give you the opportunity to apply your skills to a real-world project.
Show steps
-
Identify a non-profit organization that needs a data warehouse.
-
Design the data warehouse architecture.
-
Create the data warehouse.
-
Load data into the data warehouse.
-
Train the non-profit organization on how to use the data warehouse.
Review Course Materials
Show steps
This activity will help you get a head start on learning the fundamentals of data warehousing.
Show steps
Show steps
Show steps
- Review the course syllabus.
- Skim through the course textbook.
- Watch online videos about data warehousing.
Read "Data Warehousing Fundamentals" by Ralph Kimball
Show steps
This book will give you a solid understanding of the concepts and technologies involved in data warehousing.
View
The Kimball Group Reader
on Amazon
Show steps
Show steps
Show steps
- Read Chapter 1: Introduction to Data Warehousing.
- Read Chapter 2: The Data Warehouse Architecture.
- Read Chapter 3: Data Warehouse Design.
- Read Chapter 4: Data Warehouse Implementation.
- Read Chapter 5: Data Warehouse Management.
Complete the Microsoft Azure Data Warehouse Fundamentals tutorial
Show steps
This tutorial will teach you how to create and manage a data warehouse in Microsoft Azure.
Show steps
Show steps
Show steps
- Go to the Microsoft Azure Data Warehouse Fundamentals tutorial.
- Follow the instructions in the tutorial.
- Complete the exercises in the tutorial.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Join a study group for this course
Show steps
This activity will give you the opportunity to learn from and collaborate with other students.
Show steps
Show steps
Show steps
- Find a study group for this course.
- Attend study group meetings.
- Participate in discussions.
- Work on projects together.
Create a data warehouse in Microsoft Azure
Show steps
This activity will give you hands-on experience with creating and managing a data warehouse in Microsoft Azure.
Show steps
Show steps
Show steps
- Create a new Azure resource group.
- Create a new Azure Storage account.
- Create a new Azure Data Warehouse.
- Load data into your Azure Data Warehouse.
- Query your Azure Data Warehouse.
Design a data warehouse architecture for a specific business scenario
Show steps
This activity will help you apply your knowledge of data warehousing to a real-world scenario.
Show steps
Show steps
Show steps
- Identify the business requirements for the data warehouse.
- Design the data warehouse architecture.
- Create a prototype of the data warehouse.
- Evaluate the performance of the data warehouse.
- Write a report on your findings.
Build a data warehouse for a non-profit organization
Show steps
This activity will give you the opportunity to apply your skills to a real-world project.
Show steps
Show steps
Show steps
- Identify a non-profit organization that needs a data warehouse.
- Design the data warehouse architecture.
- Create the data warehouse.
- Load data into the data warehouse.
- Train the non-profit organization on how to use the data warehouse.
Career center
Learners who complete Plan for Data Warehousing with Microsoft Azure will develop knowledge and skills
that may be useful to these careers:
Data Warehouse Analyst
Data Warehouse Analyst
Data Warehouse Analysts are technology and business professionals who work with teams to define requirements, develop strategies, and translate user needs into technical solutions. They understand the fundamentals of data warehousing, data integration, and data modeling. In this course, you will learn about Microsoft Azure, which is a leading cloud platform for data warehousing. You will also explore common architectures for a data warehouse implementation. This course will help you build a foundation in data warehousing and prepare you for a career as a Data Warehouse Analyst.
Data Warehouse Architect
Data Warehouse Architect
Data Warehouse Architects design, build, and maintain data warehouses. They work with stakeholders to understand business requirements and translate them into technical specifications. Data Warehouse Architects also develop and implement data integration and data quality solutions. This course will help you build a foundation in data warehousing and prepare you for a career as a Data Warehouse Architect. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing. You will also explore common architectures for a data warehouse implementation.
Database Administrator
Database Administrator
Database Administrators (DBAs) are responsible for the day-to-day operations of databases, including data warehousing databases. They install, configure, and maintain database software and hardware. DBAs also perform data backups and recoveries, and they monitor database performance. This course will help you build a foundation in data warehousing and prepare you for a career as a DBA. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing. You will also explore common architectures for a data warehouse implementation.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines. They work with data scientists and data analysts to understand data requirements and develop data solutions. Data Engineers also develop and implement data quality and data integration solutions. This course will help you build a foundation in data warehousing and prepare you for a career as a Data Engineer. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing. You will also explore common architectures for a data warehouse implementation.
Data Architect
Data Architect
Data Architects design and develop data management solutions. They work with stakeholders to understand business requirements and translate them into technical specifications. Data Architects also develop and implement data integration and data quality solutions. This course will help you build a foundation in data warehousing and prepare you for a career as a Data Architect. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing. You will also explore common architectures for a data warehouse implementation.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts use data to make informed business decisions. They develop and implement data analysis and data mining algorithms. Business Intelligence Analysts also work with stakeholders to communicate data insights and recommendations. This course will help you build a foundation in data warehousing and prepare you for a career as a Business Intelligence Analyst. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing. You will also explore common architectures for a data warehouse implementation.
Data Scientist
Data Scientist
Data Scientists use data to solve business problems. They develop and implement data analysis and data mining algorithms. Data Scientists also work with stakeholders to communicate data insights and recommendations. This course will help you build a foundation in data warehousing and prepare you for a career as a Data Scientist. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing. You will also explore common architectures for a data warehouse implementation.
Cloud Engineer
Cloud Engineer
Cloud Engineers design, develop, and maintain cloud computing solutions. They work with stakeholders to understand business requirements and translate them into technical specifications. Cloud Engineers also develop and implement data integration and data quality solutions. This course will help you build a foundation in data warehousing and prepare you for a career as a Cloud Engineer. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. They work with stakeholders to understand business requirements and translate them into technical specifications. Software Engineers also develop and implement data integration and data quality solutions. This course will help you build a foundation in data warehousing and prepare you for a career as a Software Engineer. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing.
Data Integration Specialist
Data Integration Specialist
Data Integration Specialists design and implement data integration solutions. They work with stakeholders to understand business requirements and translate them into technical specifications. Data Integration Specialists also develop and implement data quality solutions. This course will help you build a foundation in data warehousing and prepare you for a career as a Data Integration Specialist. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing.
Data Analyst
Data Analyst
Data Analysts use data to solve business problems. They develop and implement data analysis and data mining algorithms. Data Analysts also work with stakeholders to communicate data insights and recommendations. This course will help you build a foundation in data warehousing and prepare you for a career as a Data Analyst. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing.
Data Quality Analyst
Data Quality Analyst
Data Quality Analysts develop and implement data quality solutions. They work with stakeholders to understand business requirements and translate them into technical specifications. Data Quality Analysts also develop and implement data integration solutions. This course will help you build a foundation in data warehousing and prepare you for a career as a Data Quality Analyst. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing.
Information Technology Manager
Information Technology Manager
Information Technology Managers plan and direct the implementation of information systems. They work with stakeholders to understand business requirements and translate them into technical specifications. Information Technology Managers also develop and implement data integration and data quality solutions. This course will help you build a foundation in data warehousing and prepare you for a career as an Information Technology Manager. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing.
Database Developer
Database Developer
Database Developers design and develop database applications. They work with stakeholders to understand business requirements and translate them into technical specifications. Database Developers also develop and implement data integration and data quality solutions. This course will help you build a foundation in data warehousing and prepare you for a career as a Database Developer. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing.
Project Manager
Project Manager
Project Managers plan and execute projects. They work with stakeholders to understand business requirements and translate them into technical specifications. Project Managers also develop and implement data integration and data quality solutions. This course may be useful for those interested in a career as a Project Manager. You will learn about Microsoft Azure, which is a leading cloud platform for data warehousing.
For more career information including salaries, visit:
OpenCourser.com/course/0hdwwc/plan
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Plan for Data Warehousing with Microsoft Azure.
Classic in the field of data warehousing and provides a comprehensive overview of dimensional modeling, the most widely used data modeling technique for data warehouses. It is essential reading for anyone who wants to design or implement a data warehouse.
Covers the fundamental concepts and techniques of data warehousing, including data modeling, data integration, data quality, and performance tuning. It also provides guidance on how to design, implement, and manage a successful data warehouse.
Provides a comprehensive overview of data extraction, transformation, and loading (ETL) for data warehouses. It covers a wide range of topics, including data integration, data quality, and performance tuning for ETL.
Provides a comprehensive overview of data warehousing and data mining. It covers a wide range of topics, including data modeling, data integration, data quality, data mining algorithms, and data visualization.
Save
Provides a comprehensive overview of data quality for data warehouses. It covers a wide range of topics, including data cleaning, data standardization, and data governance.
Provides a practical guide to building data warehouses in the cloud. It covers a wide range of topics, including data modeling, data integration, data storage, and data analytics.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/0hdwwc/plan
Share
Similar courses
Here are nine courses similar to
Plan for Data Warehousing with Microsoft Azure.
Data Literacy: Understanding Data Warehousing with Azure
OpenCourser.com/course/wvslvv/data
Data Literacy: Understanding Data Warehousing with Azure
Most relevant
Data Warehousing and Business Intelligence
OpenCourser.com/course/lc6exk/data
Data Warehousing and Business Intelligence
Most relevant
Build a Data Warehouse in AWS
OpenCourser.com/course/9ne9pm/build
Build a Data Warehouse in AWS
Most relevant
Mastering Microsoft Azure Resource Manager Architecture
OpenCourser.com/course/7h168o/mastering
Mastering Microsoft Azure Resource Manager Architecture
Most relevant
Data Warehousing and BI Analytics
OpenCourser.com/course/s7dwgx/data
Data Warehousing and BI Analytics
Most relevant
Getting Started with Data Warehousing and BI Analytics
OpenCourser.com/course/kvpw6j/getting
Getting Started with Data Warehousing and BI Analytics
Most relevant
Data Warehouse Concepts, Design, and Data Integration
OpenCourser.com/course/qqptyp/data
Data Warehouse Concepts, Design, and Data Integration
Most relevant
Data Warehousing with Microsoft Azure Synapse Analytics
OpenCourser.com/course/8mmecb/data
Data Warehousing with Microsoft Azure Synapse Analytics
Most relevant
Data Warehouse - The Ultimate Guide
OpenCourser.com/course/y80o0b/data
Data Warehouse - The Ultimate Guide
Most relevant
Time
77 hours
Level
Intermediate
Via
Pluralsight
Instructor
John Savill
Language
English
Good to know
Explores standard industry concepts and practices
Develops core data warehousing solutions in Microsoft Azure
Examines common architectures for complete data warehouse solutions
Teaches foundational knowledge of data warehousing
Taught by John Savill, a recognized expert in Microsoft Azure
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser