Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Microsoft Power BI 2.85
| Beginner
- 11 Videos | 1h 31m 13s
- Includes Assessment
- Earns a Badge
Power BI is one of the most commonly-used tools for building data reports from various source data. In this course, you'll start by installing Power BI Desktop and importing data to it from several sources, including the relational databases, MySQL and PostgreSQL, cloud data warehouses, and Excel, CSV, JSON, and XML files. You'll then use Power BI to perform simple operations, such as changing data types, renaming columns, and using uppercase text. You'll also open and run the Power Query app. Moving on, you'll use Power BI to create and format simple data visualizations, such as bar charts, line charts, and stacked bar charts. Finally, you'll practice aggregating numeric data and string (categorical) data in charts, working with the correct aggregation operators for their respective fields.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseinstall Power BI from Microsoft Store and import data to it from an Excel fileperform operations in Power BI using the UI and the Advanced Editor to sort data, change data types, rename columns, and use uppercase textperform operations in Power BI to remove columns and top rows, split columns by delimiter, filter rows, and delete a querycreate basic and advanced filters in Power BI to filter data using a condition on one or more columnscreate bar charts in Power BI, sort the values visualized in them, and edit the operations Power BI performs on the visualized data
-
edit the aesthetics of a bar chart, changing the color, display units, orientation, height, width, and moreimport JSON data into Power BI and use Power Query to convert JSON data into tabular data and change the column data typescreate and edit a line chart in Power BI by adding and configuring data labels, legends, markers, gridlines, and other chart elementsuse Power BI to design a stacked bar chart for data visualization and fields with large numbers of unique values and create a basic filter using the filters panesummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 33sUP NEXT
-
2.Installing Power BI and Importing Data to It11m 12s
-
3.Performing Data Cleaning Operations in Power BI11m 15s
-
4.Deleting and Filtering Data in Power BI7m 43s
-
5.Using Basic and Advanced Data Filters in Power BI5m 39s
-
6.Creating Bar Charts in Power BI9m 47s
-
7.Formatting Bar Charts in Power BI11m 41s
-
8.Importing JSON Data into Power BI and Formatting It9m 35s
-
9.Creating and Formatting Line Charts in Power BI11m 10s
-
10.Working with Stacked Bar Charts in Power BI7m 49s
-
11.Course Summary2m 51s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.