F1000 Logistics Real Estate Leader Turns to Sigma to Ensure Compliance

• 分析与建模 - 预测分析
• 应用基础设施与中间件 - 数据可视化
• 功能应用 - 企业资源规划系统 (ERP)

• 云规划/设计/实施服务
• 数据科学服务
• 系统集成

The accounting team of a leading logistics real estate company faced significant challenges in conducting bad debt ratio analysis and ensuring compliance due to the limitations of their existing data visualization tool, Tableau. The tool would crash when filtering the general ledger (GL) data, which contained over 500 million rows, causing delays in report generation. Additionally, the team needed simultaneous access to transaction-level data, but had to extract data from Snowflake and use multiple Excel worksheets for analysis, leading to version control issues, security risks, and compliance concerns. The company estimated that these inefficiencies were costing them between $2.4M and $3.6M per year.

The customer is a leading logistics real estate company in the United States, responsible for managing a significant portion of the country's GDP through its warehouses. In 2020, 6.3% of the U.S. GDP flowed through the company's warehouses, generating $4.4 billion in revenue. The company handles a massive amount of data, with its general ledger alone containing more than 500 million rows. The accounting team plays a crucial role in conducting bad debt ratio analysis and ensuring compliance, which is vital for the company's financial health and regulatory adherence.

The company turned to Sigma, a cloud-native data analytics platform purpose-built for Snowflake and cloud data warehouses. Sigma provided the accounting team with direct access to live, governed data in Snowflake, eliminating the need for risky data extracts and ensuring everyone worked with the same current data. Sigma's unlimited scale and speed allowed the team to generate the GL report in just two minutes, significantly reducing the time required for compliance reviews. The platform's spreadsheet interface made it easy for the team to explore and analyze millions of rows of transaction data, enabling them to quickly address potential compliance issues. The solution also facilitated real-time monitoring of financial positions and seamless sharing of insights with other teams.

• The accounting team now has a dashboard that shows the financial position of local books, allowing them to monitor issues in real time.
• Direct access to live, governed data in Snowflake ensures that everyone is always working with the same current data, eliminating data sprawl and conflicting insights.
• Sigma's cloud-native solution delivers unlimited scale and speed, enabling the team to generate the GL report in just two minutes.

• The company estimated that the wasted time and resources were costing them between $2.4M and $3.6M per year.