Data Ingestion and Semantic Models with Microsoft Fabric

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free Preview (Paid Upgrade)
  • Learning style: Self-paced, start anytime
  • Format: Text & Interactive
  • Video access: Streaming Only
  • Before you start: Introduction to Microsoft Fabric
DataCamp details
  • Chapters: 4
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Beginner

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

SKU: data-ingestion-semantic-models-microsoft-fabric Category: Tags: , , Brand:

Load data into Microsoft Fabric with pipelines, Dataflows Gen2 and shortcuts, then build and secure semantic models for Power BI reports.

At a glance
Duration4 hrs
LevelBeginner
CertificateCertificate of Completion
LanguageEnglish
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

Getting data into Microsoft Fabric and shaping it for reporting are two separate jobs, each with its own tools and trade-offs. You build pipelines that run on a schedule and log their runs, transform data with Dataflows Gen2, and reach existing data in place through OneLake shortcuts. The second half turns to the model behind Power BI reports: how tables relate, how DAX measures differ from calculated columns, who may see which data, and how to keep refreshes and reports running well.

What You Will Achieve

  • Set up a scheduled pipeline that loads data into lakehouse tables and records each run for later review
  • Pick a pipeline, a dataflow or a shortcut, and a lakehouse or a warehouse, to suit a given ingestion task
  • Spot and resolve circular or many-to-many relationships in a Power BI data model
  • Limit which rows and objects each user can see in a semantic model, then validate the security roles


Program Overview

Data Factory Pipelines and OneLake Shortcuts

Builds and automates pipelines in Fabric, stores the results, and uses shortcuts to reach data without copying it.

  • Pipeline activities, parameters, variables and scheduled runs
  • Lakehouse tables and files, stored procedure logging and a monitoring view
  • Shortcut and target paths, permissions and tracking updates

Dataflows Gen2 and Storage Solutions

Works through transformation, destination and refresh settings in Dataflows Gen2, then compares ingestion methods and storage options.

  • Dataflow components and basic transformations
  • Managed vs manual destinations, append and schema scenarios
  • Staging, fast copy and dataflow performance
  • Lakehouse or warehouse limits

Semantic Models, Security and Refreshes in Power BI

Covers report building and model design in Power BI, then security, refresh scheduling and tools for finding model and report issues.

  • Interactive reports, measures vs calculated columns, user defined aggregations and large dataset format
  • Active, inactive, bidirectional and circular relationships and the snowflake schema
  • Row-level and object-level security
  • Scheduled and on-demand refreshes, Performance Analyzer, Tabular Editor’s Best Practice Analyzer

Certificate Awarded (Paid)

Complete the course to earn it.


Job Outlook

Fabric pipelines and Power BI semantic models are used in data engineering, data science and business intelligence work, where teams bring data in from several sources and build reports on top of it.


Our take

Good for: Analysts and engineers who load data into Fabric and build Power BI reports on it, and want practice with both halves of that work.

Keep in mind: Its topics line up with part of the DP-600 Fabric Analytics Engineer Associate certification, which is a separate exam.

Bottom line: Its strength is covering both halves of the work: ingestion in Fabric and the secured, tuned Power BI semantic model built on top of it.

Frequently Asked Questions

Does the course prepare me for the DP-600 exam?

It was built to match some of the topics in Microsoft's Fabric Analytics Engineer Associate certification, known as DP-600. It covers part of that syllabus only, the exam is taken separately, and the certificate you receive here is a completion certificate, not the Microsoft certification.

Do I need my own Microsoft Fabric account for the exercises?

No. Learners are given a Fabric account during the course and follow step-by-step instructions to complete the hands-on exercises in it, so the practice takes place on the Fabric platform itself.

What does the course teach about OneLake shortcuts?

The shortcut lessons show how to identify a shortcut's own path and its target path, how permissions apply to data reached through a shortcut, and how updates to the underlying data are tracked.

Which Power BI tools are used to find performance problems?

The final chapter uses Performance Analyzer to examine report performance and Tabular Editor to identify data model issues, including reading the results of its Best Practice Analyzer. A lesson also covers choosing the right tool for a given optimization task.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    Data Ingestion and Semantic Models with Microsoft Fabric
    Data Ingestion and Semantic Models with Microsoft Fabric
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0