Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Schweiz)
Part of the BPP Education Group
+49-66234364698
Microsoft - 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).
Four reasons why you should sit your course with Firebrand Training
- You'll be trained and certified faster. Learn more on this 3-day accelerated course. You'll get at least 12 hours a day of quality learning time in a distraction-free environment
- Your course is all-inclusive. One simple price covers all course materials, exams, accommodation and meals – so you can focus on learning
- Pass first time or train again for free. Your expert instructor will deliver our unique accelerated learning methods, allowing you to learn faster and be in the best possible position to pass first time. In the unlikely event that you don't, it's covered by your Certification Guarantee
- Study with an award-winning training provider. We've won the Learning and Performance Institute's "Training Company of the Year" three times. Firebrand is your fastest way to learn, with 134561 students saving more than one million hours since 2001
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 first time or train again for free. This is our guarantee. We’re confident you’ll pass your course 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 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day 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 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 100,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 134561 students and asked them all to review our Accelerated Learning. Currently, 96.46% 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.
"I think Firebrand offers a very good and efficient concept to prepare for an exam in a very short period of time."
Anonymous (3.9.2018 (Monday) to 5.9.2018 (Wednesday))
"Good value."
Shankar Natesan. (3.9.2018 (Monday) to 5.9.2018 (Wednesday))
"Firebrand is a great bootcamp, where you can learn a lot and get very useful certifications. "
Adela Toma, Bearing Point. (19.3.2018 (Monday) to 24.3.2018 (Saturday))
"Perfect training!"
P. E.. (4.12.2017 (Monday) to 6.12.2017 (Wednesday))
"A high tempo and lots to learn from a great instructor. Thanks for helping me pass the exam in a quick tempo."
Seth Lindholm, Advitum AB (SWEDEN). (21.11.2016 (Monday) to 25.11.2016 (Friday))
Course Dates
|
Start |
Finish |
Status |
Location |
Book now |
|---|---|---|---|---|
|
21.8.2023 (Monday) |
23.8.2023 (Wednesday) |
Finished - Leave feedback |
- |
|
|
|
|
|
|
|
|
5.2.2024 (Monday) |
7.2.2024 (Wednesday) |
Limited availability |
Nationwide |
|
|
18.3.2024 (Monday) |
20.3.2024 (Wednesday) |
Open |
Nationwide |
|
|
29.4.2024 (Monday) |
1.5.2024 (Wednesday) |
Open |
Nationwide |
|
|
10.6.2024 (Monday) |
12.6.2024 (Wednesday) |
Open |
Nationwide |
|