Reduces Business Intelligence Reporting Time and Headaches with Trifacta
Average savings per year on resourcing
Increase in productivity
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.
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.
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.
Autodesk makes software for people who make things. If you’ve ever driven a high-performance car, admired a towering skyscraper, used a smartphone, or watched a great film, chances are you’ve experienced what millions of Autodesk customers are doing with our software.
“With Trifacta and Snowflake we've created a new centralized data ecosystem that has cleaned up the way that we do analysis. Our reporting process has been reduced from hours to minutes and we are able to get deeper and more proactive insights from our data. For myself as an analyst, Trifacta has just decreased a lot of headaches.”
John GarnderSr Business Intelligence Analyst, Autodesk