Adverity vs. dbt

If you're a marketing organization that wants to own your data architecture, get away from hours of manual excel work, and build a flexible and scalable BI practice for yourself and your clients, Adverity is your solution. Especially if you don't have a dedicated analytics team or current database solution. If you have access to a wide variety of API's and a fully staffed team to custom develop new connectors in under 30 days for no incremental cost, you're probably best in-housing

Incentivized

dbt (Data Build Tool) is best suited for doing the data transformation. dbt is just a transformation tool and it is not suitable for building a data pipeline which requires extraction of data and loading. dbt is well suited for SQL based transformation logic and it is less appropriate when transformation logic requires python.

Incentivized

• Customizable dashboards, that you could change and make unique to your specific need / business.
• Combining a range of data sets into one view.
• Easily sharable insights, that you can share internally or also with clients.

Incentivized

• user experience makes it easy to work with SQL and version control
• customer success team and the dbt (data build tool) community help establish best practices
• thorough and clear documentation

• Adverity is running into some issues being able to custom-develop API connectors at scale/speed. This is mostly because of their rapid growth and incredible core product. If you need custom development, be prepared to use one of the many easy-to-use workarounds Adverity offers for endpoints they don't have a direct integration with. Don't worry - you'll get your data either way.

Incentivized

• Slow load times of the dbt cloud environment (they're working on it via a new UI though)
• More out-of-the-box solutions for managing procedures, functions, etc would be nice to have, but honestly, it's pretty easy to figure out how to adapt dbt macros

Incentivized

Adverity is easy to understand and use, even for users who are less technical. Reports and dashboards are easy to send out, and back-end users can easily navigate workspaces for creating new data fetches.

Incentivized

dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things.

Incentivized

Previously I had never really used a tool like this, only using software such as GA to look at any insights and review performance. So I think that the combined view of having all of the data sets (Which in my role I wouldn't always particularly have access to), was really useful. As an individual who was optimising our clients websites it meant that I was really able to prioritise what was important, but also have a great view of absolutely all activity that was happening

Incentivized

Matillion is graphical versus dbt, which is SQL code-based (that, of course, is a matter of personal preference and not an objective advantage). The integrated testing, documentation generation, lineage, etc., were additional criteria that led us to choose dbt.

Incentivized

• Scale - the biggest advantage has been the ability to extract, transform, and load data for 150+ clients with a three-person team without a software or data engineering team to support. Adverity would easily allow us to scale up to double or triple the client load if needed.
• Templates - Another advantage related to scale, Adverity allows us to run a templated approach to extraction, transformation, and also data visualization and reporting so that onboarding is very fast. Typical clients with up to 15 data sources can be onboarded in as little as a couple of hours.

Incentivized

• In 3 months we re-wrote the data warehouse (15-20 sources) in dbt with 3 developers.
• We are using it continually for the past year with no issues.
• Sorry, I don't have ROI numbers but the impact was huge.

Incentivized