overview
When it comes to data preparation, data professionals are often bottlenecked, investing significant time and resources on repetitive normalization and transformation tasks.
Crux Wrangle is a data engineering offering that allows clients to customize and transform their data pipelines, all in a managed service with 24x7 operational oversight.
Enables you to:
-
Ingest analytics-ready data faster
-
Work with subsets of your data across any dimension
-
Combine data together for broader analysis
-
Implement your data preparation requirements without the need to configure functions, pipelines, or complex operational processes
-
Access your data pipelines via any Crux Deliver, including API, cloud platforms, Snowflake, and Python
Data Wrangling Capabilities
Crux Wrangle provides data transformation functions beyond our standard pipelines, so that data can be customized and transformed, exactly the way you want it.
Format
Change data types, change and sanitize column names, normalize number values and format dates.
Fill
Replace missing values with value-based logic.
Calculate
Create user-defined and calculated fields, and convert numerical values or anonymize sensitive data.
Combine
Join data within and across datasets, add lookup data, map attributes, align history and ongoing data.
Filter
Split data based on a particular group of interest, drop rows, columns, duplicate or missing values.
Reshape
Unpivot from wide to long, pivot by a given index or column value, sort values and transpose rows and columns.
Unified Data Engineering Approach
Crux Wrangle is a key component of Crux’s data ecosystem, which includes 24/7 monitoring, change management, and secure access. Your customized datasets can be made available through a multitude of delivery destinations via Crux Deliver, including cloud platforms and API, or you can have Crux host the storage for you via Crux Query.
“We’ve been using Crux for almost two years now and are happy with the company’s ability to meet our high standards. We consume a large number of datasets from a wide range of sources through Crux, which simplifies our ingestion and operational burden dramatically, allowing us to focus our team on higher-value and more differentiated activities. We are impressed by Crux’s customer focus, service level, data inventory and the continual acceleration we see in dataset onboarding.”
“We are extremely excited to be embarking on this innovative partnership with Crux, a new breed of technology vendor. This partnership will enable us to access wider markets, removing the complicated extraction, transformation and load process detail to provide buy-side firms access to the highest quality of data available free of integration and management headaches.”
“We are increasingly seeing the need for efficient and flexible data delivery and support in our customers data ingestion processes. Allowing Crux to streamline our data delivery to clients has helped MSCI focus on improving our core product and increase operational efficiency in today's cost pressure environment.”
“We are pleased to bring our FX Market Data to the broader consumer market, enabling academic, commercial and financial institutions that are not part of our ECN to now benefit from our datasets. Our agreement with Crux enables us connect with our customers on a reliable, easy-to-use and secure platform.”
Why Crux?
Focus on extracting unique value from data by offloading time-consuming data delivery and operations work to Crux.
Central data hub with integrations to popular cloud platforms
Activate data pipelines to access 14k datasets from 140+ Data Suppliers
Secure, ready-made infrastructure with immediate onboarding
Reliable with 24/7 operations and support team
Customizable platform and services to meet end use case needs