Vendors

This course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric. Students will build on existing analytics experience and will learn how to use Microsoft Fabric components, including lakehouses, data warehouses, notebooks, dataflows, data pipelines, and semantic models, to create and deploy analytics assets. This course is best suited for those who have the PL-300 certification or similar expertise in using Power BI for data transformation, modeling, visualization, and sharing. Also, learners should have prior experience in building and deploying data analytics solutions at the enterprise level.

img-course-overview.jpg

What You'll Learn

  • Describe end-to-end analytics in Microsoft Fabric
  • Describe core features and capabilities of lakehouses in Microsoft Fabric.
  • Create a lakehouse.
  • Ingest data into files and tables in a lakehouse.
  • Query lakehouse tables with SQL.
  • Configure Spark in a Microsoft Fabric workspace
  • Identify suitable scenarios for Spark notebooks and Spark jobs
  • Use Spark dataframes to analyze and transform data
  • Use Spark SQL to query data in tables and views
  • Visualize data in a Spark notebook
  • Understand Delta Lake and delta tables in Microsoft Fabric
  • Create and manage delta tables using Spark
  • Use Spark to query and transform data in delta tables
  • Use delta tables with Spark structured streaming
  • Describe pipeline capabilities in Microsoft Fabric.
  • Use the Copy Data activity in a pipeline.
  • Create pipelines based on predefined templates.
  • Run and monitor pipelines.
  • Describe Dataflow capabilities in Microsoft Fabric
  • Create Dataflow solutions to ingest and transform data
  • Include a Dataflow in a pipeline
  • Describe data warehouses in Fabric.
  • Understand a data warehouse vs a data Lakehouse.
  • Work with data warehouses in Fabric.
  • Create and manage fact tables and dimensions within a data warehouse.
  • Describe Real-Time Intelligence in Microsoft Fabric.
  • Create eventhouse databases and tables using KQL database.
  • Describe Real-Time hub in Microsoft Fabric.
  • Use KQL to query tables and create querysets.
  • Understand the data science process
  • Train models with notebooks in Microsoft Fabric
  • Track model training metrics with MLflow and experiments
  • Understand Data Activator.
  • Understand triggers, conditions, and actions in Data Activator.
  • Get data from Power BI Reports and EventStreams with Data Activator.
  • Assign data and create triggers in Data Activator.
  • Interact with Real-Time Intelligence.
  • Describe Fabric admin tasks
  • Navigate the admin center
  • Manage user access
  • Describe end-to-end analytics in Microsoft Fabric
  • Describe core features and capabilities of lakehouses in Microsoft Fabric.
  • Create a lakehouse.
  • Ingest data into files and tables in a lakehouse.
  • Query lakehouse tables with SQL.
  • Configure Spark in a Microsoft Fabric workspace
  • Identify suitable scenarios for Spark notebooks and Spark jobs
  • Use Spark dataframes to analyze and transform data
  • Use Spark SQL to query data in tables and views
  • Visualize data in a Spark notebook
  • Understand Delta Lake and delta tables in Microsoft Fabric
  • Create and manage delta tables using Spark
  • Use Spark to query and transform data in delta tables
  • Use delta tables with Spark structured streaming
  • Describe Dataflow capabilities in Microsoft Fabric
  • Create Dataflow solutions to ingest and transform data
  • Include a Dataflow in a pipeline
  • Describe pipeline capabilities in Microsoft Fabric.
  • Use the Copy Data activity in a pipeline.
  • Create pipelines based on predefined templates.
  • Run and monitor pipelines.
  • Describe the principles of using the medallion architecture in data management.
  • Apply the medallion architecture framework within the Microsoft Fabric environment.
  • Analyze data stored in the lakehouse using DirectLake in Power BI.
  • Describe best practices for ensuring the security and governance of data stored in the medallion architecture.
  • Describe Dataflow capabilities in Microsoft Fabric
  • Create Dataflow solutions to ingest and transform data
  • Include a Dataflow in a pipeline
  • Ingest external data to Fabric lakehouses using Spark
  • Configure external source authentication and optimization
  • Load data into lakehouse as files or as Delta tables
  • Describe pipeline capabilities in Microsoft Fabric.
  • Use the Copy Data activity in a pipeline.
  • Create pipelines based on predefined templates.
  • Run and monitor pipelines.
  • Describe data warehouses in Fabric.
  • Understand a data warehouse vs a data Lakehouse.
  • Work with data warehouses in Fabric.
  • Create and manage fact tables and dimensions within a data warehouse.
  • Learn different strategies to load data into a data warehouse in Microsoft Fabric.
  • Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
  • Learn how to load data in a warehouse using T-SQL.
  • Learn how to load and transform data with dataflow (Gen 2).
  • Use SQL query editor to query a data warehouse.
  • Explore how visual query editor works.
  • Learn how to connect and query a data warehouse using SQL Server Management Studio.
  • Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
  • Monitor current activity in the data warehouse with dynamic management views.
  • Monitor querying trends with query insights views.
  • Learn the concepts of securing a data warehouse in Microsoft Fabric.
  • Learn how to implement dynamic data masking to obscure sensitive information.
  • Learn how to configure row-level security to provide granular control.
  • Learn how to implement column-level security to protect sensitive data.
  • Learn how to configure granular permissions using T-SQL.
  • Describe the importance of building scalable data models.
  • Implement Power BI data modeling best practices.
  • Use the Power BI large dataset storage format.
  • Understand how model relationship work.
  • Set up relationships.
  • Use DAX relationship functions.
  • Understand relationship evaluation.
  • Optimize queries using performance analyzer.
  • Troubleshoot DAX performance using DAX Studio.
  • Optimize a data model using Tabular Editor.
  • Restrict access to Power BI model data with RLS.
  • Restrict access to Power BI model objects with OLS.
  • Apply good development practices to enforce Power BI model security.

Who Should Attend

The primary audience for this course is data professionals with experience in data modeling, extraction, and analytics. DP-600 is designed for professionals who want to use Microsoft Fabric to create and deploy enterprise-scale data analytics solutions.

img-who-should-learn.png

Prerequisites

Please review the prerequisites listed for each module in the course content and click on the provided links for more information.

Learning Journey

Want to boost your career in Microsoft? Click on the roles below to see the learning pathways, specially designed to give you the skills to succeed.

1. Get started with Microsoft Fabric

Explore the capabilities of Microsoft Fabric.

Click here to know more

2. Implement a Lakehouse with Microsoft Fabric

This learning path introduces the foundational components of implementing a data lakehouse with Microsoft Fabric.

Click here to know more

3. Ingest data with Microsoft Fabric

Explore how Microsoft Fabric enables you to ingest and orchestrate data from various sources (such as files, databases, or web services) through dataflows, notebooks, and pipelines.

Click here to know more

4. Implement a data warehouse with Microsoft Fabric

Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.

Click here to know more

5. Work with semantic models in Microsoft Fabric

Designing reports for enterprise scale requires more than just connecting to data. Understanding semantic models and strategies for scalability and optimization are key to a successful enterprise implementation. This learning path helps you prepare for the Fabric Analytics Engineer Certification.

Click here to know more

Skills measured

  • Plan, implement, and manage a solution for data analytics
  • Prepare and serve data
  • Implement and manage semantic models
  • Explore and analyze data

Frequently Asked Questions (FAQs)

  • Why get Microsoft certified?

    Microsoft certifications validate your skills and expertise in Microsoft technologies and solutions, demonstrating your ability to design, implement, and manage cutting-edge technologies.

    These certifications are globally recognized and highly sought after by employers, as they signify your proficiency in using Microsoft products and services to drive innovation and solve business challenges.

    Microsoft-certified professionals are in high demand, opening doors to new career opportunities and higher earning potential.

  • What to expect for the examination?

    Microsoft certification exams are designed to assess your knowledge and skills in specific Microsoft technologies and solutions.

    Exams typically consist of multiple-choice, multiple-select, and case study questions, and some may include lab simulations to evaluate your practical skills.

    Note: Certification requirements and policies may be updated by Microsoft from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • How long is Microsoft certification valid for?

    Most Microsoft role-based and specialty certifications are valid for one year from the date of passing the exam.

    To maintain your certification, you will need to renew it annually by passing a free online assessment on Microsoft Learn.

    However, Microsoft Applied Skills credentials and Fundamentals certifications do not expire.

    Note: Certification requirements and policies may be updated by Microsoft from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • Why take this course with Trainocate?

    Here’s what sets us apart:

    - Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).

    - Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.

    - Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.

    - Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.

    - Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.

    - Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Course Curriculum

Training Schedule

Training Schedule

Exam & Certification

Exam & Certification

FAQs

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for

Inquiry Details

By providing your contact details, you agree to our Privacy Policy.