power bi john p white chief technical officer unlimitedviz inc jpw@unlimitedviz.com @diverdown1964...
Post on 26-Dec-2015
215 Views
Preview:
TRANSCRIPT
Power BI
John P WhiteChief Technical OfficerUnlimitedViz Inc
jpw@unlimitedviz.com@diverdown1964whitepages.unlimitedviz.com
What It IsHow It Works
Why It Matters
November 23rd, 2013
Thank you to all of our Sponsors!!
John WhiteCTO/Co-Founder of UnlimitedVizSharePoint Server MVP, SQL Server v-TS
jpw@unlimitedviz.comhttp://whitepages.unlimitedviz.com@diverdown1964
Agenda
Overview Demo
Power BI Components
Q & A
Early Guidance
End to End with Power BI
Election Results Analysis
On Premises
ExcelPower Pivot
Power View
Power Query
Power Map
Power BI Components
Data Management Gateway
Power BI for Win 8
Power BI for iOS
Power BI for ?
Cloud
Power BI sites Powe
r Q&A
OData feeds
Shared queries
Large models
Multiple browsers
Power Query
Transform data
Share queries
Discover and acquire data
Power Query demo
Temperature Data Analysis
NOAA Raw data
http://www.ncdc.noaa.gov/data-access/land-based-station-data/land-based-datasets/global-historical-climatology-network-ghcn
Power Query considerations
• Not currently refreshable (will be by GA)• Powerful new data language (“M”)• Queries can be curated and shared
Power View
Analytical reporting not prescriptive reporting
Easy to build and share
Personal data analysis
Power View considerations
• Available through SSRS and Excel (different!)
• Primarily delivered through Silverlight• HTML 5 currently in preview• Supported in the mobile client
Power Map
Animation based
Visual tool for geospatially based data analysis
Power Map demo
Hurricane Sandy
Power Map considerations
• Excel only – no browser support (yet)• Visualizations can be exported and shared
Data Management Gateway
Cloud based data refresh
OData endpoints for on-premises data
Access on premises data from the cloud
Data Management Gateway refresh
Browser
Data Management Gateway
Internal data source
Data Management Gateway demo
Configure on premises data access
Data Management Gateway issues
• No incoming firewall needed – outbound is required
• Currently only limited support• MS SQL • Oracle
• Power Query not supported (yet)• No automatic refresh (yet)
http://whitepages.unlimitedviz.com/2013/09/power-bi-working-with-the-data-management-gateway/
Power Q&A
Intelligent visualization selection
Natural language query
Power Q&A demo
Summer Olympics
Power Q&A issues
• Currently demo mode only• English only support initially
Early guidance
Power BI workbook limits
SharePoint storage
Power BI ModelMaximum workbook size
Excel Services rendering
2 Gb
10 Mb 250 Mb
260 Mb
Browser editing
30 Mb
http://whitepages.unlimitedviz.com/2013/08/power-bi-office-365-and-file-size-limits-be-careful/
Load data into the model ONLY!
Default is this Should be this
Hide unwanted artifacts
Optimize workbook for mobile• Excel items first, Power View pages second• Items ordered alphabetically• Power View pages in workbook order
• Name every item• No titles for items• Use large text• Legends at bottom• Name PV tabs and sheetshttp://office.microsoft.com/en-ca/excel/design-reports-for-the-power-bi-app-HA104097304.aspx
What about on-premises?Feature PowerPivot
for SharePoint
Power BI
Interaction with Embedded Models
Yes Yes
Power View rendering Yes (with export) Yes
Use embedded model as data source
Yes No
Auto refresh Yes Yes (limited)
Model size limit 2Gb 250 Mb
Thumbnail gallery Yes Yes
Pre-optimize workbooks No Yes
Publish OData feeds No Yes
Natural language query No Yes
Mobile client No Yes
Why does it matter
MobileExternal
Power to the People
• Sign up for the preview• http://office.microsoft.com/en-ca/excel/power-bi-FX104080667.aspx
• Blogs• http://whitepages.unlimitedviz.com• http://cwebbbi.wordpress.com
• Twitter - @diverdown1964• Forums- • http://
social.technet.microsoft.com/Forums/en-US/home?forum=powerbiforoffice365
• Power BI Showcase Samples Program• http://pbishowcase.azurewebsites.net/
Action Items
Q & A
Join us for SharePint today!
Date & Time: Nov 23rd, 2013 @6:00 pmLocation: The Observatory Pub,
Algonquin Student’s Association
Address: A-170 on Algonquin CampusParking: No need to move your car!*
Site: http://www.algonquinsa.com/ob.aspx
*Please drive responsibly! We are happy to call you a cab
Remember to fill out your evaluation forms to win some great prizes!
&
top related