>70%
reduction
in compute costs
500B
sentences searched
in under 6 hours
Data
processed in seconds
instead of hours
Challenge
Emerald Award 2022 Winner, Principal Financial Group (PFG), wanted to reduce the time and resources required to process thousands of financial documents daily. This meant slowly searching through text for specific words and phrases to deliver an accurate performance score for its clients.
Emerald Award 2022 Winner, Principal Financial Group (PFG), wanted to reduce the time and resources required to process thousands of financial documents daily. This meant slowly searching through text for specific words and phrases to deliver an accurate performance score for its clients.
Solution
Using Matillion ETL, PFG built a natural language engine to process massive amounts of unstructured data from multiple sources in parallel. It also integrated Matillion’s dynamic querying capabilities with Snowflake’s regular expression engine to reduce compute costs.
Using Matillion ETL, PFG built a natural language engine to process massive amounts of unstructured data from multiple sources in parallel. It also integrated Matillion’s dynamic querying capabilities with Snowflake’s regular expression engine to reduce compute costs.
Results
- With Matillion ETL, PFG has optimized its financial performance scoring process.
- It can now search approx. 500 billion sentences for more than 400 complex phrases in under 6 hours.
- Reduced compute costs by more than 70%.
- With Matillion ETL, PFG has optimized its financial performance scoring process.
- It can now search approx. 500 billion sentences for more than 400 complex phrases in under 6 hours.
- Reduced compute costs by more than 70%.
Matillion's concurrency and scalability allow us to process thousands of documents simultaneously, reducing the compute time from hours to seconds.Brody Vogel Data and Operations Research Scientist| Principal Financial Group
Featured Resources
Matillion earns 2023 Top Rated Award from TrustRadius
We are thrilled to be named a leader in data productivity by TrustRadius with a 2023 Top Rated Award for the fifth consecutive ...
BlogHow TUI Uses Snowflake and Matillion to Address an Analytic Information Gap
One of the world's leading tourism groups, the TUI group umbrella globally incorporates 1600 travel agencies, five airlines ...
Success StoryWestern Union
To support Western Union's customer-centric strategy, the data engineering team built a single source of truth for customer ...