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
-
3. Power BI: Importing and Cleaning XML Data8m 34s
-
4. Creating Stacked Line Charts in Power BI8m 39s
-
5. Editing the Filters Pane Settings in Power BI10m 36s
-
6. Creating Foreign Key Relationships in Power BI11m 13s
-
7. Creating a Bar Chart with Line Markers in Power BI8m 44s
-
8. Power BI: Combining Imported Folder Files11m 11s
-
9. Performing Power Query Data Cleaning Operations10m 12s
-
10. Course Summary2m 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.
