HemSök efter kurserPower BI Basics

Power BI Basics

star_fullstar_fullstar_fullstar_fullstar_emptystar_empty

This basic Power BI training is intended for end users who have access to complete data models and are ready to visualize data from these models. The course is designed for beginners and no previous experience is required. You learn step by step how to use your data to build reports in Power BI Desktop and publish them in the cloud service where you can create and share your custom dashboards.

Courseware

Digital Material


Utbildningsformer
Remote

Längd
2 dagar

Pris
21450 kr

Target Audience

IT users who want to turn raw data into knowledge

Prerequisites

Basic Excel knowledge and Basic understanding of data analysis is a plus but no requirement

Content of Power BI Basics

Modules

  • Introducing the Power BI Platform
  • Getting Data with Power BI Desktop
  • Applying basic transformations
  • Beginning Data Modelling and DAX
  • Introducing the Power BI Service
  • Understanding Visualizations and Visual Interactions
  • Filtering, Slicing and Dicing
  • Geo Location (Map) Visualizations
  • Using custom visuals

Outline Power BI Basics (2 days Level 1)

Day 1

Introducing the Power BI Platform

  • What is Power BI?
  • Power BI Desktop, The First Experience
  • Exploring Power BI Website
  • Introduction to Power Components

    Getting Data and apply some basic transformations
  • The Role of Power Query in a Power BI Solution
  • Introduction to Data Mash-Up Engine of Power BI
  • Τhe Query Editor Transformation GUIData Modelling Basics
  • Power BI xVelocity engine basics and concepts
  • Relationships in Power BI
  • Hierarchies and Formatting
  • Sorting by other columns
  • Date Table
  • Calculated Columns, Measures, and Calculated Tables

Data Visualization

  • Power BI Desktop Visualization
  • Formatting Visuals in Power BI Desktop
  • Basic Charts and Visuals in Power BI
  • Sorting, Filtering, and categorization
  • Maps and Geo-Spatial Visualization

Power BI Service

  • Basic Sharing and using workspaces in Power BI web site
  • Dashboard vs. Report
  • Power Q&A
  • Mobile Dashboard Design
  • Schedule Refresh vs. Other types of connections
  • Gateway’s Role in the Service

Day 2

Understanding Visualizations

  • Importance of Visualization
  • Basic Charts; Bar and Column Charts
  • Clustered vs. Stacked Charts
  • Q&A for Reports
  • Quick Measures in Power BI
  • Drill Down and Up using visuals and hierarchies
  • Table and Matrix
  • Conditional formatting
  • Multi Pages reports


Slicing and Dicing

  • Filters
  • Scopes of Filters: Visual Level, Page Level, Report Level
  • Modes of Filtering: Basic, Advanced, Relative, Top N
  • Drill through Page Filter
  • Creating master-details page scenario in Power BI
  • Slicers
  • Types of Slicers; Date, Text, Number
  • Slicer Formatting
  • Syncing Slicer between Pages


Geo Location Visualization

  • Using Bing to find spots
  • Fine Tuning Address Details
  • Using Latitude and Longitude
  • Filled Map Regions and Polygons
  • Filled Map Data Category importance
  • Custom map visual with Shape Maps
  • The Hero of all maps, ArcGIS Map;

Custom Visuals

  • Adding and using a custom visual
  • Infographic Designer
  • Tachometer Gauge
  • Map custom visuals
  • Hierarchy Slicer
  • R Custom Visuals

 

Schedule

Inregistrering: 08.30
Kursstart: 09.00
Kursslut (ca): 17.00