• Provides high-level interface to all standard SQL databases via DatabaseLink
• Features a fully integrated system, which supports all aspects of data computation and analysis
• Generates high-quality, fully interactive data visualizations

Challenge

As a research analyst at BondDesk Group LLC, Joel Drouillard analyzes the way clients use the company's platform to search for fixed income securities. Recently, he needed to go even deeper inside the interface to break down certain properties of searches.

Solution

Using DatabaseLink, an industrial-strength Mathematica application that allows convenient integration of Mathematica with database management systems, Drouillard can easily retrieve all of BondDesk's click data. Once the data is in Mathematica, he can use the system's large collection of functions for numerical and symbolic computation and data processing to analyze and visualize clients' search behavior. Drouillard says, "I derive an immense amount of benefit from the tools Mathematica offers for mounting structures onto data. Visually, it's a big step forward too."

Benefits

Drouillard says that with Mathematica's integrated approach to data handling, he can get a clearer picture of search activity on the company's interface and focus more on answering questions and optimizing the system.

"One of the biggest advantages that I've derived from switching to Mathematica is its ability to operate in a vector sense or on a set sense rather than having to loop through everything. That's going to be relatively breakthrough in terms of my ability to now answer questions in a matter of minutes as opposed to... hours or days."

• Mathematica Solution for Data Analysis and Mining»
• DatabaseLink User Guide»
• Rearranging & Restructuring Lists in Mathematica»
• Customer Story Announcement»

Related Stories