IT Central Station is now PeerSpot: Here's why

Alteryx vs Microsoft BI comparison

Cancel
You must select at least 2 products to compare!
Alteryx Logo
29,811 views|21,218 comparisons
Microsoft Logo
44,966 views|35,812 comparisons
Featured Review
Buyer's Guide
Alteryx vs. Microsoft BI
March 2020
Find out what your peers are saying about Alteryx vs. Microsoft BI and other solutions. Updated: March 2020.
622,358 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Alteryx effectively visualizes the flow of data and what happens at each stage. I also like that it's a no-code solution. I also like that you can troubleshoot certain parts of the workflow by putting them in a sandbox.""I think the most valuable feature for Alteryx in a health facility is that it permits cleaning, organizing, and merging of databases such as Excel and Access.""The feature that I have found most valuable for Alteryx is its geo-referencing feature, it is very good. I use it a lot, especially for supply chain.""The Alteryx designer has been the most useful feature in the solution.""The product's Macros probably are one of the most useful aspects.""All of the data science features in terms of unioning and joining data together are valuable.""The support is very good.""I believe that the ability to leverage the gallery for scalability, as well as the general data blending functionality, is most beneficial to our core-based users."

More Alteryx Pros →

"Microsoft BI's most valuable feature is flexibility.""The visualization and reporting are the most valuable features of this solution.""It's similar to Excel, but it's much more powerful than Excel.""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.""It is very good, and it supports the Microsoft ecosystem, including Excel, etc.""The user experience is easy. Users get familiar with it quickly.""Power BI has strong support from Microsoft. If you need help, they answer promptly. There are also several discussion groups where you can get information, like the product roadmap and any new things coming up.""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."

More Microsoft BI Pros →

Cons
"The workflow and pipeline need to improve.""Deep learning models are not currently supported.""The data integration component could most likely be improved to increase enterprise scalability.""It should have Linux support. It currently supports only Windows. It does not support any other platform. Its price should also be lower. Their US partner management program is actually unresponsive. One of the reasons why we don't have a formalized partnership plan with them is because their partner management team is atrociously unresponsive. This is something that they need to change.""The only weakness I would say is on the visualization side of having that dynamic incapability.""Alteryx's development environment could be improved as it requires installation locally and can't be developed in the cloud.""What they're struggling with is it's not as mature as Tableau in the user management area. It was tougher to manage the server part of it right away, especially since the user base has grown.""The scalability worries me a lot at the moment because the cost of the solution is high and it is not growing considerably. Unfortunately, we started during early COVID times and because of the economic downturn, all the cost cuttings, and everything, it is not growing as expected."

More Alteryx Cons →

"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 someone who is new, I think that Power BI can be a little complicated.""One of the more difficult things to do is to export some of the data from Power BI to Excel.""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.""I would like for the next release to have better desktop performance, especially for big databases. Additionally, I would like to have more integrations with programs like Salesforce in order to get more live data coming in.""The mobile app is very poor.""My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack.""They can improve it in terms of rule-based security. Currently, it has very limited rules."

More Microsoft BI Cons →

Pricing and Cost Advice
  • "The price for Alteryx Designer is reasonable but the price for Alteryx Server for universal collaborations is too expensive."
  • "I don't know much about the licensing, but there are some additional costs for certain features."
  • "The license is really expensive, we cannot afford to have two or three. It takes away all the budget of my area."
  • "Its price should be lower. The key thing that we see is that talking about ROI is an important element at the time of purchase. Cost becomes a factor in every discussion. Justifying the ROI for these kinds of workflows is always a challenge, and the only way to counter the challenge is by addressing the pricing."
  • "My organization pays for it, and I do not look into the financial aspect of the licensing, but I know it is pretty expensive."
  • "In order to have designers, and, if you want to collaborate, you have to buy a server. If the designer is $5,000, and if you want a server, you have to pay $80,000."
  • "There is a license required for this solution."
  • "The cost of the solution could be reduced."
  • More Alteryx Pricing and Cost Advice →

  • "It is somewhere in the middle in terms of price. Licensing is quite clear."
  • "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."
  • "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."
  • "The pricing is very reasonable compared to any other tool."
  • "Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
  • "This product offers good value for the money."
  • "Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
  • "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."
  • More Microsoft BI Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Predictive Analytics solutions are best for your needs.
    622,358 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:One of the differences is that with Alteryx you can use it as an ETL and analytics tool. Please connect with me directly if you want to know more.
    Top Answer:Alteryx is an extremely easy and flexible data tool, flexible in terms of drag and drop toolset and also has python, R integrations if your team requires this. It can handle over 2 billion rows of… more »
    Top Answer:I am not familiar with IBM SPSS Modeler, therefore, I cannot compare these two products. Regarding Alteryx I can say the following: - An excellent desktop tool for Data Prep and analytics. -… more »
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer:Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle… more »
    Ranking
    1st
    Views
    29,811
    Comparisons
    21,218
    Reviews
    31
    Average Words per Review
    515
    Rating
    8.1
    Views
    44,966
    Comparisons
    35,812
    Reviews
    182
    Average Words per Review
    538
    Rating
    8.1
    Comparisons
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Power BI, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    Learn More
    Overview

    Alteryx can be used to speed up or automate your business processes and enables geospatial and predictive solutions. Its platform helps organizations answer business questions quickly and efficiently, and can be used as a major building block in a digital transformation or automation initiative. With Alteryx, you can build processes in a more efficient, repeatable, and less error-prone way. Unlike other tools, Alteryx is easy to use without an IT background. The platform is very robust and can be used in virtually any industry or functional area.

    With Alteryx You Can:

    • Prep, blend, and analyze data
    • Deliver faster, better business outcomes
    • Automate analytics and data science
    • Embed intelligent decisioning
    • Deploy and share analytics in hours

    Alteryx Features Include:

    Some of the most valuable Alteryx features include:

    Scalability, stability, flexibility, fast performance, no-code analytics, data processing, business logic wrapping, scheduling, ease of use, data blending from different platforms, geo-referencing, good customization capabilities, drag and drop functionality, intuitive user interface, connectors, machine learning, macros, simple GUI, integration with Python, good data transformation, good documentation, multiple database merging, and easy deployment.

    Alteryx Can Be Used For:

    • Combining and manipulating data within spreadsheets: Alteryx can be used in situations where complex data manipulation occurs. It can handle large data quickly, and the process is much simpler to see and understand.

    • Database access and supplementing SQL development: Alteryx has several sets of database connectors and functions, including many functions that your average database does not. Alteryx can work with data from multiple databases or areas within a database. It allows users to filter, sort, calculate, etc. as they would commonly do in SQL or an ETL tool.
    • API, cloud, and hybrid access: Alteryx can read and write data in databases, files, REST APIs, and a myriad of other locations (with the correct permissions). When a workflow is published, you can also call a workflow through a REST API to start it.

    • Data science: Alteryx provides pre-built models that are extremely useful for data scientists who may have limited programming skills and also gives you the ability to add R or Python code directly within a workflow.

    • Geospatial analysis: Alteryx gives users drag-and-drop tools to geocode, plot, and map locations, customers, competitors, or anything that has a location (employee, truck, pipeline, etc.).

    • Reports and dashboards: Alteryx provides built-in tools that enable the building of reports and dashboards.

    Alteryx Benefits

    Some of the benefits of using Alteryx include
    :

    • Saves time: Alteryx helps shorten the time required to start analyzing data and looking for insights, minimizing the tasks that do not add value to the business and maximizing the analysis phase.

    • Clear tool configurations: Alteryx provides simple and concise tool configurations that are quick and easy to set.

    • Excellent workflow compatibility.

    • Reduced development time: Alteryx has an extensive gallery of user-developed analytic applications that helps to reduce development time.

    • Fast data loading: Alteryx has tools that make it very effective when working with big data sets.

    • No-code, low-code analytic building blocks: You can prep, blend, and analyze data to enable highly configurable and repeatable workflows.

    • Machine learning: Alteryx allows you to quickly create properly trained algorithms that are ready to deploy.

    Reviews from Real Users

    "Automation is the most valuable aspect for us. The ability to wrap business logic around the data is very helpful." - Theresa M., Senior Capacity Planner at a financial services firm

    "Alteryx has made us more agile and increased the speed and effectiveness of decision making." - Richard F., Director, Digital Experience & Media at Qdoba Restaurant Corporation

    "The scheduling feature for the automation is excellent." - Data Analytics Engineer at a tech services company

    "The product is very stable and super fast, five-star. It's significantly more stable than its nearest competitor." - Director at a non-tech company

    “A complete solution with very good user experience and a nice user interface.” - Solutions Consultant at a tech services company

    "There are a lot of good customization capabilities." - Advance Analytics PO at a pharma/biotech company





    Microsoft BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.

    Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server, with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end-users to better analyze their data, collaborate and better present their data.

    Offer
    Learn more about Alteryx
    Learn more about Microsoft BI
    Sample Customers
    AnalyticsIq Inc., belk, BloominBrands Inc., Cardinalhealth, Cineplex, Dairy Queen
    Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex.
    Top Industries
    REVIEWERS
    Manufacturing Company15%
    Computer Software Company12%
    Healthcare Company9%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Financial Services Firm15%
    Comms Service Provider11%
    Manufacturing Company7%
    REVIEWERS
    Financial Services Firm14%
    Manufacturing Company12%
    Computer Software Company11%
    Government10%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Comms Service Provider17%
    Financial Services Firm9%
    Government7%
    Company Size
    REVIEWERS
    Small Business35%
    Midsize Enterprise15%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise14%
    Large Enterprise70%
    REVIEWERS
    Small Business38%
    Midsize Enterprise17%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise14%
    Large Enterprise68%
    Buyer's Guide
    Alteryx vs. Microsoft BI
    March 2020
    Find out what your peers are saying about Alteryx vs. Microsoft BI and other solutions. Updated: March 2020.
    622,358 professionals have used our research since 2012.

    Alteryx is ranked 1st in Predictive Analytics with 32 reviews while Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 187 reviews. Alteryx is rated 8.0, while Microsoft BI is rated 8.0. The top reviewer of Alteryx writes "Plenty of capability and works well for those who don't want to program and don't use algorithms heavily". On the other hand, the top reviewer of Microsoft BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". Alteryx is most compared with KNIME, Dataiku Data Science Studio, Databricks, SAS Enterprise Guide and Trifacta Wrangler Enterprise, whereas Microsoft BI is most compared with Tableau, Amazon QuickSight, MicroStrategy, SAP BusinessObjects Business Intelligence Platform and Oracle OBIEE. See our Alteryx vs. Microsoft BI report.

    We monitor all Predictive Analytics reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.