Skip to content

Introducing Streamlit in Snowflake and Snowflake Cortex to Analyze FactSet Shipping Data

  • July 12, 2024

Return to Resources

As geo-political tensions rise in the Middle East, and damage to infrastructure impacts the Port of Baltimore, identifying sector-level exposure to specific ports and geographic locations has never been more important for risk measurement.  Don't miss our latest webinar where we dive deeper into these topics and demonstrate how to leverage these insights for your business. Watch now and stay ahead of the curve!

In this Blog, we’ll explore challenges with analyzing Shipping data, FactSet’s Unique Data Catalog and Connected Data model, Leveraging Snowflake’s Technologies for Insights, Accessing Continuus Cargo Shipping App, Powered by FactSet, and how to Take Your Analysis Further. 

 

FactSet’s Unique Data and Connected Data Model

FactSet has a vast catalog of data, ranging from Core Fundamentals and Estimates to Unique Supply Chain and ESG data, to Unstructured Earnings Transcripts and Filings, and much more. Underpinning all of FactSet’s Standard Datafeeds is a single unified symbology that helps organize security reference data, and a hierarchy of ownership as a permanent foundation across time, allowing to link in any content at any level of that hierarchy.  

In the Continuus Cargo Shipping App, Powered by FactSet, we used FactSet Shipping and Revere Business Industry Classification System (RBICS).  

FactSet Shipping represents US Custom’s Maritime Cargo Transactions. It tracks all imports coming into the United States, regardless of where it originates. It links the Shipper and the Consignees. The Bills of Lading contain Cargo Manifests, details of the ship, capacity, and quantities. 

ShippingApp_ShippingCargo_1

FactSet RBICS is a taxonomy to analyze products and services in a multi-sector taxonomy. Most sector classifications are linear, however, RBICS is designed bottoms up, based on what companies sell, and has an expansive view of a company’s lines of business.  

Using FactSet Shipping and RBICS data, we created compelling views for analysts to get a better picture of what sector and industry exposure is represented at specific US Ports.  

ShippingApp_PortSelection

Leveraging Snowflake Cortex LLM Functions for Enhanced Insights

With our App, Firms now have a starting point where they can find sectors and industries connected to cargo shipments passing through specific ports and regions. Shipping manifest descriptions are mapped to industry networks using Snowflake Cortex LLM functions and linked to shippers and consignees to allow firms to easily identify shipping risks and exposures. Integrating text data with normalized sector and industry codes would be incredibly challenging without this technology. Leveraging our Streamlit App will enable businesses to simplify their analysis, inform business decisions, and drive innovations by creating compelling visualizations of maritime shipping transactions from bills of lading.  

ShippingApp_ShippingCargo_2

How to Access Continuus Cargo Shipping Application  

You can access the Continuus Cargo Shipping App, Powered by FactSet on the Snowflake Marketplace: 
Continuus Technologies: Continuus Cargo Shipping Application (snowflake.com)

The App is free to download. Access to FactSet Shipping and FactSet RBICS is required, purchased separately.  

 

Taking Analysis a Step Further  

If you’d like to take this analysis a step further with additional geographical locations, views, and links with other data, please contact Continuus. Our teams of data engineers are eager to assist with add-on projects and modifications as additional professional services Our teams of industry professionals are very familiar with financial analysis and can help you and your teams build compelling SQL views to further your analysis and data evaluations.

Data Governance: A Necessity in Modern Asset Management

Twenty-five years ago, data governance was not something top of mind for financial firms. The world of data was much...

by Colleen Avallone