<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
143 Ratings

Matillion

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
143 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100
208 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.4 out of 100

Likelihood to Recommend

Matillion

Matillion is great for handling bulk and 'delta' loads to your warehouse, i.e. updating the warehouse with only those records updated since the last execution of the pipeline. The components and Python scripting provide a huge amount of flexibility in what the pipeline does, but you do need to have the expertise to know how to implement it properly.Matillion has been less good at extracting data from APIs. The functionality was found to be complex and it was unclear how to manage things like pagination and rate limiting in API calls.
Anonymous | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

If you're already using Office 365, Power BI for O365 is an easy choice. Start playing around with the free version and then easily add individual Pro licenses with little risk. However, if you anticipate using this with many users, it can get expensive quickly.
Jeremiah Miller | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Matillion
7.9
Power BI For Office 365 (discontinued)
Connect to traditional data sources
Matillion
8.3
Power BI For Office 365 (discontinued)
Connecto to Big Data and NoSQL
Matillion
7.6
Power BI For Office 365 (discontinued)

Data Transformations

Matillion
8.1
Power BI For Office 365 (discontinued)
Simple transformations
Matillion
8.6
Power BI For Office 365 (discontinued)
Complex transformations
Matillion
7.5
Power BI For Office 365 (discontinued)

Data Modeling

Matillion
7.2
Power BI For Office 365 (discontinued)
Data model creation
Matillion
7.6
Power BI For Office 365 (discontinued)
Metadata management
Matillion
6.6
Power BI For Office 365 (discontinued)
Business rules and workflow
Matillion
7.4
Power BI For Office 365 (discontinued)
Collaboration
Matillion
6.8
Power BI For Office 365 (discontinued)
Testing and debugging
Matillion
6.3
Power BI For Office 365 (discontinued)
feature 1
Matillion
8.2
Power BI For Office 365 (discontinued)

Data Governance

Matillion
6.5
Power BI For Office 365 (discontinued)
Integration with data quality tools
Matillion
6.6
Power BI For Office 365 (discontinued)
Integration with MDM tools
Matillion
6.3
Power BI For Office 365 (discontinued)

BI Standard Reporting

Matillion
Power BI For Office 365 (discontinued)
9.0
Pixel Perfect reports
Matillion
Power BI For Office 365 (discontinued)
8.6
Customizable dashboards
Matillion
Power BI For Office 365 (discontinued)
9.4
Report Formatting Templates
Matillion
Power BI For Office 365 (discontinued)
9.0

Ad-hoc Reporting

Matillion
Power BI For Office 365 (discontinued)
9.1
Drill-down analysis
Matillion
Power BI For Office 365 (discontinued)
8.4
Formatting capabilities
Matillion
Power BI For Office 365 (discontinued)
8.4
Integration with R or other statistical packages
Matillion
Power BI For Office 365 (discontinued)
10.0
Report sharing and collaboration
Matillion
Power BI For Office 365 (discontinued)
9.5

Report Output and Scheduling

Matillion
Power BI For Office 365 (discontinued)
8.9
Publish to Web
Matillion
Power BI For Office 365 (discontinued)
9.0
Publish to PDF
Matillion
Power BI For Office 365 (discontinued)
9.0
Report Versioning
Matillion
Power BI For Office 365 (discontinued)
9.0
Report Delivery Scheduling
Matillion
Power BI For Office 365 (discontinued)
9.2
Delivery to Remote Servers
Matillion
Power BI For Office 365 (discontinued)
8.4

Data Discovery and Visualization

Matillion
Power BI For Office 365 (discontinued)
9.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
Matillion
Power BI For Office 365 (discontinued)
9.5
Location Analytics / Geographic Visualization
Matillion
Power BI For Office 365 (discontinued)
9.0
Predictive Analytics
Matillion
Power BI For Office 365 (discontinued)
8.6

Access Control and Security

Matillion
Power BI For Office 365 (discontinued)
9.5
Multi-User Support (named login)
Matillion
Power BI For Office 365 (discontinued)
9.8
Role-Based Security Model
Matillion
Power BI For Office 365 (discontinued)
9.8
Multiple Access Permission Levels (Create, Read, Delete)
Matillion
Power BI For Office 365 (discontinued)
8.6
Single Sign-On (SSO)
Matillion
Power BI For Office 365 (discontinued)
9.8

Mobile Capabilities

Matillion
Power BI For Office 365 (discontinued)
8.0
Responsive Design for Web Access
Matillion
Power BI For Office 365 (discontinued)
8.5
Dedicated iOS Application
Matillion
Power BI For Office 365 (discontinued)
8.0
Dedicated Android Application
Matillion
Power BI For Office 365 (discontinued)
8.0
Dashboard / Report / Visualization Interactivity on Mobile
Matillion
Power BI For Office 365 (discontinued)
7.4

Application Program Interfaces (APIs) / Embedding

Matillion
Power BI For Office 365 (discontinued)
8.3
REST API
Matillion
Power BI For Office 365 (discontinued)
6.0
Javascript API
Matillion
Power BI For Office 365 (discontinued)
9.0
Themeable User Interface (UI)
Matillion
Power BI For Office 365 (discontinued)
9.0
Customizable Platform (Open Source)
Matillion
Power BI For Office 365 (discontinued)
9.0

Pros

Matillion

  • The workspace is drag and drop, which makes it intuitive and easy to use.
  • Server creation and management is robust. We haven't had to worry too much about it once we got it created.
  • The job scheduler is very simple and intuitive.
  • Matillion allows you to run Python, which grants almost unlimited flexibility, even without using any other components.
Hyrum Ward | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

  • Easy to make visual dashboards from SQL queries. Previously we had to use a third party application that had to run on a web server that was so complex to setup and run. PowerBI removes all that.
  • Ability to control who/which group has access to each dashboard or report. Ties in well with the rest of the Office 365 ecosystem.
  • Has many connectors to allow pulling data from various systems, both onsite (via gateway) or external (via APIs), and join the data to create a report/dashboard.
  • Ability to show data but also export the data, if permitted.
  • Easy to show PowerBI dashboards on SharePoint or on other websites via embedded code.
Anonymous | TrustRadius Reviewer

Cons

Matillion

  • Limited selection of instance sizes - Larger organizations and groups my need to set up multilple instances depending on estimations on concurrent users.
  • Lack of complete github, gitlab, or other source control integration - it has internal versioning but it is limited. Manual job exports currently don't lend well for useful DIFFs comparison when using those technologies.
  • Needs more options for authentication and security - User creation is very manual and can be tedious and difficult to manage for larger installations.
Patrick Hildreth | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

  • Licensing: Currently, Microsoft has a fixed pricing model for Office 365 users, regardless of role/function of the user. Most organizations have a small number of "power users" that create usable content and many more "consumers" that simply view/run reports created by power users. Microsoft does not differentiate between these users, and thus the pricing limits organizations from large deployments of the software.
  • Version incompatibility: Excel 2010 and 2013 workbooks are compatible with each other. However, workbooks created in 2010 that include PowerPivot databases must be upgraded to 2013 format to run in 2013. Subsequently, you cannot open these upgraded PowerPivot workbooks in 2010. This requires ALL users to be on the same version.
  • Visualization: Excel charting with PowerPivot workbooks is adequate for many users. Power View also contains a number of GREAT visualizations, including animated bubble charts and a very flexible dashboard/report design canvas. However, compared to some of the other self-service BI solutions, it is still limited in its visualization capabilities.
Ken Raetz | TrustRadius Reviewer

Likelihood to Renew

Matillion

Matillion 7.1
Based on 2 answers
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow.2. Scalability: As usage increase, we want Matillion system to be more stable.
Sudarshan Kothari | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

Power BI For Office 365 (discontinued) 9.2
Based on 4 answers
I will continue to recommend this suite to folks looking for a reporting and analytics solution, as I find in MOST cases, it's great at meeting almost every requirement I've been given by a multitude of clients across a range of industries. I've built Capacity Planning solutions that allowed end user input which was then submitted to SharePoint, Executive Dashboards, custom applications, simple analytical tools for teams to easily slice and dice data, and super simple reports as well as some very complicated ones. If you haven't seen the demos online, do a search, and see for yourself - this is a great BI suite! (I do not work for Microsoft, although I do consult out there from time to time. I do occasionally make a recommendation for a different BI reporting tool, but in general, find Excel can accomplish quite a bit for less money and in less time.)
Anonymous | TrustRadius Reviewer

Usability

Matillion

Matillion 7.8
Based on 87 answers
Pretty good UI, especially for a completely web-based system. Source control integration is a bit clunky at times, but overall makes code versioning and branching much more simple, since it's largely within the same context as the rest of the code. Finding some core settings can be difficult - they're just not where one would expect them to be.
Britton Gray | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

No score
No answers yet
No answers on this topic

Support Rating

Matillion

Matillion 7.6
Based on 4 answers
For most of users support can provide needed help. And it is always in a really short time frame.In some really advanced cases there was necessary to include highly tech people and there was a lot of back and forth. Because I have a case that is not resolved for more than a year and the bug is based on initial bad implementation (Google AdManager component) I would suggest that sometimes don't rush to publish something that is not ready.
Aleksa Topalović | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

No score
No answers yet
No answers on this topic

Implementation Rating

Matillion

Matillion 8.2
Based on 1 answer
Not really a part of the implementation to give fare insight.
Anonymous | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

No score
No answers yet
No answers on this topic

Alternatives Considered

Matillion

There's a number of systems not available to enter in here that we also took a look at: AWS Data pipeline, Airflow, Xplenty, etc. The reason we chose Matillion is for the balance of features (ability to connect into cloud data sources like Jira), a simple interface to put together Data pipelines (that required little to no coding), and a reasonable price point. Matillion is pretty unique in that it hits a balance of all three of those requirements.
Kris Shinn | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

Oracle was nice, super expensive to implement if it's not in use already. JobDiva is choppy and heavy on the system while does not give great reports. Salesforce is good; remote access is good however their support is terrible
Daniel J. Lewis | TrustRadius Reviewer

Scalability

Matillion

Matillion 6.7
Based on 79 answers
Instance size can be upgraded or downgraded with few clicks and hourly billing rate will change immediately. No need to restart Matillion instance. Matillion Enterprise edition has several benefits and will be activated automatically by configuring ">=m4." large instance size
Anonymous | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

No score
No answers yet
No answers on this topic

Return on Investment

Matillion

  • Matillion has dramatically decreased the time it takes to create new ETL
  • Matillion has reduced the amount of time it takes to execute our daily ETL processing (by 50% or more)
  • Matillion has increased the number of people who can develop ETL by making ETL development easier
  • Matillion has increased the variety of data sources we can bring into our data warehouse
  • Matillion has made it a little harder to manage source control and deployment
Matthew Burr | TrustRadius Reviewer

Power BI For Office 365 (discontinued)

  • As a Microsoft Partner implementing Business Intelligence solutions, Power BI has removed the barrier for our clients to begin the "BI journey". So often, projects get hung up in that early phase of procuring and installing/configuring expensive hardware and software. Just simply getting started and designing a beginning solution has allowed our clients to see results in 1-2 weeks using their data that might have taken months to achieve otherwise.
  • One significant ROI example is process improvement. In many cases, individuals or teams are spending days each month gathering data from multiple sources for reporting to their constituents. We are reducing these times to minutes by automating many of the data collection and integration processes that were previously manual.
Ken Raetz | TrustRadius Reviewer

Screenshots

Pricing Details

Matillion

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Power BI For Office 365 (discontinued)

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Matillion
7.6
Power BI For Office 365 (discontinued)
8.8

Likelihood to Renew

Matillion
7.1
Power BI For Office 365 (discontinued)
9.2

Usability

Matillion
7.8
Power BI For Office 365 (discontinued)

Support Rating

Matillion
7.6
Power BI For Office 365 (discontinued)

Implementation Rating

Matillion
8.2
Power BI For Office 365 (discontinued)

Scalability

Matillion
6.7
Power BI For Office 365 (discontinued)

Add comparison