Radiant

Course Description

This course covers advanced data analytics methods and practices at scale. Students will gain knowledge of how to set up and manage a data analytics environment, query and transform data, set up and manage data models, and explore and visualize data while building on prior analytics experience. In this course, students will create analytics solutions using Microsoft Purview, Azure Synapse Analytics, and Power BI.

Prerequisites

Before attending this training, it is recommended that professionals have the following:

A fundamental understanding of basic data concepts and how to use Azure data services to implement them. See Azure Data Fundamentals for more details.
·Experience using Microsoft Power BI to enable advanced analytical capabilities that deliver meaningful business value, clean and transform data, and build scalable data models. See Power BI Data Analyst for more details.

Target Audience

Candidates should be experts in designing, developing, and deploying enterprise-scale data analytics solutions in order to be successful in this course. Candidates should, in particular, have advanced Power BI skills, such as managing data repositories and data processing in the Cloud & on-premises, as well as using Power Query & Data Analysis Expressions (DAX). Professionals should also be proficient in consuming data from Azure Synapse Analytics & have Experience querying relational databases, analyzing data using Transact-SQL (T-SQL), and visualizing data.

Content Outline

Explore Azure data services for modern analytics

Explain the Azure data ecosystem for analytics

Understand concepts of data analytics

Explain types of data analytics
Understand the data analytics process

Explore data analytics at scale

Explore data job roles in analytics
Understand tools for scaling analytics solutions

Introduction to Microsoft Purview

Evaluate whether Microsoft Purview is appropriate for data discovery and governance needs.
Explain how the features of Microsoft Purview work to provide data discovery and governance.

Discover trusted data using Microsoft Purview

Browse, search, and manage data catalog assets.
Use data catalog assets with Power BI.
Use Microsoft Purview in Azure Synapse Studio.

Catalog data artifacts by using Microsoft Purview

Explain asset classification in Microsoft Purview.

Control Power BI assets by using Microsoft Purview

Register & scan a Power BI tenant.
Use the search & browse functions to find data assets.
Explain the schema details and data lineage tracing of Power BI data assets.

Integrate Microsoft Purview and Azure Synapse Analytics

Catalog Azure Synapse Analytics database assets in Microsoft Purview.
Configure Microsoft Purview integration in Azure Synapse Analytics.
Search the Microsoft Purview catalog from Synapse Studio.
Track data lineage in Azure Synapse Analytics pipelines activities.

Introduction to Azure Synapse Analytics

Find the business problems that Azure Synapse Analytics addresses.
Explain the core capabilities of Azure Synapse Analytics.
Determine when to use Azure Synapse Analytics.

Query files in a data lake using the Azure Synapse serverless SQL pool.

Identify capabilities & use cases for serverless SQL pools in Azure Synapse Analytics
Query CSV, JSON, & Parquet files using a serverless SQL pool
Create external database objects in a serverless SQL pool

Utilize Apache Spark for data analysis in Azure Synapse Analytics

Identify core features and capabilities of Apache Spark.
Configure a Spark pool in Azure Synapse Analytics.
Run code to load, analyze, and visualize data in a Spark notebook.

Analyze data in a relational data warehouse

Create a relational data warehouse schema.
Create fact, dimension, & staging tables.
To add data to data warehouse tables, use SQL.
To add query relational data warehouse tables, Use SQL.

Choose a Power BI model framework

Explain Power BI model fundamentals.
Determine when to develop an import model.
Determine when to create a DirectQuery model.
Determine when to create a composite model.
Choose an appropriate Power BI model framework.

Understand scalability in Power BI

Explain the importance of building scalable data models
Implement Power BI data modeling best practices
Use the Power BI large dataset storage format

Create and manage scalable Power BI dataflows

Explain Power BI dataflows and use cases.
Explain best practices for implementing Power BI dataflows.
Create and consume Power BI dataflows.

Create Power BI model relationships

Understand how model relationships work.
Set up relationships.
Use DAX relationship functions.
Understand relationship evaluation.

Use DAX time intelligence functions in Power BI Desktop models

Define time intelligence.
Use standard DAX time intelligence functions.
Create functional intelligence calculations.

Create calculation groups

Explore how calculation groups work.
Maintain calculation groups in a model.
Use calculation groups in a Power BI report.

Enforce Power BI model security

Restrict access to Power BI model data with RLS.
Restrict access to Power BI model objects with OLS.
Apply good development practices to enforce Power BI model security.

Use tools to optimize Power BI performance

Optimize queries using a performance analyzer.
Troubleshoot DAX performance using DAX Studio.
Optimize a data model using Tabular Editor.

Understand advanced data visualization concepts

Create and import a custom report theme.
Create custom visuals with R or Python.
Enable personalized visuals in a report.
Review report performance using Performance Analyzer.
Design & configure Power BI reports for accessibility.

Monitor data in real-time with Power BI

Explain Power BI real-time analytics.
Set up automatic page refresh.
Create real-time dashboards.
Set up auto-refresh paginated reports.

Create paginated reports

Get data.
Create a paginated account.
Work with charts and tables on the information.
Publish the report.

Provide governance in a Power BI environment

Define the critical components of an effective BI governance model
Explain the key elements associated with data governance
Configure, deploy, and manage aspects of a BI governance strategy
Set up BI help and support settings

Facilitate collaboration and sharing in Power BI

Understand the differences between My workspace, workspaces, and apps
Explain new workspace capabilities and how they improve the user experience
Anticipate migration impact on Power BI users
Share, publish to the web, embed links, and secure Power BI reports, dashboards and content

Monitor and audit usage

Discover what usage metrics are available through the Power BI admin portal
Optimize the use of usage metrics for dashboards and reports
Distinguish between audit logs and the activity logs

Provision Premium capacity in Power BI

Explain the difference between Power BI Pro and Power BI Premium
Define dataset eviction
Explain how Power BI manages memory resources
List three external tools you can use with Power BI Premium.
Create a Power BI data access infrastructure.
Understand the difference between gateways, the various connectivity modes, and data refresh methods.
Explain the gateway network requirements, where to place the gateway in your network, and how to use clustering to ensure high availability.
Scale, monitor, and manage gateway performance and users.

Broaden the reach of Power BI

Explain the various embedding scenarios that allow you to broaden the reach of Power BI
Understand the options for developers to customize Power BI solutions
Learn to provision and optimize Power BI embedded capacity and create and deploy dataflows
Build custom Power BI solutions template apps

Automate Power BI administration

Use REST APIs to automate everyday Power BI admin tasks
Apply Power BI Cmdlets for Windows PowerShell and PowerShell core
Use Power BI Cmdlets
Automate simple Power BI admin tasks with scripting

Make reports using Power BI within Azure Synapse Analytics

Explain the Power BI and Synapse workspace integration
Understand Power BI data sources
Explain optimization options
Visualize data with serverless SQL pools

Create a Power BI application lifecycle management strategy

Outline the application lifecycle process.
Choose a source control strategy.
Design a deployment strategy.

Create & manage a Power BI deployment pipeline

Articulate the benefits of deployment pipelines
Create a deployment pipeline using Premium workspaces
Assign and deploy content to pipeline stages
Explain the purpose of deployment rules
content deployment from one pipeline stage to the next

Create and manage Power BI assets

Create specialized datasets.
Create live and DirectQuery connections.
Use Power BI service lineage view.
Use the XMLA endpoint to connect datasets.

FAQs

How do I become an azure administrator?

To become an azure admin, you must start with azure fundamentals. An individual with a professional experience in Azure-specific job roles can easily aim at improving their skills with official certification. However, you could also be included in other scenarios.

What is AZ 103 Microsoft Azure administrator?

This exam measures your ability to accomplish the following technical tasks: manage Azure subscriptions and resources; implement and manage storage; deploy and manage virtual machines (VMs); configure and manage virtual networks; and manage identities.

What is the use of the Migration Assistant tool in Azure Websites?

The migration Assistant tool helps the user to examine your IIS installation. It allows the user to recognize which site can be migrated to the Cloud. In general, it features components that are either not migrated or unsupported on the Azure platform.

Name the types of web applications that can be deployed with Azure?

ASP.Net, PHP, and WCF are web applications that can be deployed with SQL Azure.

What is the infrastructure required to attend your training program?

To attend the training session, you should have operational Desktops or Laptops with the required specification and a good internet connection to access the labs.

What if I miss a class on a particular day?

We would always recommend you attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, due to some contingency, if you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.

How will I be accessing the labs?

Radiant Techlearning has a data center containing a Virtual Training environment for participant hand-on-practice.

Participants can easily access these labs over Cloud with the help of a remote desktop connection.

Radiant virtual labs allow you to learn from anywhere and in any time zone.

What kind of projects are included as a part of training?

The learners will be enthralled as we engage them the real-world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and give you a better experience. These real-time projects will help you greatly in future tasks and assignments.

Send a Message.

Enroll