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
Rating 4.6 of 1028 users Rating 4.6 of 1028 users (1028)
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 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

IN THIS COURSE

  • 2m 33s
  • 11m 12s
    During this video, you will learn how to install Power BI from the Microsoft Store and import data to it from an Excel file. FREE ACCESS
  • Locked
    3.  Performing Data Cleaning Operations in Power BI
    11m 15s
    In this video, you will learn how to perform operations in Power BI using the UI and the Advanced Editor to sort data, change data types, rename columns, and use uppercase text. FREE ACCESS
  • Locked
    4.  Deleting and Filtering Data in Power BI
    7m 43s
    Learn how to perform operations in Power BI to remove columns and top rows, split columns by delimiter, filter rows, and delete a query. FREE ACCESS
  • Locked
    5.  Using Basic and Advanced Data Filters in Power BI
    5m 39s
    In this video, you will learn how to create basic and advanced filters in Power BI to filter data using a condition on one or more columns. FREE ACCESS
  • Locked
    6.  Creating Bar Charts in Power BI
    9m 47s
    In this video, you will learn how to create bar charts in Power BI, sort the values visualized in them, and edit the operations Power BI performs on the visualized data. FREE ACCESS
  • Locked
    7.  Formatting Bar Charts in Power BI
    11m 41s
    During this video, you will learn how to edit the aesthetics of a bar chart, including the color, display units, orientation, height, width, and more. FREE ACCESS
  • Locked
    8.  Importing JSON Data into Power BI and Formatting It
    9m 35s
    In this video, you will learn how to import JSON data into Power BI and use Power Query to convert JSON data into tabular data. You will also learn how to change the column data types. FREE ACCESS
  • Locked
    9.  Creating and Formatting Line Charts in Power BI
    11m 10s
    In this video, you will create and edit a line chart in Power BI. You will add and configure data labels, legends, markers, gridlines, and other chart elements. FREE ACCESS
  • Locked
    10.  Working with Stacked Bar Charts in Power BI
    7m 49s
    In this video, you will learn how to use Power BI to design a stacked bar chart for data visualization, fields with large numbers of unique values, and create a basic filter using the filters pane. FREE ACCESS
  • Locked
    11.  Course Summary
    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.

YOU MIGHT ALSO LIKE

Course Working with Scorecards, Dashboards, & Paginated Reports in Power BI
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Pro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions, 2nd Edition
Course Data Loading & Visualization in Power BI: Loading Data from Databases
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Agile Foundations: Fundamentals
Rating 4.4 of 1482 users Rating 4.4 of 1482 users (1482)
Course Business Reporting: Leveraging Treemaps, Matrices, & Slicers in Power BI
Rating 4.6 of 269 users Rating 4.6 of 269 users (269)
Course Business Reporting: Visualizing & Merging Data in Power BI
Rating 4.5 of 583 users Rating 4.5 of 583 users (583)