power bi n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Power BI PowerPoint Presentation
Download Presentation
Power BI

Loading in 2 Seconds...

play fullscreen
1 / 31

Power BI - PowerPoint PPT Presentation


  • 230 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - 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 ?