T1412BI

Ladda ner som PDF

Power BI Basics

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.

Audience

IT users who want to turn raw data into knowledge

Prior knowledge

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

Courseware

Digital Material

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 GUI


Data 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 Läs mer

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 GUI


Data 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

 

 "En Great course and instructor! Gives a brief overview of what Business Intelligence is as a concept, introduces Power BI Desktop and Power BI Services, how they can be integrated in a BI solution and show the differences between Power BI and other BI front-ends such as Excel. Great course for Power BI beginners and for people new in the BI field!"
/ en nöjd deltagare 9/3-2017 Citat från tidigare deltagare

Kursfakta

Kurs-ID: T1412BI
Längd: 2 dagar
Pris exkl moms: 14 900 kr
Inregistrering: 09.00
Kursstart: 09.30
Kursslut (ca): 17.00

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD

Ort och datum

Stockholm
14 nov-15 nov
Boka nu!
27 nov-28 nov
Boka nu!
Göteborg
14 nov-15 nov
GO! R
Boka nu!
27 nov-28 nov
R
Boka nu!
Cloud Access
i Läs mer

Delta på kursen från ditt hem, jobb eller annan plats.

14 nov-15 nov
Boka nu!
27 nov-28 nov
Boka nu!

Tipsa