PRIZM Premier from Claritas is a segmentation system that yields consumer insights to help reveal your customer’s preferences. PRIZM combines demographic, consumer behavior, and geographic data to help marketers identify, understand and reach their customers and prospects.
N/A
Vertica Analytics Database
Score10 out of 10
N/A
The Vertica Analytics Platform supplies enterprise data warehouses with big data analytics capabilities and modernization. Vertica was acquired and supported by OpenText, then sold to Rocket Software in 2026.
Nielsens account managers are amazing. I could brag about my account rep forever.
Get onsight training, it helps the process start at lightspeed.
Importing external information into consumerpoint is tricky, but super fast once it is learned. I'm pretty tech saavy and I did it wrong initially. Formatting is finicky. That's part of why the onsight training is so great.
Vertica as a data warehouse to deliver analytics in-house and even to your client base on scale is not rivaled anywhere in the market. Frankly, in my experience it is not even close to equaled. Because it is such a powerful data warehouse, some people attempt to use it as a transactional database. It certainly is not one of those. Individual row inserts are slow and do not perform well. Deletes are a whole other story. RDBMS it is definitely not. OLAP it rocks.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Could use some work on better integrating with cloud providers and open source technologies. For AWS you will find an AMI in the marketplace and recently a connector for loading data from S3 directly was created. With last release, integration with Kafka was added that can help.
Managing large workloads (concurrent queries) is a bit challenging.
Having a way to provide an estimate on the duration for currently executing queries / etc. can be helpful. Vertica provides some counters for the query execution engine that are helpful but some may find confusing.
Unloading data over JDBC is very slow. We've had to come up with alternatives based on vsql, etc. Not a very clean, official on how to unload data.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It can be expensive, but the strategic insights you get from it are unreal. It is one of those products that we now wonder what we did without it. Segmentation is a must in whatever business and PRISM makes it significantly easier. We reviewed several synthetic and organic segmentation methods, including ESRI and k means clustering analysis, and PRIZM is by far the best.
I haven't had any recent opportunity to reach out to Vertica support. From what I remember, I believe whenever I reached out to them the experience was smooth.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vertica performs well when the query has good stats and is tuned well. Options for GUI clients are ugly and outdated. IO optimized: it's a columnar store with no indexing structures to maintain like traditional databases. The indexing is achieved by storing the data sorted on disk, which itself is run transparently as a background process.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Definitely a return on investment. We have been able to make much better use of our media buys. We have seen conversion rates skyrocket because of the targeting we were able to do.
Our media buys were much more cost efffective. An example is the TV listing pages of the newspaper was cheaper than the front page for certain segments.
It has helped support expansion into a new market for our health insurance products.
We are able to design products based on the populations needs and behaviors rather than what someone heard.
We were also able to map risky health behaviors across our service area and target the unhealthy by zip code.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
