Ugly numbers to pretty pictures

Management loves it, I love developing with it but getting certain others to adopt it can be a bit of a challenge.

Pros

As the title says, it turns ugly numbers into pretty pictures. It is easy enough for a non-developer to use and turn a mess of data into an intelligent and understandable story.

Cons

It literally changes every three months. You just get used to it and with the next update a lot has changed. I don't really see this as a con though because this is more like a Christmas present waiting to see what they will have made better this go around.

Moderate cost for a moderate experience for medium sized enterprises

So so. The dashboards and reports are limited in visual design, so they all look the same and quite ugly. Because of the difficulty sharing reports/dashboards to external individuals and the lack of a Google sheets connector I couldn't use PowerBI for most of the solutions we need, but will use it for some since it integrates well with the rest of the MS office ecosystem.

Pros

The thing that most sets PowerBI apart from comparable business intelligence solutions is the lower cost of multi-user deployment within an organization. PowerBI is part of a Microsoft Office 365 subscription package for businesses and you only need to pay an additional 15USD/month for each additional admin/analyst account you add. This is a stark contrast to similar solutions like Tableau, which charge a monthly fee for each user and has a minimum user count that equates to roughly a 15,000USD/year license cost as minimum. If your organisation is already invested in the Microsoft Office ecosystem this could be the ideal solution for you if you need to keep costs down.

Cons

It can't connect to google sheets and every other business intelligence platform can. This can be really limiting if your business uses a variety of SaaS solutions since many offer the simplest data integration options via Google sheets. PowerBI also has real issues with external sharing of dashboards/reports. You only have the option of publishing internally (visible to your organization's users) or publishing publically (indexed in search engines). There is no option of sharing dashboards and reports to individuals outside your organization via a login, like what is done with Google Data Studio. PowerBI also has a steep learning curve and uses 3 coding languages (DAX, M, and SQL). It's more complicated than it needs to be but it's relational database modeling has proven a good one and competitors have copied PowerBI's approach in recent years (Tableau).

A pretty reporting tool for some (!) Microsoft Products, but pretty much useless outside of the Microsoft Landscape

In light of the hype around this "Tableau destroyer" in recent months, I want to highlight some fundamental flaws in data connectivity and reports maintenance of Power BI, which the Product Team so far has turned down as "not in scope". In practice, though, this renders Power BI pretty useless for getting dara from any 3rd party products, in the cloud in particular. This review reflects Power BI as of mid March 2017. I have gathered my knowledge from testing, community interaction and a dozen tickets with Power BI Pro Support. The focus lies on getting data via Web Services, much aligned with Microsoft’s «Cloud First» Strategy. 1) Power BI Online is in the cloud, but does not allow for HTTP calls. Power BI Desktop allows for HTTP calls, but only with static authentication parameters. First of all, a distinction needs to be made between Power BI Online and Power BI Desktop. While Power BI Online is the "master" that ultimately allows you to share and publish your reports, user experience in design is diminished by HTML limitations (you may know from Word or Excel Online) and more importantly, data connectivity (Get Data) is limited to SQL Servers on Azure and about 20 to 30 plugins from 3rd party solutions at present. Take note that on Power BI Online, you cannot select or manage your Gateways, either. This brings the attention to the Power BI Desktop client. Updated every one to two months, the Desktop client brings data connectors necessary to connect to a larger number of data sources. With the Web connector, HTTP calls been configured, although with just static headers and parameters and Basic and Windows authentication only. Importantly, though, Power BI Desktop includes Microsoft Power Query, which you may know from Excel 2016 already. With M Scripts, you can script and customise in many ways and most interestingly, convert it into table form quickly. This is where Power Query shines. However, Power Query does not seem to call on methods for nonces and timestamps required in token based authentication (OAuth for example). (Should this be incorrect, please please let me know. I have been browsing the fora and nagging Support too long already.) What’s really amusing here is that Microsoft Azure uses OAuth 2.0 themselves. So, you cannot run any reporting on Microsoft’s Azure AD or Resource Manager database for example, a notorious blackbox. Back to Powershell. (Power BI does not accept Powershell feeds.) In short, while Power BI Online does not allow to get any data out of the web (except for those 20 to 30 plugins, mostly Microsoft Products), Power BI Desktop allows for Web calls, but only with static parameters and thus, basically with your user credentials. That’s a big limitation in Data Connectivity. 2) With Power BI Online being the master, the HTTP calls cannot be scheduled or refreshed in the cloud. Now that you have configured your HTTP call (with risky user credentials), you want to publish your report and have it refreshed on a scheduled basis, say every day. Tough luck. While you can publish your Report to Power BI Online and subsequently a broader audience, it’s a static image of your Desktop data. You cannot schedule a data refresh in Power BI Online (because there is no Web feature anyway) and you cannot even refresh the data manually as this requires republishing the Report anew. You risk your management looking at outdated data whenever you forgot to republish your report and sneak the new URL into your dashboards and iframes. 3) The On-Premises Data Gateway is pretty useless for Web Services. Yes, there is the On-Premises Data Gateway. Yes, you can configure Web Services in the gateway, although it’s pretty ironic to route web calls via on-premises infrastructure. But did you ever try it? That is, you cannot specify any HTTP headers fort he calls at all, lest writing a Power Query script. And thus, we are back at authentication via Basic and Windows only and writing REST scripts in the data source for every single HTTP call because with no Headers and Body, all parameters need to be coded in the URI. Will you do that? At the end of the day, Power BI is Microsoft's long overdue acknowledgement that Excel and some Dynamics Reports do not cut it for Reporting purposes. Indeed, for reporting on SQL Server, Dynamics 365 (if you want to afford it), and Excel and Access databases stored in your OneDrive, Microsoft Power BI does a neat job. However, as soon as you want to integrate with 3rd party systems or via web services in particular, Power BI presents so many limitations in authentication, Header and Body configuration, scripting, and scheduling that you need to configure an entire SQL Server environment (on Azure or On-Premises via feature poor Gateway) and write a SQL CRL interface or buy Azure Data Factory to get that data in. For some pretty reports, do you really want to buy and customise all that BI infrastructure on Azure? My advice to Microsoft: Work on Data Connectivity, especially in Power BI Online, rather than more visuals for those limited data sources. Your Microsoft clients will consider Power BI a given for the utter lack of reporting in Office 365, Azure, or Dynamics 365 (yes, pushing it there). My advice to Users: If the connectors are not listed, look somewhere else. (And make sure it’s your use case that is listed. Power BI announced an Azure AD connector, but rather than reporting on Users, Groups, or Enterprise Apps, you can only see on a nice map where the last logins happened.) Is it a Tableau destroyer? No. It’s a long overdue acknowledgement for necessary reporting with the potential of being a solid Business Intelligence solution ONCE focus comes to lie more on data.

Pros

pretty visuals Power Query On-premises Data Gateway responsible Pro Support

Cons

lack of data sources pretty useless for 3rd Party Web Sources

Analytic Superman

Power BI has been a game changer for us when it comes to how we see and break down the analytics of our business. Its a platform that integrates all parties to one sheet and allows us to break the data down visually and analytically. Only drawback is when you need to make an update it could take the builder some time to update.

Pros

I love the way Power BI is able to show the data in a very eye friendly way. If you have a business that has markets, districts, and locations that need to show data then Power Bi allows you to break this down to any analytics you need to see with graph representation. Its great!

Cons

It does take some knowledge around formulas and excel. If you don't have an analytic data team that can make these repots for you on Power BI then it will take you a longer time to see the analytics from it.

Good data reporting tool for a small group

my overall experience is good with Power BI and I would highly recommend it to a small business or a group of people. Or if you company has more than 1000, it could also be a good competitor compared to Tableau.

Pros

very powerful, easy to use and deployment. It works best with other Microsoft product, such as Teams.

Cons

It becomes costly when you want to share a report or a dashboard to a wide range of users. Because it requires the viewer to have a Pro license, it could be as expensive as Tableau.

Best Data Visualization tool

Pros

Great integration features varied options for visualization ability to centrally build reports and publish to users Regular auto upgrade of the features

Cons

large volume of data might clog running of the reports

Business intelligence needs a little help

If you can overcome a steep learning curve you’ll be presented with a sw package which allows you to not only analyze your data but drill down to it. You’ll be able to identify root cause for your actual results. The capability of “digging” through your data to get where you want going from an overall picture to a particular one has no prize. If you are analyzing you can create a report the way you want, and if you are presenting to a boss then he/she will be happy to know he/she can get to the bottom line.

Pros

It allows you to analyze all your data, no matter if you have it all across different DB you can link it all together.

Cons

Learning to use advance features is not easy. There are tutorial yes, however they are also not so easy to understand.

A powerful tool for Business intelligence

It's a Microsoft product and it has intuitive drag & drop options and menus. It has a lot feature from Excel Pivot tables, with nice visualization possibilites. There are a lot of pre-build data connectors you can use out of the box.

Pros

Data Analysis Made Easy: you can Extract, Transform and Load (ETL) Data using Power BI Desktop. It's well integrated with other Microsoft tools.

Cons

In order to share the visualizations that you have created (reports and dashboards), you have to pay for a Power Bi Pro license for every member.

The best option to start your data-driven journey

Despite the purchase journey and given the resources it deliver, I can say it's a great experience. You can definitely improve the data-driven skills of your organization with an affordable investment.

Pros

The tool is very cheap given the visualisation resources and data integration it gives to developers and users. You can deploy and release great visuals of your data fast and easy, as well as to develop in-depth visuals integrating with Python or R.

Cons

In my experience - a small business - I struggled a bit in the purchase journey. The website is not clear regarding pricing policies, so I had to access a third party channel to purchase a Power BI Pro license.

Curretly the best software or data analytics

Its been a good experience using Power BI and we find it to be very useful in in it business intelligence capabilities. The visualisation features is the best in the market and it never ceases to amaze us.

Pros

Power BI is a power house of functionality. I like its ability to perform ETL to modeling to analytics and then visualisation withing itself alone without need for third party integrator and tools.

Cons

Its hard to use for a beginner. I had to get proper training before I could use this software. I wish it is a bit simpler

Enterprise Analytics - with some gotchas

We're using this as our enterprise analytics platform to supplement paginated reports in SSRS/PBIRS. Aside from the wrinkles mentioned, it's been a solid performer. If there was a little more "admin" capabilities around subscriptions and permissions, it'd be a home run.

Pros

Near-constant updates and feature additions. It's exceptionally easy to throw together a Power BI Report across a bunch of different data sources and then share it with 1 or 100 people. Tons of connectivity support - if you have data somewhere it can *probably* read it into a model for consumption. The "front end" development is pretty straightforward with the ability to get very fancy with custom visuals - although you need to be a real developer to build those yourself.

Cons

It feels like there are some (currently) missing enterprise features. We still haven't really figured out a holistic way of managing both the enterprise stuff, as well as the "power user" self service stuff that gets published around the org. To Microsoft's credit, there are pretty much monthly releases that add ne functionality and features. Some things I'd like to see include more API support and additional sources like Box, perhaps.

Simple and highly customizable

1. Dax query is highly reliable when comes to slice and dice the granular level data based on time trend. 2. Embedded report and dashboard in any kind of business applications easily and it becomes part of it.

Pros

1. Free desktop tool for development(Power BI Desktop) and simple installation process. 2. Almost, we can connect many source to fetch the data. Ex csv,web,excel,sql,odbc etc.., 3. Specialized ETL(Extract,transform,load) to clean the raw unstructured data into structured data with help of Power Query. 4. Powerful DAX query to customized measure and calculated column to get desirable business metrics and KPIs. 5. Top standard visuals, Custom visuals(visual market) and also we can create our own visuals using reactjs. 6. Publish in cloud(azure) to view report anywhere in the world with help Power BI service. 7. High availability and low latency to view report and dashboard with help of xVelocity engine. 8. Anyone can easily create basic charts with structured data.

Cons

1. Power BI Desktop consumes a huge amount of resource in system. 2. Service monitoring increases for larger report consumers. 3. While dealing with an enormous volume of data, constant optimization takes place.

The visualization and analytics product that is constantly evolving - for the better

With Power BI we identify patterns, issues and opportunities in sales, marketing, operations, supply chain, people management and finance data. The ways to look at the data and the drilling capabilities make this a wonderful tool

Pros

1. Improves with new releases every two weeks 2. Powerful insight management 3. Integration with MS products 4. Online forums and learning zones

Cons

1. Not as intuitive as packaged applications, but getting there 2. Not a good IDE for Python / R 3. Connectors to social media need to be improved

Very robust, though a little overwhelming

We're moving from having staff creating Excel reports or Access database reports to having Power BI do it all for us. We spend some time cleaning up the user's data, streamlining how they enter it (and where - we still use Access, some SQL, some Sharepoint), and Power BI does the rest after that. Our staff loves that they no longer have to manually create reports, and they love the way Power BI looks for them. We are enjoying it overall.

Pros

The dashboard creation is amazing. Give it a data source, design how you want to see your data, and it shows it to you. I enjoy creating dashboards for our different departments. And once our staff sees the reports and dashboards they get from this, vs how they used to get it in an Excel spreadsheet or an Access Report, they are hooked.

Cons

Overwhelming in the back end. Sometimes you just cannot get the data to display the way you want. There are so many options, features, methods. It gets overwhelming. My biggest gripe is that the back end is not as user friendly as other programs. And, comparing it to something that one of my users would create in Excel, it's difficult for me to get the exact data reported that they want. I have to figure out how to display it, and because the Power Bi is just so robust, it's a little overwhelming in that respect.

It brings the power of BI down to non-tech users

My job is to collect and process all sorts of data in my organization and present them to the highest management committee for policy level decision making. We are heavily dependent on MS Excel for this. I handle excel worksheets with thousands of entries every day. A year ago, I tried Power BI to see whether it can help me in my job or not. And i am hooked till now. I am most impressed with the processing power of Power BI. Huge worksheets can be processed very fast using Power BI. It also updates the reports automatically which improves my productivity significantly.

Pros

1. Ease of Use: Unlike other BI software’s, Power BI's interface is friendlier especially to MS Excel users. You will not feel overwhelmed rather it will look familiar. 2. Powerful engine: Users who need to tackle very large datasets with thousands of entries know that MS excel gets horribly slow processing such a large file. Power BI is a God sent for these users. Its processing engine is super-fast and the speed is more noticeable when you let it handle such large datasets. 3. Excellent data presentation tools: For regular MS Excel users Power BI is a PowerPivot on steroid but a lot smarter one. Even those users who are not familiar with the complexities of PowerPivot feels less intimidated by its simple and user friendly design. 4. User friendly but powerful DAX language: To write formulas you have to use DAX language in Power BI which in my opinion is a fancy name of just natural language formula writing. However, DAX is super easy to learn and pretty much intuitive but at the same time very much powerful. 5. Schedule refresh option: Power BI has an option to auto update the report at fixed interval of time which is very helpful if you need to prepare and submit reports weekly or monthly. 6. Option to control users of the report: In Power BI you can share your reports with other users and also control how much of the report can they see. If you want you can allow only a part of the report to be seen by some user which is super convenient.

Cons

Honestly, in my opinion, Power BI is by far the best software made by Microsoft. But considering I am a heavy user of MS Excel, it is easier to me. I think learning curve of Power BI for a beginner with no prior skill in MS Excel will be a bit steep. Then again, BI is a complex thing itself. So master any kind of BI software will be tricky by its own merit.

Power BI is one of the most user friendly BI software for adding visual representation and analytics to your existing reports

Overall good software for beginners and can be explored to get the best efficiency from the software

Pros

below are a few pros • Sharing dashboard in a group a. Sharing can be done once you have the Pro version of Power BI. Dashboard can be shared with the respective department members or your own team members. b. Since you have prepared the dashboard you will be the owner and you can decide whether you want to give the other members only viewing rights or editing rights as well. c. With this feature reports will always be on the cloud server and can be viewed as and when required d. Reports can be downloaded as and when required. • Viewing dashboard in Mobile/ tab and preparing phone layout a. Once a dashboard has been prepared and saved, the same can be accessed on Power BI App with the same login. b. Since the screen is small compared to laptop, all the dashboard elements can be redesigned to suit the phone screen. c. The other features remain the same and the dashboard is interactive on the phone as well however it cannot be edited on phone. • Export dashboard to PowerPoint, PDF a. This is one of the most important features of Power BI. Reports or dashboards prepared can be exported on PowerPoint or PDF with a click of a button. b. Hence Management reports and department reports can be automated on Power BI and once you refresh the data, the report will be ready to share. c. One problem is that few images which are not compatible with PowerPoint don’t show post downloading. • Narratives for dashboard a. This is one of the recent features offered by Power BI. With the help of narratives you can get the insight of the dashboard in a story form. b. Narrative uses its intelligence to study the data and give output in pointers, paragraphs etc which can be customised. • Importing visuals to suit your need a. Apart from the general visualizations available in Power BI, there are additional visualizations released by Power BI from time to time. These visualizations enhance the visual appearance as well as the adds to further analytics in different ways. b. Visualizations which have downloaded and used in the dashboard are Infographic designer, Narratives for Business Intelligence, KPI Column chart, and Timeline. • Edit interactions in dashboard a. It is important to understand the interactions and groupings in power BI since with the help of these you can control which graphs you want to automatically change by clicking on the other. b. With the help of grouping you can define groups and sub group which can be viewed together as a group if required. • KPI Column Chart a. This is a recent custom visual developed by Power BI. With the help of this visual you can put the KPI target against the actual on a monthly basis. b. Forecasted revenue/ cost can also be put in this visual which will be shown in different colour. c. Individual monthly targets can also be put which can be interchanged by putting variance. d. Data can also been viewed in a table form along with graphical.

Cons

• One of the important features of exporting report in PowerPoint does not allow custom visual to be exported. Hence if there are custom visuals in your report then the same will show error once exported. • Arranging dashboard is a bit tedious and takes a lot of time • To share reports, we need to publish to MS Cloud. We cannot share report from Power BI Desktop • For sharing a report even members to who report needs to be shared have to get Power BI Pro. Since the department to whom report is shared is just to view giving them a Pro license might not be useful.

Really good for aggregating data from multiple sources

Power BI has helped us go from random spreadsheet reports to consolidated dashboards that are pleasing to look at and easy to interpret.

Pros

The interface is beautiful and easy to navigate. Once data sources are all connected, it's pretty easy to create a new dashboard/layout if you know how to analyze your own data. Nearly every integration that we needed was already included.

Cons

It's hard to build some more complex reports. If you want to combine two different data sources into one view/metric, you will need some advanced skills.

Simple et très personnalisable

1.Intégrez facilement un rapport et un tableau de bord dans tout type d'application commerciale et il en fait partie. 2. La requête Dax est très fiable lorsqu'il s'agit de découper en tranches les données de niveau granulaire en fonction de la tendance temporelle. 3. les fichiers fusionnés a l'aide de power Query

Pros

Avantages 1. Outil de bureau gratuit pour le développement (Power BI Desktop) et processus d'installation simple. 2. Presque, nous pouvons connecter plusieurs sources pour récupérer les données. csv,web,excel,sql,odbc etc.. 3. Spécialisé en (Extraction, transformation, chargement) pour nettoyer les données brutes non structurées en données structurées à l'aide de Power Query. 4. Puissante requête DAX pour une mesure personnalisée et une colonne calculée pour obtenir les mesures commerciales souhaités. 5. Publier dans le nuage (azur) pour voir le rapport partout dans le monde avec l'aide du service Power BI. 6. Tout le monde peut facilement créer des graphiques de base avec des données structurées. 7. La gestion de stock a l'aide de power pivot et indescriptible

Cons

Inconvénients 1. Power BI Desktop consomme une énorme quantité de ressources dans le système. 2. La surveillance des services augmente pour les grands consommateurs de rapports. 3. Tout en traitant un énorme volume de données, une optimisation constante a lieu. 4. la traduction des formules DAX en Français pour les francophones

One of the best BI softwares out there

I have created dashboards on project progress, business cases and at times, a personal dashboard of my own assets and savings just to keep track of certain things. I love that PowerBI is easy to use, and has been designed with the end user in mind. However, I would like to have a wider variety of templates to choose from, especially if I am a beginner to the whole business intelligence idea.

Pros

Having been a user of the full range of Microsoft Office, it was only natural that PowerBI comes to mind when trying to create a live update dashboard. It is extremely easy to use - a plug and play approach comes to mind - and if you had worked with Microsoft Office before, some of the features are very intuitive to use. If the organisation that you are working with uses Microsoft Office, access issues are sorted and it becomes incredibly easy to drive adoption of this dashboard on a day to day basis

Cons

The design of the dashboard created with PowerBI can be found to be lacking at points, compared to some of the other BI softwares. The templates available seem great, but there aren't as many options as I would like when I am creating a specific type of dashboard.

The best gets better

It's easily the most feature rich overall. Other products like Tableau and Qlik have their advantages, but I'm hard pressed to find much fault with Power BI, other than the premium licenses being ridiculously expensive. The word is Microsoft is addressing that issue later in 2020/2021.

Pros

The features and ease of creating visualizations are top notch. Also integration with all other Microsoft products as well as pre-built connectors to many of the most popular software is hard to beat.

Cons

There are many features not available unless you pay for expensive premium capacity.

Overall the best Dashboard software at this moment

Part of our dashboards were developped using Power BI. Although the UI is not as perfect as Tableau, Basically it can achieve all Tableau can do, (maybe not as quick or few steps as Tableau).the modelling, the strong ETL support, the Power Query and integration with office can offset the drawbacks.

Pros

1. The wide and deep design and full support for upstream and downstream systems; 2. Excellent query engine with well design data modelling principals (which is better than Tableau); 3. Seamless integration with other Microsoft data integration products such as SSIS, SSRS, SSAS; 4. Excellent knowledgebase community and support; 5. Quick update to the Azure cloud support

Cons

1. UI design is a little bit inconvenient comparing to Tableau. 2. DAX is a bit complicated for power users.

New to Power BI but love it

Overall I love the software and would highly recommend it. Not only does it help visualize data but also helps to keep it updated in real time with the ability to connect to a server. The automation of pulling the data on a schedule and importing it directly into the visualizations solved a huge problem for our company.

Pros

I love how easy it is to make really powerful visualizations. The ease of use in order to basic visualizations is similar to Pivot tables in Excel. If you have a basic understanding of Pivot tables you will be able to open the software and get straight to visualizing. Once you take a deeper dive into the queries and data transformations you will uncover an entirely new world of analysis.

Cons

The software is easy to use for basic functions but when you get into more detail it can be difficult. It is also really hard to share your work with someone that does not pay for the service. Without paying for a Power Bi Pro account it is basically impossible to share the visualizations that you have created. Also, the Arc GIS feature only works within the software. If you try to post a map visualization to a website through an embed it doesn't work.

Miscrosoft Power BI for Federal Acquisition Spend Analysis

All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights.

Pros

Power BI simplifies the process of combining different types of data sources to create a single data model. There are also many built-in Extract, Transform, and Load (ETL) functions that help reduce the time required to prepare data. Creating reports and dashboards is as easy as drag and drop. The Power BI User Groups are strong and plentiful, so you can always read through blogs to get answers to questions that you may have. The Power BI Desktop application is used to perform ETL, create reports and is free. The reports are published to the Power BI cloud service for sharing, which is also free with limited capabilities. For more capabilities, such as security groups and scheduled data refreshing, there is a subscription fee. Microsoft will be releasing an on-premise solution for sharing Power BI content via an update to SQL Server 2016 hopefully within the next few months.

Cons

It's not always easy to speak directly with a MS Power BI expert, so that is a bummer. Also, you have to sign up to the Power BI service using an email address in order to share and view Power BI reports and dashboards, but Microsoft doesn't yet support personal (.cox, .gmail, et.) or government (.gov, .mil, etc.) email addresses which is a real bummer.

Great, Simple Vizualization Tool!

Overall I have had an excellent experience with power bi as someone coming from a Network engineering role into data science and visualization. Power bi does a great job with ease of learning the product.

Pros

Free desktop tool for modeling is great to try out for anyone. Excellent customer support. Using the power bi web dashboard is a great way to gain the visibility that you need to make this Business intelligence valuable. Being able to send reports on a schedule makes it a great tool for displaying and sharing data. The level of features and third party visualization also makes this a versatility tool that any data driven groups could benefit from. Publishing from the desktop to the web version is extremely simple.

Cons

When creating measures and columns there can be some slowness or odd reactions while using the measures/columns as filters. Not able to choose a theme for the background colors.

There are plenty of competitors, but Power BI is tops

Power BI allows me to manipulate data and present it in visually appealing and flexible formats.

Pros

I have used Tableau and Google Data Studio - among other alternatives. Nothing has seemed to compare to the functionality that Power BI offers. Everything about the program is made with the full spectrum of analysis in mind - from the designer to the data 'wrangler' to the end consumer (ie. others within the enterprise). In this way, Power BI is extremely powerful because it can be used for so many different types of projects; the data-analysis intensive to the more visual 'data-presentation' dashboards.

Cons

Sharing dashboards and reports in Power BI is easy and it has a lot of options for doing so. However, the requirement that all users must have a Pro Account to view dashboards created in Pro is a bit of a hindrance in a global organization where it does not make economical sense for every employee to have a Pro account. It seems like it would be a great addition to allow limited sharing to everyone - even those without a Pro account, as most of my internal team does not have an account.

Best Business Intelligence Tool Ever!

Great experience and great tool to experience has a very easy interface and can make dashboards easily.

Pros

Microsoft PowerBI is the most easy tool to use, an non IT personnel and not a well trained personnel can easily use this tool. This tool has an interactive Graphical user interface and if you have any problem you can just google it.

Cons

The frequent update sometimes will be much tricky to handle as if you have the newest version of the desktop and the old version of desktop so it may be tricky and the file may not upload to the server.

BI tool with the coolest features

I have been using PowerBI from the past 3 years and have never looked back. It has helped me as an analyst to draw my clients into my stories. The automation aspect of PowerBI is hard to ignore. I have shared my dashboards and collaborated with teams which was a nightmare before. I love the addition of new features resulting from a dedicate community of PowerBI users (with very responsive Microsoft developers jumping in to solve issues). Mobile version of PowerBI is convenient and a hit with clients.

Pros

I love everything about PowerBI! I like to think of it as a revamped version of MS Excel but with features that exceed all expectations. PowerBI lets you create data models, use DAX to manipulate and summarise and finally display these summaries in fancy (yet easy to understand) visualisations. The best feature might however be the ability to share and collaborate on dashboards. PowerBI can take data from almost all possible sources - text, excel, SQL databases etc etc and integrate it all together to form dashboards that can be shared online in the form of webpages as well as workspaces.

Cons

There is absolutely nothing to dislike about PowerBI. The free version of PowerBI is a great learning tool and lets you accomplish almost all your reporting tasks while the paid version lets you automate all your reporting.

Power Bi its changing the way we interact with data, information and decision making

Data is the new petroleum, Information is the new combustible; and Power BI will boost this challenging new world of information and analysis.

Pros

For the last 30 years I have been using Excel to work with Tables, Filters, Functions, Formulas, Conditional formatting, Graphs, Pivot tables, Segmentation and VBA to register data and analyze information. That was great. But now, with the huge amount of data, available from many sources and Excel limitations, we needed something more robust and Microsoft launched Power BI. I have been using it for more than a year. Now I don’t use pivot tables and graphs for analysis anymore, I use Power BI visualizations to represent and summarize the data. With it’s impressive tools including geolocalization, I have found more effective ways to convert, transform, represent, analyze and make better decisions and planning with Power BI. It’s ecosystem composed of Power Bi Desktop, Power BI Services (in the cloud) and Power Bi apps, has allowed me to find very innovative and productive ways to monitor the performance of my business and improve communication with my clients

Cons

It is in continuous development. The first week of each month, Microsoft releases a new version of Power Bi, so we have to keep us updated to use the program efficiently. But the pros outweigh the cons.

Next-Level Data Visualizations

We wanted a state-of-the-art dashboard and visualization tool that could be used across the company. After trying others, this one fits the bill perfectly.

Pros

The visualizations you can make with minimal experience or effort are astounding. Like with many Microsoft products, the sky is the limit and you can definitely get by without formal training. But if you decide to learn more about it, there is very little you can't do visualization-wise. We can even connect our on-prem SQL database with ease.

Cons

While it is easy to get started, really mastering the program can take some time and trial-and-error. It can be frustrating at times to get it to do exactly what you want it to do.

Power BI is a very powerful tool to graphically represent data for decision making

Overall, Power BI has been a game changer. The time saved on creating visual reports is immense and it makes up for some of the cons with software. They are constantly improving and adding new features which shows that they are listening to their customers.

Pros

The vast no.of data sources available means it has got all the bases covered. You can connect to SQL Server Database or an analysis service database which is vital for us. Apart from this, the ability to connect to excel and text files means we can make the legacy report more visual and fit it into our dashboard.The best of Power BI is the possibility of collaborating and sharing dashboards and dynamic reports so everyone is singing of the same hymn sheet. The large community of developers means there are constantly new visuals available which can used to awe the customers.

Cons

Power BI could involve steep learning curve for non-tech savvy people. It is difficult t convince managers to use Power BI over traditional pivot tables as it could be daunting to learn. Unless you can play around with DAX queries, Power BI could be limited to the insights it can provide.

Powerful like its name

This software has allowed me to take my ETL skills to a higher level, it has allowed me to manage and transmit information more effectively and efficiently. The online functionality for automatic data updates has allowed me to be more efficient in reports that many people must view and that must always be updated so that any user has the most recent information no matter when this is necessary. Many times I use the software even when I don't have to make visual reports, only as a data transformation tool because it is very fast, simple and capable of supporting large quantities with an excellent response time.

Pros

What I like the most is that it allows you to take your graphics to another level of professionalism, you can customize each element, in addition to the store where developers have included creations of other different or more elaborate visualizations than those that the software natively includes, which allows you to recreate the presentation of your data as you imagined. It is also excellent all the integrations you can do with systems, the cloud, etc. The data transformation module I find wonderful how fast it is, even with large amounts of information.

Cons

What I like least is the color palette, I think that sometimes it is very limited, especially when they must be specific corporate colors, the RGB scale is necessary. It also bothers me a bit how slow it is to load specifically the desktop version, but this I can understand because I suppose it depends on the amount of data connected.

Flexible, inovative reporting software

We have been using Power BI as a business for nearly 2 years now and it has spread to have reports used in pretty much every department, it still feels like there is a lot more we can get about it and we're constantly exploring new ways to use our data

Pros

It's a great way to link data together from multiple sources and create meaningful reports that would be difficult or impossible to put together in something like Excel. It's also very user friendly once past the initial learning curve

Cons

As with a lot of Microsoft products, direct customer support is lacking and you likely have to rely on other users in forums to help you with any issues/queries

Great BI tool for my presentations!!!!

Although Power BI can be a little difficult to use it is still a great tool for creating graphs and charts for presentations. It is also great for compiling and analyzing data and creating dashboards.

Pros

I like Power BI because it offers a professional look to presentations. I am able to create and manage dashboards for my various projects. I can upload data from other tools like Excel and use the data to add to or update my dashboards.

Cons

The tool can be a little confusing making it difficult to learn and use.

You get all information digested for you

Overall Power BI has helped me saving time by not having to move from one excel dile to another and waiting for large files to load, now, i have all the necessary information in 1 tool.

Pros

Having all the necessary information at my fingertips already digested and analyzed for me has made my daily coaching easier. I am able to see a broad amount of information summed up into individual graphs that help me understand the current performance of a person and helps me identify the area i need to focus my coaching in.

Cons

At first when it was implemented it was hard for me to understand the logic of thw tool. It was difficult for me to not focus on the granularity and understand the big picture first and then start diving in.

Power BI very good option for data analytics

As an IT user i had no such problem to get used to power BI, we have previous experiences with other BI vendors so it just took 2-4 hours to get my first report running and then get to know all the functions and menus the tool has.. i consider that a average person that already has some excel abilities and it has some knowledge of data will have no issues on getting a report ready very easy..

Pros

As is a Microsoft product you will be very familiar with it as it is like you grab like a mix of" Excel and powerpoint " it has very intuitive menus and drag and drop options, there are some license levels, the basic one is like an free trial that will last as long as you want to, So you have a lot of time to play with it and get some experience and have your reports to rock

Cons

The free perpetual trial has some limitations on data connectors so this is understandable as the pay version hast no limit on this. other than that, it is great.

Best Data Visualization and Dashboard Solution

We have a project that we need to transpose dashboard from other software to powerbi. PowerBi help us to achieve our goal because it is easy to use and able to handle a lot of data design complexity.

Pros

PowerBi empowers the user to develop robust, beautiful, interactive and powerful dashboard with less effort. PowerBI cloud come with a lot of very useful and helpful solution such as data gateways, alert solution and live visualization.

Cons

The cons on this software is its powerbi for report server because it doesn't have some of the very helpful solutions which is available only on powerbi cloud. Also you cannot custom rename measure or column names on visuals.

A great tool for dashboards and business intelligence reports.

Very positive. It has really bridged the gap for our company to be able to finally see our data easily in a way that makes sense.

Pros

Rapidly adding features and evolving quickly. Very good tools for visualizing all of our data and presenting it in a way that makes sense.

Cons

It is still a very new software package so there isnt a lot of documentation, and things change quickly.

Simplicity of Microsoft with Powerful Analytics

Power BI is a power of Microsoft simplicity with great UI and ease of use. If gives a very simple interface to create great visual representation of data and analytic outputs.

Pros

Data preparation and connectivity with variety of data sources is very easy. The way user interface is created to create graphical representation of data is very good. Even a person with knowledge of Excel and charting can use it. Power BI is designed to handle large data sets which gives seamless data processing even if you have huge data sets. Types of charts and graphs, geographical charts all are amazingly great.

Cons

Being a fan of Power BI can't find as much. But when it comes to teaching to someone else I found that learning curve is long. Another issue I can mention here is frequent updates and installing updates of desktop Power BI. Many times I need to uninstall old version and install new one to keep it updated.

A good analytical and reporting tool

A great reporting tool with great visuals and user friendly graphical user interface.A wonderful application for running day to day activities

Pros

It is a good analytical tool which simplifies complexities in producing articulate reports and good especially when it being used by people without much programming knowledge. The visuals are great and integrates excellently with other Microsoft applications . It is also very easy to deploy and work with

Cons

The pricing is a bit high when you want to add more users.It may be a bit difficult for beginners

POWER BI : Excellent data analytics tool

It is a useful asset with regards to Business use. You can do huge things with your information with Power BI. Dashboard creation, report age, information representation are some powerful models. I unequivocally prescribe others to utilize Power BI on the off chance that you are a specialist Excel client.

Pros

Microsoft Power BI is a helpful device. It is anything but difficult to utilize and get it. It has comparative highlights to Excel with the capacity to make and import diagrams and outlines and control them. The apparatus is mind blowing for making natural dashboards to bestow to various customers. The features and limits improve this much than a direct surpass desires file and make it easy to bestow to various customers. As it is a Microsoft item, it very well may be effectively coordinated with other Microsoft items, for example, Office 365, Excel and so forth.

Cons

There is dependably opportunity to get better. The UI is unpredictable and confounding in it. There are expansive portions in the instrument itself which is in some cases confounding to make sense of which part does what. To utilize Power BI effectively you need to utilize totally cleaned information, there is no extent of information cleaning in Power BI.

Complex at first and then it gets easier and easier

This is a great tool when managing different and several performance indicators because it gives you a clear picture of where you and your team is standing.

Pros

I love that I can get a complete visual of different performance indications at once. This allows me to mentally rank the people I am working with. It also gives me clarity of where I need to focus and where my efforts should be going to.

Cons

At first, it was hard to understand how it works being used to other types of files it made it harder. Once you realize all the gains out of having condensed information you love this tool.

Advanced, integrated, live, better version of Excel

We automated the process of reporting our team's KPIs that was carried out in Excel previously where we had to re-make them every time and spend hours. Not to mention that we were able to report more complex KPIs / parameters after Power BI.

Pros

What I liked most is that it is possible to carry out "feature engineering" in Power BI in a very Excel way but better because it is automated and integrated with live database/file. Filtering and data manipulation (groupby, sum, sort, etc) in visual interface is useful, too. It is also possible to publish reports live and if it happens to be feeding on an SQL database, then your report is boundless of any computer because it's live on Cloud now. Congratz, you can share it with anybody.

Cons

Although that's not a %100 downside, format painter is not wholly compatible with all graphs which results in duplicate of effort for formatting graphs in the dashboard.

Best BI Tools for Microsoft Stack

Pros

It was a no brainer to use PowerBI after trying Tableau and Qlik Sense. It was almost as easy to use as Excel, fit right into our Microsoft stack, and we already have licenses with our Office 365 org.

Cons

Since PowerBI is the new tool around, they are releases features so quickly that it's hard to keep up and understand if the documentation you are looking for is still relevant.

One tool for Business intelligence solution

Power BI is awesome for companies which use Microsoft products on daily basis and for experienced excel users. if you got both things this is the low price answer to handle the data of the company.

Pros

To start it is important to tell that Power BI, as is part of Microsoft business suite, is linked to other tools as Excel and SQL Server. Therefore the integration of the data of the company in one place is very easy. Power BI has a very good capabilities for report visualization, having more than 10 different kinds of charts you are able to represent the data of the company in a huge variety of formats making analysis pretty fast and easy. Let me tell you the database connectivity capabilities are outstanding with excellent cloud based connections as well.

Cons

Using Power BI will be challenging if you are not a powerful Excel user. It has no way to clean up wrong data. The system assumes the data you are pulling in has good quality. Power BI sometimes is too complex to use because has many options to handle data and setting it for the first time becomes hard.

Power BI - A Datanuts Canvas

Power BI allows us to deliver content and various reports to large groups of people at once. One of the best features that go along with this is the ability to use row level security so I can create one report, publish it for everyone, and yet they still only see the information they have permissions for. All in all Power BI makes creating reports easier and the end users get a better experience consuming the data.

Pros

The best thing about Power BI is the ability to customize it to my needs. Meaning, I can make every report look and feel the way I want. If a visual is not available as a built-in service I can go to the marketplace and search for one. If the built-in calculations won't work for what I need I can code in custom calculations.

Cons

The interface still has the look and feel of Office 2010. For software that gets updated on a monthly basis, it is surprising to me that it still looks like a product from a decade ago.

Very easy and interconnected

Fantastic, I'm allowed to present my reports to my clients in a multiplatform and dynamic way

Pros

Very good graphics, powerful editor of query's, easy to present and automate, Sharing the dashboard for a link or inserting it on my website opens up a world of possibilities

Cons

Having tutories in Spanish would help much more particularly for the topic of liaison doors, I admit I still have difficulty using that functionality

Microsoft Power BI, Master of the Analytics World

Analytics world is the future, and Power BI is the master of all that Glob...!

Pros

As my experience as MIS Specialist in one of the most famous Fragrances Company in the Middle East, we see that in any company there's the accounting department that provide all reports and analytics that's demanded by other departments, according to that those guys have to do all there outcomes reports manually, and this process will cost time, efforts, stuffs,... for that one of great benefit from MS Power BI, is that he save me money, save me time, save me my the cost of wages for the accountants, my stuff in the accounting department is just about 5 great guys. All the mater is just I have to design the report and working on the Data Warehousing a little bit, then I can get my report in the target template that provide me all what I want, and furthermore, all reports up-to-date 7/24.

Cons

We still need the integration with other services, like Vend POS, Shopify directly without any intermediate programs.

Using Power BI for Data Visualisation

We use Power BI to receive and visualize the wide array of data sources and provide us with a very detailed overview on monthly status. It is user-friendly and easy to pick up. Through Power BI, we were able to attain increased productivity and efficiency on some of our processes.

Pros

It is able to take in multiple data sources and churn out reports in a visually pleasant form for ease of viewing. It greatly improves efficiency when we do not have to resort to using Excel to generate the exact data model we want. The ability to utilize SQL Server Analysis Services for our needs is very welcomed. I especially like the user-friendly interface that Power BI provides.

Cons

There are some segments and features of Power BI that requires a good amount of time to figure out. To utilize Power Bi effectively, the data has to be cleaned beforehand as Power Bi does not provide such tools.

PowerBI Features

desgin dashboard for KPI performance monitoring on daily basis Gateway administration Plateforme administration

Pros

Conditionally format button formatting New performance analyser features Transformation tools and connector with SAP HANA data source

Cons

Memory consumption Stockage management Push a report by mail many time per day Cost of the premium License

Excell and power point had a child!

Make my presentations look more professional. Will keep using it for sure.

Pros

So many things you can do. So many graphics to choose from. I just love the clean looking of it. So easy to share the info with others. You don't have to send the whole file just the link so they can see and filter the information. Cloud based does not make my computer slow like when working with Excell.

Cons

It is a bit hard to learn to use. If you are a proficient Excell and power point user it will be easier however still getting the hang of it. It will have been nice a more friendly and easier user interface.