Industry: Technology
Department: Business Intelligence
Use case: Reporting Automation
This story is about going from nothing to a corporate wide data pipeline and on-demand data delivery in less than 12 months. During the deployments this grew from 1 to 5 people that control the data of the company. The business impact is in almost all departments powering our Dashboards.
Deliver company wide trusted data to enable better business decisions. Eliminate or reduce the many manual processes across the company that take too long to accomplish and are prone to errors.
Integration and Automation
Business Enablement
Scaling and Accelerating Business Intelligence Adoption
In early 2016, Marketo launched Mavericks, our company data pipeline. A 100% cloud based solution, Mavericks pulls data from many sources, enriches the data using business rules and then published the data where it’s needed. Every week our production system has over 80 scheduled workflows and 30 gallery applications delivering the information that organizations rely on. Marketo uses off-the-shelf and custom API connections to integrate data the business needs.
Integrations include:
Workflows are mission critical to our business so we have developed a production process that enables us to identify issues before the business. Workflows are monitored by Tableau performance monitoring dashboards. These dashboards show trend of workflow behavior and highlight issues. We also have integrated Slack to both alert us to issues and allow the business to see when data is refreshed and more.
Marketo originally used Alteryx to publish information to our BI environment Tableau, however starting in early 2016 we went further with bidirectional system updates. With each implementation we moved away from manual to automated processes.
With the use of Marketo Alteryx Gallery, users can update data previously only able to be updated via tedious manual updates or via API only. Example workflows which have been added into our company’s gallery allow users perform the following types of tasks:
Using Alteryx to prepare information for our BI environment has benefited us in both scaling and accelerating our adoption. Here’s how:
Traditionally much of the BI data manipulation happens within the BI presentation layer. This includes blending data sources, creating calculated fields and complex level of detail solutions. We take a different approach. We use Alteryx to do the data prep including detailed data modeling. This approach minimizes the load on our BI Server allowing us to have more concurrent users than is typically expected. The costs avoided for 2017 and beyond look substantial.
Driving adoption with the business happens faster when the data is in the right model and has common definitions across the company. 80% of the work is data prep and this is all done in Alteryx. Instead of training the Business to become Tableau experts, we choose to focus on driving adoption. This means that we do not spend time on calculated fields, blending data and LOD with the business. We focus on shifting from manual Excel solutions to more insightful visual dashboards. Several people in the business were able to publish dashboards that changed the way people worked within days. Reconciliation of data has dramatically been reduced. For example Marketo use a single Opportunity data source for all dashboards.
Data is pulled from five Salesforce.com tables and blended together in grey boxes. Yellow boxes blend names, adjust times and create calculated fields. Green boxes convert currencies to USD. From the orange to the blue box data is blended with excel spreadsheets owned and updated by the business. The blue box adds a timestamp and the final yellow boxes publish to Tableau.
The combination of powering our company’s data pipeline, Mavericks, and providing on demand services with Gallery has allowed us to take control of our business’s data. It’s an awesome tool where the only limits are our time and creativity.
Our business partners are incredibly happy with the work we’ve done on our Alteryx server over the last year. Look for more results from us in 2017!
The impacts of Alteryx are wide. Here are some of the highlights.
Time saved as a result of automated integration and data blending using Alteryx is over 250 hours each month, conservatively. This is based on feedback from two departments that state have detailed their timesaving. With each new solutions we save more and more business process time.
Cost avoidance comes in the way of being able to scale Tableau by Alteryx doing the data processing.
Data Quality. Data is trusted across the company allowing people to focus on the business rather than ratifying numbers.