power bi dashboard in hour agenda

4
Introduction Slide About Me Agenda, Always On! BI for Everyone Traditional Microsoft BI Current Microsoft BI Path What is Power BI Why -Key benefits Who – User of Power BI January 2017 Feature Update Power BI – All Component Installation, Prerequisites http://www.PowerBI.com How much Power BI cost? Connection

Upload: vishal-pawar

Post on 14-Jan-2017

46 views

Category:

Data & Analytics


1 download

TRANSCRIPT

Page 1: Power bi dashboard in hour Agenda

Introduction Slide

About Me

Agenda, Always On!

BI for Everyone

Traditional Microsoft BI

Current Microsoft BI Path

What is Power BI

Why -Key benefits

Who – User of Power BI

January 2017 Feature Update

Power BI – All Component

Installation, Prerequisites

http://www.PowerBI.com

How much Power BI cost?

Connection

Page 2: Power bi dashboard in hour Agenda

DEMO – Data Set, Metadata

The 2017 Data Professional Salary

Survey-https://www.brentozar.com/archive/2017/01/tell-us-

make-2017-data-professional-salary-survey/

DEMO – Power BI Desktop

Welcome screen

Top Menu

Landing Screen

File Menu

o Option Menu

Visualization Plane

o Charts

o Formatting Options

o Custom visuals visuals.powerbi.com

Fields Plane

o Column

o Measures, Hierarchy

Working Plane Layout

o Report

Home

View

Modeling

o Data

Home

Modeling

o Relationship

Home

Modeling

Home Tab

o Get Data

Get DEMO Data

o Recent Source

o Enter Data

o Edit Queries

o Refresh

o New Page

o New Visual

o Text Box

o Image

https://www.brentozar.com/wp-

content/uploads/2016/11/Group_By_Conference

_Logo.png

o Shape

Rotate

o Page View

o Manage

Relationship

o New Column NetSalary = Employee[Salary]-

((Employee[Salary]*23)/100)

HourlySalary =

Employee[Salary]/2087

WeekelySalary =

Employee[Salary]/52

o New Measures

o Publish>>Cover

Later

Publish

Page 3: Power bi dashboard in hour Agenda

Power BI Overview

Connectivity for all

Start discovering

Live to your on-premises

Immediate insights

Demo - Power BI Services

Dashboard

Report

Data Sent

Auto Refresh

Page 4: Power bi dashboard in hour Agenda

DEMO Dashboard

SQL Server Dashboard

Query Used

Relationship

Filter

Formatting

Sp_Brentz

Brent Know this better

Script Editing

Filter & Card Count

Twitter

Current Method

My Old Method