<< VIEW FULL COURSE LIST

Microsoft - Desktop

Data Shaping & Modeling, Beginning & Intermediate

COURSE DESCRIPTION

Power BI Data Shaping and Modeling provides a fundamental understanding of the Query Editor, data modeling and Data Analysis Expressions (DAX) in Power BI.

Creating a solid data model is the foundation for creating meaningful visualizations and reports. Though hands-on application of exercises in Power BI, students will learn to construct well-designed data models in Power BI. They will learn how to connect a variety of data sources to import data, cleanse it and shape it into an optimal form for reporting. Students will also learn the fundamentals of DAX and how to apply DAX for common analytics scenarios.

A fully interactive experience, our online classroom offers a unique opportunity to learn from and work with a subject matter expert. Participants get practice performing the skills and can ask questions of the instructor in real time.

COURSE LENGTH

Two days

COURSE MATERIALS

Students receive a comprehensive set of learning materials, including all course notes and class examples.

COST

$1199

Suggested attendees

Business analysts who want to learn the fundamentals of data acquisition, modeling, visualization and dashboarding with Power BI. No previous Power Query experience is required.

Course Outline
  • Data sources and connections: Power BI Desktop
    • Sourcing approaches
      • Import
      • Live via DirectQuery
    • Importing and refreshing data
    • Dataset tasks
  • Introduction and overview of transforming data with Power BI
  • Introducing Query Editor
  • Queries
  • Data preview
  • Transforming data
    • General transformation types
      • Common basic transformations
        • Transforming data: scenario
        • Explore source data
        • Remove rows and columns
        • Un-pivot columns
        • Add custom columns
  • Advanced features
    • Advanced features sampler
      • Transforming data: scenario
    • Combining data sets
      • Merge queries
      • Append queries
    • Use a function
      • Create a function based on internal functions
      • Generate date table as a new function
    • Parameters
  • Data modeling concepts and practices
    • Data types, categories, defaults and properties
    • Relationships
      • Multiple purposes
      • Understanding keys
      • Relationship cardinality
      • Cross-filter direction
    • Hierarchies
    • Calculated tables and columns
    • Introduction to DAX measures
  • DAX fundamentals
    • Overview and mechanics
    • Working with different types of functions
  •  DAX solutions to common business challenges

    • Students will perform hands-on exercises to tackle challenges common in the business environment, including less-than-ideal conditions with data that is already in place, including running totals and moving averages, suppression of totals for non-additive numbers and managing the presentation of semi-additive numbers and more