Looking for Global training? Go to https://firebrand.training/en or stay on the current site (United Arab Emirates)
Part of the BPP Education Group
+442032862989Microsoft - Microsoft Designing and Implementing Enterprise-Scale
Overview
This accelerated Microsoft: Microsoft Designing and Implementing Enterprise-Scale course, covers methods and practices for performing advanced data analytics at scale.
In just 3 days, you’ll learn to use Microsoft Purview, Azure Synapse Analytics, and Power BI to build analytics solutions. You’ll also learn how to:
- 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.
At the end of this course, you’ll sit the Microsoft exam, and achieve your Microsoft Designing and Implementing Enterprise-Scale certification.
Through Firebrand’s Lecture | Lab | Review methodology, you’ll get certified at twice the speed of the traditional training and get access to courseware, learn from certified instructors, and train in a distraction-free environment.
Audience
This course is ideal for:
- People who have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.
- People who 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).
Benefits
Seven reasons why you should sit your course with Firebrand Training
- Two options of training. Choose between residential classroom-based, or online courses
- You'll be certified fast. With us, you’ll be trained in record time
- Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
- Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
- You’ll learn more. A day with a traditional training provider generally runs from 9 am – 5 pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day of quality learning time, with your instructor
- You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
- You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 135,000 professionals
- * For residential training only. Doesn't apply for online courses
- ** Some exceptions apply. Please refer to the Exam Track or speak with our experts
Curriculum
Module 1: Implement and manage a data analytics environment (25–30%)
Govern and administer a data analytics environment
- Manage Power BI assets by using Azure Purview
- Identify data sources in Azure by using Azure Purview
- Recommend settings in the Power BI admin portal
- Recommend a monitoring and auditing solution for a data analytics environment, including Power BI REST API and PowerShell cmdlets
Integrate an analytics platform into an existing IT infrastructure
Manage the analytics development lifecycle
- Commit code and artifacts to a source control repository in Azure Synapse Analytics
- Recommend a deployment strategy for Power BI assets
- Recommend a source control strategy for Power BI assets
- Implement and manage deployment pipelines in Power BI
- Perform impact analysis of downstream dependencies from dataflows and datasets
- Recommend automation solutions for the analytics development lifecycle, including Power BI
REST API and PowerShell cmdlets
Module 2: Query and transform data (20–25%)
Query data by using Azure Synapse Analytics
Module 3: Implement and manage data models (25–30%)
Design and build tabular models
- Choose when to use DirectQuery for Power BI datasets
- Choose when to use external tools, including DAX Studio and Tabular Editor 2
- Create calculation groups
- Write calculations that use DAX variables and functions, for example handling blanks or errors, creating virtual relationships, and working with iterators
- Design and build a large format dataset
- Design and build composite models, including aggregations
- Design and implement enterprise-scale row-level security and object-level security
Optimize enterprise-scale data models
- Identify and implement performance improvements in queries and report visuals
- Troubleshoot DAX performance by using DAX Studio
- Optimize a data model by using Tabular Editor 2
- Analyse data model efficiency by using VertiPaq Analyzer
- Implement incremental refresh
- Optimize a data model by using denormalization
Module 4: Explore and visualize data (20–25%)
Explore data by using Azure Synapse Analytics
- Explore data by using native visuals in Spark notebooks
- Explore and visualize data by using the Azure Synapse SQL results pane
Visualize data by using Power BI
- Create and import a custom report theme
- Create R or Python visuals in Power BI
- Connect to and query datasets by using the XMLA endpoint
- Design and configure Power BI reports for accessibility
- Enable personalized visuals in a report
- Configure automatic page refresh
- Create and distribute paginated reports in Power BI Report Builder
Exam Track
At the end of this accelerated course, you’ll sit the following exam at the Firebrand Training centre, covered by your Certification Guarantee:
DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI exam
This exam measures your ability to accomplish the following technical tasks: implement and manage a data analytics environment; query and transform data; implement and manage data models; and explore and visualize data.
Passing score: 700
Domains:
- Implement and manage a data analytics environment (25–30%)
- Query and transform data (20–25%)
- Implement and manage data models (25–30%)
- Explore and visualize data (20–25%)
What's Included
Your accelerated course includes:
- Accommodation *
- Meals, unlimited snacks, beverages, tea and coffee *
- On-site exams **
- Exam vouchers **
- Practice tests **
- Certification Guarantee ***
- Courseware
- Up-to 12 hours of instructor-led training each day
- 24-hour lab access
- Digital courseware **
- * For residential training only. Accommodation is included from the night before the course starts. This doesn't apply for online courses.
- ** Some exceptions apply. Please refer to the Exam Track or speak with our experts
- *** Pass first time or train again free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.
Prerequisites
Before attending this accelerated course, you should have:
- A foundational knowledge of core data concepts and how they’re implemented using Azure data services.
- Proficient understanding in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analysing data by using Transact-SQL (T-SQL), and visualizing data.
Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.
Reviews
Here's the Firebrand Training review section. Since 2001 we've trained exactly 134,561 students and asked them all to review our Accelerated Learning. Currently, 96.41% have said Firebrand exceeded their expectations.
Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.
"The training for PL-100 is an intense course, jam-packed with references, resources delivered by a super knowledgeable instructor. Would recommend having a sound base knowledge of Microsoft Power Platform before attending. MS Learn provides topics for PL-100 and also a study guide for the exam which is very useful when preparing for exam."
Jessica Brooks, Kenvue. (3/1/2024 (Wednesday) to 4/1/2024 (Thursday))
"Training facilities were great and the hotel onsite is nice."
Anonymous. (18/12/2023 (Monday) to 20/12/2023 (Wednesday))
"It''s the best way to learn without any distraction. Training, eat, sleep, shower."
Anonymous. (13/12/2023 (Wednesday) to 15/12/2023 (Friday))
"When learning with Firebrand, everything is taken care of for you. This allows you to pour everything into absorbing and understanding your course content amongst peers."
ML, Griggster Limited. (3/10/2023 (Tuesday) to 6/10/2023 (Friday))
"Perfect instructor with much knowledge and the ability to bring it to the people. Thank you. The topic is huge but I would have expected a little bit more working together in the system."
Reinhard Decker, VAT Vakuumventile AG. (10/10/2023 (Tuesday) to 13/10/2023 (Friday))
Course Dates
|
Start |
Finish |
Status |
Location |
Book now |
|---|---|---|---|---|
|
19/2/2024 (Monday) |
21/2/2024 (Wednesday) |
Finished - Leave feedback |
- |
|
|
24/6/2024 (Monday) |
26/6/2024 (Wednesday) |
Wait list |
Nationwide |
|
|
5/8/2024 (Monday) |
7/8/2024 (Wednesday) |
Limited availability |
Nationwide |
|
|
16/9/2024 (Monday) |
18/9/2024 (Wednesday) |
Open |
Nationwide |
|
|
28/10/2024 (Monday) |
30/10/2024 (Wednesday) |
Open |
Nationwide |
|
|
9/12/2024 (Monday) |
11/12/2024 (Wednesday) |
Open |
Nationwide |
|