Getting Started with Power Query in Power BI

Power BI 2.12    |    Beginner
  • 14 videos | 1h 56m 51s
  • Includes Assessment
  • Earns a Badge
Power Query is a powerful data transformation and preparation tool, seamlessly integrated into Microsoft Power BI and other Microsoft products such as Excel. It enables users to effortlessly extract, transform, and load data from various sources, ensuring data consistency and quality. Begin this course by exploring how to transform and clean data using Power Query. You will learn to delete, rename, and move columns, remove duplicates, and perform a host of other data cleaning and processing operations. Next, you will discover how to create query duplicates and references and how to perform basic and advanced filtering on your data. Then you will find out how to add columns with calculated and conditional values and how you can use merge queries to create a new column in your data. Finally, you will perform grouping and aggregation operations, create parameterized queries, and combine query data using the append operation. This course will provide you with a solid understanding of how Power Query can be used for data transformation.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Recall key concepts of power query
    Perform operations using power query
    Perform column deletion and rename operations
    Perform data cleaning and transformations
    Split columns and remove duplicates
    Create query duplicates and query references
  • Perform basic and advanced filtering
    Add calculated and conditional columns
    Create columns using merge queries
    Perform grouping and summarization operations
    Create parameterized queries
    Combine queries using append
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 39s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 7m 47s
    After completing this video, you will be able to recall key concepts of Power Query. FREE ACCESS
  • Locked
    3.  Getting Started with Power Query
    10m 28s
    In this video, find out how to perform operations using Power Query. FREE ACCESS
  • Locked
    4.  Performing Column Deletion and Renaming Operations
    8m 39s
    Learn how to perform column deletion and rename operations. FREE ACCESS
  • Locked
    5.  Cleaning Data and Performing Basic Transformations
    7m 36s
    During this video, discover how to perform data cleaning and transformations. FREE ACCESS
  • Locked
    6.  Splitting Columns and Removing Duplicate Rows
    9m 24s
    Find out how to split columns and remove duplicates. FREE ACCESS
  • Locked
    7.  Duplicating and Referencing Queries
    10m 41s
    In this video, you will learn how to create query duplicates and query references. FREE ACCESS
  • Locked
    8.  Creating Basic and Advanced Filters
    11m 47s
    Discover how to perform basic and advanced filtering. FREE ACCESS
  • Locked
    9.  Adding Custom and Conditional Columns
    10m 1s
    During this video, you will learn how to add calculated and conditional columns. FREE ACCESS
  • Locked
    10.  Creating Columns Using Merge Queries
    11m 21s
    Find out how to create columns using merge queries. FREE ACCESS
  • Locked
    11.  Grouping and Summarizing Operations
    10m 49s
    In this video, discover how to perform grouping and summarization operations. FREE ACCESS
  • Locked
    12.  Using Parameterized Queries
    4m 29s
    Learn how to create parameterized queries. FREE ACCESS
  • Locked
    13.  Combining Queries Using Append
    10m 2s
    In this video, find out how to combine queries using append. FREE ACCESS
  • Locked
    14.  Course Summary
    2m 8s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Working with Scorecards, Dashboards, & Paginated Reports in Power BI
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Beginning Power BI for Business Users: Learning to Turn Data into Insights
Course Data Loading & Visualization in Power BI: Advanced Visualizations
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PL-300: Loading & Transforming Data in Power BI
Rating 4.7 of 830 users Rating 4.7 of 830 users (830)
Course Formatting cells and ranges in Excel 365
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)
Course PL-300: Preparing Data for Visualizations in Power BI
Rating 4.5 of 459 users Rating 4.5 of 459 users (459)