Intermediate Data Modeling in Power BI

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: Data Modeling in Power BI
DataCamp details
  • Chapters: 4
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Intermediate

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

Build Power BI data models with date dimensions, hierarchies, bi-directional cross-filtering and role-playing dimensions, then tune report performance.

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

A Power BI data model that grows beyond a few tables raises harder questions: how tables relate, which way filters should flow, and why reports slow down. Here you add date and year dimensions, set relationship cardinality and composite keys, build hierarchies and measures at different levels of granularity, and decide when bi-directional cross-filtering or role-playing dimensions fit. The closing lessons look at what makes a model slow and how data types and column choices change that.

What You Will Achieve

  • Add a date or year dimension to a Power BI model and relate it to your fact tables with the right cardinality
  • Build a hierarchy and create quick measures so a report can move between granularity levels
  • Decide when bi-directional cross-filtering suits a model and when to set up role-playing dimensions instead
  • Track down the causes of a slow report and fix them by revisiting data types and the choice between calculated and computed columns


Program Overview

Date Dimensions, Cardinality, and Key Relationships

Extends a model with more tables and relationships, starting with date and year dimensions and the cardinality that links them.

  • Date dimensions and relationships in Power BI
  • Creating and extending a year dimension
  • Relationship cardinality
  • Composite key relationships

Hierarchies, Measures, and Cross-Filtering

Works with hierarchies and granularity levels, then turns to relationship techniques for filtering in both directions and reusing a dimension.

  • Hidden hierarchies and building a hierarchy
  • Changing the granularity of a query
  • Measures and quick measures
  • Bi-directional cross-filtering and role-playing dimensions

Performance Optimization in Power BI

Gathers tips for spotting what slows a model and the calculation and filtering choices that help.

  • Identifying performance problems
  • Data types and calculations
  • Calculated versus computed columns
  • An alternative to bi-directional filtering

Certificate Awarded (Paid)

Complete the course to earn it.


Job Outlook

Business intelligence and reporting work in Power BI, where analysts maintain shared data models and keep dashboards responsive as tables and relationships multiply.


Our take

Good for: Power BI users who want their models to handle extra date tables, hierarchies and more complex relationships while keeping reports quick.

Keep in mind: The chapters center on relationships, hierarchies and performance tips; DAX appears mainly through measures and date tables rather than as a topic of its own.

Bottom line: A follow-on for Power BI modelers that pairs relationship design with the performance tuning a growing model needs.

Frequently Asked Questions

Which relationship cardinality types are discussed?

Cardinality has its own lesson, covering the one-to-many, one-to-one and many-to-many types that Power BI relationships support. A separate lesson builds relationships on composite keys.

When should a model use bi-directional cross-filtering?

The course weighs single-directional against bi-directional filtering in terms of model integrity and report behavior, shows where role-playing dimensions fit, and its final chapter presents an alternative to bi-directional filtering for performance reasons.

Is DAX used in this course?

Yes. You write DAX to customize the data model, including the CALENDAR() function for building a date table. Measures and quick measures also get a lesson of their own.

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
    Intermediate Data Modeling in Power BI
    Intermediate Data Modeling in Power BI
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0