Earn Your Fabric Analytics Engineer Certification in Just 5 Days
Live instructor-led training, official courseware, hands-on labs, exam vouchers, and a free retake — all in one package.
What's Included
Upcoming Sessions
MCA Microsoft Fabric Analytics Engineer Certification (DP-900, DP-600) Boot Camp
Scroll to see additional dates.
Remote Live
Why Thousands Choose Career Camps
17+ Years of Training Experience
More than 17 years helping IT professionals and organizations achieve their certification goals.
5,000+ Professionals Trained
Training experience spanning individual professionals, enterprise organizations, government and military clients.
Trusted by Professionals & Organizations
Training delivered to thousands of IT professionals and organizations, including enterprise environments.
Access to 10+ Training Providers
Career Camps gives you access to certification training from multiple established training providers.
Live Certified Instructors
Learn directly from experienced instructors—not prerecorded videos or self-paced material.
Training That Fits Your Team
Whether you're advancing your own career or training an entire team, we can help you find the right solution.
Course Description
Description
Prerequisites
While there are no required prerequisites for taking this course, students should have experience with data modeling, data transformation, and analytics.
Recommended experience includes:
Translating business requirements into analytical measures
Working with SQL or DAX
Building semantic models and reports in Power BI
Understanding core data analytics concepts
Familiarity with KQL and Python is helpful, but not required
Why Choose Us
CAREER CAMPS DIFFERENCE
Career Camps provides an in-depth hands on learning environment. Our instructors teach using demonstrations and explain concepts beyond the scope of the courseware. The best instructors are contracted from all across the US. These professionals are real world consultants who actually implement these technologies. Career Camps knows our clients work in the “real world” and it only makes sense to have an instructor with the experience in the real world.
Facilities – Many of our competitors over-crowd classrooms by placing 2 to 3 students per desk and 20+ students per instructor. Often these companies “extend” the life of very old equipment with slow performance on the software used today. Our average class size is 8 students. Our facilities have the best equipment with the most comfortable, focused environment for learning.
Instructors – Our CEO, Chester Flake holds one of the rarest Microsoft Certifications – the Microsoft Certified Learning Consultant (MCLC) Certification. This certification reflects a commitment to make sure our instructors are also actively engaged in real world consulting projects. Students expect a professional who can answer questions and demonstrate the technology.
Face to Face Training – We believe the best way to interact and learn is face to face training. Many of our competitors which offer local training are simply providing students with headphones/mic to attend class with an instructor at a remote location.
Test Pass – We offer a free retake voucher (if needed) for each of the exams required for certification. Any training center offering a “100% pass guarantee” would have to use unethical practices or unlimited test vouchers (which is not likely or practical).
Distractions – Students often look for a “local” training center so they can be close to home and work. Boot camp requires a tremendous time commitment during the program. Long class hours combined with self study each evening. The goal of boot camp is to achieve certification in a fraction of the time. We strongly recommend students attend camp away from home and work in a focused, distraction free environment.
Boot Camp – Boot camp is an accelerated training focused on teaching technology and testing students on the official exams. Most training providers “added” boot camps to the existing standard training classes they offer. These training centers think a boot camp is just a regular class where you send the student home with a voucher on the last day. Career Camps administers exams throughout the camp. Equally important – not every trainer can teach a boot camp and not all courseware is designed for boot camp format. Our trainers know the boot camp format and our courseware is designed for accelerated learning.
Florida – Career Camps has one of the most scenic locations boasting some of the best weather in US. We believe students should have a comfortable and inviting atmosphere while attending these otherwise intense programs. We place our location, facilities and amenities up against that any competitor.
Microsoft Gold Learning Partner
Career Camps has developed a comprehensive training / delivery format focused on learning beyond the generic book content (accessible to any Microsoft training provider). Our program incorporates interactive demonstrations and detailed real world explanations. When possible – additional content, videos, labs & demonstrations are provided to expand on advanced topics – providing additional insight and perspective. Career Camps training is not the typical book & PowerPoint presentation found at any local training center.
As a Microsoft Certified Partner with Gold Learning Competency – we adhere to the strict guidelines, standards and requirements to use Microsoft’s exclusive curriculum. More over – our standards go beyond the “minimum requirements” set forth by Microsoft Learning.
We leverage our partnership benefits of courseware customization to build end to end technology training solutions. Students gain practical skills which can be implemented immediately.
At most training centers – learning starts on the first day of class and ends on the last day. Our boot camp training program is designed to offer resources before, during and after the training.
What You'll Learn
- Get started with Microsoft Fabric
- Implement a data warehouse with Microsoft Fabric
- Work with semantic models in Microsoft Fabric
- Administer and govern Microsoft Fabric
- Ingest data with Microsoft Fabric
- Implement a Lakehouse with Microsoft Fabric
- Implement Real-Time Intelligence with Microsoft Fabric
- Implement a data warehouse with Microsoft Fabric
- Manage a Microsoft Fabric environment
Course Outline
Explore core data concepts
- Identify data formats
- Explore file storage
- Explore databases
- Explore transactional data processing
- Explore analytical data processing
Explore data roles and services
- Explore job roles in the world of data
- Identify data services
Explore fundamentals relational data concepts
- Understand relational data
- Understand normalization
- Explore SQL
- Describe database objects
Explore relational database services in Azure
- Describe Azure SQL services and capabilities
- Describe Azure services for open-source databases
Explore Azure Storage for non-relational data
- Explore Azure blob storage
- Explore Azure Data Lake Storage Gen2
- Explore Microsoft OneLake in Fabric
- Explore Azure Files
- Explore Azure Tables
Explore fundamentals of Azure Cosmos DB
- Describe Azure Cosmos DB
- Identify Azure Cosmos DB APIs
Explore fundamentals of large-scale analytics
- Describe data warehousing architecture
- Explore data ingestion pipelines
- Explore analytical data stores
Explore fundamentals of real-time analytics
- Understand batch and stream processing
- Explore common elements of stream processing architecture
- Explore Microsoft Fabric Real-Time Intelligence
- Explore Apache Spark structured streaming
Explore fundamentals of data visualization
- Describe Power BI tools and workflow
- Describe core concepts of data modeling
- Describe considerations for data visualization
Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
Get started with lakehouses in Microsoft Fabric
- Describe lakehouse features and capabilities
- Ingest and transform data in a lakehouse
- Query and analyze lakehouse data
Get started with data warehouses in Microsoft Fabric
- Understand data warehouses
- Understand data warehouses in Fabric
- Query and transform data
- Model data in a warehouse
- Secure and monitor a warehouse
Get started with Real-Time Intelligence in Microsoft Fabric
- What is real-time data analytics?
- Real-Time Intelligence in Microsoft Fabric
- Ingest and transform real-time data
- Store and query real-time data
- Visualize real-time data
- Automate actions
Get started with data science in Microsoft Fabric
- Understand the data science process
- Explore and process data with Microsoft Fabric
- Train and score models with Microsoft Fabric
Get started with SQL Database in Microsoft Fabric
- Work with SQL databases
- Secure databases in Fabric
- Explore Copilot for SQL Database
- Simplify data management with mirroring and virtualization
Design semantic models for scale in Microsoft Fabric
- Choose a storage mode
- Design star schema for semantic models
- Design scalable calculations
- Configure settings for scale
Understand Microsoft Fabric IQ fundamentals
- Get started with Fabric IQ
- Explore Microsoft Fabric IQ components
- Understand the ontology modeling paradigm
Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
Get started with data warehouses in Microsoft Fabric
- Understand data warehouses
- Understand data warehouses in Fabric
- Query and transform data
- Model data in a warehouse
- Secure and monitor a warehouse
Load data into a Microsoft Fabric data warehouse
- Explore data load strategies
- Use data pipelines to load a warehouse
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
Query a data warehouse in Microsoft Fabric
- Query data
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
Security a Microsoft Fabric data warehouse
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
Create DAX calculations in semantic models
- Create calculated tables
- Create calculated columns
- Understand implicit measures
- Create explicit measures
- Use iterator functions
Design scalable semantic models
- Choose the best storage mode
- Configure semantic models for large data
- Work with relationships
- Write DAX for readability with complex calculations
- Create dynamic calculation elements
Optimize a model for performance in Power BI
- Describe semantic model optimization techniques
- Review performance of measures, relationships, and visuals
- Use variables to improve performance and troubleshooting
- Reduce cardinality
- Optimize DirectQuery models with table level storage
- Create and manage aggregations
Create and manage Power BI assets
- Create reusable Power BI assets
- Manage development lifecycle for Power BI assets
- Use lineage view and endorse data assets
- Manage a Power BI semantic model using XMLA endpoint
Enforce Power BI model security
- Restrict access to Power BI model data
- Restrict access to Power BI model objects
- Apply good modeling practices
Administer a Microsoft Fabric environment
- Understand the Fabric Architecture
- Understand the Fabric administrator role
- Manage Fabric security
- Govern data in Fabric
Security data access in Microsoft Fabric
- Understand the Fabric security model
- Configure workspace and item permissions
- Apply granular permissions
Secure a Microsoft Fabric data warehouse
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
Govern data in Microsoft Fabric with Purview
- Govern data in Microsoft Fabric
- Why use Microsoft Purview with Microsoft Fabric?
- Govern data in the Microsoft Purview hub
Frequently Asked Questions
What is the Microsoft Fabric Analytics Engineer Certification Boot Camp?
The MCA Microsoft Fabric Analytics Engineer Certification (DP-900, DP-600) Boot Camp is an intensive Microsoft training program that combines foundational data concepts with advanced Microsoft Fabric analytics skills. The boot camp is designed to help IT and data professionals understand modern data analytics, data engineering, and business intelligence while preparing for the DP-900 and DP-600 certification exams.
What certifications can I earn through this Microsoft Fabric boot camp?
The boot camp prepares participants for the Microsoft Azure Data Fundamentals (DP-900) certification and the Microsoft Fabric Analytics Engineer Associate (DP-600) certification. Together, these certifications provide a progression from foundational data knowledge to advanced analytics skills using Microsoft Fabric.
Who should take Microsoft Fabric Analytics Engineer training?
This boot camp is ideal for data analysts, data engineers, analytics engineers, business intelligence professionals, database administrators, developers, and IT professionals who want to develop modern data analytics skills using Microsoft Fabric.
Do I need previous Microsoft Fabric experience?
No previous Microsoft Fabric experience is necessarily required for the DP-900 portion of the training. However, the DP-600 certification is more technical, so familiarity with data concepts, analytics, databases, SQL, or business intelligence can be beneficial.
What is Microsoft Fabric?
Microsoft Fabric is an end-to-end data and analytics platform that brings together data integration, data engineering, data science, data warehousing, real-time analytics, and business intelligence. It is designed to provide organizations with a unified environment for working with data and analytics.
Is this Microsoft Fabric boot camp good for beginners?
The DP-900 portion is suitable for beginners and professionals looking to establish foundational data knowledge. The DP-600 portion is more advanced and is better suited to professionals with some experience in data analytics, business intelligence, databases, or related technology.
Related products
-
MCA Microsoft Azure Database Administrator Certification (DP-900, DP-300) Boot Camp
$3,495.00 Course Details This product has multiple variants. The options may be chosen on the product page -
MCA Microsoft Power BI Data Analyst Certification (PL-900, PL-300) Boot Camp
$3,995.00 Course Details This product has multiple variants. The options may be chosen on the product page -
MCA Azure AI App & Agent Developer Associate Certification (AI-901, AI-103) Boot Camp
$3,995.00 Course Details This product has multiple variants. The options may be chosen on the product page
Ready to Take the Next Step?
Choose your upcoming training date or talk with our training advisors about the right option for you or your team.