
Overview
This course delves into the various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. Participants will learn how to access and process data from various sources, encompassing both relational and non-relational types. Moreover, the course will explore techniques for managing, deploying, and distributing reports and dashboards for collaborative sharing.
This course is designed for individuals who aim to understand the fundamentals of database concepts in a cloud environment, acquire basic skills in cloud data services, and deepen their foundational knowledge of Microsoft Azure’s data services.
This course is designed for individuals who aim to understand the fundamentals of database concepts in a cloud environment, acquire basic skills in cloud data services, and deepen their foundational knowledge of Microsoft Azure’s data services.
Roles
- Data Analyst
What You'll Learn
- Prepare and organize data for analysis
- Develop analytical skills (data cleaning, analysis, and visualization) using Power BI
- Create and manage workspaces and datasets in Power BI
Skills You'll Gain
- Data analysis
- Azure
- Power BI
Total hours
- Sync Hands-on/Lecture: 6 Hours
- Async Learning: 12 Hours
- Assessment: 8 hours
- Total: 26 Hours
Course outline
-
Introduction to data engineering on Azure
-
Introduction to Azure Data Lake storage Gen2
-
Introduction to Azure Synapse Analytics
-
Use Azure Synapse serverless SQL pool to query files in a data lake
-
Use Azure Synapse serverless SQL pools to transform data in a data lake
-
Create a lake database in Azure Synapse Analytics
-
Analyze data with Apache Spark in Azure Synapse Analytics
-
Transform data with Spark in Azure Synapse Analytics
-
Use Delta Lake in Azure Synapse Analytics
-
Analyze data in a relational data warehouse
-
Load data into a relational data warehouse
-
Build a data pipeline in Azure Synapse Analytics
-
Use Spark Notebooks in an Azure Synapse Pipeline
-
Plan hybrid transactional and analytical processing using Azure Synapse Analytics
-
Implement Azure Synapse Link with Azure Cosmos DB
-
Implement Azure Synapse Link for SQL
-
Get started with Azure Stream Analytics
-
Ingest streaming data using Azure Stream Analytics and Azure Synapse Analytics
-
Visualize real-time data with Azure Stream Analytics and Power BI
-
Introduction to Microsoft Purview
-
Integrate Microsoft Purview and Azure Synapse Analytics
-
Explore Azure Databricks
-
Use Apache Spark in Azure Databricks
-
Run Azure Databricks Notebooks with Azure Data Factory
Required resources
Laptop, Intel Core i5 or higher, 16GB, 1TB Storage, Graphics Card (Hardware); Microsoft Power BI (Software); Adequate Internet Connection (Network)
Pre-Requisites
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.
Assessment
Practical Assessment: Hands-on activities are prepared to assess the attainment of learning outcomes.
Final Assessment: This exam measures your ability to accomplish the following technical tasks: prepare the data; model the data; visualize and analyze the data; and deploy and maintain assets.
Credit and Recognition
The learner is eligible to take the Microsoft Certified: Power BI Data Analyst Associate.
Â
Earn this BatStateU – Microsoft LearnBadge and highlight it in your performance review!
Share your achievement on your LinkedIn profile, resume or CV, and social media accounts.”
Â


This course is accredited by Microsoft and is facilitated by a Microsoft Certified professional.
Learning Pathways
