Power BI Advanced - Custom 2 daysのトレーニングコース

1. Power BI Fundamentals — Quick Recap

Refresh the essential Power BI concepts and establish a common foundation before moving into advanced scenarios.

2. Advanced Modeling Patterns

Learn how to design robust Power BI models for more complex, real-world business scenarios.

• Model Header–Detail scenarios such as Orders and Order Lines

• Combine multiple business processes in a single analytical model

• Use shared dimensions across Sales, Forecast, Inventory and other fact tables

• Work with data stored at different levels of detail

• Combine Actual, Budget and Forecast data effectively

• Handle many-to-many business relationships

• Use bridge tables to solve complex relationship scenarios

3. Composite Models

Learn how to combine centralized enterprise data with local or specialized business data without rebuilding everything from scratch.

• Choose between Import, DirectQuery and Dual storage modes

• Understand Composite Model architecture

• Connect directly to existing Power BI semantic models

• Combine centrally managed and locally managed data

• Extend enterprise semantic models with additional business information

• Add local tables and business calculations

• Understand the performance and design considerations of Composite Models

4. Mastering CALCULATE & DAX Evaluation Context

Build a stronger understanding of DAX to create reliable calculations for complex analytical requirements.

• Deep dive into CALCULATE, one of the most important DAX functions

• Understand how report selections affect calculations

• Control and modify filters within business measures

• Understand the difference between Row Context and Filter Context

• Understand Context Transition and why it matters

• Combine Context Transition with iterators for more sophisticated calculations

5. Advanced Time Intelligence & DAX Patterns

Move beyond basic calculations and solve common analytical scenarios involving time, open transactions and changing business conditions.

Time-Based Analysis

• Build and use a Calendar table

• Understand how dates and reporting periods influence calculations

• Calculate YTD, MTD and previous-period performance

• Create rolling-period calculations

• Compare current performance with previous and comparable periods

• Introduction to Calendar-Based Time Intelligence

Facts in Progress

• Analyze business processes with Start and End Dates

• Report on open orders, active projects, contracts and similar scenarios

• Calculate what was active at a specific point in time

• Analyze items active during a selected reporting period

• Calculate the count and value of business items in progress

6. Calculation Groups

Learn how to simplify large Power BI models and create reusable calculation logic.

• Understand Calculation Groups and Calculation Items

• Reduce the number of repetitive measures in a semantic model

• Apply the same calculation dynamically across multiple business metrics

• Use SELECTEDMEASURE() to create reusable logic

• Build reusable Time Intelligence calculations

7. Visual Calculations

Discover a more accessible way to create calculations directly within Power BI visuals.

• Understand what Visual Calculations are and where they can be used

• Compare Visual Calculations with traditional DAX measures

• Create calculations based on the structure of a visual

• Perform calculations across rows, columns and categories

• Apply Visual Calculations to practical reporting scenarios

• Decide when to use Visual Calculations and when a model-level measure is more appropriate

8. Power BI Optimization

Understand what happens behind the scenes in Power BI and learn how to identify opportunities for better model and report performance.

Understanding the Power BI Engine

• Discover how Power BI stores and processes data using VertiPaq

• Understand how data volume, cardinality and data types affect performance

• Learn why model design influences report speed and model size

• Understand the difference between Formula Engine and Storage Engine operations

Analyzing Performance with DAX Studio

• Identify slow or expensive calculations

• Analyze model size and data distribution

• Investigate performance bottlenecks

• Use performance information to improve models and measures

Managing Models with Tabular Editor

• Explore and manage semantic model metadata

• Make model changes more efficiently

• Manage Calculation Groups

• Use Best Practice Analyzer to identify opportunities for improvement

9. Enterprise Semantic Model Management

Learn how Power BI solutions can be securely refreshed, managed and promoted across enterprise environments.

Efficient Data Refresh

• Understand Incremental Refresh

• Refresh only the data that has changed

• Define historical and refresh periods

• Understand partitions and their role in managing large datasets

• Apply Incremental Refresh to large enterprise models

Dynamic Row-Level Security

• Deliver personalized data access based on the signed-in user

• Move from static to dynamic security

• Create security mapping tables

• Use user identity to determine data access

• Test and validate security rules

Deployment Pipelines

• Manage Power BI content across Development, Test and Production

• Understand pipeline stages

• Compare changes between environments

• Deploy reports and semantic models in a controlled way

• Configure environment-specific settings

• Support a structured enterprise release process