8781  Reviews star_rate star_rate star_rate star_rate star_half

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
$835 USD
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.
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
Ascendient Learning would like to occasionally share news about our services and career opportunities via e-mail when we believe it would be relevant to you. Would you like to opt-in to these communications? You may withdraw your consent at any time using the opt-out/preferences link in the emails sent.

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • 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

Great instructor, clear and concise course. Labs were easy to follow and worked perfectly.

Exit certified was great as it is very in depth and hands on learning which made it very easy to learn this type of work.

Course was great and informative. The instructor had a good flow and was very personable.

Fantastic and great training. Tons of hands-on labs to really make you understand the material being thought.

This was a good program to get prepared for the solutions architect associate exam.