power bi dashboard in hour agenda
TRANSCRIPT
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
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
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
DEMO Dashboard
SQL Server Dashboard
Query Used
Relationship
Filter
Formatting
Sp_Brentz
Brent Know this better
Script Editing
Filter & Card Count
Current Method
My Old Method