gerhard brueckl_microsoft power bi
Post on 07-Jul-2018
222 Views
Preview:
TRANSCRIPT
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
1/29
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
2/29
Microsoft Power BI 101
By Gerhard Brückl
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
3/29
Gerhard Brückl
working with MS BI since 2006
focused on Analytics and Reporting
Blog: gbrueckl.wordpress.com
eMail: gerhard@gbrueckl.at
About me
http://gbrueckl.wordpress.com/http://gbrueckl.wordpress.com/
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
4/29
What is Power BI?
Power BI tools & features
• Self Service BI
• Collaboration
• Administration
Agenda
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
5/29
What is Power BI?
ACollaborateCreate
ConsumerPower User
Collection of tools &
features to support
Self-Service BI
Specific to user groups
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
6/29
BI – Architecture
Power
View
Power
Pivot
Gate
On
Power
Query
Power
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
7/29
• Power Query• Power Pivot
• Power View
• Power Map
Self-Service BI Tools
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
8/29
Self-Service BI Tools
PQPower Query PPPower Pivot PVPower View
• Find/Explore
• Extract• Transform
• Load
• Model
• Combine• Calculate
• Store
• Explor
• Interac• Analyz
• Visual
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
9/29
• SharePoint Online• Power BI sites
• Power BI Q&A
• Mobile App• Shared Queries (Administration)
Collaboration Features
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
10/29
Collaboration Features
Power BI
Site
Q&A
• BI Portal
• View/Share
• Natural lang
within BI Co
Mobile
App
• View BI Con
on mobile de
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
11/29
• Data Management and Stewardship – Single point of maintenance
• Integrated Monitoring
– Reusable in Power BI tools
• Web interface
Administrative Features
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
12/29
Self-Service – Power Query
• ETL tool for Power BI
• Supports Excel 2010 / 2013 (Office 365)
• Fully integrated
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
13/29
Self-Service – Power Query
Many
more
CSV
• Wide variety of sources
• Credential Management
Extract
Transform
Share
Load
M
• Easy to use
• Excel-like
• Powerful Scriptlanguage “M”
••
•
•
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
14/29
Self-Service – Power Query
DEMO
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
15/29
• xVelocity – in-memory column store – High performance / compression
• Flexible combination and modeling of any
• DAX – Data Analysis Expression
Self-Service – Power Pivot
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
16/29
Self-Service – Power Pivot
Many
more
External
Sources
CSV
Data Model
Ƒ(x)
DAX
Internal
Source
PQ
Many
more
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
17/29
Self-Service – Power Pivot
DEMO
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
18/29
Self-Service – Reporting
• Ad-Hoc reporting tool
– Data exploration
– Visualization
– Interactive Dashboards
• Web & Client
– Mobile support / HTML 5
• Tabular models only
– Power Pivot
– BISM
• Advancedanalysis
• 2D / 3
• Intera
• Client only
• Any sourc• Exce
• Powe
PMPower View
PVPower View
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
19/29
Self-Service –Power Pivot & Power Map
DEMO
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
20/29
• App for SharePoint• BI Portal
– Aggregates BI content
– View & Share BI content
• Hosts Q&A
Collaboration – Power BI sites
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
21/29
• Native language Query
• Answer displayed as report
• Searches all BI content
Collaboration – Q&A
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
22/29
Demo
Collaboration
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
23/29
• Download via Windows Store
• No dedicated App for other platforms yet
– Viewable via browser (HTML5)
Collaboration – Mobile App
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
24/29
Demo
Collaboration
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
25/29
• Gateways – Integrate On-Premises data
• Data Sources
– Expose Metadata
• Shared Queries
• Security and role management
Administration – Data managemen
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
26/29
Administration – Data via Gateway
Po
QuGateway
GW1
GW1 DS12
Setup gatewaySetup data source
3
QueryQue
Gatewa
42
1
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
27/29
Collaboration – Shared Query
Po
Qu
12
CreateSearch for Shared
Queries
1
Execut
& Share Query
3
2
3
3
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
28/29
Demo
Administration
-
8/18/2019 Gerhard Brueckl_Microsoft Power BI
29/29
THANK YOU!• For attending this session and
PASS SQLRally Nordic 2013, Stockholm
top related