Trifacta wins the Best Data-Driven SaaS Product award at the 2021 Annual Cloud & SaaS Awards

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
 

Reduces Business Intelligence Reporting Time and Headaches with Trifacta

 

210 K

Average savings per year on resourcing

3 X

Increase in productivity

66 %

Faster reporting
 

Core Challenges:

The Market Intelligence team was tasked with creating a 360 degree view of all of Autodesk’s construction customers that do not own their construction processing tool, so the company could proactively create upsell opportunities. Combining separate data sources with various BI access points and large data sets using SQL and MS Excel resulted in lengthy, unstable processes. Because all of the prep work was all being done manually with legacy platforms, it was impossible to report live updates and each iteration for an individual report took at least 3 hours.

 

How Trifacta Solved this Problem:

Autodesk built a modernized data ecosystem that included AWS for staging and storage, Snowflake as a centralized data warehouse, Trifacta for data preparation and automation and Power BI for visual analytics. This data stack created a simple, streamlined and dynamic workflow. With the data in a centralized location, analysts at Autodesk could use Trifacta to easily join and transform data from various sources and the automate the pipeline to BI dashboards. This provided their internal customers with real-time insights. If modifications were necessary, analysts could easily update Trifacta’s recipes within minutes to adjust for any changes.

 

Benefits

Faster Reporting

With Trifacta, Autodesk was able to automate the data workflows, which would take a week or two every quarter to updated the business rules with legacy systems.

Project Scalability

The Market Intelligence team is able to maintain the same project completion rate with 1 analyst as they were with 4 analysts previously.

Deeper & Proactive Insights

Analyst bandwidth has been freed up to focus on deeper insights allowing the field team to drive more revenue.