1 / 60

Implementing self-service BI

Implementing self-service BI. Reuben Pearse Wednesday 29 th October 2014. Sound analysis, inspiring ideas. Overview. Introduction Changes in the Microsoft BI Landscape The Components of Power BI The Power BI workflow Power BI demonstrations Corporate BI Costs and Licencing

felicia-baxter
Download Presentation

Implementing self-service 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. Implementing self-service BI Reuben Pearse Wednesday 29th October 2014 Sound analysis, inspiring ideas

  2. Overview • Introduction • Changes in the Microsoft BI Landscape • The Components of Power BI • The Power BI workflow • Power BI demonstrations • Corporate BI • Costs and Licencing • What’s coming up? – technologies and features to watch out for • Resources • Contact Details • Q & A • Sound analysis, inspiring ideas

  3. Introduction Sound analysis, inspiring ideas

  4. Reuben Pearse • Using SQL Server for 16 years • Software development • Full SDLC • .NET development • LAMP stack • BI and Reporting • Systems Consultant • Head of Systems Development at Ecorys • Why am I doing this talk? • Sound analysis, inspiring ideas

  5. About Ecorys • Leading public policy research organisation • Founded in 1981 • Over 150 staff across five UK offices • Extensive track record of evaluations and technical assistance and grant management for government, NGOs, charities and voluntary sector clients. • We’re are joint partners with the British Council as the UK National Agency for Erasmus+ • Active CSR policy • Sound analysis, inspiring ideas

  6. Introduction – Microsoft’s BI stack • Cutting through the hype… • Sound analysis, inspiring ideas

  7. Data Analyst jokes 'We're beginning to see some positive patterns in the emerging data.'

  8. Changes in the Microsoft Business Intelligence Landscape Sound analysis, inspiring ideas

  9. Changes in the Microsoft BI Landscape (1) • SQL Server Analysis (SSAS) • Disk based storage • Distinct steps of model development • Usually under the control of IT department Disadvantages • “Back-and-forth” approach to make the model work • Separation of duties (and people) • Sound analysis, inspiring ideas

  10. Changes in the Microsoft BI Landscape (2) • Semantic Modeling • In memory processing • Real-time model changes • Uniform platform for all data analysis • Can be used by individual users in Excel • Sharepoint deployment • New “Tabular” model Advantages • Excel users can consume massive amount of data • Excel users can create their own analytical models • Empowerment for analytical users! • Sound analysis, inspiring ideas

  11. BISM and Tabular Modeling (1) Traditional BI approach • Sound analysis, inspiring ideas

  12. BISM and Tabular Modeling (2) • Sound analysis, inspiring ideas

  13. BISM and Tabular Modeling (3) • BISM – Business Intelligence Semantic Model • Attempts to serve users who are comfortable with tabular structure and maintains professional OLAP models for corporate BI purposes • Sound analysis, inspiring ideas

  14. “It’s free, but they sell your information” • Sound analysis, inspiring ideas

  15. The Components of Power BI Sound analysis, inspiring ideas

  16. Power BI components (1) • Sound analysis, inspiring ideas

  17. Power BI components (2) • Sound analysis, inspiring ideas

  18. Power Query • Allows you to connect to a variety of different data sources (including Odata) • Define repeatable steps for data import and transformation • Enables data to be imported into Excel’s new data model • Includes the “M” functional language that can used to program data manipulation steps • Sound analysis, inspiring ideas

  19. Power Pivot • Power Pivot was originally available as an add-on for Excel 2010 as a self-contained unit consisting of both a user-interface and a new database engine that could process much larger volumes of data • In Excel 2013 this is implemented slightly differently, as now the new database engine is built directly into Excel (rather than via an add-on), but Power Pivot still exists as a user interface • Complex calculations can be written in DAX, the language of Power Pivot • Sound analysis, inspiring ideas

  20. Power View Power View has various implementations • Power View sheets in Excel 2013 • Power View reports in SharePoint server • Power View reports within Office365 (via Power BI) The Excel 2013 and SharePoint implementations require SilverLight installed on the machine used to view/create the reports Although SilverLight is recommended, you can view Power View served up via Power BI reports using a HTML5 compatible browser • Sound analysis, inspiring ideas

  21. Power View • Power View requirements • View/Interact • Excel 2013 • Office 365/Power BI via Browser (including mobile devices) • Silverlight or HTML5 • SharePoint + PowerPivot Gallery • Mobile BI (Windows 8 App) • PowerPoint 2013 (has to be published through SharePoint) • Sound analysis, inspiring ideas

  22. Power View • Power View requirements • Create/Edit • Excel 2013 • SharePoint 2010/2013 + PowerPivot Gallery • Sound analysis, inspiring ideas

  23. Power Map • Sound analysis, inspiring ideas

  24. Power Map • Power Map allows you to overlay geographic data onto 3D maps • Data overlayed on 3D maps can be explored by zooming in and “flying” across data • Not to be confused with the 2D maps available in Power View • Sound analysis, inspiring ideas

  25. Power BI Workflow Sound analysis, inspiring ideas

  26. Power BI Workflow • Sound analysis, inspiring ideas

  27. Power BI demonstrations Sound analysis, inspiring ideas

  28. Sound analysis, inspiring ideas

  29. Sound analysis, inspiring ideas

  30. Sound analysis, inspiring ideas

  31. Power Pivot/Power View – Demo 1 • Sound analysis, inspiring ideas

  32. Power Pivot/Power View – Demo 2 (Hierarchies) • Sound analysis, inspiring ideas

  33. Sharing you PowerViews • Send the XLSX file to someone who has Excel 2013 • Upload to a Power BI environment • Upload to a SharePoint 2010/2013 environment Power BI SharePoint • Sound analysis, inspiring ideas

  34. Demo 3 –How to upload a Power View • Sound analysis, inspiring ideas

  35. Sharing a link to a Power View • Use the “Share” options to invite other users to see your report • Enter email address details and send invite • Sound analysis, inspiring ideas

  36. Demo 5 – Power View in HTML5 • Sound analysis, inspiring ideas

  37. Sound analysis, inspiring ideas

  38. Corporate BI Sound analysis, inspiring ideas

  39. Lame BI Jokes • Q: What’s the angriest SQL function? • A: Crossjoin • Q: What’s a dentist’s favourite MDX function? • A: Extract • Q: How did the BI developer send his backed-up database to a colleague on the other side of London? • A: In a .cab file • Two SQL DBAs walk into a NoSQL bar ……but they had to leave because they couldn't find any tables!

  40. Power View in the Corporate environment Software requirements: • Windows Server 2012 • Microsoft SharePoint 2013 • Microsoft SQL Server 2012 (Enterprise) • Silverlight Configuration notes • Install Windows, add as domain controller role • Install MSSQL then SharePoint 2013 • Configure PowerPivot Gallery • Sound analysis, inspiring ideas

  41. Power View in the Corporate environment SQL Server Requirements • Sound analysis, inspiring ideas

  42. Demo 6 – Power Pivot Site • Sound analysis, inspiring ideas

  43. Power BI – Costs & Licensing Sound analysis, inspiring ideas

  44. Sound analysis, inspiring ideas

  45. Corporate BI costs SharePoint 2013 SharePoint 2013 Standard - £5,678 (approx.) SharePoint 2013 Enterprise CAL - £80 each SQL Server 2012 SQL Server 2012 Enterprise - 2 Core Processor License - Unlimited Clients - £9,500 + Windows Server 2012 and hosting • Sound analysis, inspiring ideas

  46. Power BI costs • Sound analysis, inspiring ideas

  47. Power BI costs • Approx £36 a user a month • To access Power BI sites you have to first have a Office 365 ProPlus solution (approx. £10 a user a month) • In addition you then need a “Power BI for Office 365 with SharePoint online (Plan2) with Yammer” (approx. £26 a user a month) • Sound analysis, inspiring ideas

  48. Microsoft BI – What’s next? Sound analysis, inspiring ideas

  49. Sound analysis, inspiring ideas

More Related