F1000 Logistics Real Estate Leader Turns to Sigma to Ensure Compliance
Company Size
1,000+
Region
- America
Country
- United States
Product
- Sigma
- Snowflake
- Tableau
Tech Stack
- Cloud Data Warehouses
- Data Dashboards
- Spreadsheet Interface
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Customer Satisfaction
- Digital Expertise
- Productivity Improvements
Technology Category
- Analytics & Modeling - Predictive Analytics
- Application Infrastructure & Middleware - Data Visualization
- Functional Applications - Enterprise Resource Planning Systems (ERP)
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
- System Integration
About The Customer
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 Challenge
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 Solution
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.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
