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
-
2m 33s
-
11m 12s
-
11m 15s
-
7m 43s
-
5m 39s
-
9m 47s
-
11m 41s
-
9m 35s
-
11m 10s
-
7m 49s
-
2m 51s
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.