SkillSoft Explore Course – Lambers, Inc.

IT Skills Data and Databases Data Visualization Business Reporting Using Power BI

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.

Asset ID	it_dabrbidj_01_enus
Course Type	Video Course
Course Category	Data and Databases

Objectives
Business Reporting: Getting Started with Power BI Desktop for Data Analysis discover the key concepts covered in this course install Power BI from Microsoft Store and import data to it from an Excel file perform operations in Power BI using the UI and the Advanced Editor to sort data, change data types, rename columns, and use uppercase text perform operations in Power BI to remove columns and top rows, split columns by delimiter, filter rows, and delete a query create basic and advanced filters in Power BI to filter data using a condition on one or more columns create 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 more import JSON data into Power BI and use Power Query to convert JSON data into tabular data and change the column data types create and edit a line chart in Power BI by adding and configuring data labels, legends, markers, gridlines, and other chart elements use 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 pane summarize the key concepts covered in this course

Objectives

Business Reporting: Getting Started with Power BI Desktop for Data Analysis

discover the key concepts covered in this course
install Power BI from Microsoft Store and import data to it from an Excel file
perform operations in Power BI using the UI and the Advanced Editor to sort data, change data types, rename columns, and use uppercase text
perform operations in Power BI to remove columns and top rows, split columns by delimiter, filter rows, and delete a query
create basic and advanced filters in Power BI to filter data using a condition on one or more columns
create 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 more
import JSON data into Power BI and use Power Query to convert JSON data into tabular data and change the column data types
create and edit a line chart in Power BI by adding and configuring data labels, legends, markers, gridlines, and other chart elements
use 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 pane
summarize the key concepts covered in this course