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

This course covers methods and practices for performing advanced data analytics. Students will build on existing analytics experience and will learn to implement and manage a data analytics environment, query and transform data, implement and manage data models, and explore and visualize data. In this course, students will use Microsoft Purview, Azure Synapse Analytics, and Power BI to build analytics solutions.


  • Explore Azure data services for modern analytics
  • Understand concepts of data analytics
  • Explore data analytics at scale
  • Introduction to Microsoft Purview
  • Discover trusted data using Microsoft Purview
  • Catalog data artifacts by using Microsoft Purview
  • Manage Power BI artifacts by using Microsoft Purview
  • This module explores the use of Azure Synapse Analytics for exploratory data Analysis.
  • Introduction to Azure Synapse Analytics
  • Implement star schema design and query relational data in Azure
  • Analyze data with a serverless SQL pool in Azure Synapse Analytics
  • Optimize data warehouse query design
  • Analyze data with a Spark Pool in Azure Synapse Analytics
  • Lab: Query data in Azure
  • Lab: Explore data in Spark notebooks
  • Choose a Power BI model frame work
  • Understand scalability in Power BI
  • Optimize Power Query for scalable solutions
  • Create and manage scalable Power BI data flows
  • Lab :Create calculation groups
  • Create Power BI model relationships
  • Enforce model security
  • Create calculation groups
  • Lab: Create model relationships
  • Lab: Enforce model security
  • Lab: Design and build tabular models
  • Lab :Create calculation groups
  • Optimize performance using Synapse and Power BI
  • Improve query performance with hybrid tables, dual storage mode , and aggregations
  • Use tools to optimize Power BI performance
  • Lab: Use tools to optimize Power BI performance
  • Lab: Improve query performance using aggregations
  • Lab: Improve query performance with dual storage mode
  • Lab : Improve performance with hybrid tables
  • Understand advanced data visualization concepts
  • Customize core data models
  • Monitor data in real-time with Power BI
  • Create and distribute paginated reports in Power BI report builder
  • Lab: Monitor data in real-time with Power BI
  • Lab: Create and distribute paginated reports in Power BI Report Builder
  • Recommend Power BI administration settings
  • Recommend a monitoring and auditing solution for a data analytics environment
  • Configure and manage Power BI capacity
  • Establish a data access infrastructure in Power BI
  • Recommend a source control strategy for Power BI assets
  • Perform impact analysis of down stream dependencies from data flows and datasets
  • Recommend automation solutions for the analytics development life cycle, including Power BI RESTAPI
  • Deploy and manage data sets by using the XMLA end point
  • Deploy reusable assets
  • Lab: Create reusable Power BI assets
  • Recommend and configure a Power BI tenant or workspace
  • Identify requirements for a solution, including features, performance, and licensing strategy
  • Integrate an existing Power BI work space in to Azure Synapse Analytics


Self Paced Learning

Get the recorded session and study Material. Learn in your speed


Online Virtual Class Room

Enroll in any above batch and attend live class at scheduled time


Offline Class Room

Visit our centre and enrol for the course, The course Fee will vary as per the Metro/ Non Metro or locality.


Upcoming Batches:


Where we can use Azure concept?
We can use this concept any where in any company whether it is a small company or big company . but mostly it is used for collection of big data .
Any Prerequisite to learn Azure
There is no prerequisite to learn Azure. If you are familiar with computer or have basic concept of any other programming language it would be an added advantage to you. By the way, we will start this training from scratch.
Recommend Audience for Azure course:
Anyone who is interested to learn Azure can join this course like students and working professionals
In case of my absence, how can I manage my class?
You will get access of LMS (Learning management System), if you missed your class you can refer the recorded session in your LMS. If you have any doubt you can ask in your next class whenever you will join.
Who is the Instructor?
Our instructors are industry experts having more than 10 years of corporate experience. Since they have rich experience in their domain they will train as per the industry standards.
Will you help us in Job placement?
We have tied up with more than 100+ companies in corporate industry. We will schedule your interview after successful completion of our course.
Will you help us in resume creation?
Yes, we will help you in creating your resume so that it can shortlist easily for interview.
Will you help us to get the software?
Yes, we will help you with Trial version of software.
How long can I access my (LMS) learning management System?
Once you will enroll for the course, you can access the LMS for life long.
How can I get the certification?
Once you will complete your course, you will appear for an online test. Basis on your score we will issue the certificate.
What is Self-paced course?
If you will enroll for self-paced course you can access the pre recorded sessions and you can do self-learning. You can complete your course as per your availability.
What if I have more queries or concerns?
You can write an email at info@wifilearning.com or you can contact us at our Office numbers at 91-9999468661.



anurag verma

The instructor was knowledgeable and passionate about the subject, which made the class engaging .


rohit chaudhary

This class was a bit challenging at times, but it pushed me to grow as an analyst. The coursework was rigorous, and I appreciated that


Manju Nath

overall my experience is excellent with wifi learning .Well experienced trainer and very he;pful placement team . this is the second time that i got placed . earlier i was placed as Data Analyst with the help of Wifi Learning and now as a Data engineer .


Sarthak Banshal

very good training institute. specially trainers are well ecperienced and industry expert . the best part of wifi learning is it's dedicated placement cell . if you are looking to get placed or change your domain i would like to recommend everyone to get in touch with wifi learning once .

Contact us

Phone: +91-9999468662 +91-9999468661

Email: info@wifilearning.com