<< VIEW FULL COURSE LIST

Microsoft - Power Query

Get & Transform Data with Power BI

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 so they can start creating reports that start solving 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.

Class Length

One Day

CLASS MATERIALS

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

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.

COST

$599

Class Outline
  • Data sources and connections: Power BI Desktop
    • Sourcing approaches
      • Import
      • Live via Direct Query
    • 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