Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Power BI Desktop

In Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published.

This Power BI Desktop for Business Users training course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.

The Power BI Desktop for Technical Users training course will provide you with the basic knowledge and skills to import / ingest data, create a model and create visualisations using Power BI Desktop.

By attending Power BI Desktop for Business Users workshop, delegates will learn to:

  • Power BI Desktop Concepts and Main Features
  • Data Sources compatible with Power BI Desktop
  • Connecting to Data with Power BI Desktop
  • Explore Data Visualizations
  • Apply Common Query Tasks to Shape Data in Power BI Desktop
  • Create and publish Reports

For Power BI Desktop for Business Users: Anyone who is familiar with Microsoft Office applications and who needs to work with data to be able to connect, process and analyse the data to produce suitable output at all levels within an organisation.

For Power BI Desktop for Technical Users: Anyone who will be creating Power BI Desktop models.

For Power BI Desktop for Business Users

  • An understanding of basic data concepts
  • Ability to create, format chart outputs
  • Be able to create formulas using standard aggregate functions

COURSE AGENDA

Power BI Desktop for Business Users
(Duration : 3 Days)

1

Getting Started with Power BI Desktop

  • Power BI Concepts and Overview
  • 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

Querying and Shaping the Data

  • Activities using Query Editor
  • Filters
  • Clean, Trim, Format and Replace
  • Split Column or Extract Using Delimiters
  • Column from Example
  • UnPivot
  • Creating Custom Calculated Columns
  • Adding Conditional Columns
  • Introduction to DAX Expressions
  • Histograms
4

Data Visualizations

  • Overview of Data Visualizations
  • Tables and Matrix Views
  • Applying Conditional Formats
  • Charts
  • Types
  • Options
  • Interactive Slicers
  • Date Slicers – dropdowns and searches
  • Number Slicers with value ranges
  • Date Slicers with Relative filters
  • Drill Visualizations to see underlying data
  • Create Reusable Field Hierarchies
  • Record Grouping and Binning in Visualizations
  • Analytics Lines in Visualizations
  • Forecast
  • Create Measures
  • Create a KPI Visualization
  • Drill Visualizations to see underlying Data
  • See Records
  • Date Hierarchies
  • Quick Measures
  • Clustering
  • Data Categories, Geo-Data and Maps
5

Reports and Output Options

  • Report Elements and Options
  • Working with Pages
  • Visual and Filter Settings
  • Edit Interactions
  • Bookmarks
  • Report Themes
  • Buttons and Q&A
  • Export Power BI Data to CSV
  • Create a Power BI Template
Power BI Desktop for Technical Users
(Duration : 2 Days)

1

Overview

  • Connections with Power BI Service
  • Analysis Services and data warehouses
2

Accessing data

  • Connecting to a live source
  • Importing Excel and CSV data
3

Transforming Data

  • Remove unwanted columns and rows
  • Cleansing data
  • Normalise datasets
  • Merging data
  • Importing multiple Excel files (M)
4

Modelling Data

  • Managing relationships
  • Customising fields view
  • Calculations
5

Visualisation

  • Visualise tabular
  • Adding charts
  • Adding maps
  • Adding slicers
  • Drillthrough pages
  • Bookmarks, selections and buttons
  • Custom tooltips

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X