1 / 31

Power BI

Power BI. The Road to Self-Service BI (Level 200). Nos sponsors. Jean-Pierre Riehl Membre du Board http://blog.djeepy1.net @djeepy1 . MVP SQL Server MCSE : SQL Server 2012 Data Platform MCSE : SQL Server 2012 Business Intelligence MCPD : Enterprise Application

yehudi
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. Power BI The Road to Self-Service BI (Level 200)

  2. Nos sponsors

  3. Jean-Pierre Riehl Membre du Board http://blog.djeepy1.net @djeepy1 MVPSQL Server MCSE: SQL Server 2012 Data Platform MCSE: SQL Server 2012 Business Intelligence MCPD : Enterprise Application Microsoft Certified Trainer Pure-Player Microsoft • Practice Collaboration • Practice Data & Business Intelligence • Practice Infrastructure • Practice Développement

  4. Self-Service BI «End users designing and deploying their own reports and analyses within an approved and supported architecture and tools portfolio» Gartner

  5. …approved and supported architecture and tools portfolio… Power BI

  6. Power BI : What’s in ? • Power Pivot • Power View • Power Query (formerlyData Explorer) • Power Map(formerlyGeoFlow) • Power BI Sites (on O365) • Power BI Q&A (on O365) • Power BI Mobile App • Data Management Gateway

  7. Power BI : The Big Picture External Data Power BI O365 Tenant On-Premises Data Management Gateway Q&A Power BI Admin Center Data Catalog Power Query Excel Power Pivot Power BI Site Visualize Power View Power Map Mobile App

  8. Power Query

  9. Power Query : why ? • Power BI Restit. • ? SQL Legacy Azure Façonnage Nettoyage Formatage Agrégation Règles métiers …

  10. Power Query (& Power Pivot)

  11. Power Query : Summary • SearchData • Many Sources • Many transformations • Extensible by code (language M) • Share to Power BI Data Catalog • What’s new in last version ? • Version Corporate • Search Bar • Sharing

  12. Power Pivot

  13. Power Pivot : Summary Add insight to your data model • Cross-join data • Calculatedcolumns • Measures • KPI • Hierarchies • Semantic model (metadata)

  14. Power View

  15. Power View

  16. Power View : Summary Dynamicanalysisfrom Power Pivot Data Model • Manyvizualisations (bar, pie, map, scatter, etc.) • Filters & Slicers • HTML5 preview online • Available on Mobile App

  17. Power Map

  18. Power Map

  19. Power Map : Summary 3D Geographicalvisualization & navigation Story-telling Automaticgeocoding • What’s new ? • Export a video • Less limitations on Data Model • New viz : Region

  20. Power BI Sites

  21. Power BI Sites

  22. Power BI Sites : Summary • Un site SharePoint Online classique • Une featurePower BI • Des fonctionnalités de Data Stewardship • A venir : Data Refresh

  23. Power BI Mobile App

  24. demo Power BI Mobile App

  25. Data Management Gateway

  26. Power BI Sites

  27. Data Management Gateway The linkbetween Cloud and On-Prem • 2 usages : • ODataFeeds:provideaccess for Power Query • Cloud Access : for data refreshfrom O365 • Limitations • Only a SQL Server Provider • Tables need to have a Primary Key

  28. Power BI : The Big Picture External Data Data Management Gateway Power BI O365 Tenant On-Premises Power BI Admin Center Cloud Access ODataFeeds Data Catalog Search / Share Site Site Q&A Power Query Excel Power BI Site Power Pivot Visualize Power View Power Map Publish Consume Mobile App

  29. …and after ?

  30. …and after ? • Manyconcerns to deal with : • Security • Data paths • Governance • Waiting for Q&A preview

  31. Thankyou… Any Questions ?

More Related