Power BI / Basic: analytical and modeling foundations

Power BI β€” Basic: analytical and modeling foundations

Define data meaning, preparation, star relationships, measures and visual context.

6 lessons Β· No account required

What you will learn

  • Distinguish Desktop authoring from service collaboration and refresh.
  • Design clear selection and no-data acceptance cases.

  1. Desktop, service and analytical contracts

    Separate data preparation, semantic modeling, report interaction and service distribution before interpreting a number on a Power BI page.

    Start learning

  2. Power Query types and locale

    Preserve identifiers, numeric meaning and dates during preparation rather than trusting automatic detection or display formatting.

    Start learning

  3. Shaping, unpivot and quality ledgers

    Transform wide exports into stable analytical rows while preserving grain and accounting for every accepted, rejected and intentionally removed record.

    Start learning

  4. Star schema and filter paths

    Build a small fact-and-dimension model with explicit grain, unique keys and deliberate filter propagation instead of relying on automatic relationships.

    Start learning

  5. Measures, aggregation and ratios

    Define explicit DAX measures that aggregate at the correct grain and recompute meaningful ratios in each filter context.

    Start learning

  6. Visual context, filters and interactions

    Make report selections and totals understandable by distinguishing filter scope, cross-highlighting, sorting and the question each visual answers.

    Start learning
Back to course