Power BI is Awesome Steve Wake BI Developer

Power BI is Awesome! Steve Wake BI Developer, Chipotle Mexican Grill President, Denver SQL Server User Group

Please Support Our Sponsors SQL Saturday is made possible with the generous support of these sponsors. You can support them by opting-in and visiting them in the sponsor area.

What is Power BI v 2? § New Microsoft Business Intelligence product line § Aimed at business power users and end-users § Rich interactive reports, dashboards, charts, graphs, and maps § Minimize clicks to complete tasks § Open source/custom visualizations (D 3, HTML 5, and CSS 3) § Remove Office 365 & Share. Point Online Requirements (Power BI v 1)

History of Power BI § Power. Pivot – Excel add-in using x. Velocity (Vertipaq) columnar engine § SQL Server 2012 SSAS Tabular Model § Microsoft BI Semantic Model (BISM) § Power. View § Re-branding to Power BI (notice the space) § Share. Point and Office 365 integration (Q&A, Power Query, and Power Map) § Power BI v 2 Preview (December 2014) § Power BI v 2 Service & Desktop GA (July 2015)

What is Power BI Desktop? According to Microsoft: Power BI Desktop puts visual analytics at your fingertips with intuitive report authoring. Drag-and-drop to place content exactly where you want it on the flexible and fluid canvas. Quickly discover patterns as you explore a single unified view of linked, interactive visualizations. Source: https: //powerbi. microsoft. com/en-us/desktop

What is Power BI Desktop? § Standalone design/development/rendering app with deployment to Power BI Service § Currently integrates: • Power Query • Power Pivot • Power View * Not all features of each yet, but updates each month, closing the gap § New Power BI Desktop file extension. pbix

What is Power BI v 2? § Power. BI. com & Power BI Desktop § Access on-prem sources: SQL Oracle Teradata My. SQL Postgre. SQL Sybase Analytics Platform Service (APS, includes PDW) IBM DB 2 HDFS And more! § Online data sources – Azure § Built-in connectors for Saa. S: Salesforce Zendesk Google Analytics Git. Hub SAP And more!

Demo § Power BI Desktop § Power. BI. com

Pricing Source: https: //powerbi. microsoft. com/en-us/pricing

Future § Cross Platform Support (i. OS & Android) § Cross Browser Support (Edge, Chrome, Firefox, etc. ) § Active Directory Security Integration § Separation from v 1 tools in Excel 2016 § Pyramid Analytics Integration (onsite solution) q SQL Server 2016? q Integrate Power Map? q More Saa. S connectors? (at least 1 per week so far) q Integration with Share. Point?

Questions? § Action List ü ü Go to http: //powerbi. com Register for an account using your work email address Download Power BI Desktop Create amazing insights using your data! § Contact Details • • § § swake@chipotle. com @stevewake on Twitter Linked. In, Google+ Blog http: //wakebi. com

Thank You This FREE SQL Saturday is brought to you courtesy of these sponsors, speakers and volunteers who staff this event