Rajesh Chawla rajeshcraftingdata com https www craftingdata com

Rajesh Chawla rajesh@craftingdata. com https: //www. craftingdata. com Power BI Embedded

What is embedded BI ?

What is embedded BI? Integration of self-service BI tools into business applications. Providing analytics “in context” with the application. Typically have Strong visualizations Real time analytics Interactive reporting

Why use Embedded BI ? § Improve end user experience / More customer engagement § Additional data revenue via add-on products § Product differentiation / competitive advantage

From Gartner OEM / Embedded Vendors For your copy: http: //info. birst. com/17 Q 1_NEBI_A R_2017 -Gartner-Critical. Capabilities-BI_MQ-PPC. html https: //www. logianalytics. com/gar tner-critical-capabilities/

1. Define requirements Use case(s) TCO model How do I add BI to my application? Step by step 2. Decide buy vs. build 3. Proof of Concept Vet risks (technical / pricing) Initial demo 4. Integrate into applications Website Mobile applications 5. Operationalize Deploy to production Application maintenance Help desk / support

Microsoft offering for Embedded BI

Microsoft’s offering for embedded BI What is Microsoft offering? What data sources can it use? Is it secure? Will the service be available when I need it? How much does it cost? Demo How can I find out more?

What is Microsoft’s Offering ?

Desktop (free) Windows application only What is in Power BI ? Power BI Embedded, Service, On. Premise, Desktop Saa. S (Power BI Service) Microsoft application (web or mobile) Microsoft authentication / authorization – Active Directory & integrated with Office 365 Dedicated capacity available (Premium) On-premise (Power BI Report Server) Different from MS SQL Reporting Services Server (SSRS) Licensed as either: Power BI Premium or SQL Server Enterprise In your application (Power BI Embedded) Your application – white labeled Your authentication / authorization Microsoft hosts service

What is Microsoft data offering ? Information Management Data Sources Apps Big Data Stores Machine Learning and Analytics Intelligence People Data Factory Data Lake Store Machine Learning Cognitive Services Data Catalog SQL Data Warehouse Data Lake Analytics Bot Framework HDInsight (Hadoop and Spark) Event Hubs Sensors and devices Stream Analytics Web Mobile Cortana Apps Bots Dashboards & Visualizations Automated Systems Power BI Data Intelligence Action

What does Power BI embedded look like ?

Application Building Blocks

Data Sources for Power BI Embedded

What data sources can it use?

What data sources can it use?

What data sources can it use?

What data sources can it use?

What data sources can it use?

Is it secure ?

Is Power BI secure? Yes § All data at rest or in transit is encrypted. § Authentication and authorization using Azure Active Directory. § Row level security – Depending on data source § Governed by §Microsoft Online Services Terms §Microsoft Enterprise Privacy Statement. § Compliance: Office 365 Compliance Framework Full details : Power BI Security Whitepaper

At least 99. 9% availability of Power BI Embedded for users to execute API calls and embed reports. Details at: SLA from Microsoft Will the service be available when I need it? SLA – Service Level Agreement What does 99. 9 % SLA mean (Details at: Wikipedia) Uptime Minutes down / month day 99. 99% 4. 38 8. 64 seconds 99. 9 % 43. 8 1. 44 99. 8 % 86. 23 2. 88 99 % 7. 2 hours 14. 4

How much does Power BI Embedded cost ?

How to purchase Power BI Embedded ?

Example 1 The ISV knows that the Saa. S App with Power BI Embedded handles 100 users in the peak hour. It is assumed that these users will trigger a total of 250 page renders for that hour because each user will load a report and interact with it 2. 5 times during the peak hour. Per the table, the ISV should choose Power BI Embedded A 1. Total: 750 / month (embedded) + (2 * 9. 95 / month (2 Power BI Pro)) How much does it cost? Example 2 The ISV reading its telemetry data knows the App usage patterns of the application with Power BI Embedded reports. The ISV assumes there is potential for 100, 000 monthly page renders. A month consists of 220 hours of work which is spread across 22 days with 10 hours of work in a day. By dividing the expected page renders in a month by the hours in a month, we show that an average hour handles 455 page renders. From telemetry data, the ISV knows the ratio between peak and average use is 4: 1. Using this ratio they calculate page renders at the busiest hour in the month as 1820, for which the ISV should choose Power BI Embedded A 4. Total: 5, 994 / month (embedded) + (2 * 9. 95 / month (2 Power BI Pro))

Details for “A” SKU’s th th th

Java. Script Example Java. Script Demo Report Visual Q&A Dashboard Tiles

Embed – Start Page

Embed Report – Part 1

Embed Report – Part 2

Question and Answers

How can I learn more?

Videos (Power BI Embedded) You. Tube – Playlist from Microsoft You. Tube -- Guy in a Cube Embed & Interact with Power BI Reports Embedded Updates How to find out more? REST Api’s Power BI Embedded REST Operations White Papers: Capacity Whitepaper Best Practices for designing reports in Power BI Security Whitepaper Base Page for all Power BI white papers.

• Embed Power BI into your app Step by Step https: //docs. microsoft. com/en-us/powerbi/developer/embed-sample-for-customers • Code Samples for App Owns Data is Embedded https: //github. com/Microsoft/Power. BI-Developer-Samples How can I find out more? • Working Demo for Embedded: • Live Demo: https: //microsoft. github. io/Power. BIJava. Script/demo/v 2 -demo/index. html • Code: https: //github. com/Microsoft/Power. BIJava. Script • Wiki: https: //github. com/Microsoft/Power. BIJava. Script/wiki • Getting Help – Communities: • https: //community. powerbi. com/t 5/Developer/bdp/Developer • https: //stackoverflow. com/questions/tagged/powerbi

Thank You Sponsors Platinum Gold Silver Bronze Swag Venue