Alteryx Case Studies Rosenblatt Securities Uses Alteryx and Tableau to Solidify Its Position as the Buy-Side Firm of Choice

Edit This Case Study Record

	Rosenblatt Securities Uses Alteryx and Tableau to Solidify Its Position as the Buy-Side Firm of Choice Alteryx

Rosenblatt Securities Uses Alteryx and Tableau to Solidify Its Position as the Buy-Side Firm of Choice

Alteryx

Technology Category	Analytics & Modeling - Data-as-a-Service
Applicable Industries	Finance & Insurance
Applicable Functions	Business Operation
Use Cases	Real-Time Location System (RTLS)
Services	Data Science Services
Challenge	Rosenblatt Securities, a premier independent institutional brokerage and investment banking boutique firm, was facing a challenge in performing sophisticated data analyses for its clients. The firm was dealing with millions of rows of execution records and market tick data, which often took days or even weeks to process. The firm was using Tableau visualization software since 2006, but many processes included blending different heterogeneous datasets and running multiple analytic models, which could take days or even weeks of preprocessing time and still required manual error-sampling. The firm was faced with a decision: to spend thousands of dollars on a specialized ETL tool to interact with its structured and unstructured data sources, or to build such a tool internally. Read More
About Customer	Rosenblatt Securities is one of the premier independent institutional brokerage and investment banking boutique firms. The agency-only firm is considered a leader in combining personal service and integrity with the industry’s deepest understanding of market structure and trading dynamics. The firm represents clients in equities and listed derivative markets. The firm had been using Tableau visualization software since 2006, and often pushed Tableau beyond its intended purposes. Many processes included blending different heterogeneous datasets and running multiple analytic models, which could take days or even weeks of preprocessing time and still required manual error-sampling. Read More
Solution	Rosenblatt Securities decided to deploy Alteryx Analytics, which integrates seamlessly with the company’s existing investment in Tableau Software, as well as seamlessly connects to its internal real-time and historical data infrastructure. Using Alteryx for data blending and advanced analytics and Tableau to visualize the data set, Rosenblatt Securities was able to uncover trends and themes extremely quickly. The firm replaced complicated scripts with simple drag-and-drop analytic programs and a visual workflow, gaining rapid results, enabling them to easily trace analyses to the data source, and shortening some processes from weeks or days down to hours or even a few minutes. After just a few months, Rosenblatt Securities has embedded Alteryx into many of its processes, including its daily analysis of what themes are driving the investment landscape on any given day. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Data-as-a-Service

Applicable Industries

Finance & Insurance

Applicable Functions

Business Operation

Use Cases

Real-Time Location System (RTLS)

Services

Data Science Services

Challenge

Rosenblatt Securities, a premier independent institutional brokerage and investment banking boutique firm, was facing a challenge in performing sophisticated data analyses for its clients. The firm was dealing with millions of rows of execution records and market tick data, which often took days or even weeks to process. The firm was using Tableau visualization software since 2006, but many processes included blending different heterogeneous datasets and running multiple analytic models, which could take days or even weeks of preprocessing time and still required manual error-sampling. The firm was faced with a decision: to spend thousands of dollars on a specialized ETL tool to interact with its structured and unstructured data sources, or to build such a tool internally.

About Customer

Rosenblatt Securities is one of the premier independent institutional brokerage and investment banking boutique firms. The agency-only firm is considered a leader in combining personal service and integrity with the industry’s deepest understanding of market structure and trading dynamics. The firm represents clients in equities and listed derivative markets. The firm had been using Tableau visualization software since 2006, and often pushed Tableau beyond its intended purposes. Many processes included blending different heterogeneous datasets and running multiple analytic models, which could take days or even weeks of preprocessing time and still required manual error-sampling.

Solution

Rosenblatt Securities decided to deploy Alteryx Analytics, which integrates seamlessly with the company’s existing investment in Tableau Software, as well as seamlessly connects to its internal real-time and historical data infrastructure. Using Alteryx for data blending and advanced analytics and Tableau to visualize the data set, Rosenblatt Securities was able to uncover trends and themes extremely quickly. The firm replaced complicated scripts with simple drag-and-drop analytic programs and a visual workflow, gaining rapid results, enabling them to easily trace analyses to the data source, and shortening some processes from weeks or days down to hours or even a few minutes. After just a few months, Rosenblatt Securities has embedded Alteryx into many of its processes, including its daily analysis of what themes are driving the investment landscape on any given day.

Impact #1	Rosenblatt Securities was able to reduce both the time and dollars required to gain insight, improving client satisfaction and enabling each individual on his team to focus on his or her core strengths.
Impact #2	The firm can now immediately connect to its infrastructure, retrieve the right data, and analyze it.
Impact #3	One process that used to take several minutes now runs in 50 seconds or less with Alteryx and Tableau.

Impact #1

Rosenblatt Securities was able to reduce both the time and dollars required to gain insight, improving client satisfaction and enabling each individual on his team to focus on his or her core strengths.

Impact #2

The firm can now immediately connect to its infrastructure, retrieve the right data, and analyze it.

Impact #3

One process that used to take several minutes now runs in 50 seconds or less with Alteryx and Tableau.

Benefit #1	Reduced data processing time from weeks to hours or even a few minutes.
Benefit #2	Delivered adhoc client requests in less than a minute.
Benefit #3	One process that used to take several minutes now runs in 50 seconds or less.

Benefit #1

Reduced data processing time from weeks to hours or even a few minutes.

Benefit #2

Delivered adhoc client requests in less than a minute.

Benefit #3

One process that used to take several minutes now runs in 50 seconds or less.

Download PDF Version

Overview

Rosenblatt Securities Uses Alteryx and Tableau to Solidify Its Position as the Buy-Side Firm of Choice

Operational Impact

Quantitative Benefit