Business Reporting: Visualizing & Merging Data in Power BI

Microsoft Power BI 2.85    |    Intermediate
  • 10 videos | 1h 24m 20s
  • Includes Assessment
  • Earns a Badge
Power BI and Power Query can be used in combination to facilitate both basic and advanced operations. In this course, you'll learn how to use Power Query to create the two types of calculated columns, custom and conditional. Next, you'll use Power BI to import and clean data and create stacked line charts (area charts) to visualize data. You'll filter the unique categorical values of the visualized series using various filtering techniques. You'll then combine data between tables using a foreign key relationship and create a bar chart with line markers using the analytics card. You'll move on to import a large number of files residing in the same folder. Lastly, you'll use Power BI's UI and Advanced Editor to perform basic data cleaning operations and Power Query to perform various advanced operations.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Use power query to create conditional calculated columns using if-else-elif blocks and custom calculated columns using formulas to determine values
    Import xml data to power bi, filter it, change the data type, and find and delete rows with errors
    Use power bi to build and edit stacked line charts, configure aspects of them, such as the legend and axes, and create a basic filter in the filters pane
    Configure the filters pane in power bi to automatically filter based on the specified filter value
  • Create a foreign key relationship (a.k.a., a referential integrity constraint) between two tables in power bi
    Use power bi to create a bar chart with lines parallel to the axes using the analytics card, and configure min, max, median, and average lines
    Combine files in an imported folder and perform basic data cleaning operations using power bi's ui and advanced editor
    Perform various advanced power query operations, such as removing columns and top n and error rows, performing row filtering operations, and creating grouped bar charts
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 46s
  • 9m 28s
    In this video, you will use Power Query to create conditional calculated columns using if-else-elif blocks and custom calculated columns using formulas to determine values. FREE ACCESS
  • Locked
    3.  Power BI: Importing and Cleaning XML Data
    8m 34s
    In this video, you will learn how to import XML data into Power BI, filter it, change the data type, and find and delete rows with errors. FREE ACCESS
  • Locked
    4.  Creating Stacked Line Charts in Power BI
    8m 39s
    In this video, you will learn how to use Power BI to build and edit stacked line charts, configure aspects of them, such as the legend and axes, and create a basic filter in the filters pane. FREE ACCESS
  • Locked
    5.  Editing the Filters Pane Settings in Power BI
    10m 36s
    During this video, you will learn how to configure the filters pane in Power BI to automatically filter based on the specified filter value. FREE ACCESS
  • Locked
    6.  Creating Foreign Key Relationships in Power BI
    11m 13s
    During this video, you will learn how to create a foreign key relationship between two tables in Power BI. FREE ACCESS
  • Locked
    7.  Creating a Bar Chart with Line Markers in Power BI
    8m 44s
    Learn how to create a bar chart with lines parallel to the axes using the analytics card in Power BI, and configure min, max, median, and average lines. FREE ACCESS
  • Locked
    8.  Power BI: Combining Imported Folder Files
    11m 11s
    In this video, you will learn how to combine files in an imported folder and perform basic data cleaning operations using Power BI's UI and Advanced Editor. FREE ACCESS
  • Locked
    9.  Performing Power Query Data Cleaning Operations
    10m 12s
    During this video, you will learn how to perform various advanced Power Query operations, such as removing columns and Top N and error rows, performing row filtering operations, and creating grouped bar charts. FREE ACCESS
  • Locked
    10.  Course Summary
    2m 59s

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 PL-300: Analysis & Sharing Features in Power BI
Course Tableau for Data Visualization: Exploring Visualizations & Data Formats
Course PL-300: Preparing Data for Visualizations in Power BI

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting started in Excel 365
Course PL-300: Matrix & Treemap Controls in Power BI
Course PL-300: Preparing Data for Visualizations in Power BI