Vena

Vena

(25)
4.7 out of 5 stars

Vena’s corporate performance management software combines native Microsoft® Excel® with the sophisticated workflow, audit capabilities, business rules and central database of an enterprise-class solution.

Work for Vena?

Learning about Vena?

We can help you find the solution that fits you best.

Vena Reviews

Ask Vena a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
  • For Category
Ratings
Company Size
User Role
User Industry
For Category
Showing 25 Vena reviews
LinkedIn Connections
Vena review by <span>George T.</span>
George T.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Powerful and Flexible with a bit of a Learning Curve

What do you like best?

Operating as an extension of Excel, Vena has both extensive flexibility for design and implementation along with the familiarity of using an existing product rather than learning an entirely new system.

Support and customer service reps are very keen and quick to assist.

By having a single template used across many users and projects, you can instantaneously roll out new features to your entire team.

What do you dislike?

Loading time on complex templates can be time consuming. Some mapping/design features could use a refresh to be faster or friendlier.

Recommendations to others considering the product

Give it time. Especially if you are a small company with a limited team it can be daunting at the start but once you get rolling there are benefits and additional uses at every corner. It will take some time to get users on your side since it requires some lockdowns of Excel that not everyone is comfortable with, but they see how powerful the system can be and how much work it saves, they'll get it.

What business problems are you solving with the product? What benefits have you realized?

We consolidate 10-20 companies into a single entity for reporting purposes on a monthly basis. Originally this process took several senior employees a month and was only done annually, now one of our intermediate accountants can perform all the required tasks in under a week.

In addition, we have streamlined our cost reporting system on a number of productions and have been working towards budgeting and projections systems.

Throughout all such tasks we have improved data flows between users and trimmed out an enormous amount of previously tedious work on manually updating and copying between documents.

Sign in to G2 Crowd to see what your connections have to say about Vena
Headshots
Vena review by <span>Michael R.</span>
Michael R.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Director Finance

What do you like best?

Data consolidation is seamless; scripts translate currency automatically; standardized budget templates minimize monthly maintenance.

What do you dislike?

Report writer is not available and quick access Pivot Table through OLEDB connection is slow to the point it's virtually non-functional.

Recommendations to others considering the product

Vena leverages O-LAP cube technology and takes Excel based financial modeling to the next level, by eliminating Excel's pain-points and exploiting its strengths. The implementation was well planned and executed flawlessly. Also, the roll-out to budget owners was as simple and straight forward as it gets, and the benefits are literally realized overnight after implementation.

What business problems are you solving with the product? What benefits have you realized?

Our problems: Massive Excel models interconnected with vlookup & sumif functions; multiple versions of models to support Business Units made monthly maintenance a full-time job; forecasting in local foreign market currencies and introducing currency translation to existing models was not possible.

Vena's Solution: Instantaneous consolidation of budget data; standardized budget templates eliminate costly hours of model maintenance; scripts perform currency translation behind the scenes so data is always available in USD or local currencies.

What Corporate Performance Management (CPM) solution do you use?

Thanks for letting us know!
Vena review by <span>Logan K.</span>
Logan K.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Assuming one is Excel savvy, this tool is a terrific asset.

What do you like best?

The tool is extremely malleable. One is only limited by their abilities within MS Excel. A ton can be accomplished with a fairly basic understanding of the spreadsheet building software. If one possesses a more advanced understanding (VBA, complex formulas, etc.), the possibilities are endless. My ETL (export, transformation, load) consultant (Patrick G.) has granted me 100% visibility to most components of the process. He has made it possible to download ALL staging tables that manifested in the data currently loaded into my database. This has been KEY in reconciling my data to source systems, quality checking the transformation process, automating calculations, preparing large data sets for third parties, etc. Furthermore, our consultant provided me with all the raw T-SQL code used to transform/stage our data. The visibility to the code has helped me out a ton with my understanding of SQL.

My customer success manager (Neetu G.) is awesome too. Anytime I have an issue, she makes me a priority. If I carbon copy her on a support ticket, she is very quick to make sure I am being tended to.

I could go on and on about the things I love the most. I've had a GREAT experience.

What do you dislike?

This is tough.

In the past, I would have griped about the lack of web-based presentation abilities, but Vena has been adding tons of these features (see the Dashboard module). It can be a bit tough to coax folks who aren't very Excel/data driven into spreadsheets.

The only reason I only give 9/10 on the "would you refer to friend" survey is that the program is very Excel-based. So, if someone was to tell me that they don't like Excel, I would never suggest Vena as a BI tool. That being said, it's tough to find folks within the analytics world that do not like Excel.

Recommendations to others considering the product

Do it! As long as you have a solid understanding of MS Excel, it's a great investment.

What business problems are you solving with the product? What benefits have you realized?

I am solving TONS of problems. It's worth noting that we deal in health care.

- Calculation of contractual allowance for each individual charge/CPT posted to practice management software.

- Calculation of A/R aging figures.

- Calculation of bad debt reserve.

- Mapping CPT codes to their service type, professional or non-professional, etc.

- Mapping names from multiple different systems to ensure consistency.

Vena review by <span>Carrie S.</span>
Carrie S.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Powerful, flexible solution for budgeting, reporting, and anything else with Excel and a database

What do you like best?

Vena is an amazing product with a great team behind it! Some of the things I like best:

- Super easy implementation - after a bit of training by our implementation team, we did a significant portion of the design work ourselves

- Excel user interface which is stable and quick

- Security features and workflow on the web which makes it accessible from anywhere

- Customer engaged development team that works to meet the needs and wants of it's user base - They're always listening and improving!

- If you can dream it up in Excel, you can implement and use it through Vena

- Can be used for any kind of process - even beyond budgeting/planning/reporting, etc.

- Powerful and quick cloud database system - it never takes more than a few seconds to run anything

- If you have an Excel MVP on your team, you can make Vena do just about anything without having to engage their services team

- The interface is easy for even the least technically savvy user

What do you dislike?

All products can be improved... Some of the things I like least about Vena:

- Support is only through email and can sometimes take several hours to get a meaningful response (more than "I've received your request and I'm looking into it")

- The constant improvement of the product is awesome, but sometimes my users question why their add-in asks to update so often.

- Set up and design takes a lot of clicking

Recommendations to others considering the product

Know your processes and wish list before you start implementation to get the most out of the tool. Consider what else you might use it for and how that might impact your design.

What business problems are you solving with the product? What benefits have you realized?

When we started down the research path, we were really just trying to get a good budgeting product that would make the cycle shorter - but after we implemented, we realized it could be great for reporting as well. Now our budgeting and reporting come from one source which makes life so much easier! We shortened our budgeting cycle from 4-6 weeks for a first pass to about 10 days. In addition, we're spending more time on making inputs better rather than just trying to have the various inputs tie to each other. We've also been able to more easily engage more people in the process.

We've seen several other processes that we could move to Vena (Development life-cycle, incident reporting, Asset planning, operational reporting, etc.) and while we haven't actually designed those processes yet, it's really great to know we have a product that could easily handle everything in one place rather than having to pay for multiple products.

Vena review by <span>devon m.</span>
devon m.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Vena for Tax Data Warehouse

What do you like best?

This is by far the most elegant (ie, powerful yet simple) integration of excel and a dimensional database I've yet used. The relative ease (ie, speed) with which you can develop your current excel-based models into enterprise-class applications probably has to be experienced to be believed. This product brought the terms self-service business intelligence, analytics, and data warehouse down from the domain of large-scale waterfall projects (hundreds of thousands of dollars) to an agile and practical reality for tens of thousands of dollars.

What do you dislike?

Honestly, very little. Further, most minor annoyances have been addressed during the period of our ownership. The current rate of development of the cloud-based application is very impressive. Significant releases of new or improved functionality almost monthly. It is likely beyond the scope of this review, and far beyond the interest of most users/readers here, but my most technical criticism would be directed at the maturity of the user interface for server side scripting - ie, the ability to do calculations "on the database side" rather than in excel. The tools exposed to the user for evaluating errors in advanced VenaCalc scripts are not as robust as you might expect from other programming tools.

Recommendations to others considering the product

It is important to understand that Vena is predicated on the idea that Excel is the front-end tool that finance professionals prefer to use. If you want to continue to be able to leverage the full power of native excel but need enterprise-class data reliability and efficiency, I would strongly recommend this product. If you are not seeking to retain any part of your existing Excel-based workflow, then Vena is not as easy to recommend. For example, if you are looking for a "pre-built" solution that has considered all the necessary business logic of your given problem, with a stock suite of forms and reports that are more comprehensive than your existing Excel-based analyses (ie, you want to throw out everything you have and start over), then Vena may not be the right solution.

What business problems are you solving with the product? What benefits have you realized?

We were looking for a solution to increase the reliability (data integrity, audit trail, etc) and efficiency (aggregation / roll-ups, roll-over, etc) of the income tax provision process for our $3 Billion multi-national with over 150 entities aggregating into several different federal consolidations and annual reports. We dedicated one tax professional, not IT professional, and self-implemented a working proof-of-concept within a couple of weeks and all core functionality in less 8 weeks. We were able to extend that functionality to all of the information that flows through our income tax cycle (including returns, estimates, etc) in the first year of ownership, and are piloting processes in other areas of finance. For the income tax provision alone, roll-over went from several weeks to a couple of days. Perhaps more importantly, we have eliminated the mystical -- no more "glitches" or otherwise unexplained changes. The audit trail allows us to identify the source of all issues and correct them.

Vena review by <span>Jo L.</span>
Jo L.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd on behalf of the vendor
Reviewed On

Vena is more than Excel on Steroids

What do you like best?

Being able to leverage all Excel features and functionality without worrying about losing data/ worksheets, version control, etc. All our users are power Excel people. Once we implemented the enterprise model, our users did not have to learn any new GUI to interact with the model.We were up and running very quickly.

The Vena consultants have been very knowledgeable and exceeded our expectations in terms of delivering best practices recommendations during development/ implementation.

What do you dislike?

Report writing can be significantly improved.Building a report once the model is implemented is not easy, intuitive.or flexible.

What business problems are you solving with the product? What benefits have you realized?

Several business issues were solved and therefore, benefits realized:

- No more missing Excel data/ worksheets

- Ease of version control and audit trail

- Aggregation of large amounts of data in a controlled environment

- Workflow support to guide user input

Learn more about Vena

Vena Videos

Kate avatar
Kate from G2 Crowd

Learning about Vena?

I can help.
* We monitor all Vena reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.