Business Reporting: Visualizing & Merging Data in Power BI

Microsoft Power BI 2.85    |    Intermediate
  • 10 videos | 1h 24m 20s
  • Includes Assessment
  • Earns a Badge
Likes 456 Likes 456
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
  • Locked
    3.  Power BI: Importing and Cleaning XML Data
    8m 34s
  • Locked
    4.  Creating Stacked Line Charts in Power BI
    8m 39s
  • Locked
    5.  Editing the Filters Pane Settings in Power BI
    10m 36s
  • Locked
    6.  Creating Foreign Key Relationships in Power BI
    11m 13s
  • Locked
    7.  Creating a Bar Chart with Line Markers in Power BI
    8m 44s
  • Locked
    8.  Power BI: Combining Imported Folder Files
    11m 11s
  • Locked
    9.  Performing Power Query Data Cleaning Operations
    10m 12s
  • 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.