Architecting End-to-End Data Solutions with Fabric

In this Fabric training course, learners explore the capabilities and features of Microsoft Fabric, a unified data platform designed for building scalable, secure, and high-performance data...

Read More
By Request
8781  Reviews star_rate star_rate star_rate star_rate star_half
$835USD
Duration 1 day
Course Code WA3771-MOC
Available Formats Classroom

Overview

Course Description

In this Fabric training course, learners explore the capabilities and features of Microsoft Fabric, a unified data platform designed for building scalable, secure, and high-performance data solutions. This course takes learners through essential data fundamentals, such as Big Data concepts and warehousing strategies, before diving into the core SaaS architecture of Fabric workspaces and compute engines. Learners discover how to architect unified storage using OneLake and Delta tables while mastering data engineering tasks through Data Factory pipelines, Dataflows Gen2, and Apache Spark integrations within Lakehouses. Additionally, the course covers advanced topics including the deployment of SQL databases, the implementation of Real-time Intelligence, and the creation of AI data agents to drive decision-making.

Skills Gained

  • Evaluate core data management principles including OLAP versus OLTP systems and row-based versus column-based storage strategies
  • Provision Microsoft Fabric workspaces and compute capacities to support various data engineering and analytics personas
  • Architect unified storage solutions using OneLake and Delta table formats to support SQL databases and mirroring
  • Construct automated ETL processes to ingest and transform data using Data Factory pipelines and Dataflows Gen2
  • Implement Apache Spark architectures within Lakehouses to manage big data workflows and leverage shortcuts for efficient access
  • Develop and publish AI-driven data agents to enable intelligent questioning of selected data sources

Prerequisites

  • Familiarity with cloud technologies and data platforms.
  • Experience with data integration and analytics tools.
  • Basic knowledge of Microsoft Azure services is useful but not necessary.

Note: This course includes Microsoft-authored content, along with additional lessons and labs developed by Accenture. All content is © their respective owners.

Read Less

Course Details

Course Details

Introduction to Data Fundamentals

  • Class Discussion: Big Data and the 3Vs
  • Steps in Data Management
  • Data Warehousing: On-premises vs Cloud
  • OLAP, OLTP, and Schema Types
  • Data Storage: Row-Based vs Column-Based

Introduction to Microsoft Fabric

  • Overview and SaaS Platform
  • Fabric's Role for Different Personas
  • Compute Engines and Capacity Provisioning
  • Workspaces and High-level Concepts

Databases in Microsoft Fabric

  • OneLake and Delta Table Format
  • Creating and Building SQL Databases
  • API for GraphQL and Mirroring Databases
  • Endpoints for Mirrored Databases

Data Warehouse in Microsoft Fabric

  • Overview of Data Warehouse Capabilities

Data Factory: Pipelines and Dataflows

  • Data Engineering and ETL Options
  • Dataflows Gen2
  • Pipelines in Microsoft Fabric

Understanding Apache Spark in Microsoft Fabric Lakehouses

  • Spark Overview and Architecture
  • Spark Workflow and Use Cases
  • Spark and Microsoft Fabric Lakehouses
  • Shortcuts and Their Benefits

Data Science and AI in Microsoft Fabric

  • Fabric Data Agent Creation and Options
  • Data Source Selection and Questioning
  • Publishing and Sharing Data Agents

Real-time Intelligence in Microsoft Fabric

  • Understanding Real-time Intelligence
  • Additional Readings and Resources

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

The class covered the concepts needed for the AWS Cloud Practitioner Certification.

Thorough explanations by the instructor along guide and practical training sim of software.

The class was very vast paced however the teacher was very good at checking in on us while giving us time to complete the labs.

my experince was great from the day i regetered to the actuall day of the class.

I like their training. A lot of material covered. The labs are very good. l learned a lot.