Power BI

























Microsoft Power BI 2016
Power bi logo black.svg
Developer(s) Microsoft
Operating system Microsoft Windows
Type
Data mining, business intelligence
Website powerbi.microsoft.com/en-us/

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.[1]




Contents






  • 1 General


  • 2 History


  • 3 Key components


  • 4 See also


  • 5 References





General


Power BI provides cloud-based BI services, known as "Power BI Services", along with a desktop based interface, called "Power BI Desktop". It offers data warehouse capabilities including data preparation, data discovery and interactive dashboards.[2]
In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform.[3] One main differentiator of the product is the ability to load custom visualizations.





History


This application was originally conceived by Thierry D'Hers and Amir Netz of the SQL Server Reporting Services Team at Microsoft.[4] It was originally designed by Ron George in the summer of 2010 and named Project Crescent.[5] Project Crescent was initially available for public download on July 11, 2011 bundled with SQL Server Codename Denali.[6] Later renamed to Power BI it was then unveiled by Microsoft in September 2013 as Power BI for Office 365.[7] The first release of Power BI was based on the Microsoft Excel–based add-ins: Power Query, Power Pivot and Power View. With time, Microsoft also added many additional features like Question and Answers, enterprise level data connectivity and security options via Power BI Gateways.[2] Power BI was first released to the general public on July 24, 2015.[8]


In February 2019, Gartner confirmed Microsoft as Leader in the "2019 Gartner Magic Quadrant for Analytics and Business Intelligence Platform" as result of the capabilities of Power BI platform [9]. This represented the 12 consecutive year of recognition of Microsoft as Leading vendor in this Magic Quadrant category [10].



Key components


Key components of the Power BI ecosystem comprises:



Power BI Desktop 

The Windows-desktop-based application for PCs and desktops, primarily for designing and publishing reports to the Service.

Power BI Service 

The SaaS (software as a service) based online service (formerly known as Power BI for Office 365, now referred to as PowerBI.com or simply Power BI).

Power BI Mobile Apps 

The Power BI Mobile apps for Android and iOS devices, as well as for Windows phones and tablets.

Power BI Gateway 

Gateways used to sync external data in and out of Power BI. In Enterprise mode, can also be used by Flows and PowerApps in Office 365.

Power BI Embedded 

Power BI REST API can be used to build dashboards and reports into the custom applications that serves Power BI users, as well as non-Power BI users.

Power BI Report Server 

An On-Premises Power BI Reporting solution for companies that won't or can't store data in the cloud-based Power BI Service.

Power BI Visuals Marketplace 

A marketplace of custom visuals and R-powered visuals.[11]



See also



  • Power Pivot

  • Microsoft Excel

  • SQL Server Reporting Services

  • PowerApps



References





  1. ^ "Bring your data to life with Microsoft Power BI". Microsoft.com. Microsoft. Retrieved 4 May 2016..mw-parser-output cite.citation{font-style:inherit}.mw-parser-output .citation q{quotes:"""""""'""'"}.mw-parser-output .citation .cs1-lock-free a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/6/65/Lock-green.svg/9px-Lock-green.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .citation .cs1-lock-limited a,.mw-parser-output .citation .cs1-lock-registration a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/d/d6/Lock-gray-alt-2.svg/9px-Lock-gray-alt-2.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .citation .cs1-lock-subscription a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/a/aa/Lock-red-alt-2.svg/9px-Lock-red-alt-2.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output .cs1-subscription,.mw-parser-output .cs1-registration{color:#555}.mw-parser-output .cs1-subscription span,.mw-parser-output .cs1-registration span{border-bottom:1px dotted;cursor:help}.mw-parser-output .cs1-ws-icon a{background:url("//upload.wikimedia.org/wikipedia/commons/thumb/4/4c/Wikisource-logo.svg/12px-Wikisource-logo.svg.png")no-repeat;background-position:right .1em center}.mw-parser-output code.cs1-code{color:inherit;background:inherit;border:inherit;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;font-size:100%}.mw-parser-output .cs1-visible-error{font-size:100%}.mw-parser-output .cs1-maint{display:none;color:#33aa33;margin-left:0.3em}.mw-parser-output .cs1-subscription,.mw-parser-output .cs1-registration,.mw-parser-output .cs1-format{font-size:95%}.mw-parser-output .cs1-kern-left,.mw-parser-output .cs1-kern-wl-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right,.mw-parser-output .cs1-kern-wl-right{padding-right:0.2em}


  2. ^ ab "Magic Quadrant for Business Intelligence and Analytics Platforms". Gartner.com. Gartner, Inc. Retrieved 4 May 2016.


  3. ^ "Embed the wow of Power BI in your applications with Microsoft Power BI Embedded!". Powerbi.microsoft.com. Microsoft. Retrieved 4 May 2016.


  4. ^ "A Glimpse at Project Crescent". Microsoft BI Blog. Microsoft. Retrieved 29 June 2017.


  5. ^ "Data Visualization Done Right: Project Crescent". Microsoft BI Blog. Microsoft. Retrieved 29 June 2017.


  6. ^ "SQL Server codename "Denali" CTP3, including Project "Crescent" is now publicly available". Microsoft BI Blog. Microsoft. Retrieved 29 June 2017.


  7. ^ "Office 365 Gets Colorful 3D Charts, Natural Language Search". PC Mag India. ZiffDavis, LLC PCMag India. Retrieved 4 May 2016.


  8. ^ "Announcing Power BI general availability coming July 24th". Microsoft Power BI Blog. Microsoft. Retrieved 4 May 2016.


  9. ^ "2019 Magic Quadrant for Analytics and Business Intelligence Platforms". Gartner.com. Gartner, Inc. Retrieved 11 February 2019.


  10. ^ "Microsoft announces the 2019 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms". microsoft.com. Microsoft, Inc. Retrieved 11 February 2019.


  11. ^ "Power BI Custom visuals on AppSource". Microsoft AppSource. Microsoft. Retrieved 25 December 2017.









-

Popular posts from this blog

Guess what letter conforming each word

Image
6 $begingroup$ This is an entry in the Fortnightly Topic Challenge #41: Short and Sweet. 1 letter only could be mean anything . With an additional letter in front , could be used as medicine component and something you definitely learn or at least heard once. Add another letter in front , you would possibly hear that many times . Add an additional letter in front , you would found an independent country . With an additional letter, in the end , you would found something related to apple . Add another letter in the end , you would found something bad . Hint: Each letter is unique . word knowledge letters chemistry share | improve this question ...
Read more

Port of Spain

Image
For ports in the country of Spain, see List of ports in Spain. City in City of Port of Spain, Trinidad and Tobago Port of Spain City City of Port of Spain Top to bottom (left to right): Skyline of Port of Spain from Gulf of Paria; National Academy for the Performing Arts, Independence Square, Eric Williams Plaza; MovieTowne, Port of Port of Spain Motto(s):  "We Gather Strength As We Go Along" Port of Spain Coordinates: 10°40′N 61°31′W  /  10.667°N 61.517°W  / 10.667; -61.517 Coordinates: 10°40′N 61°31′W  /  10.667°N 61.517°W  / 10.667; -61.517 Country   Trinidad and Tobago Jurisdiction City of Port of Spain Settled 1560 Incorporated (town) 1853 Incorporated (city) 1914 Government  • Mayor Joel Martinez  • Governing body City Corporation Area [1]  • City 12 km 2 (5 sq mi) Elevation [2] 66 m (217 ft) Population (2011) [1]  • City 37,074  • Rank 3rd  • Density 3,090/km 2 (8,000/sq mi)...
Read more

Run scheduled task as local user group (not BUILTIN)

Image
0 I am trying to run a scheduled task with User Group (not a single user). This is working fine when I in the field "when running a task, use the following user account:" insert BUILTIN User Group (for example: Administrators or Users). But when I try it with the created Local User Group (example: TestGroup) it is not working. The Users in the TestGroup are the same as in the Administrators group. What could be the problem? Are there some restrictions to the Created User Group compared to BUILTINUsers? scheduled-tasks taskscheduler windowstaskschedule share | improve this question asked Nov 15 '18 at 15:36 Far...
Read more