Manager at a logistics company with 501-1,000 employees
Real User
Provides accurate data and easy navigation
Pros and Cons
  • "They should add mobile access."

    What is our primary use case?

    Using it, I receive financial information from the financial department.

    How has it helped my organization?

    It gives us accurate data and an easy way to navigate.

    What is most valuable?

    I get the information I need easily, and it's easy to read.

    What needs improvement?

    They should add mobile access.

    Buyer's Guide
    Microsoft Power BI
    May 2024
    Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
    771,170 professionals have used our research since 2012.

    For how long have I used the solution?

    More than five years.

    What do I think about the stability of the solution?

    Stability is okay.

    What do I think about the scalability of the solution?

    For me it's okay, I don't have any issues with scalability.

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

    The decision to use Microsoft BI was made by the financial department.

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

    I don't have any advice as I am not in a position to recommend it. I am just an end-user, I do not develop, I do not maintain it.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Consultant with 51-200 employees
    Vendor
    Mapping Business Intelligence Developer’s Tools: Microsoft SQL server & SAP Netweaver BW

    This Post is not about Microsoft BI VS Sap BI. NO. NO. NO.

    Then What is it?

    well, I have been playing with SAP’s Netweaver BW Tools for past three months now as a part of a Business Intelligence class that’s about to conclude – Also, I have been involved with work on Microsoft’s SQL server Business Intelligence Tools. So I thought – it would be FUN to map  SAP Netweaver BW Tools (that I got to play with in an academic capacity) and Microsoft’s Business Intelligence Tools (which is currently what I am working on) – so, here you go:

    Tool in Microsoft BI Tool in SAP Netweaver BW
    ETL (Extract, Transform, Load) SQL Server Integration Services (SSIS) SAP Netweaver BW: Data Warehousing Workbench
    Cube SQL Server Analysis Services – Multidimensional Mode (SSAS) SAP Netweaver BW: Data Warehousing Workbench: Modeling
    Report Design Tool and Reporting Layer(It’s not an exhaustive list and does not include third part tools)
    • SQL Server Reporting Services (SSRS)
    • Report Builder
    • Excel (Excel Services/Pivot Tables)
    • PerformancePoint
    Business Explorer (BEx):
    1. BEx Query  Designer
    2. BEx  Analyzer (Excel Add-in)
    3. BEx web Analyzer

     

    Data Mining Data Mining Projects in SQL Server Analysis Services SAP Netweaver BW: Data mining – Analysis Process Designer

    Note about SAP BusinessObjects: I mapped the Tools in Microsoft BI with the tools that I got to study in my SAP class. Then I was searching what’s the current scenario in SAP world (I know about Microsoft’s!)– I learned that SAP BI world is comprised of TOOLS in SAP Netweaver BW + SAP BusinessObjects (BO). And in the course I studied the following components of Business Objects:

    1. Web Intelligence for ad-hoc query and reporting
    2. Crystal Reports for enterprise reporting
    3. Xcelsius (BO Dashboard) for Dashboard designing

    For those interested I am also mapping few terms used while cube development in Microsoft BI and SAP Netweaver BW

    Microsoft: SSAS Multidimensional mode
    SAP Netweaver BW
    Cube InfoCubes
    Dimensions Characteristics
    Measures Key Figures
    Data Source Views (DSV’s) Data Source

    Note:

    1) I have not mapped the Tools in Self Service BI space.

    2) This comparison is not for deciding between Microsoft BI vs. SAP Netweaver BI/SAP BusinessObjects – this post is just meant for mapping tools available in Microsoft BI and SAP Netweaver BW and so if you are an expert in say Microsoft BI – this post will help you see what corresponding tool are available in SAP Netweaver BW world. Consider it as a starting guide for your research.

    3) Note the date the post was written – the name of the products may have changed in future. refer to official sites for latest & greatest!

    Thanks for reading.

    This post was republished from Mapping Business Intelligence Developer’s Tools: Microsoft SQL server & SAP Netweaver BW

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Microsoft Power BI
    May 2024
    Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
    771,170 professionals have used our research since 2012.
    Data Analyst at a healthcare company with 10,001+ employees
    Real User
    Cost effective, helpful support, but large datasets performance needed
    Pros and Cons
    • "Microsoft BI's most valuable feature is flexibility."
    • "The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features."

    What is most valuable?

    Microsoft BI's most valuable feature is flexibility.

    What needs improvement?

    The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features.

    For how long have I used the solution?

    I have been using Microsoft BI for approximately two years.

    What do I think about the stability of the solution?

    The solution is stable, but not as good as other tools I use.

    What do I think about the scalability of the solution?

    Microsoft BI is a scalable solution.

    How are customer service and support?

    The support of Microsoft BI is good.

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

    Microsoft BI is very cost-effective and this is why we use it.

    What other advice do I have?

    I rate Microsoft BI a seven 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
    Marketing and Relationship Manager | Customer Journey at Ipiranga
    Real User
    Stable product with good technical support
    Pros and Cons
    • "The stability is good."
    • "Areas for improvement would be the construction of reports and the dashboard budget."

    What is our primary use case?

    My primary use case is to turn data into analysis.

    What needs improvement?

    Areas for improvement would be the construction of reports and the dashboard budget.

    What do I think about the stability of the solution?

    The stability is good.

    How are customer service and support?

    Technical support is good.

    How was the initial setup?

    The initial setup was complex.

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

    Licenses are available on a monthly basis.

    What other advice do I have?

    I would rate this solution as 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
    MCSE at a financial services firm with 501-1,000 employees
    Real User
    Helpful support, plenty of useful features, and stable
    Pros and Cons
    • "I like all the tools in Microsoft BI because they all have different purposes. There are a lot of people using Microsoft BI, and everybody is using it. The users have adapted well to the technology."
    • "I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."

    What is our primary use case?

    We use Microsoft BI in out data warehouse for analytics. We use it for many purposes.

    What is most valuable?

    I like all the tools in Microsoft BI because they all have different purposes. There are a lot of people using Microsoft BI, and everybody is using it. The users have adapted well to the technology.

    There are plenty of visualization tools, a lot of functionality, and documentation.

    What needs improvement?

    I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse.  I have to search on the web for a solution because I don't have the tool for it.

    The engine of Synapse Analytics and the ability to export the data that has been published to the web could improve.

    For how long have I used the solution?

    I have used Microsoft BI within the past 12 months. I have been working with Microsoft BI tools for approximately 20 years.

    What do I think about the stability of the solution?

    Microsoft BI is stable.

    What do I think about the scalability of the solution?

    We have approximately 30 people using the solution in my organization. This includes experts that make reports.

    How are customer service and support?

    The support is good. We created approximately two or three cases, and they had the solution for us, or they had meetings with us to find a solution.

    How was the initial setup?

    The initial setup of Microsoft BI is easy.

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

    If you purchase a license for a server, for users, or the professional version, you might not have to. The free version I think it can satisfy many customers' needs.

    What other advice do I have?

    Synapse Analytics is the engine of the data that Power BI consumes.

    I would advise those that use the solution to check all the license modes that the tool has because it's very confusing sometimes. You cannot just buy the product, you need to know who needs the product, who will use it, and who will be publishing. There are many aspects to figure out that when you do it will be better for you. 

    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
    Founder & CEO at a tech services company with 1-10 employees
    Real User
    Effective dashboard data transfer, stable, and scalable
    Pros and Cons
    • "There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
    • "I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple."

    What is our primary use case?

    We provide improved dashboards for our own customers by using Power BI.

    What is most valuable?

    There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly.

    What needs improvement?

    I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple.

    If you like to use Microsoft BI as an embedded solution, you need to do many things in the Azure, BI, and 365 portals. it can be complicated. This whole procedure should be simplified.

    For how long have I used the solution?

    I have been using Microsoft BI for approximately two months.

    What do I think about the stability of the solution?

    The stability of Microsoft BI is good.

    What do I think about the scalability of the solution?

    I have not scaled the solution very much but I know it is highly scalable.

    We have approximately five dashboard creators in my organization that is working on the solution.

    How are customer service and support?

    The customer service was very nice and responsive, when I opened a ticket they called me and emailed me but they could not solve the problem we had.

    We have three technicians and one of them is dedicated to the maintenance of Microsoft BI.

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

    I have previously used another solution.

    How was the initial setup?

    The initial setup is very complex.

    What about the implementation team?

    I used a consultant company to help me do the implementation and it took approximately one month.

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

    In the beginning, the solution cost approximately $1,000 per month, we have a Microsoft startup subscription. There is a subscription pack for startups company which we are able to have for one year.

    My customers will increase their usage of the solution and they will be additional costs for their usage.

    Which other solutions did I evaluate?

    I have evaluated other solutions before choosing Microsoft BI, such as Tableau. I have found that Tableau does not have a solution that can be embedded. The dashboard should be inside of our applications.

    What other advice do I have?

    If someone wants an embedded solution then Microsoft BI is very good because it works on many types of data, such as JSON.

    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?

    Amazon Web Services (AWS)
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    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
    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
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
    Updated: May 2024
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.