Case Study: MSXI achieves unified, compact cross‑platform data blending and faster insights with Alteryx

SQL, Access, Excel, and Hadoop Data Blending

MSXI faced a challenge of collecting and sharing large volumes of data that lived across many applications and file types — SQL, Access, Excel and Hadoop — which made testing, error-finding and collaboration slow and cumbersome. The team needed a way to consolidate disparate data into a single, sharable location and build a proof of concept for broader adoption.

Using Alteryx, the team blended data from multiple sources, developed reusable workflows and functions, and exported results to a visualization tool. The solution produced a compact Alteryx database file, a searchable workflow-based proof of concept ready for approval and launch, reduced processing time, improved error detection and increased customer satisfaction.

MSXI

Qin Lee

Business Analyst