3 Reasons Why I Prefer HP Vertica


3 Reasons Why I Prefer HP Vertica


Since I did a little bashing of cube technology the other day, I suppose that I should explain why I also said that I prefer HP Vertica.

Vertica Scales

Using Tableau with Vertica is like peanut butter and jelly. They just go together. Why? When you are probing a sizable and granular data set, you have the horsepower to dive deep. Ad hoc analysis of very large data can yield insight that might be masked by the aggregations of data presented in a cube. If you have a very large data source, Vertica allows you to explore without the latency you would experience in a traditional relational store.

Tableau & Vertica PBJ

Vertica is a Software Solution

Sure, there are other column-store databases that are fast, but they rely on proprietary hardware to make them work. As a former buyer of technology, I hated products that locked me into proprietary hardware solutions. Why? Because the first time you buy the box will be the least expensive proposition. The second, third and fourth boxes will get more expensive. You’re trapped because you’ve placed your faith in a hardware solution that locks you into a single vendor. Vertica is a software solution that runs on commodity hardware.

HP Vertica

Vertica is Priced Right

When using proprietary hardware solutions, you have to scale largely and with difficulty to quantify steps. Those steps are also going to be big. Because Vertica prices per terabyte stored, you can whip out your calculator and figure out what it will cost to store 10, 20 or 100 terabytes. This structure makes it much easier to plan your future needs versus cost, so you can anticipate budget needs based on projected demand more easily. Also, your progression will be more linear. You’ll avoid the giant step-up in costs that proprietary box solutions will require.


There are several more reasons to choose Vertica than those I just listed. If you want to learn more or have questions about Vertica, contact us today! We can give you the low-down.

Contact Us

More About the Author

Dan Murray

Director of Strategic Innovations
Ten Questions for ChatGPT about Tableau and Level of Detail Expressions I had some fun with ChatGPT asking it questions about cohort analysis this week. I’ll spare you the 4,000 words it created on general ...
The BI Cantos: Facilitating Data Culture Environments that encourage learning, sharing and discovery will prosper. Environments that don’t will not achieve high ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072


Love our blog? You should see our emails. Sign up for our newsletter!