Modern Data Warehouse Analytics in Microsoft Azure from Coursera

In this course, you will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure. You will explore the processing options available for building data analytics solutions in Azure. You will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.

This is the fourth course in a program of five courses to help prepare you to take the Exam DP-900: Microsoft Azure Data Fundamentals. so that you can demonstrate that you have a foundational knowledge of the core database concepts in a cloud environment.

This course is ideal for IT professionals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure with a view to taking up roles as Data Engineers and Database Administrators. It is also suitable for working database professionals looking for additional skills or credentials to showcase expertise in a cloud environment and IT professionals looking to specialize in the specific area of Azure data.

To be successful in this course, you need to have basic computer literacy and proficiency in the English language. Successful Azure Data Fundamentals students start with some basic awareness of computing and Internet concepts, and an interest in extracting insights from data. It is an advantage to have experience using a web browser, familiarity with basic data-related concepts, such as working with tables of data in a spreadsheet, and visualizing data using charts.

What's inside

Syllabus

Data Ingestion, Storage, and Processing in Microsoft Azure

In this module, you will examine the components of a modern data warehouse. Understand the role of services like Azure Databricks, Azure Synapse Analytics, and Azure HDInsight. See how to use Azure Synapse Analytics to load and process data. You will explore the different data ingestion options available when building a data warehouse, and see how to use Azure Data Factory to ingest data. You will also explore Azure services for performing data analytics.

Get Started Building with Power BI

In this module, you will learn what Power BI is, including its building blocks and how they work together.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Helps learners prepare to take the Exam DP-900: Microsoft Azure Data Fundamentals, which is a recognized industry certification

Ideal for IT professionals who want to learn the fundamentals of database concepts in a cloud environment

Suitable for working database professionals looking for additional skills or credentials to showcase expertise in a cloud environment

Suitable for IT professionals looking to specialize in the specific area of Azure data

Requires basic computer literacy and proficiency in the English language, making it accessible to a wide range of learners

Provides a solid foundation for those with some basic awareness of computing and Internet concepts and an interest in extracting insights from data

Reviews summary

Azure data warehouse analytics guide

Learners say this course is a good introduction to Microsoft Azure and its variety of data warehouse technologies. While many agree that the content is qualitatively good, pacing and structure are called into question. Practical demonstrations are lacking, videos are often passive, and concepts tend to be rushed or repetitive.

The quality of the course contents are generally good.

"Really good contents to provide insight of Azure Data Warehouse Analytics support capabilities.Worth time spent. :-)"

"The instructor was very informative and spoke very eloquently."

"I am kinda satisfied. Thank you."

This course is not very hands-on.

"This course isn't hands on like the other ones in the specialization as the topics are slightly theoretical in nature."

"The only hands on part was Azure Synapse Analytics, but the rest of the Azure apps mentioned was just videos about the apps without even a walkthrough."

"I was hoping PowerBI was going to be hands on because it takes up the entire week 2 but its just videos I could have just watched on Youtube."

The course's structure and pacing issues are major let downs.

"The content was OK, the presentation was too rushed."

"It was as if the instructor was in a race to finish."

"The topic that Microsoft deemed crucial was handled with no sense of cohesion. There was no gradual development of knowledge because of the lack of structure."

"The topics introduced in one video were carried over to the next, with much of the same information being repeated."

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 Modern Data Warehouse Analytics in Microsoft Azure with these activities:

Review Delta Lake

Show steps

Delta Lake is an open-source storage layer that brings reliability to data lakes. Reviewing Delta Lake will ensure that you have a foundational knowledge of the technology before starting the course.

Browse courses on Delta Lake

Show steps

Read the Delta Lake documentation
Watch a Delta Lake tutorial
Complete a Delta Lake hands-on lab

Refresh Knowledge of Cloud Computing Concepts

Show steps

Review background information on cloud computing concepts to strengthen the foundation for learning about cloud-based data services.

Show steps

Review key concepts such as cloud architecture, types of cloud services, and cloud security.

Review Data Warehousing and Data Analytics Fundamentals

Show steps

Review the basics of data warehousing and data analytics to enhance understanding of cloud-based data services and their application.

Show steps

Refresh concepts such as data warehouse architectures, data modeling, and data analysis techniques.

14 other activities

Expand to see all activities and additional details

Show all 17 activities

Learn Azure Data Lake Storage

Show steps

Azure Data Lake Storage is a hyperscale, cloud-native data lake that is optimized for big data analytics. This tutorial will give you the foundational knowledge you need to get started with Azure Data Lake Storage.

Browse courses on Azure Data Lake Storage

Show steps

Follow the Azure Data Lake Storage tutorial
Complete the Azure Data Lake Storage hands-on lab
Create a data lake storage account

Learn Azure Synapse Analytics

Show steps

Azure Synapse Analytics is a cloud-native, data warehouse that is designed for big data analytics. This tutorial will give you the foundational knowledge you need to get started with Azure Synapse Analytics.

Browse courses on Azure Synapse Analytics

Show steps

Follow the Azure Synapse Analytics tutorial
Complete the Azure Synapse Analytics hands-on lab
Create a synapse workspace

Get Started with Azure Databricks Tutorial

Show steps

By completing the tutorial, you will gain practical experience in using Azure Databricks for data engineering tasks.

Browse courses on Azure Databricks

Show steps

Go to the Azure Databricks documentation.
Follow the tutorial steps and set up the necessary resources.
Create a cluster and notebook.
Load data into Azure Databricks.
Perform data analysis and transformations.

Explore Azure Synapse Analytics and Azure HDInsight

Show steps

Completes a tutorial on Azure Synapse Analytics and Azure HDInsight to gain a better understanding of the available cloud data services.

Show steps

Follow tutorials to create and configure Azure Synapse Analytics.
Explore Azure HDInsight and its use cases.
Compare the features and capabilities of Azure Synapse Analytics and Azure HDInsight.

Explore Azure Data Lake Storage Gen2 Exercises

Show steps

Engaging in exercises on Azure Data Lake Storage Gen2 will strengthen your foundational knowledge and practical skills in data storage.

Browse courses on Azure Data Lake Storage Gen2

Show steps

Create an Azure Data Lake Storage Gen2 account.
Upload and manage data in ADLS Gen2.
Configure security and access controls.
Monitor and optimize data storage.

Practice Data Ingestion

Show steps

Data ingestion is the process of loading data into a data warehouse. This activity will give you the opportunity to practice data ingestion using Azure Data Factory.

Browse courses on Data Ingestion

Show steps

Follow the Azure Data Factory tutorial
Complete the Azure Data Factory hands-on lab
Create a data factory pipeline

Explore Azure Synapse Analytics Tutorial

Show steps

The guided tutorial allows you to understand the fundamentals and capabilities of Azure Synapse Analytics as it applies to building data analytics solutions.

Browse courses on Azure Synapse Analytics

Show steps

Go to the Azure Synapse Analytics documentation.
Follow the tutorial steps and set up the necessary resources.
Load data into Azure Synapse Analytics.
Create and execute data pipelines.

Develop a Data Model and Create Azure Databricks Notebooks

Show steps

Creates a data model and Azure Databricks notebooks to understand and apply the concepts of database concepts in a cloud environment.

Show steps

Design a data model for your data warehouse.
Create Azure Databricks notebooks to load and transform data.
Write queries to analyze data using SQL syntax.

Build a Data Pipeline Using Azure Data Factory

Show steps

Build a data pipeline using Azure Data Factory to understand the process of data ingestion and transformation in a cloud environment.

Show steps

Create a data factory and define data sources.
Create pipelines to orchestrate data movement and transformations.
Monitor and manage the data pipeline.

Try the Azure HDInsight Interactive Tutorial

Show steps

The interactive tutorial offers a hands-on approach to learn the capabilities of Azure HDInsight for big data analytics.

Browse courses on Azure HDInsight

Show steps

Go to the Azure HDInsight documentation.
Follow the tutorial steps and set up the required resources.
Create a Hadoop cluster.
Load data into Azure HDInsight.
Run Apache Hive queries to analyze data.

Write SQL Queries for Data Analysis

Show steps

Practice writing SQL queries to gain proficiency in data analysis and extraction.

Show steps

Review the basics of SQL syntax and data types.
Write queries to select, filter, and aggregate data.
Use subqueries and joins to combine data from multiple tables.

Practice Data Ingestion with Azure Data Factory

Show steps

Regular practice in data ingestion using Azure Data Factory will reinforce your understanding of the process and enhance your skills.

Browse courses on Azure Data Factory

Show steps

Set up an Azure Data Factory pipeline.
Configure data sources and sinks.
Create and execute data ingestion activities.
Monitor and troubleshoot data ingestion.

Create a Data Visualization Dashboard Using Power BI

Show steps

Develop a data visualization dashboard using Power BI to enhance data presentation and storytelling skills.

Show steps

Import data from various sources into Power BI.
Create visualizations such as charts, graphs, and maps.
Design and publish an interactive dashboard.

Solve Data Engineering Challenges

Show steps

Attempts to solve data engineering challenges to test and strengthen their understanding of data engineering concepts.

Show steps

Review data engineering concepts and best practices.
Solve data engineering challenges using Azure cloud services.

Career center

Learners who complete Modern Data Warehouse Analytics in Microsoft Azure will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator manages and maintains an organization's databases. They work with database users to ensure that data is accurate and accessible. This course can help you develop the skills you need to be a successful Database Administrator. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure. This course will also help you explore the processing options available for building data analytics solutions in Azure, including Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.

See salaries and explore the career path for Database Administrator

Data Architect

A Data Architect designs, builds, and maintains the architecture of an organization's data systems. They work with stakeholders to understand data requirements and develop data strategies. This course can help you develop the skills you need to be a successful Data Architect. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure. This course will also help you explore the processing options available for building data analytics solutions in Azure, including Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.

See salaries and explore the career path for Data Architect

Data Engineer

A Data Engineer designs, builds, and maintains data pipelines. They work with data scientists and other stakeholders to understand data requirements and develop data solutions. This course can help you develop the skills you need to be a successful Data Engineer. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure. This course will also help you explore the processing options available for building data analytics solutions in Azure, including Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.

See salaries and explore the career path for Data Engineer

Data Analyst

A Data Analyst collects, analyzes, and interprets data to identify trends and patterns. They work with stakeholders to communicate insights and make recommendations. This course can help you develop the skills you need to be a successful Data Analyst. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure. This course will also help you explore the processing options available for building data analytics solutions in Azure, including Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.

See salaries and explore the career path for Data Analyst

Software Engineer

A Software Engineer designs, builds, and maintains software applications. They work with stakeholders to understand software requirements and develop software solutions. This course may be useful for aspiring Software Engineers who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Software Engineer

Financial Analyst

A Financial Analyst analyzes financial data to identify trends and patterns. They work with stakeholders to understand financial data and develop solutions to improve financial performance. This course may be useful for aspiring Financial Analysts who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Financial Analyst

Cloud Architect

A Cloud Architect designs and builds cloud computing solutions. They work with stakeholders to understand cloud computing requirements and develop cloud computing solutions. This course may be useful for aspiring Cloud Architects who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Cloud Architect

Market Research Analyst

A Market Research Analyst studies and analyzes market data to identify trends and patterns. They work with stakeholders to understand market data and develop solutions to improve market performance. This course may be useful for aspiring Market Research Analysts who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Market Research Analyst

Management Analyst

A Management Analyst studies and analyzes business processes to identify and improve inefficiencies. They work with stakeholders to understand business processes and develop solutions to improve efficiency. This course may be useful for aspiring Management Analysts who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Management Analyst

Data Warehouse Architect

A Data Warehouse Architect designs and builds data warehouses. They work with stakeholders to understand data warehousing requirements and develop data warehousing solutions. This course may be useful for aspiring Data Warehouse Architects who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Data Warehouse Architect

Data Scientist

A Data Scientist uses data to solve business problems. They work with data to identify trends and patterns, and develop predictive models. This course may be useful for aspiring Data Scientists who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Data Scientist

Data Analytics Manager

A Data Analytics Manager leads and manages a team of data analysts. They work with stakeholders to understand data analytics requirements and develop data analytics solutions. This course may be useful for aspiring Data Analytics Managers who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Data Analytics Manager

Business Analyst

A Business Analyst identifies and analyzes business needs and develops solutions to improve business processes. They work with stakeholders to understand business requirements and develop business solutions. This course may be useful for aspiring Business Analysts who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Business Analyst

Operations Research Analyst

An Operations Research Analyst uses mathematical and analytical techniques to solve business problems. They work with stakeholders to understand business problems and develop solutions to improve efficiency. This course may be useful for aspiring Operations Research Analysts who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Operations Research Analyst

Statistician

A Statistician collects, analyzes, and interprets data to identify trends and patterns. They work with stakeholders to understand data and develop solutions to improve efficiency. This course may be useful for aspiring Statisticians who want to develop their data analysis skills. You will learn about the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build your foundational knowledge of cloud data services within Microsoft Azure.

See salaries and explore the career path for Statistician