1 / 31

Power BI

November 23 rd , 2013. What It Is How It Works Why It Matters. Power BI. John P White Chief Technical Officer UnlimitedViz Inc jpw@unlimitedviz.com @ diverdown1964 whitepages.unlimitedviz.com. Thank you to all of our Sponsors!!. John White CTO/Co-Founder of UnlimitedViz

adena-booker
Download Presentation

Power BI

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. November 23rd, 2013 What It Is How It Works Why It Matters Power BI John P White Chief Technical Officer UnlimitedViz Inc jpw@unlimitedviz.com @diverdown1964 whitepages.unlimitedviz.com

  2. Thank you to all of our Sponsors!!

  3. John White CTO/Co-Founder of UnlimitedViz SharePoint Server MVP, SQL Server v-TS jpw@unlimitedviz.com http://whitepages.unlimitedviz.com @diverdown1964

  4. Agenda Overview Demo Power BI Components Early Guidance Q & A

  5. Election Results Analysis End to End with Power BI

  6. Power BI Components On Premises Cloud Excel Power BI sites Shared queries Large models Power BI for Win 8 Power BI for iOS Power BI for ? Multiple browsers Power Q&A Data Management Gateway Power Pivot OData feeds Power View Power Query Power Map

  7. Power Query Discover and acquire data Transform data Share queries

  8. 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 demo

  9. Power Query considerations Not currently refreshable (will be by GA) Powerful new data language (“M”) Queries can be curated and shared

  10. Power View Personal data analysis Analytical reporting not prescriptive reporting Easy to build and share

  11. Power View considerations Available through SSRS and Excel (different!) Primarily delivered through Silverlight HTML 5 currently in preview Supported in the mobile client

  12. Power Map Visual tool for geospatially based data analysis Animation based

  13. Hurricane Sandy Power Map demo

  14. Power Map considerations Excel only – no browser support (yet) Visualizations can be exported and shared

  15. Data Management Gateway Access on premises data from the cloud Cloud based data refresh OData endpoints for on-premises data

  16. Data Management Gateway refresh Browser Data Management Gateway Internal data source

  17. Configure on premises data access Data Management Gateway demo

  18. 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/

  19. Power Q&A Natural language query Intelligent visualization selection

  20. Summer Olympics Power Q&A demo

  21. Power Q&A issues Currently demo mode only English only support initially

  22. Early guidance

  23. Power BI workbook limits SharePoint storage Browser editing 2 Gb 30 Mb Excel Services rendering Power BI Model Maximum workbook size 10 Mb 250 Mb 260 Mb http://whitepages.unlimitedviz.com/2013/08/power-bi-office-365-and-file-size-limits-be-careful/

  24. Load data into the model ONLY! Default is this Should be this

  25. Hide unwanted artifacts

  26. 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 sheets http://office.microsoft.com/en-ca/excel/design-reports-for-the-power-bi-app-HA104097304.aspx

  27. What about on-premises?

  28. Why does it matter Mobile External Power to the People

  29. Action Items • 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/

  30. Q & A

  31. Join us for SharePint today! Remember to fill out your evaluation forms to win some great prizes! & Date & Time: Nov 23rd, 2013 @6:00 pm Location: The Observatory Pub, Algonquin Student’s Association Address: A-170 on Algonquin Campus Parking: No need to move your car!* Site: http://www.algonquinsa.com/ob.aspx *Please drive responsibly! We are happy to call you a cab 

More Related