Reduces Business Intelligence Reporting Time and Headaches with Designer Cloud powered by 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, Designer Cloud powered by 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 Designer Cloud 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 Designer Cloud recipes within minutes to adjust for any changes.
Benefits
Faster Reporting
With Designer Cloud powered by 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.