Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 Overview

Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 Course Outline

Module 1: Explore Azure Data Services for Modern Analytics

  • Introduction
  • Understand the Azure Data Ecosystem
  • Explore Modern Analytics Solution Architecture

Module 2: Understand Concepts of Data Analytics

  • Introduction
  • Understand Data Analytics Types
  • Explore the Data Analytics Process
  • Understand Types of Data and Data Storage

Module 3: Explore Data Analytics at Scale

  • Introduction
  • Explore Data Team Roles and Responsibilities
  • Review Tasks and Tools for Data Analysts
  • Scale Analytics with Azure Synapse Analytics and Power BI
  • Strategies to Scale Analytics

Module 4: Introduction to Microsoft Purview

  • Introduction
  • What Is Microsoft Purview?
  • How Microsoft Purview Works
  • When to Use Microsoft Purview

Module 5: Discover Trusted Data Using Microsoft Purview

  • Introduction
  • Search for Assets
  • Browse Assets
  • Use Assets with Power BI
  • Integrate with Azure Synapse Analytics

Module 6: Catalog Data Artifacts by Using Microsoft Purview

  • Introduction
  • Register and Scan Data
  • Classify and Label Data
  • Search the Data Catalog

Module 7: Manage Power BI Assets by Using Microsoft Purview

  • Introduction
  • Register and Scan a Power BI Tenant
  • Search and Browse Power BI Assets
  • View Power BI Metadata and Lineage

Module 8: Integrate Microsoft Purview and Azure Synapse Analytics

  • Introduction
  • Catalog Azure Synapse Analytics Data Assets in Microsoft Purview
  • Connect Microsoft Purview to an Azure Synapse Analytics Workspace
  • Search a Purview Catalog in Synapse Studio
  • Track Data Lineage in Pipelines
  • Exercise - Integrate Azure Synapse Analytics and Microsoft Purview

Module 9: Introduction to Azure Synapse Analytics

  • Introduction
  • What is Azure Synapse Analytics
  • How Azure Synapse Analytics Works
  • When to Use Azure Synapse Analytics
  • Exercise - Explore Azure Synapse Analytics

Module 10: Use Azure Synapse Serverless SQL Pool to Query Files in a Data Lake

  • Introduction
  • Understand Azure Synapse Serverless SQL Pool Capabilities and Use Cases
  • Query Files Using a Serverless SQL Pool
  • Create External Database Objects
  • Exercise - Query Files Using a Serverless SQL Pool

Module 11: Analyze Data with Apache Spark in Azure Synapse Analytics

  • Introduction
  • Get to Know Apache Spark
  • Use Spark in Azure Synapse Analytics
  • Analyse Data with Spark
  • Visualize Data with Spark
  • Exercise - Analyse Data with Spark

Module 12: Analyse Data in a Relational Data Warehouse

  • Introduction
  • Design a Data Warehouse Schema
  • Create Data Warehouse Tables
  • Load Data Warehouse Tables
  • Query a Data Warehouse
  • Exercise - Explore a Data Warehouse

Module 13: Choose a Power BI Model Framework

  • Introduction
  • Describe Power BI Model Fundamentals
  • Determine When to Develop an Import Model
  • Determine When to Develop a DirectQuery Model
  • Determine When to Develop a Composite Model
  • Choose a Model Framework

Module 14: Understand Scalability in Power BI

  • Introduction
  • Describe the Significance of Scalable Models
  • Implement Power BI Data Modeling Best Practices
  • Configure Large Datasets
  • Exercise: Create a Star Schema Model

Module 15: Create and Manage Scalable Power BI Dataflows

  • Introduction
  • Define Use Cases for Dataflows
  • Create Reusable Assets
  • Implement Best Practices
  • Exercise: Create a Dataflow

Module 16: Create Power BI Model Relationships

  • Introduction
  • Understand Model Relationships
  • Set Up Relationships
  • Use DAX Relationship Functions
  • Understand Relationship Evaluation
  • Exercise: Work with Model Relationships

Module 17: Use DAX Time Intelligence Functions in Power BI Desktop Models

  • Introduction
  • Use DAX Time Intelligence Functions
  • Additional Time Intelligence Calculations
  • Exercise - Create Advanced DAX Calculations in Power BI Desktop

Module 18: Create Calculation Groups

  • Introduction
  • Understand Calculation Groups
  • Explore Calculation Groups Features and Usage
  • Create Calculation Groups in a Model
  • Exercise: Create Calculation Groups

Module 19: Enforce Power BI Model Security

  • Introduction
  • Restrict Access to Power BI Model Data
  • Restrict Access to Power BI Model Objects
  • Apply Good Modeling Practices
  • Exercise: Enforce Model Security

Module 20: Use Tools to Optimize Power BI Performance

  • Introduction
  • Use Performance Analyzer
  • Troubleshoot DAX Performance by Using DAX Studio
  • Optimize a Data Model by Using Best Practice Analyzer
  • Exercise: Use Tools to Optimize Power BI Performance

Module 21: Understand Advanced Data Visualization Concepts

  • Introduction
  • Create and Import a Custom Report Theme
  • Enable Personalized Visuals in a Report
  • Design and Configure Power BI Reports for Accessibility
  • Create Custom Visuals with R or Python
  • Review Report Performance Using Performance Analyzer

Module 22: Monitor Data in Real-Time with Power BI

  • Introduction
  • Describe Power BI Real-Time Analytics
  • Set Up Automatic Page Refresh
  • Create Real-Time Dashboards
  • Set Up Auto-Refresh Paginated Reports
  • Exercise: Monitor Data in Real-Time with Power BI

Module 23: Create Paginated Reports

  • Introduction to Paginated Reports
  • Get Data
  • Create a Paginated Report
  • Work with Charts on the Report
  • Publish the Report

Module 24: Provide Governance in a Power BI Environment

  • Introduction
  • Elements of Data Governance
  • Configure Tenant Settings
  • Deploy Organizational Visuals
  • Manage Embed Codes
  • Help and Support Settings

Module 25: Facilitate Collaboration and Sharing in Power BI

  • Introduction
  • Workspaces Evolved
  • Impact to Power BI Users
  • Permissions in Workspaces v2
  • Apps in Power BI
  • Share
  • Publish to Web
  • Embed and Link in Portals
  • Data Sensitivity Labels
  • Data Privacy

Module 26: Monitor and Audit Usage

  • Introduction
  • Usage Metrics for Dashboards and Reports
  • Usage Metrics for Dashboards and Reports - New Version
  • Audit Logs
  • Activity Log

Module 27: Provision Premium Capacity in Power BI

  • Introduction
  • Premium Resource Management
  • Supporting Multi Geographies
  • Bring Your Own Key (BYOK)
  • Featured External Tools

Module 28: Establish a Data Access Infrastructure in Power BI

  • Introduction
  • Personal Gateways Versus Enterprise Gateways
  • How Data Is Refreshed
  • Gateway Network Requirements
  • Where to Install Gateway
  • Establish High Availability Gateways
  • Establish Load Balancing of Gateways
  • Gateway Performance Monitoring Documentation
  • Multiple Data Sources per Gateway
  • Manage Gateway Users
  • Active Directory User Mapping with Custom Property Lookup

Module 29: Broaden the Reach of Power BI

  • Introduction
  • REST API Custom Development
  • Provision a Power BI Embedded Capacity
  • Dataflow Introduction
  • Dataflow Explained
  • Create a Dataflow
  • Dataflow Capabilities on Power BI Premium
  • Template Apps - Install Packages
  • Template Apps - Installed Entities
  • Template App Governance

Module 30: Automate Power BI Administration

  • Introduction
  • REST API - Power BI Service
  • Microsoft Power BI Cmdlets for Windows PowerShell and PowerShell Core
  • Install and Use the Power BI Cmdlet
  • Test REST API Calls
  • Script Typical Administrator Tasks

Module 31: Build Reports Using Power BI within Azure Synapse Analytics

  • Introduction
  • Describe the Power BI and Synapse Workspace Integration
  • Exercise - Connect to Power BI from Synapse
  • Understand Power BI Data Sources
  • Exercise - Create a New Data Source to Use in Power BI
  • Exercise - Create a New Power BI Report in Synapse Studio
  • Describe Power BI Optimization Options
  • Exercise - Improve Performance with Materialized Views and Result-Set Caching
  • Visualize Data with Serverless SQL Pools

Module 32: Design a Power BI Application Lifecycle Management Strategy

  • Introduction
  • Define Application Lifecycle Management
  • Recommend a Source Control Strategy
  • Design a Deployment Strategy

Module 33: Create and Manage a Power BI Deployment Pipeline

  • Introduction
  • Understand the Deployment Process
  • Create a Deployment Pipeline
  • Assign a Workspace
  • Deploy Content
  • Work with Deployment Pipelines

Module 34: Create and Manage Power BI Assets

  • Introduction
  • Create Reusable Power BI Assets
  • Explore Power BI Assets Using Lineage View
  • Manage a Power BI Dataset Using XMLA Endpoint
  • Exercise: Create Reusable Power BI Assets

Show moredowndown

Who should attend this Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP-500 Training?

The Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP-500 Course is aimed at professionals who are involved in Data Analysis, Data Engineering, and Business Intelligence. This Microsoft Azure Training Course can be beneficial for a wide range of professionals, including:

  • Data Analysts
  • Data Engineers
  • Business Intelligence Professionals
  • Data Architects
  • Data Scientists
  • IT Managers
  • Project Managers in Analytics Projects

Prerequisites of the Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP-500 Training

Delegates must have a basic understanding of Data Analysis techniques, be familiar with SQL, and also have some experience with Microsoft Azure services to attend this Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 Course.

Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP-500 Course Overview

In today's dynamic business environment, the Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP-500 Course serves as a cornerstone of innovation and data-driven decision-making. With the escalating importance of Data Analytics, this course provides an essential grasp of leveraging Microsoft Azure and Power BI for scalable analytics solutions.

Proficiency in this subject is imperative for Data Architects, Business Intelligence Professionals, and Data Analysts who aspire to master Microsoft Azure Courses. As organisations increasingly pivot towards data insights for informed decision-making, expertise in designing and implementing enterprise-scale analytics solutions becomes a pivotal skill set for those shaping the future of data-driven enterprises.

This 4-day Microsoft Azure Training by the Knowledge Academy is a transformative experience for delegates, offering a comprehensive knowledge base that delves into Azure's analytics capabilities and seamlessly integrates Power BI. Delegates emerge with hands-on expertise in designing scalable solutions, optimising data performance, and translating data into actionable insights.

Course Objectives

  • To comprehend the fundamentals of Microsoft Azure and Power BI integration for analytics solutions
  • To gain practical knowledge in designing scalable analytics solutions within an enterprise context
  • To optimise data performance using Microsoft Azure's advanced analytics capabilities
  • To transform raw data into actionable insights through hands-on Power BI experience
  • To apply best practices in enterprise-scale analytics solution design
  • To empower delegates with skills directly applicable to real-world scenarios

Upon completing this Microsoft Azure Training, delegates will be empowered with a profound understanding of designing and implementing enterprise-scale analytics solutions using Microsoft Azure and Power BI. Armed with hands-on experience and best practices, delegates will be well-positioned to contribute effectively to their organisations, driving informed decision-making and becoming instrumental in the evolving landscape of data-driven enterprises.

Show moredowndown

What’s included in this Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 Training?

  • World-Class Training Sessions from Experienced Instructors
  • Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP-500 Certificate
  • Digital Delegate Pack

Show moredowndown

Why choose us

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

Unlock your potential with The Knowledge Academy's Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500, accessible anytime, anywhere on any device. Enjoy 90 days of online course access, extendable upon request, and benefit from the support of our expert trainers. Elevate your skills at your own pace with our Online Self-paced sessions.

Experience the most sought-after learning style with The Knowledge Academy's Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500. Available in 490+ locations across 190+ countries, our hand-picked Classroom venues offer an invaluable human touch. Immerse yourself in a comprehensive, interactive experience with our expert-led Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 sessions.

best_trainers

Highly experienced trainers

Boost your skills with our expert trainers, boasting 10+ years of real-world experience, ensuring an engaging and informative training experience

venues

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

small_classes

Small class sizes

Our Classroom courses with limited class sizes foster discussions and provide a personalised, interactive learning environment

value_for_money

Great value for money

Achieve certification without breaking the bank. Find a lower price elsewhere? We'll match it to guarantee you the best value

Streamline large-scale training requirements with The Knowledge Academy’s In-house/Onsite Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 at your business premises. Experience expert-led classroom learning from the comfort of your workplace and engage professional development.

tailored_learning_experience

Tailored learning experience

Leverage benefits offered from a certification that fits your unique business or project needs

budget

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

team_building

Team building opportunity

Our Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 offers a unique chance for your team to bond and engage in discussions, enriching the learning experience beyond traditional classroom settings

monitor_progress

Monitor employees progress

The course know-how will help you track and evaluate your employees' progression and performance with relative ease

What our customers are saying

Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 FAQs

Please arrive at the venue at 8:45am.
It is recommended that students have: A foundational knowledge of core data concepts and how they’re implemented using Azure data services. For more information see Azure Data Fundamentals. Experience designing and building scalable data models, cleaning, and transforming data, and enabling advanced analytic capabilities that provide meaningful business value using Microsoft Power BI. For more information see Power BI Data Analyst.
Candidates for this course should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Specifically, candidates should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). They should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data.
We can provide support via phone & email prior to attending, during and after the course.
Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments
This course is 4 days
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts
The training fees for Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500 certification in the United Kingdom starts from £2295
The Knowledge Academy is the Leading global training provider for Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500.
Show more down

Why choose us

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

Microsoft Azure Training

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo
backBack to course information

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on 01344203999 and speak to our training experts, we should be able to help you with your requirements.

cross

OUR BIGGEST SPRING SALE!

Special Discounts

red-starWHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.