Program Director Education Technology & Data Services at a government with 5,001-10,000 employees
Real User
Top 20
It's good for training and teaching, handles Excel data well
Pros and Cons
  • "I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice."
  • "The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section."

What is our primary use case?

I would describe myself as more of a casual user, only because I have so many other things that I have to get done. I wish I could be more of a user, but it's hard. Right now, I have two different main use cases. I use it for teaching. At another institution, I use it for demonstrating how easy it is to build dashboards. It was really to show to all my users the benefit of business analytics. I use it to demonstrate how easy it is to generate your own analytics versus having a department run reports for you then putting it in Excel and making graphs. 

What is most valuable?

I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice.

What needs improvement?

The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section. It's probably designed by data analysts that typically get the data from somewhere else. So, one person logs into Power BI, moves the data around and puts it in the proper form then somebody else goes in from the dashboard. What I'm finding more and more is that the person playing with the data is also going to be the person building the dashboard, so the interface needs to be more seamless and dumbed down for the average user. 

Tableau is much better at that, which is probably why it's more expensive. The days where one person works on the data and someone else does the analytics are coming to an end. In the past, larger organizations usually had a dedicated analytics team and a dedicated data team. Now we buy data as a service, so we got rid of our data team and we don't have analysts per se. Instead, we have smart users. So I think Microsoft BI needs to move on to the next iteration of truly user-friendly solutions.

For how long have I used the solution?

I've been using Microsoft BI for about three years.

Buyer's Guide
Microsoft BI
September 2023
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: September 2023.
734,678 professionals have used our research since 2012.

What do I think about the stability of the solution?

Microsoft BI has never crashed on me.

What do I think about the scalability of the solution?

I honestly can't comment on how scalable Microsoft BI is because I've never taken it beyond training or simple use. But I would imagine, if it's on Azure, that it's scalable. I haven't had the pleasure of scaling it, so I don't know, but it doesn't strike me as a solution that would have problems with scalability.

How are customer service and support?

I have not had to contact technical support, but I've actually downloaded and taken three Power BI courses for free and they're very good.

Which solution did I use previously and why did I switch?

I was using Tableau but the licensing cost went up when Salesforce required them to raise the price. But if the price hadn't changed, I would've absolutely stuck with Tableau because I like it. I do not know about the cost of the licenses. We buy it from the state and when it went up, our CIO at the time said no more Tableau licenses. I had to scramble to find a replacement, and fortunately, I discovered that Power BI is included in Microsoft 365. However, I prefer Tableau's interface. Microsoft BI's user interface is convoluted in terms of how you attach a data source. You have a separate screen for defining your data and then you have to jump to a different screen to model the results. In other words, there are two separate interfaces for data and analytics. In Tableau, it's more seamless. 

How was the initial setup?

Setup is very easy. You click on the icon, download the MSI, and it loads itself. It takes about a couple of hours to deploy overall.

What other advice do I have?

I'd rate Microsoft BI as an eight out of 10. The biggest drawback is the user interface. From what I'm seeing, Windows 11 is going to have a more user-friendly interface. Even Microsoft Edge is adopting a more user-friendly interface. I'm hoping that Power BI follows this trend as well. 

My advice for anyone who is thinking about adopting Microsoft BI is to understand what you're trying to do with it. If you're trying to do analytics with it, then it depends on the kind of analytics. If you're want to do statistical analytics, it's not the tool for you. It's a tool that's better suited for visual analytics than it is for straight-up analytics. If you're dealing with patterns and data, it's great. If you're working with numbers and data, it's not so good. You're better off with a statistical package.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Manager Technical Architect at Legato Health Technologies
Real User
Useful for data visualization and building interactive dashboards
Pros and Cons
  • "It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
  • "Sluggish performance when handling large amounts of data."

What is our primary use case?

It is one of the business intelligence tools we are using—mainly for all our data visualization purposes and building interactive dashboards. We use Microsoft Power BI to generate all different types of analytic reports. We move information from our data warehouse to a SSAS cube that we've built on top of all our dimensions. We also do a certain level of aggregation in the cube itself, which is then connected to Power BI.

What is most valuable?

It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well.  

What needs improvement?

I would like to see Microsoft BI add custom visuals and certain machine-learning capabilities. It would be nice if the DAX functions could perform some kind of predictive modeling. Right now, it just does a kind of descriptive analytics.

For how long have I used the solution?

I've been working on Microsoft Power BI for three years. 

What do I think about the stability of the solution?

Throughout several updates over the past three years, I never saw any issues, particularly with installation or anything, so I see the product as stable.

What do I think about the scalability of the solution?

I feel that scalability is one area where there is room for improvement. When there is a huge volume of data, like when we apply the aggregation, the reporting slows down. That's why we mostly build things in the SSAS cube itself instead of bringing it back to Microsoft BI to do the aggregation. Certain incredibly small aggregations can be done on the Microsoft BI side, but if the dashboard size is more than 1 Gigabyte, you start to see some performance issues. 

How are customer service and technical support?

The Power BI community is really big, so we mostly rely on other users for support.

Which solution did I use previously and why did I switch?

In some projects, we have used Tableau or ThoughtSpot. If we're dealing with big data, then we often consider using Tableau. Power BI has some additional features that Tableau doesn't have, like DAX and Power Query, but Tableau works better from a scalability standpoint. Sometimes for reporting purposes, when we want to generate some kind of dashboard on the fly for the user, we have used ThoughtSpot. 

How was the initial setup?

We didn't experience any complications. We built everything on the desktop and in the .pvi files, then just move those files to the server. Afterward, we didn't see any issues at all in terms of setup.

What's my experience with pricing, setup cost, and licensing?

I'm unsure about the exact cost, but the Pro license comes out to around $10 per user. There are also additional costs for custom visuals that you can pay for.

What other advice do I have?

I would rate Microsoft BI an eight out of ten. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Microsoft BI
September 2023
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: September 2023.
734,678 professionals have used our research since 2012.
Senior Data Engineer at a computer software company with 1,001-5,000 employees
Real User
Easy to use, quick report generating, and simple installation
Pros and Cons
  • "Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."

    What is our primary use case?

    I used Microsoft BI to develop reports and then deployed them into Microsoft BI web.

    What is most valuable?

    Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports.

    For how long have I used the solution?

    I have been using Microsoft BI for approximately three months.

    What do I think about the stability of the solution?

    The stability of the solution has been good.

    What do I think about the scalability of the solution?

    The solution is scalable.

    We have approximately 100 people in my organization using the solution and they are mostly managers.

    We used the solution on a daily basis, we were using it extensively.

    Which solution did I use previously and why did I switch?

    I have used Tableau previously.

    How was the initial setup?

    The initial setup was very easy to complete and it took approximately 30 minutes.

    What about the implementation team?

    We did the implementation of the solution using two technicians.

    What's my experience with pricing, setup cost, and licensing?

    The current licensing model that Microsoft BI has is expensive. My customers have told me the cost is approximately $20 per user and this can get expensive fast. There should be a one-time purchase option if the customer has a lot of users.

    What other advice do I have?

    I rate Microsoft BI a nine out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Senior Manager.Marketing Strategy & Analysis. at a marketing services firm with 10,001+ employees
    Real User
    Integrates well, secure, but cannot handle large databases
    Pros and Cons
    • "The solution integrates with other Microsoft solutions very well."
    • "If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3."

    What is our primary use case?

    We are using this solution for analytic dashboards.

    What is most valuable?

    The solution integrates with other Microsoft solutions very well. 

    When it comes to security Microsoft BI can integrate well with Microsoft Domain Services, you are able to make it as secure as you want.

    There are useful visualizations available in the dashboards.

    What needs improvement?

    If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3.

    In a future release, they need to have better integration to allow any visualization that is done in other solutions, such as D3 or Tableau, to be able to be imported in Microsoft BI easily.

    For how long have I used the solution?

    I have been using Microsoft BI for approximately five years.

    What do I think about the stability of the solution?

    The solution is stable when the database is reasonably sized. If you have large databases of 20 million rows it can begin to have difficulties requiring a purchase of more hardware.

    What do I think about the scalability of the solution?

    The scalability is good. If you have a direct query, Microsoft BI can run on billions of rows of data.

    Microsoft BI is available to the 70,000 users in my organization.

    This solution is used extensively because everyone has access to it, not because it is the best.

    How are customer service and technical support?

    The support from Microsoft could improve.

    How was the initial setup?

    The solution is easy to install.

    What about the implementation team?

    We did the implementation of the solution.

    For those customers we have that use Microsoft BI on a dedicated server, we have a technical team that does the maintenance.

    Which other solutions did I evaluate?

    I have evaluated Tableau and D3.

    What other advice do I have?

    I would recommend Microsoft BI over Tableau if you are comfortable with Microsoft solutions. Additionally, understand your use case and choose the best solution that fits your needs.

    I rate Microsoft BI a six out of ten.

    Which deployment model are you using for this solution?

    Hybrid Cloud
    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
    PeerSpot user
    IT Service and Strategy Consultant, Facilitator at BCAP SOLUTIONS
    Consultant
    Offers great integrations with good visualizations
    Pros and Cons
    • "Easy to use and the visualization is valuable."
    • "The formatting template could be improved."

    What is our primary use case?

    The main use case is for dashboarding on Excel spreadsheets until data lake and similar sources are ready for us to start integrating and dashboarding that information. We are a government motor transport entity and for each vehicle, there's a lifecycle. At every step of that life cycle, we need to know how many of a particular type of vehicle we have in our fleet and its status. I'm an IT service and strategy consultant and we are customers of Microsoft BI.

    What is most valuable?

    BI is very easy to use including the desktop version. The visualization is valuable, it's easy to select visualizations and show your data in different views. It opens up a lot of possibilities that weren't previously available and it's versatile. We're integrating with other solutions and if you look at Power BI pulling information from the data warehouse, it's integrated to an Oracle warehouse and works well.

    What needs improvement?

    The formatting template could be improved. In order for me to easily do visualizations, I have to format my Excel spreadsheet in a very specific template. I can't take a spreadsheet from my financial director and quickly put it in Power BI and then pivot into visualizations. I have to first check the formatting, that it's in the proper columns, and headings are logical. It needs all of that database thinking before you can actually get valuable information out of it. 

    I'd like to see more templates and better tooling so that when one opens a spreadsheet it's possible to manipulate data from Power BI without having to format the spreadsheet. If you were able to pull the information out of the spreadsheet via more detailed tooling, that would be brilliant.

    For how long have I used the solution?

    We've been using this solution for about three months. 

    What do I think about the stability of the solution?

    Stability has been good so far. 

    What do I think about the scalability of the solution?

    The scalability is good. 

    How are customer service and technical support?

    We haven't required technical support.

    How was the initial setup?

    The initial setup was straightforward and didn't take too long. We had a team, the Azure FastTrack team, that assisted us and they were superb.

    What's my experience with pricing, setup cost, and licensing?

    We're using a subscription-based license and the government has a transversal agreement with Microsoft. We use the solution according to that contract, it's an EA license. When it comes to premium licenses, I think they all have room for improvement.

    What other advice do I have?

    I would recommend this solution to everyone, whether small, medium, or enterprise-size companies. Smaller companies should use the free version because it offers quite a lot and is valuable. I would recommend it for any size environment and specifically because it's not boxed in and you can visualize data that's on Microsoft products. 

    I rate the solution eight out of 10. 

    Which deployment model are you using for this solution?

    Private Cloud

    If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

    Microsoft Azure
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Project Manager at GlaxoSmithKline
    Real User
    Very good toggling feature; unfortunately some performance issues and inability to aggregate
    Pros and Cons
    • "The solution has a good toggling feature."
    • "Lacks the ability to copy data from BI into PowerPoint."

    What is our primary use case?

    I'm a project manager and we are customers of Microsoft.

    What is most valuable?

    I like the toggling feature, the ability to switch from one page to another. 

    What needs improvement?

    I have a couple of dashboards that are weekly and monthly. I was able to download the dashboard, but I cannot paste any images into PowerPoint. There are also visuals based on the brand that should automatically pop up in the graph and which should be a toggling option. And I'm having performance issues if I want to add two or three tables at a time, which I could easily do in Tableau. Copy-pasting data to PowerPoint for presentation to the executive level should be easy but we're only able to copy the visual, not the underlying data. 

    For how long have I used the solution?

    I've been using this solution for the past eight months. 

    What do I think about the scalability of the solution?

    The solution is scalable but we haven't yet migrated everyone to Power BI. Our users are not finding Power BI as good as Pique, which perhaps they're just more used to. They're trying but some of the features available in Pique are not there so they are not comprehensively using it. It's being used mainly for internal analysis for now. 

    Which solution did I use previously and why did I switch?

    We initially used Tableau because our data was an internal data source, and now all of our data is migrated to tool environments, that the Power BI is more comfortable with. BI is also a free product which is another reason the company recommends it.

    How was the initial setup?

    The initial setup was straightforward, we have a Power BI admin team who take care of all that. 

    What other advice do I have?

    Because of performance issues and because we're unable to do all the aggregation, I rate this solution six out of 10. 

    Which deployment model are you using for this solution?

    Private Cloud

    If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

    Microsoft Azure
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Summer Intern at a financial services firm with 10,001+ employees
    Real User
    Good visualization capabilities, a lot of online content, but not easy to define a relationship and has a bit of a learning curve
    Pros and Cons
    • "Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard."
    • "Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier."

    What is our primary use case?

    I used it to build a simple dashboard. What I did was very simple. I used it to load different datasets. I defined relationships between them and played around with the data by using visuals.

    I must have downloaded the version that was really available at that time.

    How has it helped my organization?

    I had to build a simple dashboard in which I had to combine two or three different datasets. They were large enough, so it wasn't possible to work on them easily in Excel. In Power BI, I used the relationship feature, and I was able to store the data in such a way that it does not occupy a lot of space. I could then send the file over email.

    What is most valuable?

    Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard.

    There is a lot of self-help content available from a lot of different platforms, such as YouTube. So, whenever I faced an issue, it was not difficult. I could always find a solution to the issue I was facing.

    What needs improvement?

    Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier.

    For how long have I used the solution?

    I worked on it this summer. I just used it for a month or two.

    What other advice do I have?

    Defining Relationships can be confusing when you are working with a complex data model. It can result in circular relationship referencing and the interface does not help solve it, or even understand it, in any way. It takes time to figure out a different way to structure the data model and Power BI offers no guidance on that. Online help is limited.

    There is a lot of content available online. When I started out, the way I was defining the relationship between the data and the way my model was structured was not very efficient. I spent a lot of time in making it more efficient. So, I would advise others to do enough research. I was learning on the go. If you spend about six or seven hours learning it, it would be much better. Even though it is marketed as something that is easily usable and anyone can come and start using it, there is a bit of a learning curve.

    I was very easily able to load the data and conduct an as-is analysis of what is happening, but if I want to do a deeper analysis of the data and break down a variable into different components, I don't know if it is possible in Power BI. I tried to do it a little bit, but it was not easy. So, it is good when you have the data, and you just want to present it and look at it in different ways, but if you want to analyze the data and break down the numbers and play around with the data, I don't know if it is possible in Power BI.

    I would rate Power BI a seven out of 10.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Lead Senior Engineer at a manufacturing company with 10,001+ employees
    Real User
    Stable, scalable and well suited for specific applications
    Pros and Cons
    • "We have found the product to be scalable."
    • "If you need data in real-time, it's not an ideal solution."

    What is our primary use case?

    The solution is basically used for data. It's on a proprietary piece of equipment on which we collect data. We look at impurities in molten metal, and it's a database and it keeps track of all the batches that we have through the furnace that we have. It tells when it's dirty and stuff like that. It's a large database that we keep track of the history of all the ingots that we run.

    What is most valuable?

    The solution serves its purpose. When you have the recurring cost every year on this other project, Qlik Sense didn't fit with it as you'd have to have Qlik Sense plus something else. 

    As long as you don't need the data in real-time, it's okay.

    The solution is stable.

    We have found the product to be scalable. 

    What needs improvement?

    We looked at it for these two new projects too, however, we needed more real-time data on this other project and so it wasn't a good solution and we thought Qlik Sense would work better.

    If you need data in real-time, it's not an ideal solution.

    For how long have I used the solution?

    I've dealt with the solution for about a year or so at this point.

    What do I think about the stability of the solution?

    From what I have seen, the solution seems to be very stable. There are no bugs or glitches and it doesn't crash or freeze. It's reliable. 

    What do I think about the scalability of the solution?

    The scalability of the product has been fine. We can expand it if we want to.

    How are customer service and technical support?

    I've never contacted technical support. I cannot speak to how helpful or responsive they are. 

    Which solution did I use previously and why did I switch?

    We have more of an industrial type application and we're going to have Tulip interface with Qlik Sense or we're just going to use Domo's platform. Domo is more expensive, a little bit more expensive, however, one of my colleagues here already used Domo and he really liked it, so we're gearing towards Domo. We haven't purchased it yet.

    Which other solutions did I evaluate?

    We looked at Qlik Sense. However, when you have the recurring cost every year on this other project, Qlik Sense didn't fit with it because you'd have to have Qlik Sense plus something else.

    What other advice do I have?

    Our corporate office may have some sort of agreement with Microsoft. We're just an end-user.

    Corporate is kind of pushing Microsoft BI, and they have questions about using it for this project, however, we had an IT consultant that said it's not a good solution.

    I would rate the solution at an eight out of ten. It's not ideal for every application, however, it works pretty well.

    Which deployment model are you using for this solution?

    Public Cloud

    If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

    Microsoft Azure
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Owner at BNS
    Real User
    Reliable with good reporting, easy to setup, can capable of scaling
    Pros and Cons
    • "The reports are easy to create."
    • "The orchestration module for refreshing data flows is something that is missing and we have to do it manually."

    What is our primary use case?

    We are software developers. We generate data using the basic data connectors that Microsoft provides. We just follow the importing and exporting data around, the Azure platform.

    We are doing C# development. We use an SQL server, and we use Power BI. Those are the main three technologies, and then it's just Microsoft to put it together.

    We use this solution to create business intelligence reports for the executive users of our applications. We are creating standard business applications like ERP and CRM and e-commerce type applications. Then, we extract a sample of the data, build a simple data warehouse, in the Power BI service, and create some BI reports.

    What is most valuable?

    The data visualisation is very attractive from the user's point of view. Users see their reports and think "Wow - that is amazing". 

    However, it is much harder to prepare data for reporting. I would say 95% of your development time is spent gathering, cleaning, and modelling data. However once that is done reporting is easy.

    What needs improvement?

    The capacity needs improvement. It is limited in its capacity in power.

    Some of its features are incredibly difficult to understand. There is a learning curve to do the more sophisticated things. For example, paginated reports are complicated. But in general, Power BI, it's not an end-user tool, however much Microsoft pretended it is. We just treat it is like another tool that we use and we deliver the reports to our clients.

    The orchestration module for refreshing data flows is something that is missing and we have to do it manually. It should be one of the admin features of Microsoft BI.

    For how long have I used the solution?

    I have been working with Microsoft BI for 15 months.

    We are using the latest version.

    What do I think about the stability of the solution?

    It is a reliable solution. 

    What do I think about the scalability of the solution?

    I haven't tried to scale it, but in theory, I know that is capable. Power BI Premium is easy to scale as long as you have the money.

    Inside the business, we only have one user, and outside the business, we have our clients where we have four developers who use this solution.

    Our clients are medium-sized companies with 50 to 100 users.

    How are customer service and technical support?

    I have not contacted technical support. Google provides the information that we need.

    How was the initial setup?

    The initial setup is straightforward.

    It can take a couple of hours to deploy the gateways, then there is the development of it.

    It doesn't require maintenance, but we are forever enhancing the reports. In general, it works without problems.

    What about the implementation team?

    We are developers, we can complete the installation ourselves.

    What's my experience with pricing, setup cost, and licensing?

    We view it as an expensive product. 

    Most of our clients cannot afford the premium capacity. 

    We just make do with Power BI pro features, which is always a big shame because we know that the premium version has a lot of features that we would like to use, and are not available to us.

    There are a few different licensing models.

    It ends up being complicated and people don't like paying for things. It's okay if you're working for a large corporation because they can obviously spend thousands of pounds every month on licenses, but our customers cannot.

    Licensing is paid on a monthly basis.

    What other advice do I have?

    Power BI has approximately 20 new features that come out every month. You just have to be patient and eventually, the features come out.

    My advice to others would be to do your homework. It's one of those things where you have to get past the marketing. The marketing message is not helpful.

    I would suggest that if you are going to use Power BI, you need to use developers who understand what it can do, what it can't do, and how it works. 

    Then they will then guide you to say, this is the type of report you can expect. 

    It took me a long time to realize what you can and cannot do with Power BI.

    That's why I suggest doing your homework first. It's not as wonderful as Microsoft pretends it to be, but it's not bad, and I am not knocking it, but you have to cut out all the hype that comes with it.

    I would rate Microsoft BI a nine out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
    PeerSpot user
    PMO at a consultancy with 10,001+ employees
    Real User
    Highly performance, easy to use, but needs more data flexibility
    Pros and Cons
    • "What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
    • "In the future, Microsoft BI can be better by increasing user-friendliness"

    What is our primary use case?

    I use Microsoft BI for the reports and our displaying the data in different ways. As a project manager, I need to follow the budget and receive confirmation about our projects. We have an SAP database and we follow and check all the budget data of the project including data usage.

    What is most valuable?

    What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand.

    What needs improvement?

    The solution could improve by having more options to manipulate the views of the data on the dashboards. I sometimes need to make them myself but there should be more customizable with drag-and-drop elements and filters on that data differently than it was designed. There are filters in the design stage but there are times you need something else other than how it was designed. For example, if you did not have some of the information at the time of the design. Having the ability to design, or request the data from the database as an end-user is very important. It would be beneficial to have more autonomy on the design of the requested data. You are not able to change the fields or the request data because it was done in the backend and you are not able to see how that request happened. Sometimes you need to make your own requests or have different requests regarding the data. We do not have access because we are not administrators.

    In the future, Microsoft BI can be better by increasing user-friendliness.

    For how long have I used the solution?

    I have been using this solution for approximately three years.

    What do I think about the stability of the solution?

    The solution is stable.

    What do I think about the scalability of the solution?

    I have found it to be scalable.

    We have approximately 1,000 people using the solution in my organization.

    Which solution did I use previously and why did I switch?

    I have previously used QlikView and Qlik Sense.

    What other advice do I have?

    I would recommend this solution to others.

    I rate Microsoft BI a seven out of ten.

    Which deployment model are you using for this solution?

    Public Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Managing Director at Streamline Strategies
    Reseller
    Easy to use, integrates well, and gives us the ability to collaborate and keep track of everything
    Pros and Cons
    • "It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view."
    • "Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop."

    What is our primary use case?

    We are using it for financial analytics and reporting. We are using it to keep a track of projects and being able to degrade the projects. We are also using it for contract closeout.

    My technical guy has been using the first version of it since it came out, but we are getting ready to upgrade to the newer version. It comes along in a bundle with the 365 Enterprise version.

    It is on the cloud. We're probably going to run a hybrid because we want to be able to move around. If anything happens or if needed, we can move from platform to platform.

    How has it helped my organization?

    We can see things from a bird's eye view. We can do predictive analytics. I can tell who's capable, who's doing what, when and how much money they're spending, and how fast they're burning. So, it gives us a bird's eye view over the financials and the money. It basically gives us the ability to collaborate and keep track of everything that's going on in an organization. We were able to bring all the collaboration and tasks right into Power BI.

    What is most valuable?

    It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view. We publish a report every morning for the government, and we got all the data into one place. The data can be refreshed. We are using the API to connect to various systems, such as the financial system, contract writing system, and workflow. We are able to bring things from NIPA, which is their budget and where they keep all their money. There are a lot of features, but the most important thing is it is very easy to use. It is not like Tableau. With Tableau, you've almost got to be a rocket scientist.

    On the user side, it is quite simple. If you know how to run a pivot table, and then you can do almost anything. All the data is right there in the database. So, if you understand pivot tables and know how they are run, and you know the reports that you are looking for, then everything becomes very easy to run in your organization.

    What needs improvement?

    Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop.

    For how long have I used the solution?

    We've been using Microsoft BI for about four and a half years.

    What do I think about the stability of the solution?

    Its stability is pretty good. It is pretty stable.

    What do I think about the scalability of the solution?

    I would rate it an eight out of 10 in terms of scalability. Currently, we are running a pilot. We're doing a pilot for army headquarters. They dictate what happens and what they use. Currently, there are 10 users, but I'm looking to go up to at least a hundred. 

    We got an architect and an assistant administrator. We got a staff of three and a half people because people take vacations or sick leaves. The good part about it is that these people can work from anywhere.

    How are customer service and technical support?

    We are a Microsoft reseller. We have partnered with Microsoft. We have developed a relationship with their technical folks over the years. So, we kind of go directly to them. My partner came from Microsoft, so he has a very good relationship with a few technical folks. So, we, kind of, have some special privileges that a couple of other vendors don't have.

    Which solution did I use previously and why did I switch?

    As a matter of fact, we had built a tool, but it took so long to get it vetted and get it through to ATOs. That's when we decided to convert to Microsoft Power BI. It has already been vetted and approved in the army environment. It is an approved government site for cloud services. We were looking for the easiest path, and that's why we worked with Microsoft BI. They've already been embedded into the government. It is bundled with Office 365.

    How was the initial setup?

    If my technical person had to rate it, he would say very easy. All we need is to have the software.

    What about the implementation team?

    It was done in-house.

    What's my experience with pricing, setup cost, and licensing?

    They are charging us by users in storage, and there is a license fee. My financial people handle all that. The client has already worked out a contract with Microsoft, and basically, we're getting government prices.

    What other advice do I have?

    The backend is the most important part. We understand its backend. We implemented the on-time system for an airport. We don't find its modeling complicated. We set up the back offices and get all the modeling done and everything connected. The customer doesn't even see that. They only see the part where they're running their reports and doing the analytics or whatever they need to do. We give them all the information at their fingertips.

    Everybody is going to Business Analytics. A lot of people don't understand the difference between analytics and coding, but that's something for me to teach and educate them on.

    I would advise doing your testing and environment setup. You should evaluate your product very well and figure out what platform your organization is running on. You should be careful and look at how well it integrates with other products. If you're not in a Microsoft environment, it is going to be quite difficult. Oracle and Microsoft are competitive. So, you go with one or the other. The reason why I like Microsoft is that they integrate with all applications. Microsoft controls 99% of the desktops.

    I would rate Microsoft BI a nine out of 10.

    Which deployment model are you using for this solution?

    Private Cloud

    If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

    Microsoft Azure
    Disclosure: My company has a business relationship with this vendor other than being a customer:
    PeerSpot user
    Project Business Analyst RPA at a consultancy with 11-50 employees
    Real User
    Compatibility with different databases, complete tool, helpful technical support
    Pros and Cons
    • "The most useful features are the ability to connect different databases to Microsoft BI and explore them. Once the database information has been extracted, you have the ability to construct indicators and dashboards from the information."
    • "The solution could improve by simplifying the user interface and adding integration or compatibility with APA."

    What is our primary use case?

    We use Microsoft BI primarily for analyzing data to construct indicators and dashboards. We use the information to better understand our business to make effective decisions about our business for the future, such as keeping competitive with other companies.

    What is most valuable?

    The most useful features are the ability to connect different databases to Microsoft BI and explore them. Once the database information has been extracted, you have the ability to construct indicators and dashboards from the information.

    Microsoft BI is a complete tool, it has all the functions needed for its purpose.

    What needs improvement?

    The solution could improve by simplifying the user interface and adding integration or compatibility with APA.

    For how long have I used the solution?

    I have been using Microsoft BI for many years.

    What do I think about the stability of the solution?

    The solution is stable.

    What do I think about the scalability of the solution?

    The solution is scalable. We are able to see the users and the capability from the cloud platform.

    How are customer service and technical support?

    Microsoft provides good technical support.

    How was the initial setup?

    The installation is easy. However, there are many options and areas to configure that can be difficult.

    What other advice do I have?

    I would recommend those wanting to use this solution to take some courses to at least learn the minimal knowledge to analyze and construct indicators. This is a very powerful tool and if you understand it you can get the most out of it.

    I rate Microsoft BI a nine out of ten.

    Which deployment model are you using for this solution?

    Public Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    BI Solution Engineer at DataSelf
    Reseller
    Easy to use for buildings charts and graphs and doing calculations
    Pros and Cons
    • "It is a little easier at buildings charts and graphs than Tableau."
    • "It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."

    What is our primary use case?

    I've been a consultant, so I've built some reports for some clients. I use and prefer its desktop version. 

    What is most valuable?

    It is a little easier at buildings charts and graphs than Tableau.

    What needs improvement?

    At the enterprise level, it is a little expensive. To get the full capacity of integrations, you need to go premium.

    It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases. 

    For how long have I used the solution?

    I've been in the Business Intelligence Industry for about seven years. I use this product off and on.

    What do I think about the scalability of the solution?

    It is complex to scale. There are just too many things you have to put in place. You got to have the gateways, and you got to have the premium service. There are a lot of components that get involved. It is not very straightforward. 

    We sell our own BI tool. So, we have hundreds of clients. They are mid-sized organizations. We're building out our Power BI stack because people do like it, but right now, we have most of our stuff in Tableau.

    Which solution did I use previously and why did I switch?

    I also use Tableau. They're very comparable products. I worked for different companies that built their own proprietary stuff, and mainly for visualization, Tableau and Power BI were the connectors to go to. So, there wasn't a switch.

    I really like Tableau's web version over Power BI's web version. It is just easier to drag and drop things and blend data on the backend. It has a little simpler process in that regard. I don't like the charting in Tableau. Its charting is a little more complex than Power BI's charting.

    Calculations are a little harder in Tableau. They can be a little more complex in Tableau as compared to Power BI. Tableau is a little more detailed in terms of creating calculations. You can't just add two columns together. Tableau should have the ability to add or subtract columns. They should make it like a wizard.

    How was the initial setup?

    The simple stuff is easy. When you want to get into the calculations and building DAX-type formulas, I don't think DAX is that great. I find Tableau's coding a little easier.

    What's my experience with pricing, setup cost, and licensing?

    Its pricing is reasonable for the desktop stuff, but for enterprise-level, it is a little expensive. 

    What other advice do I have?

    I would advise others to just do their research and figure out what they want to do with it so that they know if it is going to be hard or easy.

    I would rate Microsoft BI an eight out of 10.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: My company has a business relationship with this vendor other than being a customer:
    PeerSpot user
    OBIEE/ODI senior consultant at Kastech
    Real User
    A stable and scalable solution with good tech support
    Pros and Cons
    • "The visualization part and its inclusion in a cloud-based application are valuable features."
    • "The solution is somewhat costly in comparison with MSBI tools."

    What is most valuable?

    The visualization part and its inclusion in a cloud-based application are valuable features. 

    What needs improvement?

    The solution is somewhat costly in comparison with MSBI tools. 

    In MSBI, when it comes to mobile and maps-related applications, we are always looking for some support with the reporting tools. Once we click on the region, then automatically it goes to the two area maps. Based on the map, it will reinforce our data values. There is constant change involved and new updates and enhancements are coming out as needed in new versions. 

    What do I think about the stability of the solution?

    The solution performs well and is stable. 

    What do I think about the scalability of the solution?

    The scalability is very good and use of the application is flexible. 

    How are customer service and technical support?

    We can create certain tickets, contact them and explain our requirements and they will look into the issue and help us to find a workaround for us to implement. They will address the issue in the next version. 

    We are very satisfied with their support. 

    What about the implementation team?

    We are implementers of this solution and maintain the visualization on the reporting parts, as well as fulfill the business requirements. 

    What's my experience with pricing, setup cost, and licensing?

    The solution is less expensive than other PowerBI tools, but more so than those of MSBI. 

    Which other solutions did I evaluate?

    The solution is less expensive than other PowerBI tools, which is why most people go with it, although it does cost more than MSBI tools. It has good feasibility for fulfilling one's business needs. PowerBI is very strong in the market at the moment and we are creating visualization that works. It is a stable tool, as well. 

    What other advice do I have?

    While PowerBI is cloud-based, it can be used both on-and-off-premises. MSBI can also be implemented on-premises. PowerBI mostly involves visualization. 

    I rate Microsoft BI as an eight out of ten. 

    Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
    PeerSpot user
    Solutions Architect at a tech services company with 11-50 employees
    Real User
    Easy to learn with good data preparation features and good stability
    Pros and Cons
    • "As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools."
    • "The one thing that I noticed specifically was the graphical features, and some of the analytical features. They were stronger on the Tableau side."

    What is our primary use case?

    There were two systems that the client was looking at creating some BI visualizations for. There was the system called ICE, which is a system that takes in automated calls, for service calls. They go into voicemail, however, if there's not an agent to take the call, it'll track statistics like how long a client was on hold, if an agent actually took the call, if the person hung up, et cetera. There are all of these different statuses and it would take all of those statistics. The product was used primarily to take that data in that case.

    The other system was an ITSM system, which was the ticketing system. It would

    it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools. But the one thing that I noticed specifically was the graphical features, and some of the analytical features, I think they were stronger on the Tableau side. But the data preparation features, I much preferred the Power BI with the Power Query type features, at least for the datasets that we were working with. They were helpful in preparing the data.

     combine those two data sets and reduce a merged analytical set of reports to just show when the call volumes were and what the performance rate was and the nature of the calls and things like that.

    What is most valuable?

    As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools. 

    The data preparation features were great. I much preferred the Power BI with the Power Query type features - at least for the datasets that we were working with. They were helpful in preparing the data.

    What needs improvement?

    The one thing that I noticed specifically was the graphical features, and some of the analytical features. They were stronger on the Tableau side.

    There are two areas where the solution can be enhanced. One is natural language, where you can have third parties, however, it would be nice to have it built-in within Power BI, where a graph could be automatically explained in whatever language so that somebody can just kind of read through and have the graphic as an extra for exploring. That's something that I was looking at.

    The other is the explained data, which is more of a lineage-type feature. My understanding is Tableau has that feature and Power BI doesn't. I was looking at a graph of comparisons and I noticed Tableau had this explained data feature, which gives, some lineage where data has come from, and Power BI doesn't have that. Or, if it does, it's not as well developed as Tableau.

    For how long have I used the solution?

    I used the solution a few months ago. I'm semi-retired, however, I did have a two-month contract and did some work with it. On the project, I did work a lot with Tableau, however, I also used Power BI, and would like to continue to use it more. 

    What do I think about the stability of the solution?

    It was a short project on the Power BI side. I didn't really identify any glitches. Certainly, over time things might've come out, however, I enjoy doing experimenting and playing around with things. The one definite thing that I noticed, as I do art with Tableau, is some really neat art stuff, so I tried to replicate that with Power BI and the quality just wasn't there.

    What do I think about the scalability of the solution?

    With ITSM, there's a lot of data that they collect on that side. That could be an issue, scalability. It wasn't moved to production yet. I basically produced a report as there were some issues with the ICE data, the voicemail system, and data collection. They had some issues that they had to solve. However, they were collecting data on a daily basis. You get thousands and thousands of calls on a daily basis. It depends on how they want to store that data historically. There may be some performance issues and scalability issues, however, for me, I can't really address that, as I didn't see that side. There's always a potential for trouble.

    How are customer service and technical support?

    It was a really short project for me. I was really there just to analyze those two data sources and produce a report for them, with some examples, using Power BI. I was able to do that without getting tech support involved.

    Which solution did I use previously and why did I switch?

    I've used other solutions, such as Tableau and Power Query. Tableau from a graphical point of view is much better than Power BI, however, from a data manipulation standpoint and things like that, I prefer Power BI and Power Query to prep the data.

    Tableau got bought out by Salesforce, which is a cloud-based company, so they're all going to push everything to the cloud. I'm sure they'll incorporate all these new features.

    How was the initial setup?

    I downloaded the solution from their website. 

    The server side was already set up, therefore, I don't know much about the initial setup process. As a contractor, I came in just on the development side, which was just downloading the Power BI tool as a client. It was fairly easy. That's the nice thing is it's easy to set up. It is similar to Tableau, in that Tableau is fairly easy to set up. It is all built towards this whole idea of self-service.

    What other advice do I have?

    I'm just a customer.

    As I downloaded the solution right off the website, I assume it was the latest version. I don't know the version number off-hand. 

    I would do the development on-pre

    There were two systems that they were looking at creating some BI visualizations for. So there was the system called ICE, which is a system that takes in automated calls, for service calls. And so goes into voicemail, but if there's not an agent to take the call, it'll track statistics like how long you were on hold, if an agent actually took your call, if you hung up. All of these different statuses would take all of those statistics. And so it was to take that data.

    And the other system was the ITSM system, which is the ticketing system. And kind of combine those two data sets and reduce a merged analytical set of reports to just show when were the call volumes were, and what was the performance rate, and the nature of the calls and things like that.

    It's easy to set up, however, regarding scalability and high-end analytical features, Tableau is still better on that. It's always important to keep up, as technology's changing all the time. They're always adding new features. There are no negatives in exploring these tools. In the end, you just want some visualizations that help you make decisions. Both Tableau and Power BI tools are great for that. However, if you want advanced stuff, then it's just about experimenting and seeing what will help you solve your problems.

    I'd rate the solution at an eight out of ten.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Portfolio manager at a transportation company with 5,001-10,000 employees
    Real User
    Great for visualizing data with good flexibility and an excellent dashboard
    Pros and Cons
    • "The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
    • "It's quite difficult to learn how to use Power BI."

    What is most valuable?

    Microsoft Power BI is a very powerful tool. It allows us to extract data from Excel or Share Point. 

    We can send various project reports from the dashboard to management. It allows us to set up our own preferences. 

    We can work with all sorts of data from the previous year or two. With that native data, we can have everything in one dashboard that accurately reflects the reporting. The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible. 

    The solution has been very stable so far.

    We find the product to be quite scalable. 

    What needs improvement?

    It's quite difficult to learn how to use Power BI. I'm not from the IT background, and I've been given the license to use the Power BI, however, I find that the support and video demos from Microsoft are not really helpful for me. I don't handle Microsoft BI 24/7. My working time isn't dedicated to using it and learning it. I need it for certain tasks and trying to wrap my head around it, while also handling other duties is difficult. There's too much of a learning curve for beginners.

    The cost of the solution is high.

    For how long have I used the solution?

    We originally started our migration back at the end of 2019. We've used it for a year or two now.

    What do I think about the stability of the solution?

    The product is stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

    What do I think about the scalability of the solution?

    The solution can scale. If a company needs to expand it, it can do so. It's not a problem. 

    Right now, in our organization, only 15 of us have the full license for the Power BI Pro. Not everyone in the office actually uses it. However, we have over 1,000 people using various other Microsoft products in our company.

    How was the initial setup?

    As I am not technical, I did not handle the initial setup. We have IT personnel within our organization that handled it. I just gave them my laptop, and they just installed it for me. Occasionally, they can also do it remotely from their office to our office. I never touch it. We just open the apps from the desktop. The process, when do that way, i's quite convenient. It's quite easy for end-users.

    What about the implementation team?

    We have our own IT team that handles the installation. They either take the laptop or do the installation remotely. In either case, it's handled in-house and not by integrators or consultants. 

    What's my experience with pricing, setup cost, and licensing?

    The solution is quite expensive. 

    What other advice do I have?

    I'm an end-user of the product, however, I'm not overly technical or in IT.

    We have a custom Microsoft setup. We are using a few apps from Microsoft, such as the Microsoft Plan, and we are using Power BI, Power Automate, et cetera. It's all from Microsoft, and it is part of our IT infrastructure. When we combine it together, it is a project and portfolio management solution. It is not a commercial, off-the-shelf product. 

    I'm not sure which version number we are using. 

    I'd rate the solution at a nine out of ten.

    In terms of Microsoft Power BI, for all people who need to do their own reporting or want to visualize their daily work or tasks, in terms of projection, giving others a view on what they are doing, it's a very good tool. It allows users to show projections of what we are doing. Users can grab statistics, which is quite convenient, and understand what they are doing from a visual perspective, which we find quite useful.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Junior Data Scientist at a university with 5,001-10,000 employees
    Real User
    Good transforming of data for visualization, useful, stable, and scalable
    Pros and Cons
    • "It is quite easy to use and it helps me to achieve the projects that I've been assigned."
    • "I feel the modeling page should be simplified."

    What is our primary use case?

    We use Microsoft BI typically to clean up data in Excel, as well as to create reports for my supervisor that will be analyzed and then used to draw conclusions.

    How has it helped my organization?

    It provides the common ground for data to be cleaned. We use this for everyone to work on cleaning up data in order to use it for visualizations, which has been helpful.

    What is most valuable?

    The transforming data before you start with the visualization comes in pretty handy.

    It is quite easy to use and it helps me to achieve the projects that I've been assigned.

    I have never had the inability to perform the tasks I've been assigned with the software. 

    It's very useful because you can create helpful reports, which assist you to analyze data in a very organized way.

    What needs improvement?

    I feel the modeling page should be simplified. The links between different parts of your data, on the models' page, are a bit confusing. It was difficult for me to learn. 

    For how long have I used the solution?

    I have been using Microsoft BI for three months.

    We are using an older version specific to the organization.

    What do I think about the stability of the solution?

    Microsoft BI is a stable product.

    What do I think about the scalability of the solution?

    Microsoft BI is quite scalable, especially with the number of coding languages that are available to use.

    We have approximately 23 data scientists in our organization who are using this solution. We use it extensively.

    We are mostly using Microsoft BI but we are trying to bring in Tableau and maximize the potential of both.

    How are customer service and technical support?

    I have not contacted technical support.

    Which solution did I use previously and why did I switch?

    I also have experience with Tableau.

    How was the initial setup?

    When I arrived, this solution was already set up.

    What other advice do I have?

    For others who want to start using Microsoft BI, I would say go through some tutorials on your own first and then try and practice with practice data sets that are available online. Also, feel free to play around with the different tools, and the different visualizations, because you can use them differently for different things.

    I would rate Microsoft BI a nine out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Strategic Market Development Sr. Manager at a pharma/biotech company with 201-500 employees
    Real User
    Easy to use, flexible, but mobile application needs improvement
    Pros and Cons
    • "The solution is easy to use and flexible."
    • "The solution could improve the mobile application design. It is difficult to use compared to the desktop version."

    What is our primary use case?

    I am using this solution to monitor the dashboards that someone else has created.

    What is most valuable?

    The solution is easy to use and flexible.

    What needs improvement?

    The solution could improve the mobile application design. It is difficult to use compared to the desktop version. Additionally, we have experienced a problem when attempting to update the desktop application. When we click to update we are unable to open the file to update.

    For how long have I used the solution?

    I have been using this solution for approximately two years.

    What do I think about the stability of the solution?

    I have found the solution to be stable.

    What do I think about the scalability of the solution?

    We have approximately 50 people using this solution in my organization.

    Which solution did I use previously and why did I switch?

    I have previously used Microsoft Excel.

    How was the initial setup?

    The installation was simple and it takes approximately five minutes.

    What about the implementation team?

    I did the implementation of the solution.

    What's my experience with pricing, setup cost, and licensing?

    We have a professional license for Microsoft BI and the price is fair. 

    What other advice do I have?

    I would recommend this solution to others.

    I rate Microsoft BI a seven out of ten.

    Which deployment model are you using for this solution?

    Public Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Manager - Customer Success at a tech services company with 10,001+ employees
    Real User
    User-friendly and easy to install but isn't very scalable
    Pros and Cons
    • "The product is stable."
    • "My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset."

    What is our primary use case?

    We primarily use the solution for analysis. I have a DB setup that I have. I use that DB for analyzing data, providing business solutions or business insights to the customers. Most of the time, I use Power BI for that or sometimes even Tableau.

    What is most valuable?

    The solution isn't hard to use. It's very user-friendly. 

    The product is stable. 

    The product is easy to install.

    What needs improvement?

    I haven't used the advanced version and therefore haven't accessed all of the features.

    The solution isn't very scalable. My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset.

    For how long have I used the solution?

    I've been using the solution for two years. 

    What do I think about the stability of the solution?

    The stability of the product is good. It doesn't crash or freeze. there are no bugs or glitches. It's reliable. 

    What do I think about the scalability of the solution?

    I wouldn't describe the solution as scalable. 

    While it is available as an option to most people in our organization, I'm not sure how many people are actually actively using it. I know that I use it myself quite often. 

    How are customer service and technical support?

    I've never reached out to technical support for assistance. I cannot speak to how helpful or responsive they are. 

    Which solution did I use previously and why did I switch?

    I also use Tableau. I've used Tableau for about seven months. 

    There are other programming languages like Python and R, where they use analytics for graphical representation, or they can use Power BI and Tableau in our company. There are many options.

    How was the initial setup?

    The installation is not complex or difficult. It's straightforward. 

    We have Office 365, which holds Power BI, and therefore I was able to have it easily installed.

    I can't recall how long the deployment actually took. 

    What's my experience with pricing, setup cost, and licensing?

    I personally do not pay for a license. It may be arranged through our company. I have no insights into that aspect of the solution, however. 

    What other advice do I have?

    I'm a customer and an end-user.

    The solution, being on the cloud, is automatically updated, and therefore, you are always on the latest version if you are using it. 

    I'd rate the solution at a seven out of ten.

    I'd recommend the product to those who want a basic tool that can help them study analytics.

    Which deployment model are you using for this solution?

    Public Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Engagement Professional at a consultancy with 51-200 employees
    Real User
    An intuitive business analytics service with tons of connections
    Pros and Cons
    • "The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive."
    • "It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."

    What is our primary use case?

    I have used Microsoft BI for sales analysis. I've also used it to analyze people. Pretty much across the board, whether it's the number of people, number of dresses, number of hamburgers, number of widgets and then creating the dashboards and the metrics and so forth.

    What is most valuable?

    The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive.

    What needs improvement?

    It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI.

    For how long have I used the solution?

    I have used Microsoft BI over the last 12 months.

    What do I think about the stability of the solution?

    I haven't really had any issues, but I haven't given it the full whammy or the full monty. It's been stable for my use.

    How was the initial setup?

    The initial setup was easy for me.

    What other advice do I have?

    I would tell potential users that there are many other tools out there, but I think it's a steep learning curve. For example, Alteryx and Domo, and Trifacta can be difficult to learn unless you have a SQL background. But if you're a Microsoft person, the transition is fairly easy for Microsoft BI. It's intuitive, and I would recommend it from that perspective. 

    On a scale from one to ten, I would give Microsoft BI an eight.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Senior Manager Analytic & Insights at a hospitality company with 10,001+ employees
    Real User
    Flexible, easy to scale, good reporting, and good support
    Pros and Cons
    • "The visualization and reporting are the most valuable features of this solution."
    • "This solution is resource-heavy."

    What is most valuable?

    The visualization and reporting are the most valuable features of this solution.

    It is quite flexible for reporting purposes.

    What needs improvement?

    This solution is resource-heavy. I would like to see it consume fewer resources. When I use it on my laptop, it consumes a lot of resources.

    For how long have I used the solution?

    I have used this solution within the last 12 months.

    We are using the latest version.

    What do I think about the scalability of the solution?

    It can scale easily.

    We have more than 50 people who are using this solution in my company. Across the company, most are in marketing and finance.

    How are customer service and technical support?

    I would rate the technical support an eight out of ten.

    Which solution did I use previously and why did I switch?

    We use Oracle BI and Oracle OBIEE.

    How was the initial setup?

    The initial setup was pretty straightforward.

    What's my experience with pricing, setup cost, and licensing?

    It would be better if the price was cheaper.

    What other advice do I have?

    I would recommend this solution and suggest they use it.

    I would rate this solution an eight out of ten.

    Which deployment model are you using for this solution?

    Private Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Data Warehouse Engineer at a government with 1,001-5,000 employees
    Real User
    Easy to use and flexible but can't handle big data
    Pros and Cons
    • "The product is easy to use and simple to navigate."
    • "The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files."

    What is our primary use case?

    We primarily use the solution primarily for making dashboards. We are also doing analytics on Microsoft BI.

    What is most valuable?

    The solution is very stable.

    The product is easy to use and simple to navigate.

    The product has proven to be quite flexible.

    It is quite scalable and it is doing the work that we want it to. 

    What needs improvement?

    We'd like the solution to be more scalable. 

    We'd like the ability to manage it on the cloud, as a cloud-based solution. It is running out of business as it is not able to keep pace with the big data. Big data is not something that BI can support. It cannot be scaled that much. 

    The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files. Microsoft is aware of this.

    For how long have I used the solution?

    I've been using the solution for seven to eight years at this point. It's been a while. 

    What do I think about the stability of the solution?

    The solution is very stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable and the performance is very good.

    What do I think about the scalability of the solution?

    The solution is quite scalable, although, in our case, as we are not on the cloud, we are facing some issues.

    We have more than ten people using the solution currently.

    How are customer service and technical support?

    I've never reached out to technical support in the past. I cannot speak to how helpful or responsive they are. 

    How was the initial setup?

    I wasn't a part of the initial setup. That was something that was handled by another team. I can't speak to how long it took to deploy.

    My understanding is that you only need two people to deploy the solution. Admins usually handle it.

    What's my experience with pricing, setup cost, and licensing?

    I don't have any insights into the licensing and payments required. 

    What other advice do I have?

    We are using the latest version of the solution. I'm not sure of the exact version number. 

    I'd rate the solution at a seven out of ten. For us, it has met our expectations and we enjoy its capabilities.

    I'd recommend this product to other users and organizations.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Senior Operations Coordinator at CambriLearn
    Real User
    Useful Natural Language feature, reliable, and good technical support
    Pros and Cons
    • "I have found the most valuable feature of this solution is the Natural Language tool."
    • "The solution could benefit by allowing deeper data analytics."

    What is most valuable?

    I have found the most valuable feature of this solution is the Natural Language tool.

    What needs improvement?

    The solution could benefit by allowing deeper data analytics.

    For how long have I used the solution?

    I have been using Microsoft BI for approximately four years.

    What do I think about the stability of the solution?

    The solution is stable.

    How are customer service and technical support?

    I was satisfied with the technical support.

    What other advice do I have?

    I rate Microsoft BI an eight out of ten.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
    Real User
    Leaderboard
    Scalable, easy to learn, and integrates well with the entire Microsoft Office Suite
    Pros and Cons
    • "The initial setup is straightforward."
    • "Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik."

    What is our primary use case?

    I mainly use it for sales analysis. We are in the telecom industry, so on a daily basis, we see a couple of trends in the number of activations of customers and registration, the performance of the dealer, and items like that.

    What is most valuable?

    Its integration with the Microsoft Office Suite is great. I can easily connect it to any of the Excel or any CSV files, and I can immediately create a dashboard. 

    It's like the higher level of pivot tables. For the people who mainly use Excel, this is like an advanced version. This is much more flexible and I don't have to train people to use it, as it's very user-friendly compared to Qlik. Qlik needs some expertise and a layman cannot immediately go to Qlik and do stuff unless he understands it. When it comes to Power BI it's a five minutes tutorial, he can definitely understand what needs to be done.

    The solution is stable and scalable. So far I don't have any issues, however, it depends on the amount of data we use. I'm just running it on my PC.

    The initial setup is straightforward. 

    The solution is free as it's bundled with Office 365.

    What needs improvement?

    Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik. 

    They could also improve the mobile experience. If people are using this mobile app for BI, they need better performance there. The rendering of the objects, for example, if you create the dashboard on Power BI when someone sees that on the app, it comes in a different format. They can do some enhancements there to standardize it.

    Once we expand it as a centralized repository, if I could find much more use cases, that would be ideal. However, now it's very limited in our organization.

    For how long have I used the solution?

    We don't use the solution filly and don't yet have a license for it. That said, I've had the chance to work with it for more than a year now.

    What do I think about the stability of the solution?

    The solution is stable. There are no bugs or glitches and we don't have any trouble with it crashing or freezing. It's reliable and the performance is good. 

    What do I think about the scalability of the solution?

    My understanding is that the solution is scalable. 

    I can easily load a billion rows in less than two or three minutes and play around with it. However, I haven't tested on big data files or anything like that.

    Right now, we don't have too many users. It's just three to four people as of now, as our primary BI tool is still Qlik Sense. It's only for ad hoc use cases we use Power BI, and just myself and a couple of team members, as well as the BI specialist, that access it.

    How are customer service and technical support?

    I've never reached out to technical support in the past. If I run into issues, I tend to Google solutions to find answers to my questions. YouTube is also a good resource if you need information.

    Which solution did I use previously and why did I switch?

    We currently use Qlik Sense as our BI product.

    How was the initial setup?

    The initial setup is not complex or difficult. It's simple and straightforward. 

    It took, 10 to 15 minutes, if I remember correctly, to set everything up. It's just a .exe file installing. It's not hard and it's pretty fast.

    What about the implementation team?

    We did not need a consultant or an integrator to handle the implementation. I just played around a bit with it.

    What's my experience with pricing, setup cost, and licensing?

    We don't have a license on Power BI, so we don't publish anything. It's mainly for some ad hoc use cases that we use Power BI format.

    Power BI is free; it comes with Office 365.

    Which other solutions did I evaluate?

    I've currently looked at MicroStrategy and am in the process of comparing a few other products.

    What other advice do I have?

    We are just a customer and an end-user.

    We are using Power BI, however, not to the full scale. It's still unlicensed as of now, and I'm using desktop versions only.

    I don't remember the version, as it comes with Office 365. I didn't give a thought to the version.

    From my experience with the desktop version, I'd rate the solution at a nine out of ten.

    From my experience, I'd recommend the solution to others. 

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Data Scientist at a tech vendor with 201-500 employees
    Real User
    Reports creation easy, useful dashboards, and good online community support
    Pros and Cons
    • "The most valuable features are the easy creation of reports, dashboards, and the ability to perform analysis. It is important for us to create reports because we have some operations during certain hours and we can use this tool to track the information."

      What is our primary use case?

      We are using this solution to create dashboards and reports for business analytics. We are in the early stages of testing and we have yet to determine if we are going to continue using the solution. We have to fully evaluate the solution first.

      How has it helped my organization?

      The use of the dashboards with analytics has helped our organization.

      What is most valuable?

      The most valuable features are the easy creation of reports, dashboards, and the ability to perform analysis. It is important for us to create reports because we have some operations during certain hours and we can use this tool to track the information. Additionally, it is a benefit they are adding more features all the time, such as machine learning.

      For how long have I used the solution?

      I have been using this solution within the past 12 months.

      What do I think about the stability of the solution?

      The solution is stable.

      How are customer service and technical support?

      I never needed to use technical support. However, they have a good online community where I found documentation, a lot of general information, and tutorial videos on YouTube and Google.

      How was the initial setup?

      The installation is simple.

      What's my experience with pricing, setup cost, and licensing?

      The price for this solution is reasonable. However, there is an additional cost if you want to publish the dashboard privately.

      What other advice do I have?

      I rate Microsoft BI a nine out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      VP Cloud Platform
      Real User
      Intuitive with great visuals and good scalability capabilities
      Pros and Cons
      • "Technical support has been great."
      • "Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now."

      What is our primary use case?

      We have a startup focused on analytics around sports and athletes' performance. The data sits in our platform called Hercules, which is exposed through an ODBC connector or API layer. We're currently building a connector to expose that data in a consumable way, inside Power BI (with one connector for Tableau as well). 

      What is most valuable?

      I love the fact that it's got a very intuitive user interface. 

      I like the fact that you can create aggregations and view measures and metrics on the fly. 

      I like the visuals themselves as all of our customers are moving away from Excel and this gives them a very unique way to have their data represented in a more visual manner with active slicing and dicing data right there, with the time dimensions and different dimensions. 

      I also like the automatic refresh mechanism that it can do. You can have the data refresh automatically every 30 minutes, for example.

      The initial setup is pretty simple. 

      The stability has been pretty good.

      The solution can scale.

      Technical support has been great.

      What needs improvement?

      Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now.

      When you're building, the documentation sucks. It's a painful experience to find out how to do things inside the connector framework. 

      I don't like the fact that they need to have a premium excuse to manage larger sets of data. On top of that, there are limitations in building a custom connector. If you want to build a custom connector for your customers, the navigation is flawed. For example, when I build a custom connector to talk to Power BI and report, I want some contextual data of the report, and I want to have what we call incremental refresh. However, incremental refresh right now is only supported in a SQL-based backend. It's not supported for API-based connectors. That's something that we really, really want. We only try to work around it.

      Basically, I would love to see that incremental refresh with API-based connectors. I'd also want the report-based contextual information available inside the connector.

      The licensing is very confusing.

      For how long have I used the solution?

      I've been using the solution since about 2014. I've used it for many years at this point.

      What do I think about the stability of the solution?

      We've found the stability to be fine so far. there are no bugs or glitches. It doesn't crash or freeze. 

      What do I think about the scalability of the solution?

      It's easy to scale if you have the premium model. We just started exploring that right now.

      The clients we have that use it are medium-sized businesses. These are basically soccer clubs or sports clubs, who are internally using it. however, we want to give it to a larger audience. We haven't gone there yet, though likely we will in the future.

      How are customer service and technical support?

      Technical support has been awesome. they are helpful and responsive and we are more than satisfied with the level of service we receive from them.

      Which solution did I use previously and why did I switch?

      I also use Tableau. I've used Power BI to a larger extent than Tableau, however, we have a startup in which we have an audience on BI and we are doing research to see how many of them are on Tableau versus Power BI.

      We didn't previously use a different solution. We started with Power BI because that was one of our device partner's tools of choice. However, we are trying to support Tableau and Power BI now.

      How was the initial setup?

      The setup was pretty straightforward. I mean the setup for the Power BI Desktop. The download is pretty straightforward. Once you get to do more complex things with it, using the gateway and things like that, then it gets a little complex. On top of that, the documentation is difficult. It's there, however, it's difficult to find.

      What's my experience with pricing, setup cost, and licensing?

      The licensing is a little convoluted, and not easy to take advantage of. You're able to scale it in the premium model. However, they are very different versions. There's a difficulty in understanding which one of them applies to you and what the costs would be eventually, and what the performance and thresholds are for each one. The documentation might be there, however, for a small company, in order to find out all the aspects of licensing it's not that easy.

      Which other solutions did I evaluate?

      We've also evaluated Tableau and we use both right now.

      What other advice do I have?

      We are in the startup program for Microsoft.

      I'm on the latest version of the solution. I cannot speak to the exact version number.

      It's deployed on the cloud for automatic refreshment service and it's got a gateway on-prem.

      It's a very good tool to quickly get started and it does scale, however, as you get into the larger deployments and at a larger scale, it's better to involve a Power BI expert or a partner to help you get there.

      I'd rate the solution at an eight out of ten. There's room for improvement from the setup and scale perspective.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Associate at a financial services firm with 10,001+ employees
      Real User
      Affordable but a little complicated to get used to
      Pros and Cons
      • "Connectivity, installation, and configuration are pretty fast and seamless compared to Cognos."
      • "For someone who is new, I think that Power BI can be a little complicated."

      What is most valuable?

      Compared to Cognos, Tableau and Power BI are pretty fast. 

      How was the initial setup?

      The initial setup is very quick. Connectivity, installation, and configuration are pretty fast and seamless compared to CognosPower BI eradicated dependency on a framework model. 

      What's my experience with pricing, setup cost, and licensing?

      Power BI is cheaper than Tableau and Cognos.  Power BI Desktop comes free and the Pro license is $10 per month whereas Tableau desktop would cost you $70 per month. Cognos is mostly suited for large and medium size companies 

      What other advice do I have?

      For someone who is new, I think that Power BI can be a little complicated. Overall, on a scale from one to ten, I would give Power BI a rating of seven. 

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      PeerSpot user
      Senior Manager at a comms service provider with 501-1,000 employees
      Real User
      Top 10
      User-friendly, stable, and integrates well with other data sources
      Pros and Cons
      • "The interface is very easy to use."
      • "The on-premises version lacks some technical features that are available with the Cloud version."

      What is our primary use case?

      We use this solution for our departmental reports, which are accessible from Microsoft Project Server and SharePoint.

      What is most valuable?

      Microsoft BI is very friendly.

      The interface is very easy to use.

      The integration with other data sources is very easy and very handy.

      What needs improvement?

      The on-premises version lacks some technical features that are available with the Cloud version.

      There is definitely room for improvement.

      The visualization is lacking, it needs improvement.

      For how long have I used the solution?

      I have been using Microsoft BI for one year.

      What do I think about the stability of the solution?

      Microsoft BI is a stable solution.

      How are customer service and technical support?

      We have not contacted technical support.

      Which solution did I use previously and why did I switch?

      Previously, we did not use another solution.

      How was the initial setup?

      From a technical perspective, the installation is straightforward.

      It took one week to deploy.

      The deployment was done by the database team.

      You only need one person to maintain this solution.

      Which other solutions did I evaluate?

      We did not evaluate other solutions before choosing Microsoft BI.

      What other advice do I have?

      I would recommend the cloud version of this solution.

      I would rate Microsoft BI an eight out of ten.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      PeerSpot user
      Director at Decision Science
      Real User
      Top 5Leaderboard
      Saves time in preprocessing stage, but it needs to be more user-friendly for non-technical users
      Pros and Cons
      • "I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
      • "Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."

      What is our primary use case?

      Since we are a consulting company, our cases vary from customer to customer and from department to department, but mainly we have found two "standard" cases: Business users connecting to a DWH, or trying to consolidate several Excel workbooks to create business dashboards.

      In the DWH cases, it is simpler since most of the data transformations and modeling are done by IT, but in the 'spreadsheet world', it becomes more complicated.

      Users try to move from a huge table filled with numbers and "color-coded" cells to data visualizations, sometimes not even knowing how to write a simple Excel expression.

      How has it helped my organization?

      The biggest improvement comes from a "do it once, refresh many" concept. The users used to perform a lot of massaging on the data itself prior to the analysis phase. Now, they build their reports and refresh the data, so they have a lot more time to perform analysis, which is the real added value to the business.

      Unlike other tools (like Tableau), getting to this point took a lot of resources in training, but when the users got there, it is a real time saver for them, allowing them to focus more on analysis, not on data manipulation.

      What is most valuable?

      I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story.

      Data Modeling is very simple and powerful for an experienced user, but I think it needs some improvement for the non-technical people. Besides this, it allows us to save a lot of time in data "massaging" prior to the analysis phase.

      Reports are quite easy to build, even when some programming concepts are needed. Some users struggle with DAX a lot!

      What needs improvement?

      I think Power BI needs to focus more on the end-user (i.e. the business user). Solving things in DAX is not a nice approach to a user that has no knowledge of IT nor wants to get it.

      Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product.

      I see a lot of materials on how to go about doing things in Power BI, but Microsoft can add a "learning path". It would instruct users where to start, then what to learn next, etc, to sort out their learning journey.

      For how long have I used the solution?

      I have been using Microsoft BI for ~four years.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Lead Technical Instructor at codehub
      Real User
      A more intuitive solution than the competitors and provides a better understanding of the whole process without needing much code
      Pros and Cons
      • "In contrast to what we were using before I think that Power BI has given us more extensive results."
      • "I would like to see integration with Excel."

      What is our primary use case?

      I'm using the desktop version and collaborating within our company.

      As a training company we wish to analyze the instructions as they relate to our customers. Also, we take certain examples for our classrooms, our training.

      What is most valuable?

      I consider the solution to be quite good. In contrast to what we were using before I think that Power BI has given us more extensive results. It's more intuitive and it is better for understanding the whole process without much code. We're only using the user interface, not writing code.

      We find it to be easier and it provides a better understanding of the results, both for us and our customers.

      What needs improvement?

      I cannot think of anything needing improvement at present and am quite satisfied with what we have, This said, I would like to see integration with Excel. This is because many of our customers like to have their results appear not only on a dashboard, but also in Excel, as they use it extensively. They would approve of the integration. 

      Also, there should be greater functionality from Power BI for the performance of certain complex tasks. Many things are being done with the interface and if we'll want automation to play a role then we will need more flexible programming, such as we have with Data Expressions. The interface must be utilized for carrying out more complex tasks. We wish to automate this using software and programming language. 

      For how long have I used the solution?

      I have been using Microsoft BI for one or two years. 

      How are customer service and technical support?

      I feel the technical support to be fine. We have all the support that we need.

      How was the initial setup?

      Having a proper understanding of how the data is modeled poses the greatest challenge. However, someone who has this should find the installation to be quite straightforward. The initial step involves having an understanding of the data model. 

      I think the setup is quite easy and straightforward. The solution can simply be downloaded  and used. The most difficult thing involves the distillation of SQL Server, not what relates to Power BI.

      What about the implementation team?

      From our side we have around 20 people who are responsible for the deployment and maintenance, although I include in this figure not only the technical but all of the administrative staff. We have the trainers and also the people who are working with the technical support to deliver the training.

      What's my experience with pricing, setup cost, and licensing?

      The cost of the solution is more flexible for us because the desktop is free and we pay as we use it in the cloud.

      The customers have licenses of their own. We use their installations to help them with their work. Usually, these people represent new entries into the company and we give them the initial experience to start working with the software.

      What other advice do I have?

      As I could tell, I feel the solution to be easy. It is very good that all the users, as they use MS SQL, have a product from the same company. It is an overall experience for them to use Power BI.

      We are an end-user and a partner to the vendor. We do training and provide consultations to our customers. 

      We work with companies, around eight in total, and we deal with their employees. Overall, we are talking about approximately 300 people. We give training to the employees of these companies and also provide consultations. 

      I strongly recommend the solution because I think it's a very modern tool and quite easy for all the data analysts and programmers.

      I believe that all of the people who we have mentioned so far are quite satisfied with the solution.

      I rate Microsoft BI as a nine out of ten. 

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Certification Division at a manufacturing company with 11-50 employees
      Real User
      Feature-rich, scalable, and is easy to install
      Pros and Cons
      • "Microsoft BI is scalable."
      • "I would like to see better, undisturbed stability without any interruptions."

      What is our primary use case?

      I am using this solution for official purposes and for my personal needs. I use it to sort my documents.

      What is most valuable?

      I have yet to experience all of the useful applications. I need to experience a lot more.

      What needs improvement?

      I would like to see better, undisturbed stability without any interruptions.

      For how long have I used the solution?

      I have been working with Microsoft products for three decades.

      I believe we are using Version 10.

      What do I think about the stability of the solution?

      Because our internet here is not constant, it fluctuates, which is why I don' use the cloud-based version.

      It is not stable. The stability could be improved.

      What do I think about the scalability of the solution?

      Microsoft BI is scalable.

      We have more than 50 users in our organization. More of the users are technical people.

      How are customer service and technical support?

      We have an IT technical expert in our organization. If we have any issues, he is the person who resolves them.

      How was the initial setup?

      The initial setup is straightforward. It is very easy to install.

      What about the implementation team?

      I completed the installation myself. I did not need the help of an integrator or consultant.

      What's my experience with pricing, setup cost, and licensing?

      I am considering personalization but I don't know what the possibilities and the advantages of it are.

      What other advice do I have?

      I would recommend this solution to others who are considering it.

      I would rate Microsoft BI an eight out of ten.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Data Science Intern at Clockworkx Gmbh
      Real User
      A business analytics solution that handles a large amount of data, but the types of plots you can use are limited
      Pros and Cons
      • "I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
      • "It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."

      What is our primary use case?

      We have some monitoring data from turbines, and we want to plot the data to monitor the health state of turbines in different time stamps. I tried to download some data from the Postgres database and then do some plotting with that. I also tried to link different plots with each other to filter them and things like that.

      What is most valuable?

      I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data.

      What needs improvement?

      It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use.

      For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that.

      Suppose you want to code a plot, Python available. You can code the plot you want, and you don't have to use a predefined one. But when you want to plot it and you want to import like five or ten packages in Python, there are limitations. It doesn't support all the libraries that Python has. Microsoft BI only supports a few, like three or four libraries at most. When I want to use my old code in Power BI, it doesn't handle it, and that was also annoying.

      In the next release, it'll help if they added a coding area where you are more open to make custom things. Especially for a developer, it needs to be improved. For a Power BI person, it's fine, I think, because it doesn't require much technical knowledge, but a developer will need it. Maybe they should create a space for that.

      For how long have I used the solution?

      I have been using Microsoft BI for the last three months. 

      What do I think about the stability of the solution?

      It's stable, but it's so slow. Sometimes it takes some time to respond, especially when you put two or three plots with big data. It becomes very slow.

      How are customer service and technical support?

      I didn't contact technical support as I used the support on the internet. I'm satisfied with the documentation, but I didn't find what I was looking for.

      Which solution did I use previously and why did I switch?

      I was using Dash Open Source, but when I discovered that it would take a lot of time, I wanted to define a platform for that. So, Power BI was the solution. Now I want to try Tableau, but I haven't had a chance to do that yet.

      What's my experience with pricing, setup cost, and licensing?

      I used a two months free trial to see if it had what I needed. I can pay later for a full license, but I don't think I will do that.

      What other advice do I have?

      On a scale from one to ten, I would give Microsoft BI a six.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Associate Director at a tech services company with 51-200 employees
      Real User
      Suitable for smaller businesses, scalable, but large data challenges
      Pros and Cons
      • "In my experience the scalability is good. You are able to increase users and add more data."
      • "When there are large amounts of data being processed there are additional tools needed to handle it."

      What is our primary use case?

      Microsoft BI can be used for business data visualization.

      What needs improvement?

      When there are large amounts of data being processed there are additional tools needed to handle it.

      In an upcoming release, there could be an associative experience, such as in Qlik.

      For how long have I used the solution?

      I have been using this solution for approximately four years.

      What do I think about the stability of the solution?

      The stability is good but as you add more data the stability decreases.

      What do I think about the scalability of the solution?

      In my experience the scalability is good. You are able to increase users and add more data.

      How was the initial setup?

      The initial setup can be easy if you have a small amount of data being used. I have found Qlik is better if you have large amounts of data.

      What about the implementation team?

      We have a team of approximately 20 people that handle BI operations.

      What's my experience with pricing, setup cost, and licensing?

      The solution is priced well for what they offer. However, the premium version is very expensive.

      Which other solutions did I evaluate?

      I have evaluated Tableau and Qlik.

      What other advice do I have?

      I would recommend this solution to those that have smaller businesses where they have lower user numbers and not a lot of data points. If they have a larger business I would choose an alternative, such as Qlik.

      I rate Microsoft BI a seven out of ten.

      Which deployment model are you using for this solution?

      Hybrid Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
      PeerSpot user
      BI technical analyst at a government with 11-50 employees
      Real User
      Priced well, responsive technical support, but needs to be simplified
      Pros and Cons
      • "The scalability is good. We have 20 people in my organization using this solution and plan to increase usage."
      • "In an upcoming release, the solution could be simplified and have a more complete product package rather than a suite of products that we have to put together."

      What is our primary use case?

      This solution can be used for enterprise reporting, ad hoc visualization, and statistical analysis.

      What needs improvement?

      In an upcoming release, the solution could be simplified and have a more complete product package rather than a suite of products that we have to put together.

      For how long have I used the solution?

      I have been using this solution for approximately one year.

      What do I think about the stability of the solution?

      In my experience, I have found this solution scalable.

      What do I think about the scalability of the solution?

      The scalability is good. We have 20 people in my organization using this solution and plan to increase usage.

      How are customer service and technical support?

      The technical support has been good and the responses have been fast.

      Which solution did I use previously and why did I switch?

      I have used other business intelligence solutions previously and I switched because this solution was cheaper and is on a Microsft platform.

      How was the initial setup?

      The initial setup is more complicated than other solutions. Microsoft typically has more involved installations. 

      What about the implementation team?

      I did the implementation myself. We have three administrators doing the deployment and maintains of the solution.

      What's my experience with pricing, setup cost, and licensing?

      Power BI is cheaper for smaller groups when comparing to competitors. It requires a monthly per-user subscription.

      Which other solutions did I evaluate?

      I have evaluated Tableau.

      What other advice do I have?

      I would recommend this solution to others.

      I rate Microsoft BI a seven out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      CEO at a tech services company with 1,001-5,000 employees
      Real User
      Can be easily integrated to any database and is flexible and user friendly
      Pros and Cons
      • "It's quite flexible, and it's easy to create reports using this system. It is very graphic and very user friendly."
      • "The smart phone application could be improved, along with better graphics and faster updating."

      What is our primary use case?

      We use it for management reporting.

      What is most valuable?

      It's quite flexible, and it's easy to create reports using this system. It is very graphic and very user friendly.

      One of the advantages of Microsoft BI is that it's easy to integrate it with any databases.

      Another is that it doesn't need a lot of technical support because it's easy to use.

      What needs improvement?

      The smart phone application could be improved, along with better graphics and faster updating.

      For how long have I used the solution?

      I've been using it for 3 or 4 years.

      What do I think about the stability of the solution?

      It is a stable solution.

      What do I think about the scalability of the solution?

      It is scalable.

      How was the initial setup?

      It's easy to install. It requires that you prepare some databases for installing this product, but it doesn't take too much time to do it.

      What about the implementation team?

      We used a consultant.

      What's my experience with pricing, setup cost, and licensing?

      Microsoft BI is not expensive. Compared to the price of other BI products, the price is very fair.

      What other advice do I have?

      On a scale from one to ten, I would rate Microsoft BI at ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      IT Project Manager at a manufacturing company with 10,001+ employees
      Real User
      Not user-friendly and the support could be better, but the real-time reporting is good
      Pros and Cons
      • "The most valuable feature of this solution is real-time report tracking."
      • "It's not user-friendly; more tutorials, training, and better documentation would be helpful."

      What is our primary use case?

      We use this solution for dashboards and reporting.

      We work in manufacturing and we track any incidents that we have regarding safety.

      What is most valuable?

      The most valuable feature of this solution is real-time report tracking. For example, we have a report for a human body and the human body is populated with injury data. In real-time, we can see where most of the injuries have occurred. 

      What needs improvement?

      It is a difficult tool to use and it's hard to figure it out.

      It's not user-friendly; more tutorials, training, and better documentation would be helpful.

      For how long have I used the solution?

      I have been using Microsoft BI for three months.

      We are running the latest version.

      What do I think about the stability of the solution?

      I don't have any issues with the stability of Microsoft BI. It's a stable solution.

      What do I think about the scalability of the solution?

      It's mainly used by developers. We have 10 to 20 developers who are using this solution in our organization.

      How are customer service and technical support?

      Technical support could be improved. If you are able to get someone it's great, but if you don't then you are left hanging. 

      Which solution did I use previously and why did I switch?

      Previously, they were using BusinessObjects.

      With the EA agreement, we get access to everything from Microsoft. It just made sense to switch.

      How was the initial setup?

      The initial setup was completed through our internal Microsoft team.

      What's my experience with pricing, setup cost, and licensing?

      Licensing costs are on an annual basis. There are no fees in addition to the licensing.

      What other advice do I have?

      For anyone who is interested in using this solution, they should hire a dedicated Microsoft team to implement it, and get a lot of training.

      I don't know it well but I would rate it a five out of ten.

      Which deployment model are you using for this solution?

      Hybrid Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      CFO at Travel Food Services ltd
      Real User
      Very scalable and stable with a fluid interface
      Pros and Cons
      • "The interface is very fluid."
      • "The challenge of this product is in truncating the table data."

      What is our primary use case?

      We're a retail hospitality chain spread throughout India, operating over 330 outlets across the country in various formats, ranging from a coffee chain to fast food restaurants through our in-house bespoke brands. All these brands run out of travel hubs like airports, railway stations, and highways stops. We needed a solution to manage both the multiple SKU levels and in terms of individual dynamics, the profitability of each store. We constantly track the various types of back-end raw materials, specifically on our prediction modeling where we use Power BI. We also use Power BI analytics to drive those results with regard to the day-to-day dashboarding, reporting in terms of collection, on sales trends per hour, manpower and the like. We are customers of Microsoft and I'm the CIO. 

      What is most valuable?

      I like that the interface is very fluid in the sense that you can upload via Excel or you can attach via connectors, any software you like.

      What needs improvement?

      The challenge of this product is in truncating the table data. It would be great if Microsoft would include a naming convention which has the advantage of enabling a VLOOKUP on top of it, so two tables can be merged more seamlessly. Currently, the time it takes to merge two tables in Power BI makes the entire analysis quite complex because it requires common numbering in one table and then creating another common indicator in another table in order to merge the two. It wastes precious time. 

      Secondly, while they talk about visual analytics, sometimes the challenge is when you're looking for more in terms of geovisual analytics, such as city maps which requires a functionality whereby you can upload transactions. For example, if I want to visually present my data on an airport map, showing which stores are generating what revenue dependent on the traffic heat map, I am unable to do that because I cannot upload drawings. Ideally, I'd like to show each store as a bar map with waves explaining the sales in each location. It allows me to pinpoint which locations are more profitable. 

      I'd like to see a degree of variability so I have the flexibility of putting those variable components in my predictive modeling, and I can get a feel for the trends. It requires a common input database. You can do it in Excel, but you can't do it in Power BI, which I find surprising.

      For how long have I used the solution?

      We've been using this solution for nine months. 

      What do I think about the stability of the solution?

      The product is fairly stable, it doesn't get too many upgrades or updates from that perspective so it's fairly straightforward in terms of implementation and our entire ecosystem was on Microsoft which helped us. The only area that can be problematic is when you're trying to create relationships between two databases and you're trying to link it with your Power BI solution, sometimes that mapping takes considerable time.

      What do I think about the scalability of the solution?

      The solution is scalable. We are a cluster of eight legal entities and we've been able to expand to all of them. We started with 20 outlets and today we have 350 outlets. We are more granular and today Power BI allows us to drill down to the last voucher. We have around 14 users from the finance and operations teams.

      How are customer service and technical support?

      We haven't needed to call Microsoft, because we worked with one of their gold partners in India. So we are on an AMC model with them in terms of manpower. If there are any problems or upgrades we need, we reach out to the partner. 

      How was the initial setup?

      The initial setup was straightforward for the simple reason that our entire ecosystem was on Microsoft and we use Azure Web Services in terms of hosting. We split the entire project into two parts to simplify things. The first part was more about the granular analysis of sales and various other elements, which took considerable time due to the many external stakeholders involved. Phase two was relatively simple, because it was department specific and we created a split team, which led to the creation of a better platform.

      What's my experience with pricing, setup cost, and licensing?

      Licensing is on an annual basis. We have a complete Microsoft Ecosystem license. I think there is room for improvement with the licensing, specifically during the pandemic when it would have been reasonable to offer a discount. Many other companies, SAP and Oracle, for example, gave waivers to the MSME sector. Microsoft traditionally is used by smaller or medium-sized companies so I was expecting some sort of discount on the pricing, but unfortunately that didn't happen. We managed to avoid an escalation in cost, but frankly speaking, a discount would have been much appreciated.

      What other advice do I have?

      It's important to understand your entire ecosystem in terms of your tables; the kinds of tables your back-end database has and the elements of analysis that you are looking at. If you are looking at predictive modeling, you need to have at least two to three years of data, because that allows you to define the trajectory of the predictive modeling. Otherwise, it doesn't serve any purpose. Secondly, be very specific with your implementation partner, as to how you'd like a particular visualization tool to look, otherwise you may not get what you want. Finally, it's important to invest in people and create a center of excellence made up of people who know Power BI well, or who will get trained and certified on it. You'll need an in-house team which can do the small tweaks and changes as you require, otherwise you'll get stuck each time you need to do something.

      I rate this solution an eight out of 10. 

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Senior Analyst at a tech services company with 10,001+ employees
      Real User
      Good visualizations, dashboards, and scalability, but needs better user interface, rule-based security, and support
      Pros and Cons
      • "Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data."
      • "We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source."
      • "They can improve it in terms of rule-based security. Currently, it has very limited rules."
      • "They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it."
      • "Their technical support can be better. They normally take too long to escalate and resolve a case."

      What is our primary use case?

      We use it for reporting. We are using its latest version.

      What is most valuable?

      Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data.

      We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source.

      What needs improvement?

      They can improve it in terms of rule-based security. Currently, it has very limited rules.

      They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it. 

      Their technical support can be better. They normally take too long to escalate and resolve a case.

      For how long have I used the solution?

      I have been working with Power BI for five or six months.

      What do I think about the stability of the solution?

      I am at the initial stage of using it. We have just deployed a report in our organization, and it is working fine so far. It seems to be stable. I am not sure if we faced any issues with it.

      What do I think about the scalability of the solution?

      It is good in terms of scalability.

      How are customer service and technical support?

      I have had only one interaction with them, and it was a bad one. They took around a month to resolve a simple issue. We also had to escalate the case. The resolution was very simple, and ideally, they should have found it on the first day. They normally take too long when it comes to the escalation of cases.

      How was the initial setup?

      As a first-time user, I found it to be of medium complexity. You have to connect it with the SQL database or your data source. You might not find it very straightforward.

      What other advice do I have?

      It can also be deployed on-premises. If you have it on-premises, make sure that you meet all the prerequisites and have all permissions. You should sort these things out before deploying Power BI. I faced some issues because I missed one of the prerequisites, and it took me one month to get it resolved. That's why I recommend completing all prerequisites.

      I would rate Microsoft Power BI a seven out of ten.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Solution Architect
      Real User
      Provides great container data flow and status related paginated reports
      Pros and Cons
      • "Provides good data flow related to the container and control flow."
      • "There are some connector-related issues in their MSBA solution."

      What is our primary use case?

      One of our primary use cases is to build an MSBA-based business intelligence solution for  collection agents, so that they can receive daily information relating to bills in the form of ledgers. I've built several packages to import the data from where it has been dumped. I then created the data mask for data analysis to showcase all the outputs and conclusions. As a result, there is a clear breakdown of total collections, the different parameters, customer-based information, and other essential information. We are partners of Microsoft BI and I'm a solutions architect.

      How has it helped my organization?

      The solution has helped increase the client's total sales revenue for their collection agent. It's basically MSBA, plus an AIML kind of solution and it helps the client to increase the overall efficiency of their collection agents, increasing total revenue for the company. 

      What is most valuable?

      The most valuable feature is the data flow related to the container and the control flow. Microsoft has recently introduced paginated reports in the status part. These are web-based and also mobile-based, depending upon the layout of the report. It can be easily printed in Word format as well as in layout format, regardless of size. 

      What needs improvement?

      There are some connector-related issues in their MSBA solution and there are certain features that Microsoft should include in the MSBA solution. One is the connective level problem that we currently face from the different data sources. It provides about 80% connectivity to all the data sources, but there is the remaining 20%. They could provide some kind of additional functionality which would make it a great solution. 

      For how long have I used the solution?

      I've been using this solution for about 18 months. 

      What do I think about the stability of the solution?

      The solution is pretty stable in its current form, and we are working on the same platform to optimize and incorporate everything. 

      What do I think about the scalability of the solution?

      This solution is fully configurable and totally scalable. We are currently expanding the solution to include the area collections managers, the territory collection managers, and the regional collection managers. There are currently close to 3,000 users who are field collection agents. There is a maintenance cost but it's pretty low because it's an on-premise solution, so there is no cost attached to the server-based maintenance. Our support team is responsible for maintenance.

      The solution is currently used throughout the company although there are geographical restrictions. They plan to extend usage to a pan-country level. It will take some time to implement but we are at the end stages of deployment on the pan-country level. Once completed, we expect there will be around 15,000 users. 

      How are customer service and technical support?

      We provide technical support as required by our clients. Urgent issues can be resolved within two or three hours. 

      Which solution did I use previously and why did I switch?

      Microsoft BI is similar to Talent and Pentaho BI but Microsoft is more competitive and flexible over the other BI solutions. We can cover up or build our end-to-end solution from scratch and that includes reporting and we don't need to go to any kind of a visualization tool for that.

      How was the initial setup?

      The initial setup was complex because the data vault was not totally structured and we needed to create some kind of a data lake, dump the data, then analyze it and create the data mask. We require certain validations and checks before importing or exporting the data as well as the application of the cubes to SSRS before reporting services. Deployment time can be dependent on the server and we have designed the system to optimize the process. We have a deployment team which can include two to three developers. Deployment takes about 10 minutes. The client decides on the deployment plan because they have applications that hang on the production server and don't want deployment to hamper other applications. 

      What was our ROI?

      Microsoft BI is provided as a BI solution to incorporate or implement all data in a single platform. It enables you to build a data mart for your company and analyze it on a single platform. Even data analysis techniques can be carried out on this platform, and output of data can be visualized from the SSRS reporting tool. In this solution, the ROI is quite high because collection has increased up to 25% in one month compared to the same month last year.

      What's my experience with pricing, setup cost, and licensing?

      We have used a client-based service in the pricing. As yet, there are no additional costs. 

      What other advice do I have?

      For anyone interested in building a BI solution from scratch, it's important to be aware that the data is not taken at a single platform. I believe that Microsoft BI is the best platform for this because it gives the flexibility to store the data into an SQL Server from different sources, and the ability to first dump your data into those servers. The analysis and reporting is in the same platform. Power BI has a much greater range than SSRS. Microsoft BI is a tool that gives it to you on a single platform, and you can build an end-to-end BI solution. This is not possible in Power BI. 

      This solution gives me the total flexibility to use my skill set, in the technical forms and in the analysis form, in one go. I can do several things on a single platform regarding the data science, as well as the data analysis, pulling information, analyzing data, transforming data, creating data lakes, data warehouse, and data masks, all in a single platform. 

      I rate this solution a nine out of 10. 

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Digital Strategy Manager at a energy/utilities company with 10,001+ employees
      Real User
      Easy to learn, scales well, and offers good security
      Pros and Cons
      • "Technical support is quite responsive."
      • "If I compare it to Tableau, I'd say the visualizations can be better. We should have multiple options. By that I mean, while there are multiple options for the visualization, the look and feel of the dashboard when you compare to Tableau is on the lower side. Tableau has a much better visualization."

      What is our primary use case?

      There are multiple use cases. I can't count them even on my fingers. There are around 20 to 30 solutions we have been deploying. We use it across finance, procurement, HR, engineering, and whatnot. Each of the domains we have touched. Data visualization is the main need of any organization. With Microsoft being in our ecosystem, Power BI works perfectly well for us.

      What is most valuable?

      The solution overall works quite well, especially if you have a Microsoft-heavy ecosystem.

      The ease of creating the dashboard is quite good. 

      The analytics are very strong when we couple it with Azure. It offers very good Big Data Analytics that work perfectly well. 

      Scalability is not at all a problem. 

      You can perform the role-based access perfectly. It gives you everything you need with a single sign-on authentication due to the fact that we are in the Microsoft environment.

      You don't have to worry about security. That is very robust.

      What matters most is the turnaround time to create a solution, which is quite fast. This is due to the fact that it's quite intuitive in nature. Even those new to the solution can create solutions very quickly. There isn't a high learning curve.

      The initial setup was not difficult.

      The pricing has been pretty good. 

      Technical support is quite responsive.

      Overall, the solution is quite intuitive.

      What needs improvement?

      If I compare it to Tableau, I'd say the visualizations can be better. We should have multiple options. By that I mean, while there are multiple options for the visualization, the look and feel of the dashboard when you compare to Tableau is on the lower side. Tableau has a much better visualization.

      For how long have I used the solution?

      We've been using the solution for three and a half years at this point. We've definitely used it over the last 12 months.

      What do I think about the stability of the solution?

      The product is quite stable. It works well in the Microsoft environment. It doesn't crash or freeze. there are no bugs or glitches. It's reliable.

      What do I think about the scalability of the solution?

      The solution scales very well. If a company needs to expand its offering, it can do so easily. It's one of the selling points of the solution.

      We have about 60 to 70 people on the solution currently.

      We already are deployed it at a global level. It's just not India-based. We use it across our organization, and it is getting used a lot.

      How are customer service and technical support?

      We've dealt directly with technical support. They have been responsive. We have called them multiple times and the response was good. We are quite satisfied with the level of service.

      How was the initial setup?

      The initial setup was okay. We didn't have any problems. I wouldn't call it complex. I'd describe it more as straightforward. It took us around three or four months to set up and deploy the solution.

      What's my experience with pricing, setup cost, and licensing?

      We have a yearly contract. We signed up for three years and that rolls over annually.

      We have a bundle, an enterprise-level package. Its pricing is good for us.

      Which other solutions did I evaluate?

      We did evaluate Tableau for a moment, however, due to the existing license of Microsoft, the default choice was Power BI.

      What other advice do I have?

      We are using the latest version of the solution. I can't recall the exact version number.

      It's one of the leaders in the top data visualization and analytics toolsets. I'd advise other companies to go for it. It's stable, scalable, and a powerful product and it comes very handy when you want to create visualizations very fast. It's a go-to product if you want to go for data visualization and reporting.

      Overall, I would rate the solution at a nine out of ten.

      Which deployment model are you using for this solution?

      Private Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Manage Client Partner at a tech services company with 501-1,000 employees
      Real User
      Feature rich, functional dashboard, and plenty of charting visuals
      Pros and Cons
      • "I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs."
      • "I have been doing trial and error to figuring out how to do the data analyzing and modeling. There could be some improvement to simplify it."

      What is our primary use case?

      I am using the solution for data analytics.

      What is most valuable?

      I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs. As for now, I am able to do a lot of operations but not with much proficiency. I am just getting started with it. I am not very good at doing dashboard creation or writing reports but sometimes I do it during office hours to understand and learn the analytical tools.

      What needs improvement?

      I have been doing trial and error to figuring out how to do the data analyzing and modeling. There could be some improvement to simplify it.

      For how long have I used the solution?

      I have been using the solution for approximately one year.

      What do I think about the stability of the solution?

      I am only working with small datasets at the moment and the solution has been stable. I am not sure how it will be for larger datasets. We have approximately 50 people using the solution in my organization.

      What's my experience with pricing, setup cost, and licensing?

      This solution came free, it was offered by Microsoft with our E3 license.

      What other advice do I have?

      This solution is a useful tool for the business and experts. It has plenty of features. I do not have a lot of advice because I am just starting to explore the solution but I have found it very helpful in terms of data presentation. 

      I rate Microsoft BI a nine out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: partner
      PeerSpot user
      Owner at a consultancy with 11-50 employees
      Real User
      Powerful visualizations, easy to use, and integrates well with Microsoft products
      Pros and Cons
      • "It integrates better with other Microsoft products. It is very easy to use and has very powerful visualizations. It has also got a lot of development going on."
      • "It should have more integrations."

      What is most valuable?

      It integrates better with other Microsoft products. It is very easy to use and has very powerful visualizations. It has also got a lot of development going on. 

      What needs improvement?

      It should have more integrations.

      For how long have I used the solution?

      I have been using this solution for probably two years.

      What do I think about the stability of the solution?

      It is stable.

      What do I think about the scalability of the solution?

      It is scalable. I have a few large customers of this solution.

      How are customer service and technical support?

      I don't have any experience with their support.

      Which solution did I use previously and why did I switch?

      I also use Tableau. Tableau and Power BI are similar in terms of capability.

      How was the initial setup?

      It was easy. It was done in minutes.

      What about the implementation team?

      I can do it on my own. You would require external consultants or in-house experts.

      What's my experience with pricing, setup cost, and licensing?

      Licensing is on a monthly basis, but I am not sure.

      What other advice do I have?

      I would rate Microsoft BI a nine out of ten.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Responsable Industrie 4.0 at a engineering company with 10,001+ employees
      Real User
      Easy to use for a non-IT person and good for data modeling and working with a large amount of data
      Pros and Cons
      • "I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person."
      • "It is not the right tool to do deeper analysis or predictions. When you have some data and you want to do some deep analysis, there is no feature to help you with this."

      What is most valuable?

      I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it.

      The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. 

      Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person.

      What needs improvement?

      It is not the right tool to do deeper analysis or predictions. When you have some data and you want to do some deep analysis, there is no feature to help you with this. 

      For how long have I used the solution?

      I have been using this solution for one year.

      What other advice do I have?

      I would rate Microsoft BI an eight out of ten.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Vice President & Head at a tech services company with 501-1,000 employees
      Real User
      Good support, seamless integration with Microsoft solutions, and perfect for Microsoft infrastructure
      Pros and Cons
      • "It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite."
      • "It should be more user-friendly and simple."

      What is our primary use case?

      My team uses it. They majorly used to work on SSRS and SSIS.

      What is most valuable?

      It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite.

      What needs improvement?

      It should be more user-friendly and simple.

      For how long have I used the solution?

      I have been using this solution for almost five years.

      How are customer service and technical support?

      Their technical support is good.

      What other advice do I have?

      Companies that are Microsoft shop do prefer using this solution, but non-Microsoft companies or customers generally go for solutions such as Tableau and Domo. Companies that want to go really cheap without any tool costs generally go for an open-source solution. In terms of reporting, data visualization tools such as Tableau and Domo are its competitors. 

      The pricing of all these tools will vary depending upon the licenses that you are using and the contract that you have, but from the ease-of-use perspective, Tableau is very easy to work with. A lot of work is being done on Tableau.

      I would rate Microsoft BI an eight out of ten.

      Disclosure: My company has a business relationship with this vendor other than being a customer: partner
      PeerSpot user
      Technical Director, Information Management at a construction company with 5,001-10,000 employees
      Real User
      Good reports, dashboards, and visualizations, but needs more report outputs and better documentation
      Pros and Cons
      • "Reports, dashboards, and visualizations are most valuable."
      • "It should have more report outputs. They should expand the report outputs. Its documentation should also be better."

      What is our primary use case?

      It is used for data visualization and analytics. We have its latest version.

      How has it helped my organization?

      It has provided better and deeper analytics for our data. It has also been helpful for custom visualizations as per client requirements.

      What is most valuable?

      Reports, dashboards, and visualizations are most valuable.

      What needs improvement?

      It should have more report outputs. They should expand the report outputs.

      Its documentation should also be better.

      For how long have I used the solution?

      I have been using this solution for five years.

      What do I think about the stability of the solution?

      It is fairly stable.

      What do I think about the scalability of the solution?

      It is scalable based on licensing. You would need premium and additional organizational licenses. Mostly everyone in the organization uses this feature. We have around 4,000 users of this solution in our organization, which includes a lot of project management people.

      We don't have any plans to increase the usage in the future. We are currently content with its usage.

      How are customer service and technical support?

      They exceed expectations and provide good quality support.

      Which solution did I use previously and why did I switch?

      We had other solutions, but they were some form of ad hoc databases and spreadsheets. We switched to this solution for integrating various data sets from different data sources and for richer analytics.

      How was the initial setup?

      It was straightforward. It took two weeks.

      What about the implementation team?

      It was an in-house job. For its maintenance, we probably have a staff of about 20 people.

      What other advice do I have?

      I would rate Microsoft BI a seven out of ten. It is a really well-developed product, but it has some room for improvement.

      Which deployment model are you using for this solution?

      Hybrid Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Head of Offshore Operations & Solutions at Techcarrot
      Real User
      Quick reporting, high data conductivity, and reliable
      Pros and Cons
      • "I have found the quick reporting and the conductivity with all the data sources valuable."
      • "I would like to see some AI incorporated into this solution in the future."

      What is our primary use case?

      We use the solution for revenue forecasting and other predictive analytic reports based on specific requirements.

      What is most valuable?

      I have found the quick reporting and the conductivity with all the data sources valuable.

      What needs improvement?

      I would like to see some AI incorporated into this solution in the future.

      For how long have I used the solution?

      I have been using the solution for approximately five years.

      What do I think about the stability of the solution?

      The stability of this solution is great.

      What do I think about the scalability of the solution?

      The scalability at first was not the greatest but it has turned out it can be very good.

      How are customer service and technical support?

      The support has been good.

      How was the initial setup?

      I have found the installation straightforward compared to other competitors.

      What about the implementation team?

      Having this solution on the could cloud allows for quick deployment. We could deliver the solution within four to eight weeks depending on the complexity.

      What's my experience with pricing, setup cost, and licensing?

      There is a license for this solution and we purchase them annually.

      What other advice do I have?

      I rate Microsoft BI an eight out of ten.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
      PeerSpot user
      Data Science Leader at a tech services company with 11-50 employees
      Real User
      Can be used to plan, communicate, and visualize knowledge extracted from data
      Pros and Cons
      • "The best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question."
      • "I think that the solution is harder to use for people who are not experts in data."

      What is our primary use case?

      We use it for BI analytics. I am a data scientist, so I model data and show the data through dashboards using this tool.

      What is most valuable?

      I think that the best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question.

      What needs improvement?

      I think that they can make the solution easy to use for people who are not experts in data because many clients try to use it, but they need to be prepared before using it.

      Also, now we have another solution on the market that is more easy to use for those who are not trained in these kinds of tools.

      For how long have I used the solution?

      I have been using Microsoft BI for more than five years.

      What do I think about the stability of the solution?

      I think the stability is good. I haven't had any problems yet with Power BI.

      How are customer service and technical support?

      My experience with technical support has been good.

      How was the initial setup?

      For me, the initial setup was easy, but I have been working for more than 20 years in data analytics. However, sometimes for end-users it's not as easy as another tool on the market.

      A dashboard can be made in 30 minutes or two days, depending on the client, the information, and the quality of the data. I am also a teacher, so for my classes I can create a low plan dashboard in 30 minutes.

      What other advice do I have?

      I used to recommend Microsoft BI, but the only issue is that you would need to know data analytics before using it. So it is not easy to use if you're not an expert. However, it is a good tool, and I think it's a good solution for many business problems.

      Also, I would rate Microsoft BI at eight on a scale from one to ten.

      Which deployment model are you using for this solution?

      Hybrid Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      CEO Gerente General at a tech services company with 51-200 employees
      MSP
      Stable, efficient and has a straightforward setup
      Pros and Cons
      • "We found the initial setup to be straightforward."
      • "The solution could use a faster speed on certain interactions and a refresh of the dashboards."

      What is our primary use case?

      We primarily use the solution across many company verticals and within every area of the company - including finance, accounting, operations, logistics, HR, et cetera.

      How has it helped my organization?

      In general, it's helping companies be more efficient, more productive.

      What is most valuable?

      There's not one specific feature we prefer. I would say it depends on the customer and the processes. What is important to one user may not be as important to another. There's no one feature that excels over another so that we don't see it like second place.

      The product offers very good efficiency.

      The solution is very stable.

      The solution can scale well.

      The documentation on offer is good.

      We found the initial setup to be straightforward.

      What needs improvement?

      In Power BI, it would be ideal if we had the capability to import data with forms or similar methods.

      It would be nice to have the ability to have a service price to offer customers of Power BI, without having the customer be part of Power BI, I would say. Maybe that could help us consult the suppliers.

      The solution could use a faster speed on certain interactions and a refresh of the dashboards. It can sometimes get a bit slow.

      For how long have I used the solution?

      I've been dealing with the solution for about five years or so. It's been a while.

      What do I think about the stability of the solution?

      The solution is extremely stable. There are no bugs or glitches. It doesn't crash or freeze. It's very reliable in terms of performance, but it is slow sometimes.

      What do I think about the scalability of the solution?

      The solution is easily scaled.

      Most of our clients are quite large companies. The companies we deal with have thousands of users, however, only a few really use Power BI. Typically only the supervisors and managers use it, not everyone.

      How are customer service and technical support?

      We've never used customer support. We haven't needed to reach out to them.

      The documentation on offer is okay. It can help you troubleshoot or learn about the product.

      Which solution did I use previously and why did I switch?

      We also work with Tableau and and QlikView alongside Microsoft. We do use some others, however, to a much lesser extent.

      How was the initial setup?

      The initial setup is straightforward. The deployment takes a good two days to finalize.

      In terms of maintenance, we have a support team that covers all of our customers. There isn't really that much that needs to be done. 

      What's my experience with pricing, setup cost, and licensing?

      There are less expensive options on offer.

      Which other solutions did I evaluate?

      Tableau is always one of the solutions we would like to evaluate further, and ClickView is another one.

      It is my understanding that ClickView is less expensive, whereas Tableau is more expensive. Really, the reason why most companies go through Microsoft is if they have a Microsoft Business Suite or Office and it's all tied in the same ecosystem. That's perhaps the biggest benefit. It's all within the same ecosystem.

      What other advice do I have?

      We are consultants and implementers so we usually resell software. We do the end-to-end automation for customers as well. In the case of Microsoft BI, our clients are the ones that buy the license and use it. We don't necessarily use it directly.

      We're always working off the latest version, as the solution is constantly updated online. 

      I would recommend the solution to other companies and users. 

      I'd rate the solution at a nine out of ten.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Operations & BI Analyst at American Hospital Dubai
      Real User
      A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)
      Pros and Cons
      • "Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
      • "It should be more user-friendly. There are very small or tiny icons that you need to move very carefully. If you go a little bit up and down, some of the values change. Its user interface should be improved. It should be like Tableau. Its performance is also slow and should be improved. I definitely feel some sort of speed issues with Power BI. The integration of Excel with Power BI would also be good."

      What is our primary use case?

      I am currently using it for my professional and training use. I am using the Power BI Premium per user recent scheme announced by Microsoft. In my current company, we are using Tableau.

      What is most valuable?

      I’m going to go cover my TOP 5 Features for getting you started on your own visualisations so you can be up and running and leveraging Power BI within your own business in no time at all. Power BI Desktop Sure you probably want to build some beautiful and interactive reports and dashboards to share all those insights from your data with your business, but perhaps lacking the experience that report designers, data queries specialists or Excel Power Users have? Well now all your end users can easily access data and build their own reports using a simple yet powerful interface, Power BI Desktop. Power BI Desktop is a free download which provides an excellent canvas for creating your own masterpiece’s or perhaps just a simple report or dashboard tile. Power BI Desktop with its monthly release cycle is constantly evolving with newly added features or enhancements that can ‘bring data alive’ often in just a few minutes or hours. Visibility Data is arguably one of most precious resource that businesses are generating today. The key aim to be able to manipulate and easily combine this valuable data with other datasets, and then have a simple way to gain a deeper understanding of their business. With data often residing across multiple systems and formats, a valuable resource that businesses need is to be able to collate the various datasets and generate different ways to visual and understand it. In order to identify trends and relationships which were not previously visible and help make those important DECISIONS that business need to make every day based on the right facts. With a deeper understanding that comes from interpreting data in a visual form, the data world has become even more important for a business to be able to leverage and gain the competitive edge it needs; so it’s no wonder that Microsoft’s BI can provide so much value with the data-shaping and modelling capabilities to unlock hidden insights. Custom Visualisations Every business has its own culture and way of doing things, sometimes the ‘standard way’ of doing something just doesn’t cut it and a need to customise it to make it work is needed. The same goes for visualisations that come as standard with Power BI tool, which for some may not provide the depth or complexity of visualisation that is needed in order to ‘bring data alive’. However by accessing the growing library of custom visualisations or even creating ones that meet a specific need is perhaps a way to find a competitive edge. Import Excel Data One of the recent improvements that was added was the ability to import data from Excel. It has a wizard for making it very straight forward so your Excel ‘Power User’s’ now have even greater functionality to make sense of the data. Power Q&A Have you wanted to be able to ask questions in your own language and have it answered? Now Power BI makes that very easy with the Dashboard Power Q&A and the underlying data models. You just start typing in your question and the data model provides the context and answer which can then be manipulated to suit your own visualisation needs.

      What needs improvement?

      Power BI is good with handling simple relationships between tables in a data model. But, if there are complex relationships between tables, that is, if they have more than one links between tables, Power BI might not handle them well. You need to create a data model carefully by having more unique fields so that Power BI does not confuse the relationships when it comes to complex relationships.


      In most cases, you might not feel the need to configure and optimize visualizations in Power BI. But even if you do, Power BI does not provide many options to configure your visualizations as per your requirements. Thus, users have limited options for what they can change in visuals.


      The user interface of Power BI is often found crowded and bulky by the users. It is in the sense that there are many icons of options that block the view of dashboard or report. Most users wish that the user interface or the report canvas was clearer with fewer icons and options. Also, creating scrolling dashboards is a native feature.


      As we know, the expression language used to deal with data in Power BI is DAX. However, you can perform a lot of actions using the DAX formula in Power BI, it is still not the easiest language to work with. Sometimes the formulas you create work well in Power BI, sometimes they don’t. You can concatenate up to two elements but concatenating more than two elements needs nesting statements.


      Power BI has a limit of ingesting data at a time which is approximately 2 GBs of data. If you wish to import and use data of even greater volumes, you need to extend your free version to a paid version of Power BI. Also, users have reported that Power BI takes a little more than usual time or even hangs while processing millions of rows and columns of data.


      Usually, Power BI is the easiest to use BI tool if you are using it simply to import data and create reports. But Power BI is an entire suite having a lot of other interrelated tools. When the purpose of your use is more than just creating reports in Power BI Desktop, you need to learn and master several other tools like Gateways, Power BI Report Server, Power BI Services, etc.

      For how long have I used the solution?

      I have been using this solution for more than three years.

      What do I think about the stability of the solution?

      I am currently using it for my personal training, and I didn't find any stability issues, but when it comes to big data, there may be some sort of issues where the system might hang.

      What do I think about the scalability of the solution?

      In terms of adding more users, there shouldn't be any issues or limitations. Currently, I am using it for my personal use.

      For very big companies with large-scale data and many rules, there would be speed issues with Power BI. Therefore, I don't recommend Power BI at this level. For such organizations, Tableau is the best solution. I have tried Tableau in many companies with many nodes, and I found no speed issues with Tableau. So, I won't recommend Power BI for organizations where 2,000 or 4,000 computers are connected, and there are multiple branches with data coming from different countries.

      How are customer service and support?

      I contacted them for an installation issue related to the RPA Power Automate Desktop. I had downloaded this software, and I was trying to use it with Office, but there were some installation issues. I contacted Microsoft's technical team, and they logged in to my computer and fixed the issue.

      Their support is very nice. They called me and then remotely connected to my computer through Teams. They gave me very good support, and I am perfectly satisfied with them.

      Which solution did I use previously and why did I switch?

      I can mentions main difference between Power BI and tableau which is as under. Advantages of Tableau Here, are pros/benefits of using Tableau BI: •Less cost of training •Very fast and easy to create visualizations •Good customer support •Data Interpreter Story-telling ability •Tableau offers a feature of visualization •It helps you to combine shape & clean the data for analysis. •It helps you to handle a large amount of data. •Uses scripting languages like R & Python to avoid performance for complex table calculations. •Allows users to create reports, dashboards, and stories using Tableau Desktop. Advantages of Power BI Here, are pros/benefits of Power BI •Offers pre-built dashboards and reports for SaaS Solutions •Provide real-time dashboard updates. •Secure and reliable connection to your data sources in the cloud or on-premises •Power BI offers quick deployment, hybrid configuration, and a secure environment. •Data exploration using natural language query. •Feature for dashboard visualization •New features frequently added that are great for excel users. •Extensive database connectivity capabilities Q&A feature publish to the web. •integration with both Python and R coding to use visualizations. •Power Query provides many options related to wrangling and clean the data. •Post publishing the data into Power BI web service can schedule refresh without manual intervention. •Power BI backed by the superpower of with artificial intelligence and machine learning. Disadvantages of Power BI Here, are cons/drawbacks of Power BI •Dashboards and reports only shared with users having the same email domains. •Power Bl will never mix imported data, which is accessed from real-time connections. •Power BI can't accept file size larger than 1 GB. •Dashboard never accept or pass user, account, or other entity parameters. Disadvantages of Tableau Here, are cons/drawbacks of Tableau •Relatively high cost •No change management or versioning •It is expensive, BI, when compared to other tools. •Importing custom visualization is a bit difficult. •Not offers easy methods for embedding reports to other applications. •Tableau is suitable only for a large organization which can pay for licensing cost. •The tableau does not offer support for artificial intelligence and machine learning. •There is integration with other Microsoft products like Power Apps , Dynamics 365, Office 365, and Microsoft Flow, which uses Single Sign-On (SSO).

      How was the initial setup?

      Its initial setup is very simple. There is no issue at all. If you have everything set up on your computer, it takes only 10 minutes.

      In terms of maintenance, Power BI does not require any maintenance, but the database behind Power BI requires some sort of maintenance. Power BI is like a tap. It is just providing what is in the tank. For clean water, you just need to clean the tank at the back. To get good visualizations, you need to clean your database, tabling structure, and data modeling. If you are doing all data modeling in Power BI, then data modeling requires some sort of maintenance.

      What's my experience with pricing, setup cost, and licensing?

      Power BI comes in three levels – Desktop, Pro, and Premium. The Desktop level is free for individual users. Pro – The Pro plan costs $9.99 per user, per month and includes a mobile app, the ability to publish and share reports, a 1 GB model size limit, eight data refreshes daily, the ability to connect to over 100 data sources, embedded APIs and controls, AI visuals, data security and encryption, metrics for content creation and publishing and up to 10 GB per user maximum storage. Pro is available for free for companies that have the Microsoft 365 E5 solution. Premium (per user) – Microsoft launched this new pricing strategy that costs $20 per user, per month. It includes all of the features of the Pro plan, plus paginated reports, a 100 GB model size limit, 48 data refreshes daily, advanced AI features, XMLA endpoint read/write connectivity, data flows, the ability to analyze data stored in Azure Data Lake Storage, application lifecycle management and up to 100 TB of maximum storage. Premium (per capacity) – This plan starts at $4,995 per month per dedicated cloud compute and storage resource. It includes all of the features of the Premium per user plan, plus on-premise reporting, a 400 GB model limit, multi-location deployment management, Bring Your Own Key (BYOK) and autoscale add-on.

      Which other solutions did I evaluate?

      No, I am diehard fan and accredited professional of Microsoft technologies, so I have no other thought.

      What other advice do I have?

      I will suggest below guidelines to Power BI users. Limit the number of visuals in dashboards and reports According to Microsoft's Optimization guide for Power BI, placing many visuals in a single report slows report performance. Limit widget visuals to eight per report page and grids to one per page. Limit pages 30 points (cards: 1, gauges: 2, charts: 3, maps: 3, grids: 5). Limit tiles to 10 per dashboard. To improve Power BI report performance, remove unnecessary interactions between visuals By default, all visuals on a report page can interact with one another. For optimal report performance, interactivity should be minimized. Reduce the number of queries fired at the back end and improve report performance by disabling unnecessary interactivity. Enable Row-Level Security (RLS) Row Level Security restricts user access to certain rows in a database depending on the characteristics (role) of the user executing a query. With RLS, Power BI only imports data the user is authorized to view. Combining Power BI roles with roles in the back end can result in substantial performance gains. Test all roles before rolling out to production. Use Microsoft AppSource certified custom visuals Power BI certified visuals are AppSource visuals that have passed rigorous quality testing. Microsoft verifies that certified custom visuals have robust, high-performance code. Certified custom visuals are the only custom visuals that can be viewed in Export to PowerPoint mode and email subscriptions. Use preview feature of hierarchy slicers instead of custom visual If you need to show hierarchy in slicers, enable the preview feature provided by the Power BI desktop instead of using of a custom visual. Provide data categorization for Power BI reports (HBI, MBI, LBI) High Business Impact (HBI) data requires users to get a policy exception to share the data externally. Low Business Impact (LBI) and Medium Business Impact (MBI) data do not require exceptions. By using Power BI data sensitivity labels, you raise user awareness about required security and how reports should be shared inside and outside the organization. Use on-premises data gateway instead of Personal Gateway Personal Gateway takes data and imports it into Power BI. Enterprise Gateway (on-premises data gateway) imports nothing, which is more efficient when working with large databases. Use different Power BI gateways for Live Connection and Scheduled Data Refresh If the same gateway is used for Scheduled Data Refresh and Live Connection, Live Connection performance will slow down when Scheduled Data Refresh is active. Avoid this issue by creating separate gateways for Live Connection and Scheduled Data Refresh. Test custom visual performance on reports to ensure fast report load time; use an alternative visual if the chosen visual performs poorly Uncertified custom visuals are generally not tested by the Power BI team. Custom visuals can perform poorly when handling large datasets or complex aggregations. If a custom visual performs poorly, consider replacing it with a different visual. Limit complicated complex measures and aggregations in data models Push calculated columns and measures to the source where possible. The closer they are to the source, the higher the likelihood of improved performance. Create calculated measures instead of calculated columns. Use star schema to design data models. Use slicers sparingly Slicers are a great way of allowing users to navigate data, but they come at a performance cost. Each slicer generates two queries: one gets the data, and the other fetches selection details. Creating too many slicers negatively impacts performance. To evaluate which slicers are infrequently used, use the Filter pane and remove unnecessary slicers. Ensure the Power BI report and data source are in the same region With the tenant and data source in the same region, you can reduce network latency. The results are faster data transfer and faster query execution. Import only necessary fields and tables instead of entire datasets Ensure the model is as narrow and lean as possible. Power BI works on columnar indexes; longer and leaner tables are preferred. Ensure the cache update frequency aligns with the data source refresh frequency Cache update frequency should be set at similar intervals to data source refresh frequency. By default, the Power BI cache update frequency is set to one hour. If, for example, your data set refreshes only once per day, you should update the cache frequency accordingly. Use white or light background colors For users distributing printed reports, white or light backgrounds are printer friendly. Shorten numbers Don’t exceed three or four numerals when displaying numbers. Display measures to one or two numerals left of the decimal point and scale for thousands or millions. Use Report Tooltip pages to provide more context for the highlighted measure Report tooltips are a great way of sharing additional information on the metric. Use limited visuals in Report Tooltip. Ensure you select Tooltip field carefully (categorical or measure). Use templates (.PBIT files) to speed up and standardize report development instead of starting with an empty .PBIX Templates can be saved with custom color palettes and themes pre-incorporated. Templates ensure corporate branding is pre-applied to all pages. Templates ensure connections to commonly used data sources are already in place. Templates create commonly used DAX measures. Source: LinkedIn Use names that are meaningful to your business users or intended audience Power BI provides the ability to give aliases to report objects. Avoid ambiguity when naming columns and measures. Consider hiding unused columns in the data model. Source: LinkedIn Reduce queries Reduce the number of queries sent by Power BI using the settings for Slicers and Filters.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user

      Pra mim, deve ser ultilizado com recursos um pouco mais simples para atender outros publicos, facilitando os usuarios a terem conhecimento sobre a plataforma.

      Project Consultant at a financial services firm with 501-1,000 employees
      Consultant
      A stable solution with a great dashboard
      Pros and Cons
      • "Microsoft BI is very easy to set up and use."
      • "Integration with products that are not Microsoft could be more improved."

      What is our primary use case?

      Around 50% of our customers use this solution. We plan to extend our usage of this solution.

      What is most valuable?

      Our customers really like the dashboard. They can click on whatever they want for an in-depth view. Microsoft BI is very easy to set up and use. 

      What needs improvement?

      In general, all the Microsoft programs are integrated quite well, but it could be improved. Also, integration with products that are not Microsoft could be more improved.

      For how long have I used the solution?

      I have been using Microsoft BI on and off for the past two years. 

      What do I think about the stability of the solution?

      If implemented correctly, Microsoft BI is quite stable. 

      What do I think about the scalability of the solution?

      It's quite scalable. 

      How are customer service and technical support?

      I have never contacted customer support. 

      What's my experience with pricing, setup cost, and licensing?

      I don't know much about the licensing because our customers pay for it. 

      What other advice do I have?

      I would recommend this solution. Overall, on a scale from one to ten, I would give Microsoft BI a rating of nine. 

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Solutions Architect at a tech services company with 11-50 employees
      Real User
      Multiple datasets synchronization, visual customization, and reliable
      Pros and Cons
      • "The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app."
      • "They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly."

      What is our primary use case?

      The solution is a dashboard. We have the on-premises data gateway, which allows us from the Azure Cloud to get into Power BI. The dataset content comes from the on-premise data warehouses.

      We have produced historical analytics and KPIs from ServiceNow for Incident management, performance, SLA coverage, trends, and identifying anomalies. Anomalies are, for example, if a ticket is reopened, that means it was closed incorrectly or the solution was not correct. If a ticket has been an incident or a request has been routed more than two times, that means somewhere in the processes it was not clear and the ticket is going in circles out to the anomalies data.

      A lot of analytics based on ServiceNow and Gyra as ITSMs systems. There is also combined analytics between Salesforce and for example, Web analytics, Google Analytics, and so on. Allowing us to see how visits to the website translate into lead opportunities. This is done by combining the two, extracting them and combining the two sources of data, such as Google Analytics and Salesforce.

      What is most valuable?

      Some of the most valuable features of this solution are the ability to take your data and have the possibility to combine them into datasets and have synchronization. 

      You are able to synchronize the data without additional cost eight times a day and you can set when you want to synchronize it. For example, during business hours, we synchronize the data once an hour and during the night I do not synchronize it at all. 

      The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app.

      Microsoft is open to suggestions for improvements in future releases. We requested to allow Python Notebooks to be displayed as visuals on top of the datasets, which now available and was not five versions ago.

      What needs improvement?

      The possibility to synchronize more often without having to pay more would be great. They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly.

      For how long have I used the solution?

      I have been using the solution for three years.

      What do I think about the stability of the solution?

      I have found the solution to have high performance and to be reliable.

      What do I think about the scalability of the solution?

      The solution is highly scalable. We have approximately 100 people using the solution in my organization.

      How was the initial setup?

      The solution is a service, which does not require a traditional installation. However, there is a large configuration portion. It can be very simple to configure minor operations but can become complex if you connect via Power BI, a lot of sources.  For example, from on-premise and from multiple clouds. It allows you to go from very simple, to very complex. It is up to your solution design in the end. 

      You can create your first dataset in a matter of hours. This once again is dependent on your configuration.

      The solution requires maintenance but not to the Power BI itself. The configuration is deployed on top of Power BI, you can set automatic alerts if, for example, the data is not synchronized or It not available.

      What's my experience with pricing, setup cost, and licensing?

      The price of the solution can be expensive if you want to synchronize your data more.

      What other advice do I have?

      I rate Microsoft BI an eight out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Founder/CEO at Data.tac Nigeria Limited
      Real User
      Allows us to compile and transform data into visual representations
      Pros and Cons
      • "Microsoft BI allows us to connect to any database or any dataset."
      • "Compared to other applications, like Tableau, Microsoft BI doesn't have as many functions that allow you to do more in-depth analysis and represent the findings."

      What is our primary use case?

      We get a lot of chunks of data, especially production data and data based on education — performance-related data. We use BI to analyze the data so we can give feedback to our clients. If they're experiencing problems, we help them find trends, etc.

      Within our organization, there are roughly six or seven people using this solution.

      What is most valuable?

      Microsoft BI allows us to connect to any database or any dataset. It automatically renders some of the information which makes things a lot easier for us.

      What needs improvement?

      Compared to other applications, like Tableau, Microsoft BI doesn't have as many functions that allow you to do a more in-depth analysis and represent the findings. I think they have a standard that they keep to.

      As the UI experience is always changing, the interface and security can always be improved. 

      For how long have I used the solution?

      I have been using this solution for roughly four years. 

      What do I think about the stability of the solution?

      Stability is quite good. It's reliable.

      What do I think about the scalability of the solution?

      We haven't had to expand because usually we just wait for the data. However, we do have plans to expand.

      How are customer service and technical support?

      On a scale from one to five, I would give their technical support a rating of four. 

      How was the initial setup?

      The initial setup was very straightforward. 

      What's my experience with pricing, setup cost, and licensing?

      I believe we pay on a monthly basis. Compared to what's available on the market, I think we pay a fair price.

      What other advice do I have?

      I would recommend Microsoft BI to others. On a scale from one to ten, I would give this solution a rating of seven.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      MI Manager at a recruiting/HR firm with 1,001-5,000 employees
      Real User
      Extremely responsive and helpful support, easy report modeling, and supports connections with multiple data sources
      Pros and Cons
      • "It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation. Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution. Their technical support is very good. They are extremely responsive, helpful, and hands-on."
      • "The visual outlet or the visualization aspect can be improved because the settings piece is quite problematic. It requires a lot of time to set the visuals and check. It is quite fiddly to change all the settings and font sizes. It just needs better ability in terms of using templates or visualization templates to get the vision. Our users always benchmark based on the product, and they don't appreciate everything under the bonnet. The only rating is based on the actual reports in the settings for the dashboard. They should make it look a bit funky and a bit more aesthetically pleasing on the eye. It is quite a fiddly tool, but other than that, it is pretty slick. Because it is community-driven, the marketplace tends to be changing forever. You get the standard visualizations, and you've also got all other marketplace visualizations that require you to spend a bit more money and purchase things in the marketplace. With certain visualizations, there is no longevity. I had used certain visualizations, but they discontinued them, and I had to rebuild my reports, which is obviously very frustrating. There should be some sort of stabilization around how the marketplace visuals impact the users when they expire."

      What is most valuable?

      It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation.

      Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution.

      Their technical support is very good. They are extremely responsive, helpful, and hands-on.

      What needs improvement?

      The visual outlet or the visualization aspect can be improved because the settings piece is quite problematic. It requires a lot of time to set the visuals and check. It is quite fiddly to change all the settings and font sizes. It just needs better ability in terms of using templates or visualization templates to get the vision. Our users always benchmark based on the product, and they don't appreciate everything under the bonnet. The only rating is based on the actual reports in the settings for the dashboard. They should make it look a bit funky and a bit more aesthetically pleasing on the eye. It is quite a fiddly tool, but other than that, it is pretty slick. 

      Because it is community-driven, the marketplace tends to be changing forever. You get the standard visualizations, and you've also got all other marketplace visualizations that require you to spend a bit more money and purchase things in the marketplace. With certain visualizations, there is no longevity. I had used certain visualizations, but they discontinued them, and I had to rebuild my reports, which is obviously very frustrating. There should be some sort of stabilization around how the marketplace visuals impact the users when they expire.

      For how long have I used the solution?

      I have been using this solution for about two and a half years. We use Power BI Premium, and we have its latest version.

      What do I think about the scalability of the solution?

      It is scalable once you've got your ducks in a row. We live in a world of fast-paced data. The business I am working in is dealing with a lot of unstructured data, so it has to go through the data onboarding transformation piece. It is more scalable if it connects to a data warehouse, but connecting to an Excel spreadsheet or unstructured data requires enormous amounts of investment. I have seen some other tools that are more data wrangling tools, so you don't want to blur your line. You need to stick to what you're good at. Is it data visualization and modeling, or is it data transformation? They're trying to diversify and make the tool all-encompassing, but we're now having to use a different tool for data transformation or data wrangling. We then just connect it to a data warehouse, and it becomes a really slick and scalable tool.

      How are customer service and technical support?

      They are very good. They are extremely responsive and helpful. They arrange a call quite quickly, and they actually get on the call and help you and do troubleshooting with you. They are not sending you to the Q&A page. They are quite hands-on in terms of support. So, I am really happy with their support.

      What other advice do I have?

      I would advise others to just make sure that whatever you're going to deploy can be scaled out. You should get your data modeling in place first. 

      I would recommend this solution. They have so many releases every month, which is quite cool. They are keeping on top of it, and it is not like you have to wait six months for a release. I'm still trying to keep up with the releases of the last four or five months.

      I would rate Power BI a nine out of ten.

      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Technical Director at Progetti e Soluzioni
      Real User
      Intuitive, stable, customizable, and has a lot of powerful functions
      Pros and Cons
      • "It is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs."
      • "When you go to the cloud, its licensing is not intuitive. It is a little bit complex. When you have to purchase a new license, it is difficult to understand on their website what exactly you need to pay and how you can group. It is something that is applicable to all Microsoft products. They're not always so simple and clear when it comes to licensing. Their support can also be better in terms of explaining how they resolved an issue and what steps they took to resolve it. They are able to resolve the issue, but they can be better at explaining the approach they took to resolve the issue. It could have something in the direction of machine learning. It can have some kind of integration with machine learning where you can ask for some reports with natural language."

      What is our primary use case?

      We are using it for analyzing transactions. In the products that we develop and supply to our customers, there are some applications that are connected to payments. We analyze the trend of transactions or payments that are done in our system by our clients. We want to understand how our clients are using our solution and if there are some conditions that are making them use our product more than others. We also analyze who is paying and how much, and how and at what time are they using our system.

      What is most valuable?

      It is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. 

      It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs. 

      What needs improvement?

      When you go to the cloud, its licensing is not intuitive. It is a little bit complex. When you have to purchase a new license, it is difficult to understand on their website what exactly you need to pay and how you can group. It is something that is applicable to all Microsoft products. They're not always so simple and clear when it comes to licensing.

      Their support can also be better in terms of explaining how they resolved an issue and what steps they took to resolve it. They are able to resolve the issue, but they can be better at explaining the approach they took to resolve the issue.

      It could have something in the direction of machine learning. It can have some kind of integration with machine learning where you can ask for some reports with natural language.

      For how long have I used the solution?

      I have been using this solution for two years.

      What do I think about the stability of the solution?

      It is stable enough.

      What do I think about the scalability of the solution?

      It is easy to make it grow as a product. Our organization is not big. We have a total of 10 to 15 people who access this solution. We will continue to use it for sure. 

      In general, we are producing applications that we sell to our clients in a SaaS model. All data of our clients is inside our database. The clients have to manage the service. All this data that they are loading in our server can have interesting information for them. So, we are using it to understand our clients and the behavior of the user.

      How are customer service and technical support?

      We had to use some support for licensing. They were fast enough, but sometimes, they were not very clear. We had a few calls with them. In the end, they solved the problem, but they didn't have a very clear approach. It was more of a communication problem. Their support can be better in terms of explaining how they resolved an issue and what steps they took to resolve it. 

      How was the initial setup?

      Its installation is easy on the cloud as well as on the desktop. You can also easily move and publish from desktop to the cloud. We had issues with licensing, but after you have received licenses, it is easy. 

      It is also good how the data that is being collected on some servers for different data centers is automatically synchronized. It is easy enough to do automatic scaling or collect the data from the source and the publisher.

      What about the implementation team?

      We did it ourselves. At the moment, we are not using a consultant. It is intuitive enough for our use, and there is one type of analysis and one type of role. However, in the future, we might require a consultant for customizing the dashboard and the reports and splitting the data according to different roles. We would require analysis of different roles based on different sets of data. For machine learning, we'll surely require a consultant.

      For its deployment and maintenance, we have three or four people for each specific competency. Some of them are more experienced in the data that has to be collected, and some of them are experienced in how data can be collected from the in-house server. There are also some people who are more competent in the business domain.

      What's my experience with pricing, setup cost, and licensing?

      We pay for users who are publishing on the cloud. The desktop version is free.

      Its licensing is on a yearly basis.

      What other advice do I have?

      I would recommend this solution. It has many features that are good. It mostly needs improved licensing. 

      I would rate Power BI a nine out of ten. 

      Which deployment model are you using for this solution?

      Private Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Consultant en Business Intelligence
      Consultant
      Free software which is very intuitive and easy to use
      Pros and Cons
      • "Very intuitive and easy to use."
      • "Capacity could be improved."

      What is our primary use case?

      Our primary use case of this solution is as a reporting tool. We implement it for our clients. I'm a consultant in business intelligence and we are customers of Microsoft BI.

      What is most valuable?

      I like this product because it's a free software, very intuitive and very easy to use.

      What needs improvement?

      The capacity of the solution could be improved. If you don't need all the data it offers then don't download it because the software slows down. 

      For how long have I used the solution?

      I've been using this product for the last year. 

      What do I think about the stability of the solution?

      It's a stable solution. 

      How was the initial setup?

      The initial setup is quite straightforward. 

      What other advice do I have?

      I rate this solution an eight out of 10. 

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Power BI Technical Specialist at a manufacturing company with 1,001-5,000 employees
      Real User
      Useful for collaboration and insightful data visualizations, highly scalable, and easy to deploy
      Pros and Cons
      • "We are able to collaborate on things and get insightful data visualizations."
      • "Its performance and stability can be improved. It takes time to load, and sometimes, it also breaks down for the whole region. Its usability could also be better, and it could also have more connections with different data sources."

      What is our primary use case?

      We are using it for reporting ERP data, IT service data, financial data, and so on.

      How has it helped my organization?

      It has been helpful in getting insights. We weren't able to get insights at such a level. It is also helpful in getting an overview of different departments. We are able to do it much faster than before.

      What is most valuable?

      We are able to collaborate on things and get insightful data visualizations.

      What needs improvement?

      Its performance and stability can be improved. It takes time to load, and sometimes, it also breaks down for the whole region.

      Its usability could also be better, and it could also have more connections with different data sources.

      For how long have I used the solution?

      I have been using this solution for two years. In this company, I have been using it for two months.

      What do I think about the stability of the solution?

      It is not completely stable. Sometimes, it goes off for the whole North Europe region. Its stability should be improved.

      What do I think about the scalability of the solution?

      It is scalable, and there are no issues with its scalability. I would rate it a ten out of ten in terms of scalability. We have around 300 users of this solution.

      How are customer service and technical support?

      We don't have any issues with their technical support. 

      Which solution did I use previously and why did I switch?

      I have worked only with Power BI.

      How was the initial setup?

      It is easy because documentation and a lot of tutorials are available. Its deployment took one month.

      What's my experience with pricing, setup cost, and licensing?

      Power BI premium is really expensive for our market. A lot of small and medium companies would like to purchase it, but they can't afford it.

      What other advice do I have?

      I would rate Power BI an eight out of ten.

      Which deployment model are you using for this solution?

      Hybrid Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: partner
      PeerSpot user
      Head of Analytics Director at a tech services company with 51-200 employees
      Real User
      Low-cost, feature-rich, and easy to deploy, but would be nice to get faster support for new features
      Pros and Cons
      • "It is low-cost and easy to deploy. It is fully-featured."
      • "They are improving it all the time. What would be nice is if they could respond to feature requests more quickly. They can provide faster support for new features."

      What is our primary use case?

      It is for dashboards and reports. 

      What is most valuable?

      It is low-cost and easy to deploy. It is fully-featured.

      What needs improvement?

      They are improving it all the time. What would be nice is if they could respond to feature requests more quickly. They can provide faster support for new features.

      For how long have I used the solution?

      I have been using this solution for two years.

      What do I think about the stability of the solution?

      It is reasonably stable.

      What do I think about the scalability of the solution?

      In my organization, we have around ten users. In our client's organization, we have about 100 users.

      How are customer service and technical support?

      I normally find whatever I need in Microsoft documentation or through Google. There is a lot of activity in the market. A lot of other people typically would have already asked the same question that I have, so it is fairly easy to find information.

      Which solution did I use previously and why did I switch?

      I didn't really use any other product. I used to be a Qlik partner, and I became a Microsoft partner two years ago.

      How was the initial setup?

      Its installation is straightforward. The developer suite has one-click installation. The end-users just get a web URL. There is no installation for end-users. They just access it.

      There is a Microsoft certification that you need to complete, but it is all deployed on the Microsoft Azure cloud. So, there are no infrastructure requirements.

      What's my experience with pricing, setup cost, and licensing?

      It depends upon the tier of your Office 365 subscription. On E5, which is a Microsoft Azure subscription, you get it for free. If you are on a lower tier, you can subscribe for $10 a month per user, which is really cheap.

      What other advice do I have?

      I would recommend this solution. It is pretty good. Technically, it is at the same level as the other products that I've used so far. It has all the features, and it is easy to deploy. Its costs are really palatable. They are improving it all the time. I am fairly satisfied with this product.

      I would rate Microsoft BI a seven out of ten. There are always areas for improvement, but I am fairly happy with it. I would not rate anything else also higher than seven.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
      PeerSpot user
      CEO at a tech services company with 201-500 employees
      Consultant
      Top 5Leaderboard
      Highly scalable, very stable, good data presentation, and useful for deeper insights and analysis
      Pros and Cons
      • "The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter."
      • "Its price could be better. Its licensing cost is very high."

      What is our primary use case?

      We are using Power BI Premium at the moment. It is an online solution, which always has the latest version.

      It is for data visualization and data insights. BI means business intelligence, so it helps you understand the performance of your business better. It gives you deeper insight into the data so that you can draw meaningful conclusions from the data, and your decisions are based on data insights rather than a hunch. 

      How has it helped my organization?

      It is a good and very useful product. I find it to be extremely useful because it gives me a deeper insight into my business, and it lets me analyze things and make decisions based on the data.

      What is most valuable?

      The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter.

      What needs improvement?

      Its price could be better. Its licensing cost is very high.

      For how long have I used the solution?

      We discovered it about two months ago, and we started using it.

      What do I think about the stability of the solution?

      It is very stable.

      What do I think about the scalability of the solution?

      You can scale it to thousands of users. It is a cloud product. Microsoft Cloud is being used by people across the world. So, there is no limitation in terms of scalability.

      At the moment, we have about five users, but the number of users will increase to 50. We are absolutely going to keep using it.

      How are customer service and technical support?

      We generally don't approach Microsoft for support. We are able to handle things at our end.

      Which solution did I use previously and why did I switch?

      We used simple Excel reports, but Excel reports are not as good as Power BI. Power BI is far ahead.

      How was the initial setup?

      It is a cloud product. You can access it through a web browser. It takes no time. 

      It takes time only when you have to prepare the reports because you need to know how to prepare the Power BI reports. There is an MIS team, and there are Power BI designers who design the reports, but for users, it doesn't take much effort because they just have to click and see.

      What's my experience with pricing, setup cost, and licensing?

      Its licensing cost is very high. It is $20 per user, which is very high, but it is a good product, so you pay for it.

      What other advice do I have?

      I would recommend this solution. I would rate Microsoft BI a nine out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Consultant at a training & coaching company with 201-500 employees
      Consultant
      Flexible with good support but it could be more mobile friendly and the price could be better
      Pros and Cons
      • "I like the flexibility it offers."
      • "The graphic interface could be better."

      What is our primary use case?

      We use Microsoft BI for analytics.

      What is most valuable?

      I like the flexibility it offers.

      What needs improvement?

      The graphic interface could be better.

      I would also like to see it mobile-friendly.

      For how long have I used the solution?

      I have been using Microsoft BI for one year.

      We are using the latest version.

      What do I think about the stability of the solution?

      In some ways, it is stable.

      What do I think about the scalability of the solution?

      It's a scalable solution. We have 10 or 15 users in our organization.

      How are customer service and technical support?

      Technical support is good, and we are satisfied with it.

      Which solution did I use previously and why did I switch?

      Before Microsoft BI, we used Tableau.

      How was the initial setup?

      I was not involved with the installation but my understanding is that it was easy to install.

      We have a team of two people to maintain this solution.

      What's my experience with pricing, setup cost, and licensing?

      There are licensing fees.

      It's an expensive solution.

      What other advice do I have?

      I am not sure if we will continue to use this solution, it depends on the business requirements.

      Depending on their business size and setup, I may recommend this solution.

      I would rate Microsoft BI a seven out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Information Architect at a government with 10,001+ employees
      Real User
      A simple, flexible, low-code, and scalable solution for data integration and modeling
      Pros and Cons
      • "It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable."
      • "It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."

      What is our primary use case?

      We are using it for reporting, analytics, and data science. We have its latest version.

      How has it helped my organization?

      Microsoft's CRM platform has very limited reporting capabilities. Power BI was able to meet the business requirements for reporting and more in-depth analytics. It is a part of the Microsoft Ecosystem, and there is a straightforward connection from Power BI to CRM. 

      What is most valuable?

      It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable. 

      What needs improvement?

      It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes.

      It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. 

      The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable.

      I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community.

      For how long have I used the solution?

      I have been using this solution for about 18 months.

      What do I think about the stability of the solution?

      It is pretty stable. I haven't determined any major issues.

      What do I think about the scalability of the solution?

      It is very scalable. It fits perfectly with the larger Azure Data Lake reference architecture. Power BI platform is a fundamental piece, and it becomes scalable to use with other components within that reference architecture.

      We're in the process of laying out a three-phase approach. Over the next year, its usage will increase from 50% to 75%. In terms of the number of users, we have around 150 users who are data scientists and data analysts. We have around 5,500 desktop users, and it is a part of 365, which is on every desktop. 

      How are customer service and technical support?

      There is a lot of online support. We also have Microsoft consultants on contract, and the support comes through them. Their support is very good.

      Which solution did I use previously and why did I switch?

      We also have IBM Cognos. We haven't switched. They're being used in tandem. There are different sets of requirements for two different solutions. 

      How was the initial setup?

      I wasn't part of the deployment, but my understanding is that it was pretty straightforward.

      What about the implementation team?

      We used a Microsoft consultant for implementation. Our experience was good. We don't have any maintenance crew.

      What other advice do I have?

      I would rate Microsoft BI a nine out of ten.

      Which deployment model are you using for this solution?

      Private Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Business Intelligence Developer at a manufacturing company with 51-200 employees
      Real User
      Great for monitoring and reporting
      Pros and Cons
      • "Premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month."
      • "I would like to be able to use more predicting data science features without having to use R."

      What is our primary use case?

      Our primary use cases for this product are monitoring and reporting. I have some dashboards for the sales department and a little bit for operations. I'm going to create a new dashboard for marketing. 

      What is most valuable?

      What I like about Power BI compared to Tableau, for example, is that Tableau is mostly a visualization program, but Power BI is a more complete solution, because it has DAX, Power Query, and a presentation and graphic layer. So, I use it not only for reporting and graphic purposes on the frontend, but also for doing things like modeling. It is very flexible, a lot more flexible for than Tableau for what I need.

      One of the things that I appreciate is that premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month. I'm investigating in that because I think the price is good. 

      What needs improvement?

      I would like to be able to use more predicting data science features without having to use R. If I were able to do most of the data science that I normally do inside Power BI without using R, I would decrease my use of R and mostly use Power BI. 

      For how long have I used the solution?

      I have been using Microsoft Power BI for four and a half to five years. I have been using it since they created in basically. I started using it when it was Power Pivot in Excel and as soon as they created Power BI, I started using it. 

      What's my experience with pricing, setup cost, and licensing?

      I recommend easing into Microsoft Power BI gradually. I started by creating models and graphics in Excel first. Then, when I learned a little bit about modeling, I started moving to Power BI and working there. 

      So, I recommend starting with Excel and practicing there first. Power Pivot is the app that you can use in Excel for this kind of work. Before switching to Power BI, learn about data modeling and dashboarding in Power Pivot in Excel first. 

      Which other solutions did I evaluate?

      Before switching to Microsoft Power BI, I evaluated Tableau. It's a lot cheaper to use Power BI. The cost per user in Power BI is around $10 per month, while the cost per user for Tableau is a lot more expensive. That was a deciding factor for me. 

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Part Owner at a tech services company with 11-50 employees
      Real User
      Great technology and some very good features
      Pros and Cons
      • "Good CS and administration."
      • "Creating dashboards could be easier."

      What is our primary use case?

      I am a consultant for a big company. We deal with energy companies, petroleum, sales companies and we deal with everything from financials to operations. We deal with market strategy and we provide consultancy services - I'm a part owner of the company. 

      What is most valuable?

      I like the CS, administration, most of the features are good as well as the technology.

      What needs improvement?

      I think creating dashboards could be easier. Compared to other solutions, the cost of the license is expensive and that could be improved. 

      For how long have I used the solution?

      I've been using this solution for over 20 years. 

      What do I think about the stability of the solution?

      The stability is excellent. 

      What do I think about the scalability of the solution?

      The scalability is excellent, all our professional consultants use it. Where we deploy in the banking sector, they can have 1,000 licensed users; in smaller companies there can be 50 users. 

      How are customer service and technical support?

      Technical support is quite good, but I'd like to see a quicker response time. 

      How was the initial setup?

      Deployment time depends on the company, it can take up to two months. 

      What other advice do I have?

      I rate this solution a nine out of 10. 

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Inovation Manager at SoCalGas
      Real User
      Creates charts and graphs to provide visuals of the data
      Pros and Cons
      • "The standard BI visualization capabilities are great."
      • "Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution."

      What is our primary use case?

      We mostly use this solution for dashboards and reporting.

      There are roughly 2000 people in our office. At the least, 100 people use Power BI. We have around 10 super users who use it a lot. A lot of people just use it to look at dashboards. A lot of managers look at Power BI for their dashboards.

      How has it helped my organization?

      It has centralized our organization. It has democratized dashboard and report building and provides a centralized format. Without Microsoft BI, people would otherwise develop and manage their spreadsheets in Excel, which is just a lot harder than what Power BI enables us to do.

      What is most valuable?

      The standard BI visualization capabilities are great. It makes all the visualizations and has a drag and drop builder. It also has a power query data modeling capability that's excellent.

      What needs improvement?

      We're a big organization. We're looking at standardizing. Anybody can just pick it up and use it because it's easy. We want to be able to standardize what Power BI is and I think that's a challenge that we're encountering now.

      Anything they can do to improve enterprise collaboration is going to help people get set up and utilize the solution.

      For how long have I used the solution?

      I have been using Microsoft BI for roughly two years.

      What do I think about the stability of the solution?

      It has crashed, but it's pretty stable. I haven't had any problems where a published dashboard was not working. Once a dashboard is published, I haven't seen any problems with it.

      I think it depends a lot on the data access. As long as the data backend can get into Power BI, then everything works. If there are any data connection issues, that's when there will be problems.

      How are customer service and technical support?

      I get tech support from my admin. I've never contacted support.

      What about the implementation team?

      We have a Power BI admin administrator that helped us with the initial setup. From the user's perspective, it's pretty easy.

      What's my experience with pricing, setup cost, and licensing?

      I think it's a good price, from what I've heard. I know it's competitive with other Power BI tools. It comes in lower. I've heard no complaints about the pricing.

      Which other solutions did I evaluate?

      Our company did evaluate Tableau and a couple of other tools. We ended up promoting Power BI for everyone because it was licensed and we were already using Office 365. It integrates well with all of our existing environments.

      What other advice do I have?

      From a user's perspective, I'd advise people to really try to understand the data sources and have a good data environment in place, beforehand. That makes the Power BI environment much better.

      Overall, on a scale from one to ten, I would give this solution a rating of nine. I think it's the best BI tool that I've used. I know it has a really good rating. It accomplishes a lot for us in terms of data manipulation and BI in the reporting.

      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Partner at a tech services company with 1-10 employees
      Real User
      Easy to use, good scalability, and reliable
      Pros and Cons
      • "The solution is easy to use."
      • "There are some problems with the functionality of this solution. The dashboard is not very user friendly and is quite complicated."

      What is our primary use case?

      I have used the solution for analytics which is displayed on the dashboard for my client.

      What is most valuable?

      The solution is easy to use.

      What needs improvement?

      There are some problems with the functionality of this solution. The dashboard is not very user friendly and is quite complicated. They need to make it easier for developers because they could bring key components into the dashboard. I have found using scripting language in other competitor solutions easier.

      Since I am new to using this solution I am not sure what should be in a future release. I probably do not need all of the features in this current version.

      For how long have I used the solution?

      I have been using the solution for a couple of months.

      What do I think about the stability of the solution?

      The stability is good. 

      What do I think about the scalability of the solution?

      The solution is scalable. We have a couple of people using the solution in my organization.

      Which solution did I use previously and why did I switch?

      I have used Qlik Sense in the past and it is more functional than this solution. I prefer Qlik Sense and I will most likely be switching soon.

      How was the initial setup?

      The solution is easy to install and it does not take long.

      What about the implementation team?

      I did the implementation.

      What's my experience with pricing, setup cost, and licensing?

      As far as I am aware you do not need a license for the solution.

      Which other solutions did I evaluate?

      Comparing this solution to others such as Tableau and Microstrategy, this solution is probably better. However, I think overall Qlik Sense is best for me.

      What other advice do I have?

      I am not going to be using the solution in the future because I prefer Qlik Sense.

      I rate Microsoft BI an eight out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      New Build Completion & Commissioning at a energy/utilities company with 1,001-5,000 employees
      Real User
      Powerful, user-friendly, and easy to set up
      Pros and Cons
      • "The product can go easily go and extract data and it can put it into any format."
      • "I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint."

      What is our primary use case?

      We primarily use the product for running the reports and all data extraction in our organization.

      What is most valuable?

      The solution is a wonderful tool overall. 

      Power BI is very powerful and very easy to use. Its user-friendliness is one of its most valuable aspects. It has a very nice user interface that makes everything easy to navigate.

      The product can go easily go and extract data and it can put it into any format.

      It's a very good data analytic tool.

      The initial setup is pretty easy. It's pretty straightforward in general.

      What needs improvement?

      I can't say that anything glaring is missing from the offering at this time.

      Microsoft is doing a lot of research on it and they're coming up with a lot of good release items.

      I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint.

      I'd like to have more time with the solution to evaluate it to see if there's really anything missing. We don't really go in-depth with the product.

      For how long have I used the solution?

      I've been using the solution since about 2017. It's been a few years now.

      What do I think about the stability of the solution?

      The stability is very good. It's a Microsoft product and therefore they wouldn't put anything out that wasn't tested and worthy of release. There aren't bugs or glitches. It doesn't crash or freeze. It's quite reliable and offers good performance. 

      What do I think about the scalability of the solution?

      While the scalability is there, the cost is what you have to factor in. It has to scale as if there's more data, it needs to meet that demand and be able to extract and analyze it.  

      How are customer service and technical support?

      Technical support for the most part has been very good. They are helpful and responsive. We are satisfied with the level of support we receive. On a scale of one to 25, I would give it a mark of 20.

      How was the initial setup?

      We've found the initial setup to be pretty straightforward. It's not complex. A company shouldn't have too much trouble getting everything up and running.

      What's my experience with pricing, setup cost, and licensing?

      I'm not sure of the exact cost of the solution. It's not an aspect of the product I need to worry about.

      I am aware that we currently have an enterprise license.

      Which other solutions did I evaluate?

      I personally haven't evaluated or compared any other solutions. I don't have any knowledge in terms of how it compares to other options.

      What other advice do I have?

      We are customers and end-users. We don't have a specific business relationship with Microsoft.

      I would rate the solution eight out of ten overall. We've been pretty satisfied with the product.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Research & Development Expert at a energy/utilities company with 11-50 employees
      Real User
      Good visualization and graphing functions, integrates with Python
      Pros and Cons
      • "The most valuable feature is integration with Python."
      • "The integration with third-party products could be more stable."

      What is our primary use case?

      I use Microsoft BI for my own projects that are related to integrating with Excel datasets. I use the visualization and graphing functions, and I have tried using the Python integration.

      What is most valuable?

      The most valuable feature is integration with Python.

      What needs improvement?

      The integration with third-party products could be more stable.

      For how long have I used the solution?

      I have been using Microsoft BI for approximately one month.

      What do I think about the stability of the solution?

      Microsoft BI could be a little more stable.

      What do I think about the scalability of the solution?

      We have approximately 10 users. I don't expect that we will expand our usage or continue using this product.

      How are customer service and technical support?

      I have not been in contact with technical support.

      How was the initial setup?

      There is no complexity in the initial setup. It takes approximately 15 minutes to deploy.

      What about the implementation team?

      There are twenty people in the team that handles the deployment and maintenance of our solutions.

      What other advice do I have?

      In summary, this is a good product and I recommend it.

      I would rate this solution a nine out of ten.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Project Manager at a computer software company with 5,001-10,000 employees
      Real User
      User-friendly with a straightforward setup and good stability
      Pros and Cons
      • "The initial setup is pretty straightforward."
      • "It seems that the solution could use more analytics to help users draw more contextual business insights. Right now, you need other solutions for that."

      What is our primary use case?

      We primarily use the solution to run our industry reports. We get the data from data warehouse we are creating. I use it to export the data.

      We have been using Microsoft BI for one of the customers. That was completely in the customer environment. That's all. We did not have that solution for us in-house. However, we are working towards introducing it for our own purposes in the near future.

      What is most valuable?

      The product is very user-friendly.

      The solution can be used with any BI tool you have.

      The initial setup is pretty straightforward.

      The solution has been very stable for our customers.

      It appears the solution has the capability to scale, although we have yet to try to do so.

      What needs improvement?

      We have yet to implement the solution completely. We're still exploring features and capabilities. It's too early to discuss items that may be lacking.

      It seems that the solution could use more analytics to help users draw more contextual business insights. Right now, you need other solutions for that.

      For how long have I used the solution?

      I've been using the solution for the past five years now. It's been a while.

      What do I think about the stability of the solution?

      The product has been quite stable so far. The performance is good. It's reliable. There aren't bugs or glitches. It doesn't crash or freeze.

      What do I think about the scalability of the solution?

       We have not attempted to scale the solution yet. We are in the initial stage of exploring different features on it. We believe it to be a scalable product, however, we have not attempted it ourselves yet. We might in the future.

      We don't have any customers on the solution right now as we are just trying to figure things out.

      How are customer service and technical support?

      We haven't used technical support. I wouldn't be able to speak to how helpful or responsive they are. 

      Which solution did I use previously and why did I switch?

      We are also using Tableau. We use Tableau right now, and we are likely introducing Microsoft BI in-house in the near future. For now, we just have customers that use it.

      How was the initial setup?

      We found the initial setup to be straightforward. It's not a difficult implementation and I wouldn't describe it as complex. A company setting up the solution for the first time shouldn't have any problem doing so.

      What's my experience with pricing, setup cost, and licensing?

      We're still in the process of licensing the model. We don't have it set up yet. My understanding is that we will pay for licensing on a yearly basis. I don't have the exact figures in terms of the costs.

      Which other solutions did I evaluate?

      Right now, I am looking to do a comparison between Tableau, Power BI, MicroStrategy, and Pyramid Analytics. I have not had a chance to really dig too deep into research.

      What other advice do I have?

      We are just customers and end-users. We don't have a business relationship with Microsoft.

      We are using the most recent version of the solution at this time.

      We're still exploring the solution and haven't fully implemented it yet.

      I would rate the solution at an eight out of ten. It's very user-friendly and so far I have had a good experience.

      Which deployment model are you using for this solution?

      Private Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Business Application Group Manager at OBASE
      Real User
      Scalable with various licensing options and offers good technical support
      Pros and Cons
      • "Technical support is quite good."
      • "The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."

      What is our primary use case?

      We primarily sell Power BI licenses. 

      Mostly, we focus on the retail industry. Usually, we are using the Power BI reports for dashboards. We are also providing our customers with some data warehouse reporting. Basically, we do long-term categorization of stock and inventory numbers and sales figures so that they can compare the sales and stocks to the inventory numbers.

      We tend to deal with physical inventory reports. We tend not to deal with the solution for financial operations.

      What is most valuable?

      The solution has different licensing tiers.

      The product can scale if you need it to.

      Technical support is quite good.

      With the cloud deployment, there's no setup required.

      The product works well for small or mid-level organizations.

      What needs improvement?

      The solution's stability could be improved. In the retail industry, due to issues with information updating and data uploading. Clients may end up pricing items wrong as they could accidentally base their choices on old or wrong data.

      The licensing needs improvement. There needs to be a middle option between Pro and Premium versions. It could also be less expensive.

      For how long have I used the solution?

      While we have experience with Microsoft tools for the past ten years, I personally have had experience with Microsoft BI for the past two or so years.

      What do I think about the stability of the solution?

      The solution is not really stable. I've faced a lot of limitations especially in terms of some data flows updates. We have faced some exceptions. Right now, we have created a case for Microsoft in order to solve some problems we've been having as, right now, there's some sort of system fault.

      While the platform is a little more stable, the big problem is the latency issues around customer updates.

      In a recent project, in Sweden, we faced an exception in Power BI from the update path. Whenever we refresh the animations and the fact tables, we faced something that said we couldn't upload the data. After 20 minutes we tried to refresh again. We didn't change anything with our reports or platform or anything related to infrastructure or schema. We didn't touch anything. An yet, the data is updated successfully. That leads us to ask the question: what was the problem 20 minutes ago? We still don't know the answer.

      That is why we need some stability for the update service. We are deciding some business decisions based on this data. If this data is not updated, we may decide to take the wrong path. 

      This is very important in the retail industry. For example in the grocery field, sometimes with vegetables or fruits or other products, customers need to decide to change the prices within lock days. They need to decide, based on demand, if they should increase or lower prices. They can't make the correct decisions if the numbers don't update.  

      What do I think about the scalability of the solution?

      The scalability potential actually depends on your licenses. Microsoft provides three licenses. One of them is absolutely free. Another is called Pro. Yet another is per user or Premium. There is a huge difference between the Pro license and the Premium license. There is no need to scale the Pro license or other license models.

      When you put the on-premise reports, you can scale out or scale up. It depends on your existing resources. However, in the services as a software (SaaS) version, it actually comes with Microsoft's units or Microsoft resources. 

      How are customer service and technical support?

      We have an ASFP agreement with Microsoft. As a Gold Partner, Microsoft is pretty good and responding automatically and helping us resolve issues.

      If a partner does not have an ASFP agreement, they tend to have to go to forums or try to Google answers to their problems.

      We are aware that sometimes when we make changes to BI, the solutions might be complex. There might be SQL involved, which needs to be taken into account, for example. We may have to look into other resources and other tools to see if there are interactions that are the issue. However, Microsoft is quite helpful as we work through issues. We're quite satisfied with their level of support.

      Which solution did I use previously and why did I switch?

      We also work with and sell MicroStrategy in Turkey. 95% of the MicroStrategy projects have been completed with our company. It is a direct competitor with Power BI. My company commonly does consulting for some small and medium markets and for that we recommend Power BI. Whenever we talk about enterprise-level solutions, the company we will use is MicroStrategy.

      How was the initial setup?

      There isn't much of an installation process, as the solution is on the cloud.

      What's my experience with pricing, setup cost, and licensing?

      There is a free license, however, it is limited. The Premium license and the Pro license functionalities are very different. Whenever we talk with our customers, they ask "Should we chose the Premium?" We say that "No, you don't need to, as it's too expensive. It is much more expensive than the Pro license." However, the Pro license functionality is not enough for some customers. There is no middle between Pro and the Premium. We need something in between.

      The Pro license is maybe suitable for SMBs, small and medium-sized businesses. The premium version is ideal for companies that need to scale up and out.  

      There also may be some additional costs that can drive up the price.

      What other advice do I have?

      I prefer this product and I suggest Power BI to all customers, however, we know that if Power BI is a new idea, we make sure to show company-specific data or analytics for analyzing the data and how this solution can analyze everything quickly. That said, it's not for everybody. If all companies tried to put all their reporting expectations in the Power BI, it would not fit their expectations.

      It's not a standalone solution. You need other items in your toolbelt. You need, for example, something that can handle raw data, you need warehousing, et cetera.

      In general, I would rate the solution eight out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
      PeerSpot user
      Global Director - HR Technology & Platforms at a manufacturing company with 10,001+ employees
      Real User
      Good visualization with an easy initial setup and good overall stability
      Pros and Cons
      • "The fact that you can visualize items is great."
      • "The solution could be quicker at rendering data."

      What is our primary use case?

      We primarily use the solution for building dashboards, one-off analytics, and things of that nature that combine data.

      How has it helped my organization?

      The functions from a standpoint of generating analytics have been really helpful overall. That aspect has helped improve our organization.

      What is most valuable?

      In general, we are pretty pleased.

      The ability to combine the data and to connect with pretty established platforms has been the solution's most valuable aspect to us. 

      The fact that you can visualize items is great. The visualization power is very good.

      The initial setup is straightforward.

      What needs improvement?

      I don't know if I can pinpoint any specific items that I don't like. However, the more connectors that they provide the better. 

      I don't use it day in, day out to tell you if it has any kind of functionality items that may be open up for improvement opportunities. 

      The solution could probably beef up items related to statistics and things to cover the gap between the advanced things that you can do with Tableau. Any kind of advanced statistical analysis would be very helpful in future releases.  

      The solution could be quicker at rendering data.

      For how long have I used the solution?

      I've been using the solution for three years or so.

      What do I think about the stability of the solution?

      The solution is very stable. It's reliable. We've been happy with it. There aren't bugs or glitches. It doesn't crash or freeze.

      What do I think about the scalability of the solution?

      The solution can scale well if you need it to. That shouldn't be a problem for any organization.

      I'm not sure how many people are actually using the solution in our organization. Everybody has been kind of encouraged to leverage the platform on an ongoing basis. However, obviously, those that are holding jobs related to any kind of analytics are probably more prone to using it.

      How are customer service and technical support?

      I don't tend to deal with technical support. That's probably more on the IT team than on my plate and therefore I don't really know how their tech support works. I can't speak to their knowledgeability and response times.

      Which solution did I use previously and why did I switch?

      With our company, there were probably those that needed to do advanced analytics that were using solutions like Tableau or Excel.

      How was the initial setup?

      The initial setup is not complex. It's pretty straightforward. A company shouldn't run into any problems when it comes to setting it up.

      What other advice do I have?

      We have a pretty strong partnership with Microsoft and we tend to help them develop their product as well.

      We are using the latest version of the solution at this time.

      I would advise other organizations that the product has a lot to offer and therefore it's worth the investment and the effort.

      I would rate the solution at a nine out of ten. Sometimes it could be quite at rendering data, however, overall, we've been happy with the results.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Business Analyst at a non-tech company with 10,001+ employees
      Real User
      An easy and flexible BI solution, but the dashboard could be better
      Pros and Cons
      • "The Microsoft Power BI app is very good. It's also very flexible."
      • "The dashboard could be simplified."

      What is our primary use case?

      We use it mainly for Qlik Sense. We're using business interests analytics. Everyone from marketing to sales uses it. Microsoft BI is usually used for oversight.

      What is most valuable?

      Microsoft BI is easy and but not very user-friendly. But you can directly connect it to an Excel file. You can find out how many sites to look at and do it yourself directly. The Microsoft Power BI app is very good. It's also very flexible. 

      What needs improvement?

      The dashboard could be simplified. The service is currently good, but it could be better. If you compare it to Tableau and Qlik Sense, they are doing much better work. The ability of their dashboards is much better. The technical part is easy in Qlik Sense, where we can do some coding. It isn't easy in Power-BI.

      Microsoft BI can be more user-friendly. Scalability is also a challenge for us because it's difficult to handle Power BI's dashboard.

      For how long have I used the solution?

      I have been using Microsoft BI for the last four years.

      What do I think about the stability of the solution?

      Microsoft BI is a stable solution. We haven't had any issues yet.

      What do I think about the scalability of the solution?

      It's not very scalable because it's difficult to manage the Microsoft BI dashboard.

      How are customer service and technical support?

      Technical support is good.

      How was the initial setup?

      The initial setup is very easy.

      What's my experience with pricing, setup cost, and licensing?

      Their price is good.

      What other advice do I have?

      I would recommend this product to potential users. But if they have options, I would recommend one of the others.

      On a scale from one to ten, I would give Microsoft BI a six.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Assistant Vice President at a tech services company with 10,001+ employees
      Consultant
      A complete and in-demand solution with good price, integration, and features
      Pros and Cons
      • "Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python."
      • "It should be more scalable for an enterprise-level implementation. When you deploy large data sets, the response has to be faster in Power BI. This is one thing that needs to be improved in it."

      What is our primary use case?

      I lead the data visualization competency. As a competency leader, my responsibility is to make people grow in this technology. It could be Power BI, Tableau, or QlikView. We are service-oriented, and depending upon the demand, we have to have experienced people and a resource pool ready in these areas. Depending upon the requirement, I decide how many people need to be trained or hired.

      What is most valuable?

      Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python. 

      What needs improvement?

      It should be more scalable for an enterprise-level implementation. When you deploy large data sets, the response has to be faster in Power BI. This is one thing that needs to be improved in it.

      For how long have I used the solution?

      I have been using this solution for close to two years.

      What do I think about the stability of the solution?

      We found no issues. It is an aggregated reporting tool. It cannot handle a detailed level of data. It is meant only for the dashboarding purpose. You need to have your underlying data in an aggregated way, and then it would be faster. It depends on whether you have a live connection or you don't have a live connection.

      How are customer service and technical support?

      We don't see many issues, but whenever we put a request, they at least respond.

      Which solution did I use previously and why did I switch?

      I have worked on Tableau. Before Tableau, I have worked with traditional tools, such as SAP BusinessObjects. My team has got experience with Spotfire, but we are not seeing a great demand for Spotfire.

      If you ask me for the top three, I would qualify Power BI, then Tableau, and then QlikView. That's the demand that I'm seeing in the market from various customers.

      What's my experience with pricing, setup cost, and licensing?

      I am satisfied with its price. Its price is very less as compared to Tableau and QlikView.

      What other advice do I have?

      My first advice is to learn SQL. The foundational knowledge and SQL skills are the most important. You have to be very strong in writing SQL code. You have to improve your mind so that you know what you are writing in Power BI. After that, it is very easy to pick up any front-end reporting tool, such as Power BI or Tableau. After you have good expertise in Power BI, you can slowly learn Python so that you can do good integration. All these efforts would be great for your career.

      Being a gold partner of Microsoft for the past few years, we work directly with Microsoft product teams. Sometimes as part of a pre-launch, they also connect with us. If we see a feature or functionality that a client requires, we at least put it across to them. How they prioritize it within their product team is up to them. They prioritize depending on the need of the market and demand from various clients, and they release features accordingly. Sometimes, we also work on a pre-release.

      They release new features and functionalities every month. They have also recently released data protection smart narratives. If you look at the Gartner report, they are leading. I see a lot of demand for this solution.

      I would rate Microsoft BI an eight out of ten.

      Disclosure: My company has a business relationship with this vendor other than being a customer: partner
      PeerSpot user
      Managing Director at IDMdev Tech Solutions®
      Real User
      It is stable and provides a quick view of the most important indicators, but its setup and support should be better
      Pros and Cons
      • "The use of graphics to show and view the data indicators is the most valuable feature. It is also very stable."
      • "Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions."

      What is our primary use case?

      We have integrated this solution into the software that we created for a client specifically for reports and data consumption. It is a hybrid infrastructure project with hybrid integration. It has a lot of reports executed or created from the cloud.

      How has it helped my organization?

      It has helped us to have a really quick view of the most important indicators of the operational issues of our platform. It has enabled collaboration between different operational levels in the company.

      What is most valuable?

      The use of graphics to show and view the data indicators is the most valuable feature. It is also very stable.

      What needs improvement?

      Its setup and support should be improved. We would like to see more material for developers that provides clear explanations about how we can do data mining by using Microsoft BI. It would also be good if we can connect a feature to other customized machine learning solutions.

      What do I think about the stability of the solution?

      It has good stability.

      What do I think about the scalability of the solution?

      We haven't used it a lot, but it seems good so far. We have only three users. We may include two or three more users to the platform.

      How are customer service and technical support?

      Their technical support is bad. I didn't like the technical support of Microsoft.

      Which solution did I use previously and why did I switch?

      We also use Oracle and Tableau.

      How was the initial setup?

      The initial setup was not complex, but we would like a more agile process. The initial deployment took about two months. The platform that we created was very robust.

      What about the implementation team?

      We are a reseller of the solution. We did the deployment.

      Which other solutions did I evaluate?

      We were thinking of integrating Tableau instead of Microsoft BI, but the client chose Microsoft BI.

      What other advice do I have?

      I would rate Microsoft BI a seven out of ten.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Director of Sales and Marketing at a tech services company with 11-50 employees
      Real User
      Integrates well with Microsoft tools and has a good familiarity but lacks technical support
      Pros and Cons
      • "It integrates with all of the Microsoft tools."
      • "The initial setup is a little bit technical."

      What is our primary use case?

      We primarily use the solution for integrating into our ERP so people can have a dashboard analysis of whatever is important to analyze or compare, whether it be top-selling products or sales performance, or quota analysis.

      What is most valuable?

      Just as a BI tool, there's not much difference between solutions. It works well with our product and it's something that customers are familiar with and they often already have a lot of licensing with Microsoft. It's an easy add-on to their users.

      There's generally a sense of familiarity with the product.

      It integrates with all of the Microsoft tools.

      What needs improvement?

      It's not even fair for me to respond on that as that's not my wheelhouse. I don't know how easy it is as I'm not doing any of the designs. Therefore, I have not had any real training on it. I don't think that's fair for me to criticize anything that they're doing.

      The initial setup is a little bit technical and what an end user wants to see is always a moving target.

      The solution needs better technical support.

      For how long have I used the solution?

      I've been using the solution for about three years at this point.

      What do I think about the stability of the solution?

      In terms of stability, we haven't had any challenges with it at this point. As with multiple integrations across several companies we tend to make whatever change is best for the biggest base of clients. We haven't had any issues thus far.

      How are customer service and technical support?

      Technical and end user support is something that might be lacking from Microsoft. As a user when I want to find an answer to, "Hey, how do I do this?" I often get better answers by going to a  website of a company that represents them than I do going directly to their site.  Maybe they do that on purpose to help drive business to those people, however, it would be helpful if it was more centralized and the quick and simple steps answers that I get elsewhere.

      Which solution did I use previously and why did I switch?

      I have some past experience with solutions such as Tableau and Cognose but not integrated into this ERP product.  We chose one that we would feel would be on a common platform of our customers.

      How was the initial setup?

      The setup is fairly straightforward but implementation is a little bit complex mostly due to how the customer driven scope changes often as they realize the power of a BI tool and want to be able to expand it's use.

      We're on a Progress platform, so that's a little more technical on our side at the beginning of the original project.

      What's my experience with pricing, setup cost, and licensing?

      The licensing costs vary. It all depends on the individual customer due to the fact that Microsoft's options are modular. For example, they have Microsoft Office suite, then they add CRM and then you might add BI.  It's not expensive per user, however, as you increase the functionality or add different tools, it becomes more expensive.

      What other advice do I have?

      We qualify as a partner as we're a software distributor. We're using the most current version of the solution.

      Here is the biggest thing: when you look at any BI tool or if it's the first time you're implementing one, you can easily get over enticed by the flashy display or the common things. However, it's the ability to drill down to your true business processes that are going to make it or break it as being the right tool or accesses the right information. Somebody that gets a BI tool for the first time will open a dashboard and say, "Oh, that's important for me to see every day." However, the reality is, when using a dashboard view you're looking for a red flag or highlights. The power of the BI tool is allowing you to drill down to the data behind the dashboard, that's where the real testing comes in.  Figuring out where to get the information from and how best to analyze it.  That's my best BI tool advice. Anybody can make a dashboard look pretty. It has to be useful too.

      In general, I would rate the solution seven out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Business Intelligence Manager at a tech services company with 51-200 employees
      Real User
      Good reporting, enables self-service BI, it's stable, and we are satisfied with the pricing
      Pros and Cons
      • "It's easy to create reports and it's easy to download the data from the corresponding report."
      • "We would like improvements made to the paginated reports so that it produces quality similarly to SSRS."

      What is our primary use case?

      This solution is primarily used for business analytics. We generate reports so that the business analytics team can use them for their analysis.

      How has it helped my organization?

      Previously, we used Excel to perform the analysis. It was very tedious for them to get data into Excel, do the refresh, and generate the reports. Now, using Microsoft BI, they can connect directly with the data, it gets refreshed automatically, and they don't have to worry about refreshing it.

      They get the data in the report section and they don't have to worry about report generation, data modeling, and other aspects.

      What is most valuable?

      The most valuable feature is the reporting. It's easy to create reports and it's easy to download the data from the corresponding report.

      This product enables self-service BI.

      What needs improvement?

      The paginated report functionality, which was intended to replace SPSS, is not yet up to the mark. We would like improvements made to the paginated reports so that it produces quality similarly to SSRS.

      There is no automation for paginated reports, so then need to make it automated.

      Ultimately, I would like to see all of the features from SSRS that are missing. That's ideally what I would like to have.

      For how long have I used the solution?

      I have been using Microsoft BI for the past 10 years.

      What do I think about the stability of the solution?

      This product is pretty stable.

      What do I think about the scalability of the solution?

      Scalability depends on the kind of reports and data we are looking at. It has multiple features for us based on the functionality and the requirement of the customer. It's not limited only to enterprise-specific customers. Rather,  It can be used by small, medium, as well as enterprise-based customers.

      There is no limitation as such. So it's quite scalable.

      I have work two different companies at this time, and as far as I know, there are between 1,500 and 2,000 people who use this product.

      How are customer service and technical support?

      The quality of support depends on the Microsoft partner that you are working with. 

      We have not faced any significant issues, but when we have, we raised a bug with the Microsoft technical team and they have resolved things accordingly.

      Which solution did I use previously and why did I switch?

      This is the only tool that we are using for reporting. Previously, we used Crystal Reports.

      What about the implementation team?

      We deployed this product ourselves. We used the documentation that is available at Microsoft.com.

      What's my experience with pricing, setup cost, and licensing?

      The cost of licensing depends on the number of people that are going to be using the reports, and we are satisfied with it at $10 per user.

      Which other solutions did I evaluate?

      Our company focuses on Microsoft products, so we did not evaluate solutions by other vendors.

      What other advice do I have?

      My advice is that if you are looking for an aggregated level of data, using it for reporting, then it's better to use Power BI because everything will be in memory and it will be much faster.

      I would rate this solution a nine out of ten.

      Which deployment model are you using for this solution?

      Private Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: partner
      PeerSpot user
      Director Comercial at Grupo Consultores
      Real User
      A robust, scalable, and easy-to-deploy solution that helps in constant collaboration and has a lot of online resources
      Pros and Cons
      • "Constant collaboration is the most valuable. I can build a dashboard, and several co-workers can access this dashboard. We can share information that is important for decision-making. It is a very easy-to-deploy solution. It is compatible with a lot of data sources. It is also very stable and scalable. There is also a very good forum and a lot of help and online training."
      • "I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it. I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources."

      What is our primary use case?

      I use Microsoft Power BI for analytics. It is an online service for business intelligence. I use it to analyze every piece of data that I have. My key performance indicators are on Power BI. My sales indicators, such as number of clients, number of sales and region, type of client, type of solution, due to date comparison, and due to year comparison, are really based on the sales of the company. I am using Power BI Pro.

      What is most valuable?

      Constant collaboration is the most valuable. I can build a dashboard, and several co-workers can access this dashboard. We can share information that is important for decision-making.

      It is a very easy-to-deploy solution. It is compatible with a lot of data sources. It is also very stable and scalable. There is also a very good forum and a lot of help and online training.

      What needs improvement?

      I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it. 

      I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources.

      What do I think about the stability of the solution?

      It is a very robust and stable solution. We are a company that works with enterprise solutions from SAP and Microsoft. We have worked with companies that have 5,000 users and without a problem. So, it is very robust and stable.

      What do I think about the scalability of the solution?

      Being a cloud solution, it is very scalable. You can easily scale it based on the usage. If you're using it, you pay for it, and if you're not using it, you stop paying for it.

      In our company, Power BI being used by maybe 15 people out of 70. It is a growing solution. Three years ago, we had only five people who were working with Power BI. Now, we are building more and more dashboards for our service desk area, and its usage is growing.

      How are customer service and technical support?

      I haven't contacted them. We report everything to our own Service Desk, and they are the ones who scale the problem to the manufacturer. This means that every time that we have important issues, they have to be solved in a very decent period of time by the manufacturer. There is a very good response time, and every time we had problems, they were solved. We didn't have anything pending.

      How was the initial setup?

      Given the fact that it is on the cloud, it is really easy to deploy. It is only about connecting the engine to your data source and start building the dashboards. You can just connect your data. It doesn't matter if it is on-premises or as a service. You can just connect it.

      What's my experience with pricing, setup cost, and licensing?

      It is based on the usage. If you're using it, you pay for it, and if you're not using it, you stop paying for it.

      What other advice do I have?

      If your data source is a Microsoft-based data source, this is the best choice. If you have a data source that is not Microsoft-based and is on a non-Microsoft platform, such as MongoDB or Unix, you should see some solutions like MicroStrategy or Qlik. If you have a pure 100% Microsoft-based data source, Microsoft Power BI is the answer. You can do wonders with Microsoft Power BI. It is a very cool solution.

      I would rate Microsoft Power BI a nine out of ten.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Software Engineer at syntegra
      Real User
      Top 20
      Easy data source connecting, simple implementation, but needs more financial visuals
      Pros and Cons
      • "I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated."
      • "I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients."

      What is our primary use case?

      We are an analytics company, and we consult for different companies. Currently, we were doing automation of financial reporting, income statements, balance sheets, cash flow, and different kinds of analysis on revenue and products. We extract data from ERP solutions, accounting data, and then we transform that into financial reports.

      What is most valuable?

      The data modelling and the use of decks are key features. It is difficult to create financial statements using most BI solutions, with decks it is a bit easier to summarize data and to have cascading totals that you would find in an income statement or balance sheet. Most other solutions, you can not have a moving total but with this solution, we found it very easy to implement. 

      I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated. 

      What needs improvement?

      I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients. We should have a visual for income statements and other elements, this should be made easier. For example, suppose you are looking at an inventory report, it is all plug and play because you can just use a matrix or a table to summarize the information and the visuals. The systems are more adapted to that kind of area than for financial purposes.

      For the next release, I think they need to improve on getting more visuals that are related to the finance side of things. Like I mentioned before, the matrix now is more of an OLAP cube, we are looking into something more adapted to the finance field, such as a drag and drop where you can build an income statement very quickly without too much code. This would be a nice addition. 

      As far as I understand Microsoft has two solutions that are similar, Power BI Report Builder and Power BI Desktop. The features that you get in Power BI Desktop are more advanced than the features that you get in Power BI Report Builder. They should just merge the two and move forward this way. There is no reason to have two different applications serving the same purpose.

      For how long have I used the solution?

      I have been using the solution for 18 months.

      What do I think about the stability of the solution?

      The biggest problem we have had is refreshing with MySQL, we are using a MySQL backend. It has to refresh all the data at once and store it in a cache, is my understanding. I am not sure where Power BI stores the data that it gets from the warehouse, this takes some time. If there are interruptions in the network, then the figures become messed up at some point. It should either commit all the data or it should not commit anything at all if there are errors. I think that is the biggest issue we have had so far.

      What do I think about the scalability of the solution?

      We are rolling out the solution to various clients and one of them is a large client in the manufacturing industry. The solution scalability is very good, we can do a lot with it.

      We have about 40 users at the moment. As we continue to expand, we are looking at approximately 20 companies with about five users at a time. Currently, we have done five companies, but I think by the end of this quarter, we should have about 100 users in total. At the end of the year, we hope to have at least 200 users from different financial departments in different companies. It is my team that does the financial reporting, we also have other companies that have the operations and logistics. We are looking to probably double that figure because eventually, we should be moving to the enterprise license. We had seen that the enterprise license will be beneficial to us. If everything goes as planned, we are looking at about 500 users at some point.

      How are customer service and technical support?

      At the moment we have not needed much technical support from Microsoft. Most of the problems we have faced have either been resolved by someone else on the forums available. We also have an expert consultant in the UK who helps us. The areas that have needed assistance has been very minimal.

      Which solution did I use previously and why did I switch?

      We have used Eclipse BIRT and Knowage in the past but were not as good and more complicated. We find Power BI is more direct, it is much easier to connect to other data sources and so forth.

      How was the initial setup?

      The setup was very straightforward. You just download through the Windows Store or through the website, then you just start to connect your databases.

      What about the implementation team?

      The first deployment took approximately four months. The data preparation took most of the time, once we got into Power BI we had most of our financial reports in a month.

      Part of our implementation strategy was to get the requirements from the customer, documents, information on what they were using before, key performance indicators and other information. Afterwards, we started to build the data warehouse with the requirements in mind. We tried to mimic the reports that they were using before when we were building the Power BI reports. We tried as much as possible to have reports that look similar to the reports to meet our customer's needs.

      There is a similarity between Microsoft Excel and Power BI. If you understand one it make the other easier to understand. If you grasp Excel, it is easy to grasp Power BI as a user. We wanted to make it as similar as possible to the Microsoft Excel experience, with the drill-downs and the pivot tables and so forth. I think with the matrix in Power BI, it is more or less similar, it is the same experience. To summarize our implementation strategy, it was to try to mimic the reports as much as possible and then add more features that are available in Power BI.

      What's my experience with pricing, setup cost, and licensing?

      We pay on a monthly basis which is approximately $10 per user on the Microsoft Power BI Pro license. At the moment we are still down at 400 users, but once we reach 500 users, we will move to the premium edition. The premium is $5,000 for unlimited users. Currently, with the 40 users, the cost is roughly $500. 

      There can be some additional cost, for instance, it was an internal decision to have an on-premises gateway set up with the standard Windows Server installed on it. We had to set up this server on our side, which costs us no more than $400. This was important because we needed something to allow our reports to refresh on a regular interval without people using the personal gateways.

      What other advice do I have?

      I would advise those thinking about implementing the solution to compare different products to see what is on the market. They have to look at the pricing which is what we looked at initially, I think it quite affordable. Additionally, research the infrastructure that is required and the cost per user for the different BI solutions. Some of the solutions are cheap, such as Eclipse BIRT and Knowage, but it takes a lot of efforts to get your reports out with them.

      With this solution, it is more of a drag and drop scenario. You have a quicker delivery time as compared to the traditional or the older BI solutions.

      The biggest lesson I have learned with working with this solution has been in the area of data warehousing, you should develop something that is more like a star schema when building a BI solution, especially with this solution. It makes things much easier. We did not favour the star schema, we preferred the snowflake approach. However, data modelling is easier when you use the star schema.

      I rate Microsoft BI a seven out of ten.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Consultant at a computer software company with 10,001+ employees
      Real User
      A scalable BI solution with useful visualization features
      Pros and Cons
      • "I think the visualization part is valuable."
      • "Actionable insights could be better."

      What is our primary use case?

      All our operational dashboards are on Microsoft BI. Visualization is primarily what we use Microsoft Power BI for today. 

      We're in a position to explore all the underlying data. For example, your SLAs, how they're trending month on month, or how your backlog of tickets is going.

      We look at all the respondent resolution SLAs or different priorities every month. If there's a dip somewhere, we're able to double click and then go to the actual client or the ticket, which has caused a problem.

      You can go back and see if you need to do anything to recover from that situation. For example, if your SLA brings 25% and if you're dipping to 94%, go back and see why you're dipping. If there are, let's say, too many incidences from a specific technology or a specific client, go back and see what you need to do to fix those things.

      We're now looking to get to the next level with exploratory analytics. We want to go into what we call explanatory analytics, which analyzes the underlying data. Instead of waiting for something to fail, you come out and say, "Hey, these are some areas that are not working well, and you probably need to look at it."

      We're trying to use Microsoft BI and for what we call actionable insights. This tool should be able to build up and show you what the underlying data is telling you. For example, our affiliates may be trending at 95%, but since we run a shared service, there could be some clients where it's 100% and some clients where it's probably 85%. Those claims could lead to a client-side problem or a client satisfaction issue.

      Explanatory analytics can give you such exceptions automatically. Then you can go back and work on those clients to ensure that you pull your SLA back up from 85% to 95% and ensure that customer satisfaction doesn't dip.

      What is most valuable?

      I think the visualization part is valuable. It's also very easy to build new dashboards. It's fairly intuitive for people who understand the Microsoft Power BI tool.

      We're fairly happy with the product in terms of both configuring the Microsoft BI dashboards and making changes to them. It's fairly easy to make changes.

      What needs improvement?

      Actionable insights could be better. I would like it to provide exceptional reports that you need to act upon to keep your operations or businesses going. That's something I would like to see. 

      On the origination side, if there are better graphs and maps to visualize data like I've seen other tools like Tableau do, it might be useful. They need to have very different ways of presenting information. If it's eye-catching, better than a pie chart or a bar graph, that's even better.

      For how long have I used the solution?

      I have been using Microsoft Power BI for about a year.

      What do I think about the stability of the solution?

      Microsoft BI is stable. We aren't faced with too much downtime. On a scale of five, I would probably rate it at 4.8 out of five throughout any given week.

      What do I think about the scalability of the solution?

      I think we have scaled up Microsoft BI fairly easily because it's on a cloud. We've added users. We added more dashboards from our different service lines, and we found it fairly easy to scale up.

      How was the initial setup?

      The initial setup is fairly easy and straightforward.

      What other advice do I have?

      I would definitely recommend Power BI from a visualization perspective. It's quick and easy to set up and scales up very well. If you've been using data on Excel sheets and converting them to graphs on PowerPoint, I think this is a tool that gives you almost a live visualization of what your operations are. 

      We use it for our day-to-day IT operations. I'm sure it can also be used to visualize other data like how many clients, how clients build up weekly, and the various stages of transitioning client needs into services. These things can be very easily developed on our Microsoft BI dashboard.

      On a scale from one to ten, I would give Microsoft BI an eight.

      Which deployment model are you using for this solution?

      Public Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      CEO at Finanblue
      Real User
      Extremely flexible, enabling data extraction from a variety of sources and systems
      Pros and Cons
      • "Ability to extract data from a variety of sources and systems."
      • "The mobile app is very poor."

      What is our primary use case?

      We use Power BI to manage all business indicators. Our customers' files, operations, number of transactions, satisfaction levels, history. We have a very powerful dashboard we use in Power BI and all our customers use it. I use it to drill down data from customers, to make decisions regarding business and other things. We are Microsoft partners and I'm a board member of our company.  

      What is most valuable?

      Power BI has a unique set of APIs to connect different databases on different systems. It means that I can extract data from a variety of sources and systems. It's very flexible. I work with numerous systems. We have new systems, super fast systems, and I have very old systems that run very well. They don't need updating because they run so well. Power BI has the power to connect with different sources, and I have a data scientist that orchestrates all that data because it's also about understanding the data, the application of intelligence and strategy on the data, and exposing it on the dashboard. 

      What needs improvement?

      I think that they should improve the mobile application that they have, it's very poor. We generally have a very huge area to cover, to move blocks and data. But sometimes I need a small set of data that I can see in my personal iPhone. But the iPhone solution, and the solution from any smartphone, tablet, etc., is so limited. It's particularly important now when so many people are working from home. Sometimes I need to reply to a call from my support or customer teams, they might be asking for a concession for a customer. I want to be able to look at the data on that customer. I take out my phone and I have no data. It's the worst. I think that if they improve the mobile solutions, it would help me and my team. 

      For how long have I used the solution?

      I've been using this solution for five years. 

      What do I think about the stability of the solution?

      The stability of the product is very good. Microsoft solutions are very reliable. They're very mature and deliver reliable solutions. 

      What do I think about the scalability of the solution?

      The scalability is good and powerful. Everyone in the company uses Microsoft tools, predictive tools. Microsoft 365, Power BI, SharePoint, Teams, Word, PowerPoint.

      How are customer service and technical support?

      Technical support is a challenge, it's a complex question. Microsoft has different levels of support, it's all very customized. Different kinds and sizes of companies require different levels of support. The support is strong but it comes at a price. It's their business model. I can buy a number of hours from a specialist and get a real-time response.

      How was the initial setup?

      The initial setup is quite complex and not easy to manage. You need a data scientist. It's not only connected to a data source, it's not only connected to an Excel sheet. For basic use that's okay but for corporate use to extract major features from the solution, you need a data scientist. It's expensive but a necessity and it's a very good investment for companies, because the data scientist enables the company to make better decisions and to help improve customer satisfaction.

      What other advice do I have?

      It's very important to have a very good data scientist, without that it's very difficult. It's a key requirement. I'm only unhappy with the Windows software. I'm a Mac user for over 20 years, and, in comparison, Windows is bad. For us, SAP, Oracle, Salesforce, IBM are not affordable. They're interested in larger companies. In the last few years, Microsoft seems to be happier to go for the smaller companies too.

      I would rate this solution a nine out of 10. 

      Which deployment model are you using for this solution?

      Hybrid Cloud
      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Innovation & Project Portfolio Management Practice Director at FACTUM
      Real User
      I would rate support for this solution as excellent
      Pros and Cons
      • "Our setup is very straight forward and can be done in a matter of hours."
      • "The upgrade process could be improved."

      What is our primary use case?

      We use Microsoft BI on our portfolio management platform. We use live dashboards, in the public cloud.

      What is most valuable?

      We only use it for export and import, but that suits our purpose, along with the dashboards.

      What needs improvement?

      The upgrade process could be improved. Sometimes we miss information if we haven't kept up with the versions. It should be easy to migrate, but it does not provide enough information about what may be lost if you upgrade, especially if something goes wrong with the upgrade. Any current developments should be included in the upgrade so that it is a seamless process.

      For how long have I used the solution?

      We have been using Microsoft BI for about 4 years. We use the latest version, and we have 4 users.

      What do I think about the stability of the solution?

      Very good. We don't have any issue regarding the stability of the solution.

      What do I think about the scalability of the solution?

      The scalability is good.

      How are customer service and technical support?

      You can find everything on their website. We rarely need to contact Microsoft directly, so I would rate Microsoft support for Microsoft BI as excellent.

      How was the initial setup?

      Our setup is very straight forward and can be done in a matter of hours.

      What other advice do I have?

      You have to know what you want to accomplish, meaning that you have to know why you are using the solution, what kind of information you want to show in that solution and the location of the data. I would rate this solution 9 out of 10.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Other
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Solutions Architect at a tech vendor with 10,001+ employees
      Real User
      Top 5Leaderboard
      Full featured dashboard, easy to use, but expensive and needs more customization
      Pros and Cons
      • "The dashboard features are really valuable, you can connect to multiple data points."
      • "The solution could be more customizable and you do not have too much freedom on the code."

      What is most valuable?

      The dashboard features are really valuable, you can connect to multiple data points. Overall, the solution is easy to use.

      What needs improvement?

      The solution could be more customizable and you do not have enough freedom on the code.

      For how long have I used the solution?

      I have used the solution for one year.

      How was the initial setup?

      The install was straightforward and the advanced dashboards operate on well-branded tablets.

      What's my experience with pricing, setup cost, and licensing?

      The premium licensing is approximately $5,000 per month which is pretty expensive.

      What other advice do I have?

      If you are planning on implementing Microsoft BI, having experience with other Microsoft products will make using this solution easy and straightforward. 

      I rate Microsoft BI a seven out of ten.

      Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
      PeerSpot user
      Senior Consultant at a computer software company with 10,001+ employees
      Vendor
      Good user interface, good technical support, and has the ability to scale
      Pros and Cons
      • "The solution's initial setup isn't too complicated."
      • "The integration with other solutions could be improved for reporting aspects."

      What is our primary use case?

      We have a few projects. We're using the solution primarily to develop a modern sitemap.

      What is most valuable?

      The product has a very defined, well-prescribed format to it. It's easy for everyone to use for the most part.

      The training is pretty good. It's well-described so that users can navigate the solution easily and follow the correct steps to initiate tasks effectively.

      The user interface is pretty good.

      The technical support on offer is excellent.

      We've found the scalability to be quite good.

      The solution's initial setup isn't too complicated.

      What needs improvement?

      I need more time with the solution. Right now, I can't think of any features that are missing from the product.

      The integration with other solutions could be improved for reporting aspects. There are some reporting features in Tableau that we need access to and it would be ideal if there was a function between the two for data integration and data manipulation, with the final representation of the report available on Tableau.

      For how long have I used the solution?

      I've been using the solution for a year or more at this point. It hasn't been too long.

      What do I think about the stability of the solution?

      So far, the solution has been largely stable. However, I'm still exploring the solution and testing it against my requirements. The stability hasn't quite been proven fully just yet.

      What do I think about the scalability of the solution?

      The solution is pretty scalable. It meets all of my client's requirements. I'm able to make changes and expand if I need to. It's pretty simple to scale it out as necessary.

      We deal, for the most part, with medium-sized companies. We don't really deal with smaller organizations or bigger enterprises.

      How are customer service and technical support?

      I'm extremely satisfied with technical support. It's been excellent so far. They are responsive and knowledgeable and I always get my questions answered in a timely manner. I have no complaints about their level of service.

      Which solution did I use previously and why did I switch?

      I've also worked with Tableau and SAP products. We use them all currently.

      How was the initial setup?

      The initial setup is not complex in any way. It's quite straightforward. It was installed quite easily onto our system. We didn't run into any issues in that sense.

      What other advice do I have?

      I'm using the calculator version of the solution.

      We use both the cloud and on-premises deployment models.

      We are Microsoft partners. We're not just users.

      Overall, I would recommend the solution. We do have other plans to use other BI solutions, however, we haven't really focused on that just yet. So far, this product has met our needs pretty well.

      On a scale from one to ten, I'd rate the solution at a nine. We've largely been happy with the product and its offering.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: My company has a business relationship with this vendor other than being a customer: partner
      PeerSpot user
      Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
      Real User
      Helps introduce data analytics in a way that students understand and appreciate
      Pros and Cons
      • "What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
      • "When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world."

      What is our primary use case?

      I have taught and mastered many desktop tools, including Power BI, for the purpose of prototyping designs for business intelligence and data warehousing. Currently, I am teaching data analytics at graduate level and Power BI is on my schedule.

      We teach tools like Power BI by going through common scenarios in a business intelligence environment, which most often deal with the factual numerics that get designed into a sales force reporting dashboard or similar solution, showing details like order placement, orders shipped and paid for, etc. The templates for these typically use a style of diagramming called star schema, which is a common dimension modeling technique. 

      I can't say whether it's the most frequent real-world use case that a real customer would focus on, but for the level of our tutorials, a sales scenario might involve a description of customers, products, locations, maybe geography, and the timing of sales for trends analysis.

      Other than Power BI, I also teach AWS and Azure, where I help guide students to plan and come up with architecture for deploying to the cloud. It's not actually very hands-on, as it's more to help with architecture diagramming for the intentions that students have when using them. And at our institution, all of our courses last only four weeks, so it's very fast tracked, which sometimes means that we don't really go too in-depth.

      AWS has a lot of samples and diagrams, including many graphics that are fairly artistically detailed. The level at which I've helped students reference those kinds of diagrams is mainly for their team projects, to illustrate their intention, for example, to deploy a database into AWS. If it's an SQL Server database, we usually choose Azure. But it's not to actually do it. It's rather to have the intention to, for illustration purposes.

      How has it helped my organization?

      I had a brilliant student in May last year, 2019, who did her graduate capstone project - where I was her advisor - using Power BI. And she has two times now responded to my invitation to be a guest speaker on that tool to classes such as the data analytics class that I've been teaching for about 20 times now, going back six years.

      At my institution, I'm the only one teaching database design, whether undergrad or grad, and I found Power BI was a very attractive tool to introduce during the database design class, and then later enable the students to use it for their capstone. Unfortunately, it didn't work out in November this year, because few of the students picked up on it and gave the actual time it would take to focus their attention on using Power BI templates.

      Overall, my observation is that the enrollment is way down and the students who are still in the program are very distracted, I think because of the pandemic. Despite this, Power BI has helped me introduce students to business intelligence and data analytics because it's a very attractive and cost-effective tool (there's no cost to it, it's free).

      Another reason I'm inspired to focus my time on helping students with Power BI is because of the analyses done by the Gartner Group and Forrester Research, wherein they reviewed the strengths of Power BI. Both of them call it a "killer app". That caught my attention. And Power BI seems like the best thing to suggest to the students.

      And I'm up to it on my side teaching through online, although I'm regretting that I cannot go on a campus to be still there for the students whose strong preference is to be together in a room learning on site. I hope that in the class in May, there'll be more people really interested in actually using it. In November, I was hoping some of the students would, but for reasons such as the pandemic, these online students have too many distractions. Especially if they're also still working or they have families with kids at home.

      What is most valuable?

      What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable. And that's what it takes.

      It makes use of the ordinary things, and they'll sound familiar. Excel, Access, or SQL Server as the database, and the deployment techniques like Azure for it to be in the cloud.

      It's very heavily like Microsoft promoting its own products, but I forgive it because this time it works. And I'm speaking from some experience; I worked in the data warehouse technology group at Oracle for three and a half years, and I was helping Oracle's clients put up a data warehouse with Oracle as the database, and to migrate data into the Oracle database. So that was my background. And for me to be persuaded that this collection of regular, already known, already used desktop tools could work just as well, but with the added value of the samples, the templates, frequent updates, and lots of support. That says a lot.

      It also has other features that I like, especially regarding the designs in the set of templates for things that would perhaps be very puzzling to somebody doing it for themselves. It has pre-built tables to hold, during project lifestyle, maybe a small select amount of test data with the intention of the large amount of data going into production after deployment. And it has all the table designs that start out generic but that can be easily customized.

      What needs improvement?

      When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world.

      The evidence that I see when I look into it is there's a lot of user group type of connections to the Power BI world. And many, many bloggers telling their stories and promoting themselves or small businesses promoting themselves to do it for you using Power BI. The claim being that they could help you get it done instead of you doing it yourself. That's what goes on in this industry. You see a lot of entrepreneurial people who want to work in the role of consultant and get paid for it. There's a lot of that.

      And the invitation to look into the websites comes from little mini tutorials, which can be very helpful. But the next step of those tutorials, if most of the people get what they want out of them, is a contract to do the work. I don't want to introduce those kinds of things to my students, because it's kind of promoting something that could be a distraction.

      I worked for years as an independent consultant. I even did a fairly long series of contracts up in the state of Washington at Microsoft and I had 38 years in the industry before I became an academic teacher. But I'm avant-garde when it comes to sales. I avoid salesman because I don't want to believe the hype. I don't want to be deceived. And I don't want to suggest that somebody go that way. The topic of sales is overdone. This is an opinion on my part.

      On a practical note, the process of importing data into a new environment that has recently been designed is always a major effort. And Power BI has some weaknesses when it comes to loading data into an otherwise good concept and a good design because if it's not seriously tested and all shortcomings noticed beforehand, the importing process will fail.

      Even a cool tool like Power BI cannot anticipate the complexity of the variety of sources of data. But they're not alone. That would not be a disqualifier. But because I don't have direct yet, hands-on, having done this, I don't really know how Microsoft would improve this area.

      I think they've got it handled on integration. Everything that you're working with is already a Microsoft environment or a Microsoft tool. It's integrated. But if you're using the desktop tools by Microsoft and you need to deploy into a backend of Oracle, there might be some things that a smart consultant has to help out with. So cross-platform integration could use some improvement in terms of ease-of-use.

      For how long have I used the solution?

      I have used Microsoft BI in my data analytics classes for a few years now. 

      What do I think about the stability of the solution?

      In an abstract sense, it's holding up. I don't speak to actual customers of Microsoft products to answer that question. But I would suggest that it's holding up because the Gartner Group put out another magic quadrant output that describes it as being in the leader category.

      It's a well-respected research group, Gartner. In fact, companies that want to acquire its research for anything more specific or consulting, have to pay for it and have ownership. I don't pay for it. But there are many vendors who have my school email on their lists, so I get the reports for free, and I have my hands on quite a collection of the reports.

      And that's why I'm mentioning them because the Gartner Group has mentioned Power BI twice now. So as far as long-term prospects go, I'd say Power BI is a stable solution.

      How are customer service and technical support?

      Microsoft provides frequent updates and a lot of support for Power BI.

      Which solution did I use previously and why did I switch?

      I have worked in the data warehouse technology group at Oracle for three and a half years, helping Oracle's clients deploy a data warehouse with Oracle as the database. But when Power BI came onto the scene, I was more and more persuaded to use it instead for business intelligence and data warehouse purposes. This was mainly because I enjoyed how easily Power BI builds on existing tools that I'm already familiar with like Excel and Access. 

      How was the initial setup?

      The setup is straightforward, because it exhibits itself within familiar tools, like spreadsheets.

      The complexity comes when you try to convert from simple beginnings into something that needs to eventually become reality. But I'm guessing. I don't know that it's complex. And anyway, I personally like complex. It attracts my attention.

      What's my experience with pricing, setup cost, and licensing?

      For my primary use case, i.e. teaching students, the free version of Power BI is adequate.

      What other advice do I have?

      May is the next time I'll be teaching the data analytics class, the graduate class, and I will be actively trying to promote Power BI for the team project.

      I would rate Microsoft Power BI an eight out of ten. 

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Data Analyst at a tech services company with 201-500 employees
      MSP
      Easy to deploy and use, but it should support integration with more systems
      Pros and Cons
      • "The user interface is easy to work with."
      • "More connections with other systems should be added, which would allow for other integrations."

      What is our primary use case?

      We are a service provider and Microsoft BI is one of the tools that we implement for our clients. We do not use it ourselves.

      My primary use case is integration, but it is also used for reporting and data analysis services.

      What is most valuable?

      The user interface is easy to work with.

      What needs improvement?

      More connections with other systems should be added, which would allow for other integrations.

      For how long have I used the solution?

      I have been using Microsoft BI for between eight and nine months.

      What do I think about the stability of the solution?

      Microsoft BI is a stable product.

      How are customer service and technical support?

      I do not have experience with technical support. In cases where I have found an issue, I Google it, spend time learning about the problem, and then resolve it.

      Which solution did I use previously and why did I switch?

      I have also used Alteryx and Informatica. We still may use one of these other products, depending on our client's requirements. If the client wants us to work using a specific product then that is their choice.

      How was the initial setup?

      The initial setup is straightforward and the deployment will take an hour, or an hour and a half.

      What about the implementation team?

      We deployed this product ourselves. It is easy to work on.

      What other advice do I have?

      I primarily use Microsoft BI for integration, so it is difficult for me to say what needs to be improved. Overall, this is a good tool and I recommend it.

      I would rate this solution a seven out of ten.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Compensation Coordinator at a computer software company with 1,001-5,000 employees
      Real User
      The easiest and most stable solution that has good querying capabilities and great support and is light years ahead of other solutions
      Pros and Cons
      • "The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time. It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet."
      • "I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that. Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has."

      What is our primary use case?

      In general, we use it to have access to the data that we have processed from the HCM system and also to deploy it to the teams. Because it has low-level security features, I can guarantee that only selected people have access to the information seamlessly. We don't take a lot of steps to create, for example, different profiles and ensure the data security that I need.

      It is on the cloud because we have pro accounts. Usually, we have the desktop version for designing and using ourselves here, but when we deploy this, it is usually on the Microsoft cloud; it is not on-premises. We are using the most updated version because they release monthly updates.

      What is most valuable?

      The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time.

      It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet.

      What needs improvement?

      I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that.

      Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has.

      For how long have I used the solution?

      I have been using this solution for around two and a half years. I am currently using it, and I have also used it in the previous company.

      What do I think about the stability of the solution?

      It is very stable and very reliable. It is by far the most reliable system I have used for deploying many things.

      What do I think about the scalability of the solution?

      It is very scalable, especially because the pricing was great. Right now, they are integrating a lot with Microsoft Power Apps and the Power Platform as a whole. Power Ultimate and other things are being integrated into the system as well.

      In my previous company, more than 200 to 300 people were using it on a daily basis. In my current company, we have less than ten people using it because we are still a very confined team.

      How are customer service and technical support?

      The technical assistance is great, and I have never had any problems with them. Their support to communities is also great. I would rate them a ten out of ten.

      How was the initial setup?

      The initial setup was very easy. It took a little bit less than a month to get everything designed, tested, and deployed after we got the licenses.

      What's my experience with pricing, setup cost, and licensing?

      Its pricing is great.

      What other advice do I have?

      The first piece of advice is to become very clear about licensing and the data governors. Always get the licenses and get them right. You must also be clear about who is going to control these accesses. The second piece of advice is to understand a lot about the low-level security to create profiles and data access features to allow the specific data to be seen only by a specific public.

      Currently, in my organization, the greatest challenge is getting proper licensing. We have a little bit of resistance from our IT department who would like us to use Tableau more. It is not Microsoft's problem. It has more to do with the vendor of choice of the company, and they say that we have to use Tableau, but I don't want to use Tableau.

      I would rate this solution a ten out of ten. It deserves this rating.

      Which deployment model are you using for this solution?

      Private Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Chief Data-strategist and Director at theworkshop.es
      Real User
      Enables you to embed visualisation and reports into your applications
      Pros and Cons
      • "It's a great tool for visualization data, and it's free for engineers."
      • "It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake."

      What is our primary use case?

      Usually, when dealing with business intelligence projects with big data, all customers have Office 365 but within these licenses, Microsoft BI is often included.

      How has it helped my organization?

      The use case depends on the project. For example, in the logistics project, we need maybe four persons. For retail sales without stocks, it's a very easy project for us, but only for sales, and purchase orders, it's a standard part of the tool, to incorporate warehousing. Sometimes it's more difficult to clean the data if you have something like visualizations. It is often more difficult to understand what kind of data you need for the customer, or the strategy of the company who needs the information, to build a suitable solution. Customers often change their requirements. That's why Microsoft BI is more useful than traditional user tools, as it is flexible to changing requirements.

      What is most valuable?

      It's a great tool for visualization data, and it's free for engineers. Microsoft BI has a good online community. You don't need to be an engineer to use it. In Microsoft BI you can embed the visualisation and reports into your applications. Embedded items are much faster and cheaper to use. It's very easy to work with the customers using this kind of tool, rather than say, Oracle. I have used the personal edition, but some customers have been trained to use the professional version. Initially, I spent a lot of time learning the new system. As I was already experienced in other, similar technologies it was not difficult to understand the visualizations. I encouraged our clients to do more with Microsoft BI.

      What needs improvement?

      It should work faster and have more common languages so that you can use it more in different types of connections. It doesn't work well on big data. It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake. It uses the DAX language, which is not used widely. Maybe they should develop this part of the tool to improve access to people who don't know DAX. Sometimes it needs to have a special configuration and hardware to connect to a data warehouse. So, interoperability with other systems could be improved.

      For how long have I used the solution?

      I began using it a few years ago. I was involved in testing and last year, I was tasked with some large projects in Azure which included databases, a data warehouse with SQL, and Azure SQL. It is a cloud-based service, which means that a project is easy to use and design. You can use different tools for different things, but all the visualization in Microsoft BI is all in one tool. 

      What do I think about the stability of the solution?

      Microsoft BI is stable and works consistently well. 

      What do I think about the scalability of the solution?

      Microsoft BI is a very scalable tool. You can start small and build up your project as you wish. 

      How are customer service and technical support?

      I used Microsoft Azure support because we have a project. I have a good relationship with Microsoft. I don't have any problems.

      How was the initial setup?

      It is easy to install Microsoft BI. You simply download and install it from the Microsoft Microsoft BI website, and it is available to download on windows. It can be downloaded and installed in 5 minutes.

      What's my experience with pricing, setup cost, and licensing?

      Microsoft BI is free for the personal edition, but there is also a paid-for professional version. Setting up Microsoft BI is simple.

      Which other solutions did I evaluate?

      Oracle products are well-engineered but too heavy to accomplish small tasks. However, to use it for enterprise, you need to have a lot of knowledge about the different kinds of tools available. It has more flexibility but is more complex because it's designed for enterprise-level systems. Comparing this to Oracle which is at least 10 years old. Java is also old, but it's more structured. It's more proprietary.

      What other advice do I have?

      Every month Microsoft puts in another update. We are likely to use Microsoft BI in future projects. Microsoft BI does not fit every business case, so for that reason, I would give it an eight out of 10.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Amazon Web Services (AWS)
      Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
      PeerSpot user
      Northern Europe IT Business Intelligence Manager at Adecco
      Real User
      The tool is very flexible, allowing for creativity
      Pros and Cons
      • "The tool is very flexible so it allows creativity."
      • "I think that the product would benefit by increasing the range of visuals and graphics readily available, as opposed to using a third party included as part of the product."

      What is our primary use case?

      Microsoft BI can be useful for several scenarios, depending on your end audience, or what they're looking for. Depending on your creativity, imagination, and what the tool allows you to build, you can create a lot of cool things with it. You can build a lot of very elaborate and dynamic reports for example. The most important thing to consider is to understand what your audience is looking for. The development side of the tool is not the problem.

      How has it helped my organization?

      The usability of the tool is very simple. If you know the basics, it's fine. Even if you don't have the basics, there is a lot of self-service documentation available which helps to guide the user to start to use the tool, and how to navigate through it. 

      There was also a new feature added last month to help new users practice using the system by providing an example data set to experiment with. Power BI server can be run on-premise so that your reports are available locally. Or you can have a premium version, including all your reports on the Cloud. It can be determined by the number of refreshes required from the reports or can depend on the volume of users that are consuming the reports.

      What is most valuable?

      The tool is very flexible so it allows for creativity. Power BI allows you to incorporate Microsoft Visio diagrams and other graphics from Microsoft tools. You can also integrate third-party visual graphics created from other tools, such as R or Python. It is useful to be able to obtain additional charts or different types of graphics developed by a third-party tool. This gives you more options for your end solutions. However, for some third-party tools and graphics such as Zoom charts, you have to pay for those separately. This is useful if you really wish to mesmerize your audience with dynamic, interactive visuals.

      Alternatively, if you just want to use what is available to you, and with a little bit of UX/UI knowledge and creativity, you can build really cool stuff with it. For example, you can have dynamic dashboards on a screen that is connected in real-time. Users can interact directly with the data, so when they click the mouse, they can see the data changing. There's a lot of things that you can do with it. Let's say you develop a report, to put on a big touchable screen. Let's say the CEO is presenting to someone, and he's on a big screen. As soon as he touches a dialogue or a graphic on the screen, all the data changes. 

      As an example, in CNN news, or any news, where they are presenting, and there are some dashboards and reports, journalist clicks on the screen, and everything changes instantly. That's what Power BI can do. If you have touch screens Power BI allows you to interact with your data.

      What needs improvement?

      I think that the product would benefit by increasing the range of visuals and graphics readily available, as opposed to using a third party included as part of the product. One way they could do that is for Microsoft to buy some of those third party companies, as they are specialists in visual creation, and they are making money from that. However, I understand that perhaps Microsoft maybe doesn't want to invest in that side of the business. Perhaps it is a financial decision. I would say that if we can have those additional visuals built into the product, it will be great. Alternatively, in the future, there should be an additional tool there that allows you to create your own visuals. That will give users more flexibility. 

      It would also be useful for users with little experience in coding, or other Microsoft tools such as Excel. For example, let's say, you are a random user, and you're just looking at the computer for the first time. You open Power BI, but you know you can go to an Excel file and connect to that Excel file from Power BI. This is very simple and intuitive. So, once you have connected to the data, you can see your fields on the right-hand side, and all you need to do then is to drag and drop the fields you need. You can then select a relevant visual or graphic, and put the information alongside that visual, and then you have the visual and the data created as one item. This is very useful and dynamic. This would also have the other huge advantage, in that it would be a cheaper solution to use. I would like the ability to reuse connections. 

      For example, if I created a connection to an SQL server, and I published my report using that connection, and then shared my report, it would be useful to be able to reuse the existing connection to the SQL server. In this way, I can reuse the existing dataset to create another report. I believe this is already the subject of a support ticket. Say I then wanted to reuse another connection from a different connection, say Oracle, to use in the same report, I could use the connections to those two sources and build the report. If I already have the sources online, and available for me, it would make sense that I could reuse them. At the moment, you can only reuse one data source. You cannot reuse more than one data source, at least if the data sources are online. One workaround would be to access each data source in turn, to obtain the data for the report. However, from October 2020, when using Excel driven reports, it is possible to reuse data flows or reuse the data component, from Power BI in Excel. So Microsoft has already implemented it for Excel, but it is still in the preview features. That will help a lot in financial areas. This could also impact company sales forecasts and sales.

      For how long have I used the solution?

      I have 10 years of experience using BI tools, like Tableau, Power BI, QuickView, and MicroStrategy. I have a background in technical architecture but my main expertise is in BI tools. I use Power BI. It's a business intelligence tool that helps you develop and create reports that you can connect to various data sources. Then you can slice and dice, and build what you want to build from there.

      What do I think about the stability of the solution?

      Microsoft BI is stable.

      What do I think about the scalability of the solution?

      The product is scalable, and new updates come out every month.

      How are customer service and technical support?

      Microsoft Technical Support is very good. If I need their assistance, they will liaise with me. They are very flexible, useful, and very friendly. They are very open to helping you out. So depending on how you escalate your call, and say it's a high-priority issue they contact you very fast. They have support lines globally. So if I'm in the Czech Republic, I may be contacted by someone from Romania, or from India, or another zone. It's fine, if, for example, I'm not English, and I need to speak to someone who speaks Spanish, they put me in touch with someone who speaks Spanish. There is a lot of available support for Power BI, and they have their own Power BI page called Power BI Support. Power BI issues are registered on that page. Support usually fixes the issues within the given timeframe. The other good part about Power BI is the huge Microsoft community that it is there. So you can raise tickets and use the community which is on the same page. Sometimes the community helps you find your solution. So, it provides two ways to access support solutions.

      How was the initial setup?

      It's easy to install which helps new users to the product. The installation process is easy. You can install it from the Microsoft store, or you can go directly to the Microsoft portal, and download the version that you require. It keeps historical versions available in case you need to test a different version. The advantage of the Microsoft store is that as soon as you install it from there, it always keeps you updated with the latest version. Also from a Power BI service point of view, you have several capabilities. The learning curve comes in when researching the different features, and what is new in the product, as well as what is going to be provided in future versions. The advantage of Power BI is that every month you have something new provided with the update. For example, you may have a new connection, additional visuals, or use new narratives.

      What's my experience with pricing, setup cost, and licensing?

      We have 8,000 Power Bi licenses in our organization, so it is widely used. Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI.

      What other advice do I have?

      I would give Microsoft BI a 10 out of 10.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Executive Vice President at a security firm with 201-500 employees
      Real User
      Good visualization, automatic charts, and drill-down capabilities
      Pros and Cons
      • "The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities."
      • "Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization. It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go."

      What is our primary use case?

      I take care of business transformations in the company, which includes solution transformation, and so on. We have a range of products that are legacy products. They are fairly old. We are substituting them with new age products, and one of them is Power BI. We are using its latest version currently.

      What is most valuable?

      The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities.

      What needs improvement?

      Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization.

      It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go.

      For how long have I used the solution?

      I have been using this solution for a couple of years. 

      What do I think about the scalability of the solution?

      Its scalability is good. The only issue is the performance that degrades when more data comes in, but when it comes to scalability within a particular level of data, it is really good.

      How are customer service and technical support?

      I don't know. I am not technically so much involved in the day-to-day side of this.

      How was the initial setup?

      The initial setup is a process by itself, so we have to take external help in terms of implementation. In terms of various reports and other things, I don't have an idea about the complexity of the implementation because we took expert advice, and an external consultant implemented it for us. I would guess that it is a bit extensive and needs a lot of work to be usable.

      What other advice do I have?

      I would definitely recommend Power BI for those entities that are not complex. Unless and until there is a very high volume to be handled, I believe Microsoft Power BI is the best solution to go for, particularly when somebody buys a stack of Microsoft products, which includes Office, SharePoint, and so on. The whole Microsoft Office Suite is a brilliant product in its entirety, and there is good and easy integration with SharePoint, etc. This is a nice feature that other products don't have. There is a stack of IBM as well, but it is not as good as Microsoft.

      I would rate Microsoft BI an eight out of ten. I am pretty happy with this solution, and the two points are down because of the performance issue and probably the cost.

      Which deployment model are you using for this solution?

      Private Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      PeerSpot user
      Manager, BI & Analytics at Perceptive Analytics
      Real User
      Top 20
      User-friendly, offers a flexible measure creation capability, scalable to large datasets, and has good community support
      Pros and Cons
      • "Two valuable most features are the ability to create columns and create measures."
      • "In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization."

      What is our primary use case?

      I am currently a management consultant and, before my current employment, I was a management consultant as well. I also had a stint with an online retailer in India. My usage with Power BI has been in the area of practical day-to-day operations, web host operations, and equipment status monitoring.

      What is most valuable?

      Two valuable most features are the ability to create columns and create measures.

      The create measures feature offers you a little bit more flexibility. You can define what kind of measure you need using a formula, and the way Power BI works is very similar to Excel. In fact, most of the functions that you use in Excel are present in Power BI as well. When you create measures or columns, you just write the formula as you would in Excel, which will allow you to visualize that data in the way that you want.

      What needs improvement?

      In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization. By comparison, if you look at some other visualization tools, such as Tableau, for instance, the range of designs, or the range of graphics that you can create with Tableau is far greater than what you can do with Power BI. 

      Of course, they do provide an option to download templates and use them, but every time, you have to go to the Power BI store, search for those templates, download them and then use them. I think it's a growing universe of visualizers that they have, so probably, they are also working on the same thing. I believe, in terms of the designs of the visualizations that the tool can create, there is some room for improvement.

      One more aspect that needs improvement is the formatting of visualizations that we create. Formatting in this context is the colors or the font style or font sizes. The formatting options, I believe, could be made a bit more user-friendly than the way things are right now. It's a little hard to figure out where to go and how to change the formatting of a particular chart or graph. So, I think the formatting options could be made a little bit more user-friendly.

      For how long have I used the solution?

      I have been using Power BI for more than three years.

      What do I think about the stability of the solution?

      Microsoft BI is definitely stable.

      What do I think about the scalability of the solution?

      This product is scalable and in fact, I have worked on it with fairly large datasets. It also gives you the option of publishing onto a server. When the dashboard/report is published to the Power BI server, we get a link that can be shared with others in the organization. At the enterprise level, it is possible to give access to a list of users who will have a need to look at the report frequently. These users can just click on the link and view the report whenever they want to. It is also possible for them to use filters and interact with the report.

      How are customer service and technical support?

      I am fairly comfortable with the tool and to this point, I really haven't felt the need to reach out to Microsoft with regard to the specific features of the tool. In case I do need some help on a particular feature, what I usually do is Google what I am trying to find and I get some links to the Microsoft community, or something similar, which answers my question.

      To that extent, it has been very convenient to find help in whatever we are required to do with the software. The simple things are taken care of automatically. In case there is some trouble with the visualizations, you can always find help or assistance on the Microsoft community pages.

      Which solution did I use previously and why did I switch?

      I have also worked with Tableau and I think that each of these tools has its advantages.

      I believe the cost of the software plays a deciding factor in a company's decision to implement either of the two. While each product has its pros and cons, if you're looking for something that's more value for money, then I think Power BI is the better choice.

      On the other hand, if you are willing to choose an expensive option that gives you a lot more flexibility, then I think that Tableau would be a better choice.

      It ultimately depends on what you are going to use it for. If you're using it for a variety of visualizations that you want to create, Tableau will be a better choice. On the other hand, if people have budget constraints then Power BI will provide a good value for the money.

      How was the initial setup?

      The initial setup is straightforward. You just download the software from their website, install it, and sign in.

      What's my experience with pricing, setup cost, and licensing?

      This product offers good value for the money.

      What other advice do I have?

      In a nutshell, I recommend this product and I would suggest implementing it. It has a very good range of features that it offers. For organizations starting on their business intelligence journey, I believe Power BI is a very good tool to start with. It's very user-friendly and it provides a graphical user interface where users can just drag and drop their required fields into particular templates of visualizations. It means that you get the charts quickly. There's no complex learning curve involved. From that perspective, I would say that it's definitely worth a try.

      My biggest complaint is that it's a bit limited right now, in terms of the choice of visualizations it offers.

      I would rate this solution an eight out of ten.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Team Leader at Eurobank EFG Bulgaria AD
      Real User
      An intelligent and intuitive data visualization and analytics tool
      Pros and Cons
      • "It's similar to Excel, but it's much more powerful than Excel."
      • "I cannot comment on the stability as we haven't yet used it for a big project."

      What is our primary use case?

      We use Microsoft BI for the visualization of data. We also hope to use it for machine learning as it's very powerful, but at the moment, we are trying to get authorized for reporting and analysis.

      What is most valuable?

      It's similar to Excel, but it's much more powerful than Excel. I love the unlimited number of rows that can be processed, the grant server application, and the strong security.

      It produces a very nice picture — very nice graph managers that are very attractive.

      The way you prepare your reports is very intelligent and intuitive. 

      It's very easy to operate and the dashboard is great.

      For how long have I used the solution?

      I have been using this solution for a few months now.

      What do I think about the stability of the solution?

      Microsoft BI is stable, but I cannot comment on the stability as we haven't yet used it for a big project.

      How are customer service and technical support?

      The customer support is excellent. We get perfect support and it is regional — not only in our country, but there is also regional representation from Microsoft's so-called architects; they are very good professionals who help us with whatever we require.

      How was the initial setup?

      Currently, we are in process of implementing this solution on my computer. I installed the Microsoft Power BI desktop application very easily and started my training. I didn't experience any difficulties.

      I collected information from several sources and it's been working well — I am happy with this software.

      I needed about 15 minutes to install the desktop application. The other portion is web-based, so I haven't gotten to that yet.

      What's my experience with pricing, setup cost, and licensing?

      Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month.

      What other advice do I have?

      I would absolutely recommend this solution to other interested companies.

      Overall, on a scale from one to ten, I would give Microsoft BI a rating of eight.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Senior Manager: ICT Compliance at Department of Public Service and Administration
      Real User
      Top 10
      Relatively new, stable, and scalable
      Pros and Cons
      • "It's a pretty scalable product."
      • "The product could have better analytics capabilities."

      What is most valuable?

      The solution is stable.

      It's a pretty scalable product.

      Overall it's a good product. It is still rather new, therefore, for now, it's still a learning curve as we get used to all of the features and capabilities.

      What needs improvement?

      The charting tool could be improved.

      The product could have better analytics capabilities.

      The initial setup is not straightforward.

      For how long have I used the solution?

      I've been using the solution for five months.

      What do I think about the stability of the solution?

      The solution is quite stable. I'd call it reliable. It doesn't crash or freeze and I can't recall bugs or glitches happening.

      What do I think about the scalability of the solution?

      The solution is scalable. If your organization needs to expand it, it shouldn't be a problem to do so.

      We have about five people on the solution, however, we don't have it fully functioning just yet.

      Which solution did I use previously and why did I switch?

      I did not use a different solution previously before the implementation of this product. This is the first solution we've used for these purposes.

      How was the initial setup?

      The initial setup is pretty complex. It's not straightforward or simple. You need to be a bit of an expert in order to handle it, and I am, unfortunately, not an expert. If you had more experience with it, you might find it easier than I did.

      What's my experience with pricing, setup cost, and licensing?

      I was not involved in the pricing or procurement process of the solution. I'm not sure how licensing works of the overall cost of the solution on a monthly or yearly basis. It's not part of my day-to-day.

      What other advice do I have?

      We're just a customer. We don't have a business relationship with Microsoft.

      I'm not sure which version of the solution we are using. It may be the latest.

      On a scale from one to ten, I'd rate it at an eight. We've been pretty happy with it, even though it is quite new to us.

      Which deployment model are you using for this solution?

      Hybrid Cloud
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      BI Consultant at a manufacturing company with 1,001-5,000 employees
      Real User
      Top 20
      Easy to use, good inquiry and visual gallery features, and the community is strong
      Pros and Cons
      • "This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it."
      • "A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."

      What is our primary use case?

      We primarily use Power BI for data science solutions.

      How has it helped my organization?

      This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it. This is true even for business people who want to do a little bit of self-service. The whole thing has become quite simplified, as compared to what it was.

      What is most valuable?

      There are many good features in this product.

      The most valuable features are a combination of the DAX and the inquiry capability, plus the visual gallery that we have. I think that these three things, or the combination of them, is the best that we have found.

      What needs improvement?

      I would like to have the capability to schedule exports in different versions. For example, if I want to schedule a subscription and attach an Excel file, we don't have this capability right now. A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement.

      For how long have I used the solution?

      We have been working with Power BI for more than five years.

      What do I think about the stability of the solution?

      Overall, it is pretty stable. The cloud version is definitely very stable, and I have found very few flaws or areas for improvement. We have been using it for more than five years and we have every intention to continue with it.

      What do I think about the scalability of the solution?

      It has been pretty nice for us, in terms of scalability. There hasn't really been a problem, as such. We have approximately 300 users.

      How are customer service and technical support?

      Technical support from Microsoft gets a big thumbs up from me. They have blogs, a support page, and the community is very active. Most of the answers we need, we find them there. 

      With this amount of information available, we don't need to use technical support extensively. When we do post something on the blog or in the community, the response that we get is pretty prompt.

      The last time we utilized technical support was when we were investigating creating a subscription with an Excel file attached to it. We found out that it isn't yet possible with the current version.

      How was the initial setup?

      The initial setup is straightforward, to say that least. It took just a few days to deploy.

      What's my experience with pricing, setup cost, and licensing?

      The pricing is very reasonable compared to any other tool.

      What other advice do I have?

      My advice for anybody who is considering this tool is that if you want to move to a self-service BI, this is probably the best tool available right now. The self-service is pretty good in terms of os user acceptance, usage, and simplicity. It is something that everybody wants and Power BI does really well in that area.

      The biggest lesson that I have learned from using Power BI is that if the data is not according to what you want, that really isn't a problem. It has been a problem in the past, especially where the data is not in the form or the shape that you need, but with Power BI, that problem can be solved very easily.

      I would rate this solution an eight out of ten.

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Co-Founder at Beta Edge Technology Limited
      Real User
      Top 5Leaderboard
      Reasonably-priced and promotes collaboration through good shareability features
      Pros and Cons
      • "The most valuable feature is shareability, where we can publish work to the cloud and share it with team members."
      • "I think that they can add more types of charts because the selection on the desktop version is limited."

      What is our primary use case?

      We use this solution to analyze financial statements from our partners.

      We build dashboards to see information on a product that is offered by one of our local telcos.

      What is most valuable?

      The most valuable feature is shareability, where we can publish work to the cloud and share it with team members. If you want to build a dashboard then you can publish it to the cloud, and then add people. This will give them access to the dashboard where they can review it, and modify it as well.

      They have a mobile option that allows you to see the dashboard from your mobile phone, rather than having to look at your laptop.

      What needs improvement?

      I think that they can add more types of charts because the selection on the desktop version is limited.

      I would like to see an option for adding audio to the visualizations. 

      They need to add support for putting emojis into the dashboards.

      For how long have I used the solution?

      We have been using Power BI for the past two or three years.

      What do I think about the stability of the solution?

      In terms of stability, this product has never failed me. I have not experienced any bugs or glitches.

      What do I think about the scalability of the solution?

      The scalability is good. They allow for multiple types of data sources, so if you grow your databases or you change your data sources, it's easy to add them to the tool visually.

      We are a startup with four people, and everybody is using it. We are proposing it to our clients in cases where we are selling analytics because it's a good option for them.

      How are customer service and technical support?

      I have not had a reason to speak with technical support, although I've looked at the community. They do have additional features that you can download from the site, as well. I have not a problem in terms of support.

      Which solution did I use previously and why did I switch?

      I used Tableau in 2016, but I decided not to use it in this startup company because they don't have a free option. They do have a trial version, but that expires and I would have to then look for another solution.

      With Microsoft BI, they have a free desktop version. 

      I have also used Cognos BI before, although it was a bit complicated. This is another reason that I settled on Microsoft BI.

      How was the initial setup?

      The installation is direct and quite easy to do. The instructions are available online and they are easy to follow.`

      What about the implementation team?

      I completed the deployment myself.

      What's my experience with pricing, setup cost, and licensing?

      We are using the free desktop version of this product.

      Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable.

      What other advice do I have?

      My advice for anybody interested in using Microsoft BI is to set up the desktop version. It's good to start off with, it's easy to learn, and they get the trial period for the BI service. Then, once they're done with the trial period, I think the licensing per month is quite affordable.

      In summary, this is a good solution. It is not perfect, although if they added audio, emojis, and more types of graphs, then it would be.

      I would rate this solution a nine out of ten.

      Which deployment model are you using for this solution?

      Hybrid Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Advisory Software Engineer at a tech services company with 1,001-5,000 employees
      Real User
      Top 10
      Interactive, user friendly, and efficient in terms of performance
      Pros and Cons
      • "The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use."
      • "A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."

      What is most valuable?

      The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. 

      I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use.

      What needs improvement?

      A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it.

      The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation.

      There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution.

      For how long have I used the solution?

      I have been using this solution for more than four years.

      What do I think about the stability of the solution?

      It is stable. I haven't found it hanging. It consumes a lot of memory on the local system but not while developing the reports. It also depends on the data on which we are working, but generally, it is light and stable.

      How are customer service and technical support?

      My overall experience with Microsoft is actually quite good. We have contacted their technical support once or twice. It was something related to the Power BI visualization, where we needed to visualize some data, but they had some kind of limitation in personalization. We also wanted to connect Power BI with other servers, but we were facing some performance issues. The reports were not working fine. I don't think they managed to solve our issues.

      Which solution did I use previously and why did I switch?

      I have worked on SiteSense and Oracle OBIEE. I feel more satisfied when I'm working with Power BI. It is more convenient as compared to other solutions.

      How was the initial setup?

      The initial setup is easy. I didn't find any complexity in it. It can be difficult if the end users don't know how to use it. If they are trained on it, then after a week or a month, it gets easier for the end users. 

      What's my experience with pricing, setup cost, and licensing?

      Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. 

      It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version.

      What other advice do I have?

      I would rate Microsoft BI a seven out of ten.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Head of Digitalization at a mining and metals company with 5,001-10,000 employees
      Real User
      Seamlessly integrates with Microsoft products, but can be made simpler to operate
      Pros and Cons
      • "Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
      • "They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. They can make it easier to create some of the reports. They can also include predefined templates that you can directly use."

      What is our primary use case?

      It is mostly used for monthly cost reports for our department. We are also using it as a dashboard for giving some overview for management purposes. We are using the latest version.

      What is most valuable?

      Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable.

      What needs improvement?

      They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. 

      They can make it easier to create some of the reports. They can also include predefined templates that you can directly use.

      For how long have I used the solution?

      I have been using Microsoft BI for almost two and a half years.

      What do I think about the stability of the solution?

      Stability is quite good as long as you have proper sizing from the beginnings. If you do the right sizing keeping in mind the current usage as well as future growth, it is good.

      What do I think about the scalability of the solution?

      It is scalable. We have around 65 seniors managers who use it on a weekly or monthly basis. Some reports are done weekly and some monthly.

      How are customer service and technical support?

      I have not contacted them so far. I am from the user side. We contact our centralized IT department for any issues. If they have a technical issue that requires further escalation, they will directly contact Microsoft technical support.

      How was the initial setup?

      The initial setup is quite simple, but for the product use, you need to have people who have got experience of at least three to six months in using these applications. It took us two months to deploy across the company.

      What about the implementation team?

      We have a core team that gets training from a Microsoft partner. We then deploy it ourselves. After six months of using this solution, some of the key users get advanced training. 

      We also maintain it ourselves. We have around ten people for its maintenance.

      What's my experience with pricing, setup cost, and licensing?

      It is somewhere in the middle in terms of price. Licensing is quite clear.

      Which other solutions did I evaluate?

      We reviewed some other intelligence tools, and we just used them for trials.

      What other advice do I have?

      I would recommend this solution, especially for the companies that mostly use Microsoft products and ecosystem. I would rate Microsoft BI a seven out of ten.

      Which deployment model are you using for this solution?

      Private Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Lead Statistical Analyst | Innovation Champion at a pharma/biotech company with 10,001+ employees
      Real User
      Has good drag and drop interactability visualization but it's a bit complicated to make it refresh automatically
      Pros and Cons
      • "We like the drag and drop interactability visualization. We really like that. It's user-friendly."
      • "If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work."

      What is our primary use case?

      We have SharePoint in our company and then we just wanted to visualize that list and it connects to the Check Point list.

      What is most valuable?

      We like the drag and drop interactability visualization. We really like that. It's user-friendly.

      What needs improvement?

      If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work. Even though it's supposed to connect seamlessly, it's a bit complicated to make it refresh automatically.

      For how long have I used the solution?

      My company has been using Microsoft BI for a few years but I've been using it since January 2020.

      What do I think about the stability of the solution?

      It's very stable.

      What do I think about the scalability of the solution?

      I think it's very scalable. I don't even foresee that as a challenge. 

      We have five or six users who view the reports. There are other departments who might be using it as well but we have five or six in my department. It's expected to rise to 15, 20.

      The users are managers who want to look at some of the resources.

      How are customer service and technical support?

      I haven't interacted with Power BI before. If I get stuck at someplace, I just go online and I search in the forums and I find my way.

      How was the initial setup?

      There isn't really a setup involved. It's just download Power BI desktop and publish it.

      What's my experience with pricing, setup cost, and licensing?

      We have a premium Power BI license in-house that's quite an expensive license. It's $10 a month for four users and then I think 35,000 at the premium rate.

      What other advice do I have?

      Ensure that you use Sharepoint. If you are within the Microsoft system and want to have a similar experience to Microsoft Teams, then Microsoft Power BI is a very good solution for that.

      I would like to have the ability to run the scheduled refresh for R and Python on the server. Right now, it's not possible.

      I would rate it a seven out of ten.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Business Intelligence Developer at Kathmandu
      Real User
      Easy to make people understand what is going on but I would like to use SQL properly within the reports
      Pros and Cons
      • "The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on."
      • "I would like to be able to use SQL properly within the reports and allow multiple people to work on the same report at the same time. If one person is working on it, then it causes issues for anyone else wanting to make reports."

      What is our primary use case?

      Our primary use case is to learn what Power BI can do. We also use it to create dashboards and to see what is available for people to use. We see how it integrates with Excel. You can easily get the data into a visualization but also still have access to the underlying data.  

      We use it see how we can move away from an Excel spreadsheet but still give the users the correct answers to the questions that they have. I want to move away looking and fixing issues on particular lines and be able to easily answer the questions with visualizations so users can answer the questions a lot quicker and adapt to changes easier.  

      How has it helped my organization?

      I was self-learning it, we don't use it in our organization. We are looking to use it though in the future. We use a different tool and want to see if we can get more questions answered with Power BI. It's linked to Office 365 and Azure, so it would help us to answer some difficult questions and help identify issues/problems so we can find solutions and adapt the model a lot quicker. Going through over 100,000 lines of data takes too long and we need to be able to group the data more to be able to identify what works better, so a pie chart or map will help to identify issues that are not working. 

      What is most valuable?

      The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on. But I need a way to work on getting the data showing correctly and be able to drill down into a worksheet like Excel, as people like to know what the top-level information means. It's important to be open and show them what they want. The number of visualizations is great. So many different options to choose from like heat maps to pie charts.

      What needs improvement?

      I would like to be able to use SQL properly within the reports and allow multiple people to work on the same report at the same time. If one person is working on it, then it causes issues for anyone else wanting to make reports. We want to condense some reports, so they work for all departments, and not have a version for every single department. Also, I would like to have formulas easier to complete and create. Having its own system means something new to learn, although saying that, it's not hard to pick up this information. 

      For how long have I used the solution?

      I have been using Microsoft BI for six months.  

      Which solution did I use previously and why did I switch?

      Microstrategy, and no, we have not swapped yet. I use both to keep on top of my own skill set. 

      What's my experience with pricing, setup cost, and licensing?

      It depends on what you are wanting to do. Get the cost of users, and the servers, and work out if you are hosting, or if it's going into the cloud. 

      Which other solutions did I evaluate?

      We didn't as it's a company decision to look to change the BI system. 

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Microsoft Azure
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      PeerSpot user
      Consultor at PwC Brasil
      Real User
      Integrates data onto dashboards to help managers make better decisions
      Pros and Cons
      • "PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions."
      • "Real-time updating needs improvement."

      What is our primary use case?

      Daily updated production indicators dashboard: We get production data (Number of pieces, downtime, and downtime reasons) from the shopfloor and input them on an Excel sheet. 

      How has it helped my organization?

      PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions.

      With this solution, we were able to know which problems were critical and chronic. Once we used Power BI for production management, we realized that we could also use it for quality assurance, finance, and others types of management.

      What is most valuable?

      Interactive graphs are its most valuable feature.

      What needs improvement?

      Real-time updating needs improvement.

      For how long have I used the solution?

      Two years.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Vice President - HSE Engineering at Reliance Industries Ltd
      Real User
      Identifies customer purchasing patterns and provides good visualization
      Pros and Cons
      • "It has provided customer purchase patterns and great visualization."
      • "This solution needs integration with SAS and more deep analysis functionality."

      What is our primary use case?

      Our primary use for this solution is geospatial analysis.

      How has it helped my organization?

      This solution has provided an accurate analysis of our customers repurchasing the same plan for telecom Jio. It has provided customer purchase patterns and great visualization.

      What is most valuable?

      The most valuable features are the visualization and integration with Office365.

      What needs improvement?

      This solution needs integration with SAS and more deep analysis functionality.

      For how long have I used the solution?

      I have been using Microsoft BI for five years.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Data Scientist at Packen SAS
      Real User
      Automation of real-time and batch analytics are fast and help us to better explain our data
      Pros and Cons
      • "This solution has improved our ability in making decisions and explaining data."
      • "We would like to have better SQL support for queries."

      What is our primary use case?

      Our primary use is real-time & batch analytics on Postgres databases in combination with MS Excel.

      How has it helped my organization?

      This solution has improved our ability in making decisions and explaining data.

      What is most valuable?

      The most valuable features are the automation of analysis and already prepared tools to do the analytic work rapidly.

      What needs improvement?

      We would like to have better SQL support for queries. It means to have a kind of development environment trying to correct bad sintax in SQL query, or having an intellisense like style for code completion being aware of table's fields and having a preview of the query response without needing to run the whole procedure. 

      For how long have I used the solution?

      We have been using Microsoft BI for two months.

      Which solution did I use previously and why did I switch?

      Previously we used MS Excel but continue using it mainly for prototyping.

      What's my experience with pricing, setup cost, and licensing?

      Power BI free layer is attractive and second stage with Power BI online is not expensive.

      Which other solutions did I evaluate?

      Which deployment model are you using for this solution?

      Public Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      BI Analyst at eVision Industry Software
      Real User
      Easy to use, good self service functionality, facilitates collaboration with other users
      Pros and Cons
      • "If you are not very technical this tool could be very useful."
      • "Adding paginated reports to this tool could be of great help for users who want to move away from SSRS."

      What is our primary use case?

      Power BI is a great tool for analytics. It is useful if you have a requirement to create a dashboard with self-service capability, along with KPIs, and you want to drill down to the data details.

      How has it helped my organization?

      I have tried SSRS and later moved to Power BISSRS requires every analytical feature to be implemented separately. However, with the appropriate granularity of data, you can drill down and drill up easily which gives you a different view of the dashboards. Now with having on-premises availability, it makes this tool even more powerful.

      What is most valuable?

      If you are not very technical this tool could be very useful.

      The most valuable features are:

      • Self service
      • Inbuilt analytics
      • Custom visualization
      • Printing of dashboard helps a lot
      • Dashboard scheduling
      • Easy collaboration with other users on Power BI
      • Learning curve for this tool is small
      • Dashboard refresh rate can be configured
      • Power BI works both on-premises and cloud

      What needs improvement?

      Adding paginated reports to this tool could be of great help for users who want to move away from SSRS. 

      I would like to see built-in Git support, incremental loading of data, and a machine learning model for predictive analysis.

      Custom colouring from the dashboard itself would be helpful.

      For how long have I used the solution?

      I have been using Microsoft BI, SSRS, and Power BI for four years.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Microsoft Dynamics Specialist at a computer software company with 51-200 employees
      Real User
      Top 20
      Good reporting, and provides data insights that help to improve efficiency and profit
      Pros and Cons
      • "The feature I find most valuable is the ability to publish Power Bi reports, using an embedded link, directly onto a website."
      • "I would like to see Machine Learning for Power Bi Pro users or an intermediate license to enable Machine Learning if you don't have access to a Premium account."

      What is our primary use case?

      I have developed and deployed more than twenty separate customer solutions. I am a Business Intelligence Deployment Specialist. The most significant implementation was to reduce the Financial consolidation time for one hundred and twenty companies into one shareholder report, from thirty days to four minutes.

      How has it helped my organization?

      We help customers deploy and analyze sophisticated analytics models. These models have helped them all to get a better insight into their data and many of them have found very valuable insights that made them more profitable, more efficient, and in some cases changed the direction of the business.

      What is most valuable?

      The feature I find most valuable is the ability to publish Power Bi reports, using an embedded link, directly onto a website. Data that is not classified as confidential can very easily be exposed to customers, vendors, or even just visitors to the web site.

      What needs improvement?

      I would like to see Machine Learning for Power Bi Pro users or an intermediate license to enable Machine Learning if you don't have access to a Premium account.

      The minimum embedded capacity for Machine learning is currently an A3 capacity, and this should be reduced to include A1 level licenses.

      For how long have I used the solution?

      I have been using this solution for three years.
      Disclosure: My company has a business relationship with this vendor other than being a customer: Microsoft Gold Partner
      PeerSpot user