Brand Image
Loading ...
  • 26 Hours

  • Remote, Online

  • English

  • Cost

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

Scroll to top

2018 2nd Quarter Beyond Borders

[news-letter-popupbox year='2018' quarter='2']

This will close in 0 seconds

2018 3rd Quarter Beyond Borders

[news-letter-popupbox year='2018' quarter='3']

This will close in 0 seconds

2018 4th Quarter Beyond Borders

[news-letter-popupbox year='2018' quarter='4']

This will close in 0 seconds

2019 1st Quarter Beyond Borders

[news-letter-popupbox year='2019' quarter='1']

This will close in 0 seconds

2019 2nd Quarter Beyond Borders

[news-letter-popupbox year='2019' quarter='2']

This will close in 0 seconds

2019 3rd Quarter Beyond Borders

[news-letter-popupbox year='2019' quarter='3']

This will close in 0 seconds

2019 4th Quarter Beyond Borders

[news-letter-popupbox year='2019' quarter='4']

This will close in 0 seconds

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.