Power BI enables business users to interact with their data in their own “natural language.” The natural language query capability allows users to ask questions of their corporate data and get instant visual results. The program’s Q&A feature interprets the semantics of the question the user is asking and serves up the correct interactive chart or graph.
Since the process becomes as easy as going to a colleague to ask a question, it dramatically increases how business users can get more value from their existing business intelligence (BI) solutions.
How can your firm achieve this advantage? It’s as simple as leveraging some tools, such as Office 365 and its Excel component, that are already at your employees’ disposal! The accessibility of these powerful resources allows us to lower the barrier to entry for businesses that want to leverage their data more effectively.
• Excel is the most commonly used analytical tool for business users — it truly is accessible to almost anyone. Power BI dramatically simplifies and reduces the time it takes for IT to set up and manage the complex infrastructure needed for an enterprise-wide BI platform. In addition, Power BI enables businesses to strike a balance between the needs of business users who are working in Excel and an IT department’s requirements for agility, monitoring, and governance.
• Today, Excel delivers end-to-end self-service BI functionality through capabilities such as Power Query, Power Pivot, Power View, and Power Map.
Management of team data queries
With Power BI, people can share not only workbooks but also the queries they create using Power Query in Excel. This allows members of the team to build and manage data queries for others to use when creating their own reports.
Once published to Power BI, users can define who they want to share their data queries with and track who’s accessing which queries. Data queries are registered with the Data Catalog so that they can be easily discovered through a data search in Excel. If a user tries to access a query but does not have access to the underlying data source, a workflow will allow the user to request access from the database administrator responsible for the data.