<< VIEW FULL COURSE LIST

Microsoft - Power Query

Get & Transform Data with Power BI, Beginning & Intermediate

COURSE DESCRIPTION

This one-day course provides a fundamental understanding of the Power BI (and Excel) Query Editor. Though hands-on application of exercises in Power BI, students will learn how to connect to a variety of data sources to import data into Power BI. They will learn how to use the Query Editor to transform this source data into an organized data optimized for reporting to create reports that solve real-world BI problems right away.

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.

Enhance your Power BI skills and save $400 with our Power BI three-class bundle.

COURSE LENGTH

One Day

COURSE MATERIALS

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

COST

$599

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
      • Loading data
        • Loading data: scenario
        • Load data
  • 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