Course information

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

Why choose us

Our New Delhi venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

New Delhi is one of the districts within Delhi, as well as it being the capital city of India, it is also the home to the Government of the National Capital Territory of Delhi and some of the branches of the Government of India, these being the judiciary, executive and legislative branches and is also home to around 249,998 people. The capital of India - New Delhi was initiated within 1931 by Viceroy Lord Irwin however formed during 1911 by George V, who was the King of the United Kingdom as well as the Emperor of India and his British architects Sir Herbert Baker and Sir Edwin Lutyens formed the foundation stone and announced the capital city of India would be changed. The primary schools and secondary schools within New Delhi are either run privately or by the government and as of 2004 to 2005 there was around 1.5 million students going through the educational system within 2416 primary schools, 822,00 students in 715 middle schools and 669,000 students in 1576 secondary schools and around 500,000 students within 165 universities and colleges. All universities are either state, deemed or central universities, The top universities within New Delhi are the Jamia Millia Islamia, the University of Delhi, Indian Statistical Institute, National Law University, Jawaharlal Nehru University, Guru Gobind Singh Indraprastha University, Ambedkar University Delhi, Jamia Hamdard, Delhi Technological University – which is the first Engineering college within Delhi and one of the oldest in India, the Indira Gandhi National Open University is the largest national university in the world with over 4 million students, New Delhi is also home to the Indian Agricultural Research Institute, Pusa, New Delhi, Premier institute for agricultural research and education in India. The university courses and programs can offer different types of degrees such an undergraduate and post graduate courses, Bachelor courses and Scholarships, New Delhi prides itself on its premier institutions as the teaching and researching they do means that within 2011 the census recorded the literacy rate for females as 80.9% and for males it was slightly higher at 91.0% with an overall literacy rate of 86.3%. Subjects within the different universities can include, social sciences, engineering, humanities, technology, sports, law, social work, arts, management, education, computer information technology, foreign languages, mathematical science, dentistry and medical. 

Show moredown

Address

Pioneer Institute of Education and Computer Studies
F322/A, 3rd Floor
Adarsh House (Above PNB Bank)
Old MB Road
Lado Sarai
New Delhi
110030

T: +91 8037244591

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Analytics Solutions Using Microsoft Azure And Microsoft Power BI Training in New Delhi. 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 Analytics Solutions Using Microsoft Azure And Microsoft Power BI Training in New Delhi, 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 Analytics Solutions Using Microsoft Azure And Microsoft Power BI Training in New Delhi. 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 Analytics Solutions Using Microsoft Azure And Microsoft Power BI Training in New Delhi 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 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 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

Analytics Solutions Using Microsoft Azure And Microsoft Power BI Training in New Delhi 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 Retired : Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI DP500in New Delhi starts from INR49995
The Knowledge Academy is the Leading global training provider for Retired : 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

Looking for more information on Microsoft Azure Certification?

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 +91 8037244591 and speak to our training experts, we should be able to help you with your requirements.

cross

BIGGEST
BLACK FRIDAY SALE!

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.