Microsoft Power BI Desktop:- Introduction – Intermediate

Length: 3 days

Power BI is part of a suite of Microsoft tools which allow data to be analysed and published. With Power BI Desktop, you have a reporting tool that enables you to connect to data and query data from many different sources using the Query Editor. From the datasets built with Query Editor you can then create Reports and Visualizations or dashboards using the Power BI Desktop. Reports are then published.

This course covers all of the features of Power BI Desktop to connect to data, create Visualizations, query the data and then publish reports.

Prerequisites

This course is suitable for experienced Excel and database users

Basic competency in data concepts

Ability to create, format charts

Creation of formulas using aggregate functions

Topics

1 – Getting Started with Power BI Desktop Power BI Concepts and Overview Accessing Help Power BI Screen Elements and Toolbars Introduction to Main Features Imports Visualizations Filters and Queries Reports

2 – Connecting to Data Sources with Power BI Desktop Data Sources Power BI Desktop will Connect to Data Types and Properties in Power BI Desktop Import and Enter Data Get Data and Query Editor Introducing the Query Editor Using the Query Editor to Connect to Data Combining Data Sources as a Mash Up Use Append Queries Merge Data Tables Working with Relationships in Data