1 / 24

Power BI Just play with your data

Power BI Just play with your data. 27 january 2014. @georgeault. Nicolas Georgeault – SharePoint Architect. Nicolas Georgeault. SharePoint Architect with Public Consulting Group Microsoft Most Valuable Professional – SharePoint Server

chung
Download Presentation

Power BI Just play with your data

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 BIJust playwithyour data 27 january2014 @georgeault Nicolas Georgeault – SharePoint Architect

  2. Nicolas Georgeault • SharePoint Architect with Public Consulting Group • Microsoft Most Valuable Professional – SharePoint Server • Microsoft Certified Solution Expert – SharePoint Server 2013 • Microsoft Solutions Associate – Windows Server 2012 • Twitter: @NGeorgeault • Email: ngeorgeault@club-sharepoint.fr • Blog: http://blog.georgeault.co • Yammer: ngeorgeault@club-sharepoint.fr

  3. SharePoint Saturday Montréal 2014 February 8th, 2014 Montréal, QC http://www.sharepointquebec.org/sps2014 http://spsevents.org/worldwide/Montreal

  4. SharePoint Saturday Montréal 2014 • All Free!! • 4 full tracks • Great speakers • High valuedpartners • Schwartz Smokedmeat for diner

  5. Microsoft Business Intelligence SharePoint Collaboration Excel Workbooks Power Pivot Applications SharePoint Dashboards & Scorecards Analysis Services Reporting Services Data Quality Services Integration Services Master Data Services OData Feeds Line of Business Applications Hadoop Big Data

  6. Self-Service Business Intelligence • What Do Users want to Do?

  7. Self-Service BI in Excel 2013 • Excel 2013: Complete and Powerful Self-Service BI Tool Report creator Data Analyst Report consumer

  8. Self-Service BI in Excel 2013 • Excel delivers powerful, intuitive capabilities for self-service BI With great power comes great Responsibility (That’s A Lot of Power!)

  9. FEATURES OF POWER BI • In-built Data Model • Ability to create / detect relationships • Share datasets securely • Manage data connections • Data in the reports is refreshable • New Timeline control

  10. COMPONENTS OF POWER BI POWER QUERY • Formerly known as “Data Explorer” • Import and combine data from multiple/ external datasets, mash it with internal data, etc. • Aggregate, drill down, … • Merge, expand, append and refresh • Isolation of data sources • Downloaditfromhttp://j.mp/1aCCdik (Preview)

  11. POWER QUERY

  12. COMPONENTS OF POWER BI POWER VIEW • Relational & cross-filtered visualizations and reports • Interactive dashboards like widgets • Consumes data model • Can also be hooked up to external data models • Already part of Excel 2013… Just activateit ;)

  13. POWER VIEW

  14. COMPONENTS OF POWER BI POWER PIVOT • Builds pivot table/charts from billions of records • Independent pivot charts • Create dashboards by linking table and charts • Separate calculation area for KPIs and calculated fields • Create KPIs based on calculated fields • Alreadypart of Excel 2013… Just activateit;)

  15. POWER PIVOT

  16. COMPONENTS OF POWER BI POWER MAP • Formerly known as “Geo-Flow” • View data geographically in 3D interactive map • Best suited for demographic data. • Can drill down up to Longitude and Latitude • Downloaditfromhttp://j.mp/L2vVvQ (Preview)

  17. POWER MAP

  18. Play withyour data Demo

  19. Shareyour data and reports Demo

  20. Architecture • xVelocity Engine ( next generation of Vertipaq) • In memory analytics • Columnar storage • Compression technology

  21. LIMITATIONS OF POWER BI • Limited backward compatibility for Excel 2010 • 250 megabytes (MB) per file upload in Excel Web App in Office 365 • Office 365 Student edition does not have these powerful features

  22. Remarques • Can I use Power BI in production? NOT YET, the productisstill in public beta • Can I use itwith SharePoint On Premises? At this moment… NO. You can use Excel 2013 and store files in your SharePoint but Power BI worksonly on Office 365. • Can I use Power Viewon myfavouritetablet? IPAD? Android? YES, an HTML5 version of datavisualizations have already been developped and dedicatedappswillbedelivered on sometablet.

  23. Power BI Public Beta • www.powerbi.com • Complete demo • Q&A available • W8 & RT Apps

  24. Follow us… • Web – www.sharepointquebec.org • Twitter - @guspquebec • Facebook - j.mp/16EFeNd

More Related