In this post, we are going to post about Power BI Service Desktop & Embedded Interview Questions and Answers. As per Gartner’s magic quadrant report, Microsoft is one of the few leaders in the Data Analytics space. Microsoft is one of the few companies which offers a complete end-to-end Data analytics stack. With strong product offerings, both on-premises and in the cloud makes it an obvious choice for Enterprises looking to tap into the Data Analytics space. PowerBI is one such offering from the Microsoft Cloud BI stack which rapidly evolved from a simple Self-Service data analysis tool to a full Enterprise BI offering. Started as an add-on for Office 365, Microsoft carved it out to make it a standalone tool. Started off in 2015, its development happened at a rapid pace and is now a skill in demand for a lot of BI Professionals. Now, that PowerBI is a matured product, we compiled a list of interview questions. Read along to know more.
Answer: SSAS is Microsoft’s OLAP implementation. There are two types of cube currently available.
These Cubes help the application to service OLAP queries. OLAP applications like Excel 2013/2016 or PowerBI desktop can query OLAP Cubes as a data source. Both PowerBI.com cloud service & PowerBI desktop can connect to Multi-Dimensional and Tabular Cubes for the end user reporting and dashboards. Users would be able to connect to on-premises SSAS OLAP cubes and also refresh incremental data changes using the On-Premises Data Gateway. The Gateway provides a secure connection from customer premises to the cloud over SSL/Https without the need to configure a VPN.
Answer: Even though Microsoft does not officially call PowerBI a suite of product (like System Center), it did evolve a lot, post its release in 2015. For now, we have the following components as a part of the PowerBI suite. They are as follows:
Answer: The PowerBI Desktop is a companion Data Modelling tool for PowerBI.com cloud service. Both use a familiar user interface, so users are not confused between the two environments. Both PowerBI desktop and Excel can help users to create robust data models. However, the UI of Excel is very different than PowerBI.com and might confuse new users. Moreover, Excel is a paid software, and PowerBI desktop is a free redistributable package.
PowerBI.com, on the other hand, is the Cloud Service where users will eventually publish their PowerBI Desktop & Excel DataModels & Reports and share it with others within the organization. Here is a side by side comparison with screenshots:
Answer: Data Models comprises of various fundamental entities, to introduce abstraction in a DBMS. With Data models, you can define how data is connected to each other (Schema) and how they are processed and stored inside the system. The very first data model could be data entity-models, where all the data used are to be kept in a common plane.
In Excel 2010/2013/2016 you can embed Data Models using PowerPivot Add-On. PowerPivot allows a user to create SSAS Tabular models using a familiar Excel user interface.
Answer: Users can consume PowerBI reports using the following methods:
Answer: PowerBI embedded is an Azure-based cloud Service which enabled Web developers to create and integrate PowerBI reports. Users/Developers can create their reports using PowerBI desktop, without the need to write any code. Then, the PowerBI desktop report can be published to a PowerBI embedded workspace and consumed by end users. Here is a sample screenshot:
Answer: PowerBI embedded helps web developers to create and integrate Powerful PowerBI reports. If the customer is not interested in going to PowerBI.com to consume reports, this is a good alternative. The second use-case is the use of custom authentication for these web apps as opposed to what is currently being offered on PowerBI.com.
Answer: Using Data Management Gateway, IT Admins and users can setup data refresh for incremental data updates. The Gateway uses a secure https/SSL encrypted connection to talk to a PowerBI tenant directly. Currently, there are two types of gateways, Personal and Enterprise. The personal gateway is ideally suited for developers to refresh their reports from their laptops/desktops. Enterprise gateway, on the other hand, is designed with IT team in mind. The IT team will manage all data sources and access management, while developers and end-users will create and consume reports.Currently, PowerBI users can set up a maximum of 8 daily refresh cycles using the Gateway.
Answer: PowerBI currently supports different types of streaming datasets. You can directly stream data using a push URL to PowerBI.com service. PowerBI also supports streaming data sources from PubNub, which is an Infrastructure as a Service provider. The third option is to Azure Stream Analytics which is built on top of Azure Service Bus and Event Hub. You can select the streaming data to go-to PowerBI as your destination. Here is a sample report with streaming data.
You can find more information on PowerBI Service, PowerBI Desktop and PowerBI Embedded from the official Microsoft website. Here are the official links below:
We hope that you liked our list of Power BI Service Desktop & Embedded Interview Questions and Answers. If you have any questions or feedback, please feel free to use the comment section below.
Comments are closed.