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 courseuse Power Query to create conditional calculated columns using if-else-elif blocks and custom calculated columns using formulas to determine valuesimport XML data to Power BI, filter it, change the data type, and find and delete rows with errorsUse 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 paneconfigure 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 BIUse Power BI to create a bar chart with lines parallel to the axes using the analytics card, and configure min, max, median, and average linescombine files in an imported folder and perform basic data cleaning operations using Power BI's UI and Advanced Editorperform various advanced Power Query operations, such as removing columns and Top N and error rows, performing row filtering operations, and creating grouped bar chartssummarize the key concepts covered in this course
IN THIS COURSE
-
2m 46s
-
9m 28s
-
8m 34s
-
8m 39s
-
10m 36s
-
11m 13s
-
8m 44s
-
11m 11s
-
10m 12s
-
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.