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

3 – Data Visualizations
   Overview of Data Visualizations
   Creating and Working with Tables and Matrix Views
   Applying Conditional Formats to Visualizations
   Charts
   Types
   Options

4 – Slicers
   Interactive Slicers
   Date Slicers – Dropdowns and Searches
   Number Slicers with Value Ranges
   Date Slicers with Relative Filters
   Create Reusable Field Hierarchies
   Record Grouping and Binning in Visualizations
   Analytics Lines in Visualizations
   Insight – Explain Increase/Decrease
   Forecast
   Create Measures
   Create a KPI Visualization

5 – Drill-down

    Drill Visualizations to see underlying Data
   See Records
   Date Hierarchies
   Page Drillthrough Filters
   Show Values As and Quick Measures
   Clustering
   Creating Role Based Views
   Data Categories, Geo-Data and Maps

6 – Querying and Shaping the Data
   Common Activities using Query Editor
   Filters
   Using Delimiters
   Transforms
   Pivot and Group By
   Creating Custom Calculated Columns
   Adding Conditional Columns
   Columns From Examples
   Introduction to DAX Expressions
   Histograms

7 – Reports and Output Options
   Report Elements and Options
   Working with Pages
   Keyboard Shortcuts and Navigation
   Selection Pane
   Lock Objects
   Adding Graphics
   Report Level Filters
   Bookmarks
   Spotlight
   Report Themes
   Export Power BI Data to CSV
   Create a Power BI Template