Vertica Reviews

We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance.

The platform has improved our organization by providing faster data retrieval and cost-effective solutions compared to other databases like Oracle. The columnar storage format allows for quicker data processing and reduced costs.

Our company uses one of the latest containerized versions of Vertica. When the curated processes are completed, our company uses Vertica at the end of all pipelines. In our organization, we usually store the curated datasets in parquet files, but we offer Vertica storage access for data consumers to manipulate and query the data easily. Our company also stores data in the Vertica database for analytics. 

In one of our organization's prior investigation reports on Vertica, it was highlighted that the solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature for our company.

We are very happy to have a good warehouse solution that we can run on-premises. Next year we will start testing it on the cloud so we can progress to a hybrid solution. We would like to have Vertica in the cloud integrating with our data lake. We could go with another cloud solution but Vertica has been a good solution for us so far and we hope the cloud product is as good and flexible.  

On-premises, Vertica would still be used as our data warehouse solution. That would keep us where we know that the cost for the hardware is relatively reasonable where we have customers running large number of reports. At the moment we have customers running many thousands of reports a day and having Vertica gives us real-time insight into our data. The ROI with Vertica on premises has been sunstantial. 

Allow near realtime reports into vast amounts of data has given is insights into most areas of our business

Vertica is our sole data warehouse solution. It is our single point of access to all data loaded from disparate data sources across the organization, and is the single point of truth for all business rules encapsulated in our fact and dimension tables. All of our reporting to all business departments originates from Vertica.  We are also using Vertica's inherent analytic functions, most notably geospatial, and are automating much of our analytics team's R libraries and functions into Vertica for faster processing.

The fast columnar store database structure allows our query times to be at least 10x faster than on any other database. This enables us to get answers to data questions as well as numerous analytics on our data out to our internal and external clients quickly. We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently. What was once a two year backlog of report requests on our old data system has been virtually eliminated now that we are using Vertica to provide the solutions.

We are able to create complex reports in Tableau by crunching the data in Vertica first and simply extracting the data to Tableau. We have used Vertica to automate manual processes across our business that previously used mostly Excel, and now R, improving efficiency company-wide. We have saved our Analytics Department days worth of man hours each month by using Vertica's Integrated R package instead of their local R Studio implementations. We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds.  

We use Vertica for different business analytics, like IPTV and viewership analytics.

Vertica is easy to use and provides really high performance, stability, and scalability.

• Compression / speed with highly complex queries

We use it for analytics (marketing).

We use the solution for the warehouse. We implement machine-learning solutions such as clustering or classification models.

We can implement advanced solutions with very interesting capabilities to review whether the customer returns the tool and the licensing cost.

In my company, we use Vertica as it's a tool meant to serve as database performance software and to make some selections, including some usual activities on a database revolving around options like select, insert, update, delete, and a few more.

The best thing about Vertica is that it is a supportive database performance software. Generally, the tool is used for performance and KPIs.