dbt vs. ibi Data Migrator vs. Vena

The prerequisite is that you have a supported database/data warehouse and have already found a way to ingest your raw data. Then dbt is very well suited to manage your transformation logic if the people using it are familiar with SQL. If you want to benefit from bringing engineering practices to data, dbt is a great fit. It can bring CI/CD practices, version control, automated testing, documentation generation, etc. It is not so well suited if the people managing the transformation logic do not like to code (in SQL) but prefer graphical user interfaces.

Incentivized

Vena is great for managing data and putting all of your information in one easy-to-locate spot. It also makes finding data faster and easier. It is also great for tracking project performance and budgeting. It is fairly user-friendly and easy to use from an admin side.

Incentivized

• dbt supports version control through GIT, this allows teams to collaborate and track the data transformation logic.
• dbt allows us to build data models which helps to break complex transformation logic into simple and smaller logic.
• dbt is completely based on SQL which allows data analyst and data engineers to build the transformation logic.
• dbt can be easily integrated with snowflake.

Incentivized

• Bringing all of our financial processes together in one place
• Helps Operations and Finance to see what is happening in real time at each site.
• It makes the budgeting process very easy for Operations to input and Finance to go in and check alongside at the same time.

Incentivized

• Field-level lineage (currently at table level)
• Documentation inheritance - if a field is documented the downstream field of the same name could inherit the doc info
• Adding python model support (in beta now)

Incentivized

• Preparing forecasts under different scenarios can be challenging. Your input templates need to be set up to toggle between the various scenarios. We found that certain templates, particularly workforce were not able to easily switch between different scenarios.
• Connection to Bamboo - initial testing of this resulted in the history being deleted and only showing the current employees. For us it was important to have the history in Vena.
• No native connection to Tableau - while a CSV upload is a way around would be great to have this since you already have a Power BI connection.

Incentivized

Vena has been a huge win for us as an organization, as it vastly improved our budgeting process by removing manual consolidation that was incredibly time consuming, and it allows us to see a multi-year view of our organizational budget across all of our funding sources. We've seen Vena's platform grow over the years and we've not yet fully adopted some of them so it feels like there's still potential to get even more value out of the platform.

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

I would rate Vena's overall usability as an 8 out of 10. Vena offers a user-friendly interface, especially for those familiar with Excel, making it relatively easy to use. Most features are intuitive. However, some advanced functionalities may require more training or time to master, so it's not a perfect score. Overall, Vena provides a solid user experience that supports efficient financial planning.

Incentivized

Vena has been available and running. There are notifications well ahead of scheduled maintenance and so far, scheduled maintenance has been occurring during off hours and fortunately has not occurred during a time that is crucial for us to be actively using.

Incentivized

Vena Solutions pages load quickly and only a few times does it get a bit slow, only when there are many integrations and the reports are long. But in general it is always fast and honestly I am very satisfied with the speed in the generation of statistical reports and the pages

Incentivized

They are very quick to respond when you submit a ticket and typically fix issues quickly as well. I only didn't give this a 10 because there is still an open issue with our Salesforce connection that we've been waiting on now for a few months.

Incentivized

Our initial in person training was a little rough b/c I felt like our trainer wanted to focus on maximizing Vena rather than understanding what we were needing for our organization. He was very responsive and added insights, but could have worked to understand our needs a little better.

Incentivized

The training was structured as a group training to learn the basics of creating a data model and mapping a template. While we had nearly 10 participants, I was the only actual implementer so we probably didn't actually need the training and could have just learned the initial skills from the implementation consultant. Two years later, when we hired a new team member, they completed several modules in Vena Academy (a self paced learning course) which allowed them to get up to speed on the basics with just a bit of supplemental guidance from me as our existing admin.

Incentivized

The Vena consultant had great knowledge of both the Vena solution and Excel and Excel functions. He was able to help suggest ways to build our templates that met our requirements using Excel functions we had not previously considered using. And we have been able to use the Excel information he provided in other ways outside of Vena. He was very patient and flexible as we learned the Vena tool and created templates

I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT there's a FREE version for 1 dev seat with no read-only access for anyone else, so you can always start with that and then buy yourself a seat later.

Incentivized

Vena is a strong fit for teams that want to keep working in Excel while adding structure, workflows, and a centralized database. Vena emphasizes its native Excel experience, along with planning templates, workflow automation, and integrations for budgeting/forecasting.


Planful is more positioned as an end-to-end financial performance platform, with a broader emphasis on planning, budgeting, forecasting, reporting, AI/ML-driven forecasting support, real-time collaboration, and enterprise-scale (including multi-entity/multi-currency environments). It also supports Microsoft 365 reporting via Spotlight. We selected Vena because it was a better fit for our current use case and team setup:

Our Operations and FP&A teams primarily use it for budgeting and forecasting, so the Excel-based workflow made adoption easier.


It was easier to implement and simpler for users to learn and operate day-to-day.


It fit well with our need to improve planning structure without forcing a major process change.

Incentivized

Vena solutios is a software that provides robust tools that help different departments in their statistics and we can visualize a lot of promising and visually attractive data. Vena Solutions' level of scalability is high and sustainable over time thanks to the fabulous technical support that is ready to help us at all times

Incentivized

• Simplified our BI layer for faster load times
• Increased the quality of data reaching our end users
• Makes complex transformations manageable

Incentivized

• Automated monthly financial statements saves us 3 hours a month.
• Moving reporting away from IT has begun to save hours of IT involvement, which will only grow as we shift more reports to Vena. This frees up IT to work on more important IT initiatives.
• Using budget templates saved hours of copy and paste time when gathering inputs from each department.

Incentivized