MindMax Achieves a Perfect Data Pipeline in the Face of Complex Data Sources
MindMax partners with universities to increase enrollment, particularly among continuing education and adult learners. Partner universities benefit from data-driven insights that inform optimization of traffic and lead generation, empower administrators to maximize and manage enrollment, and guide potential students through the application and registration process.
Brian DiScipio, VP of Technology, and Kiersten Warendorf, Senior Business Analyst, knew that scaling the MindMax customer base would hinge on the full automation of BI and ETL through the creation of a modern data pipeline and stack. The move away from manual data extraction was a top priority. With Sisense and Fivetran, MindMax was able to automate its ETL process and connect all of its data sources to craft a single source of truth—fueling its unrelenting commitment to customer satisfaction and actionable, data-driven insights at every step of the enrollment funnel.
The Challenge: Analytics and ETL—Fully Automated
To demonstrate value to potential customers, MindMax must measure and track processes from the top of the funnel to enrollment. Its legacy analytics & BI solution required manual extraction of data from disparate sources, including Salesforce, Google Analytics, Facebook Ads, LinkedIn, and Marketing Automation systems —and a manual data mashup in Excel.
“It was really difficult to create reports and dashboards that were both meaningful to clients and incorporated data from all these different sources of information,” says DiScipio. DiScipio and Warendorf knew there had to be a cleaner, faster way to empower their customers with data-driven insights.
The Search is On
Warendorf quickly approved the addition of the Sisense Data and Analytics Platform. “Sisense gave me the ability to pull in data from different sources, manipulate all of that data in one place, and present it simply in one chart or graph,” she says. “It’s really cool and powerful.”
MindMax chose Sisense not only for its functionality but also for its price point and ability to serve multiple clients through white-labeled embedded analytics in its web portal. With Sisense, MindMax was covered on the BI front. But for MindMax’s complex data pipeline, an even wider variety of data connectors would be necessary to completely automate the ETL process. Partnership with an industry leader in automated data-connectors was necessary to bring MindMax’s full data picture into focus.
A Single Source of Truth Achieved with Sisense and Fivetran
Fivetran is a preferred Sisense platform partner and adopted by joint customers for simplifying data connectivity to high-performance data warehouses. Setting up Fivetran and Google BigQuery was quick and easy, and it instantly freed up a tremendous amount of Warendorf’s time, which she could dedicate to conducting analyses and generating insights. “Bringing Fivetran on was life-changing for me and my job,” she says. “Trying to figure out why ETL was breaking down, how to fix it, and how to bring historical data through was frustrating. The difference now is night and day.”
Fivetran brought all of MindMax’s data into one location, Google BigQuery, and the MindMax team used Sisense to create dashboards and analytics using this data. Warendorf finds that the products are well integrated and that the Fivetran and Sisense teams work well together.
With the joint Sisense-Fivetran solution, we’ve freed up 50% of our time—and MindMax and its customers are finally empowered by insights gleaned from clean, consistent data across the data pipeline.
With the joint Sisense-Fivetran solution, DiScipio and Warendorf have freed up 50% of their time—and MindMax and its customers are finally empowered by insights gleaned from clean, consistent data across the data pipeline. In addition to Salesforce, Google Analytics, and Marketing Automation systems the company is adding social platforms and student information systems as data sources. Colleges and universities use varying software systems and technologies, so the ability to ingest student information as part of the data set provides a huge advantage.
With Sisense and Fivetran, both internal teams and customers can nurture a more data-driven culture. Internally, half of MindMax employees are actively using Sisense across multiple departments, including marketing and project managers. But empowering customers with insights is where MindMax truly shines. Today, team members can easily pull data for each customer, display actionable insights in a meaningful way, and keep data private across customer accounts. Some customers even have access to their own customized dashboards powered by real-time analysis—with this initiative set to expand into 2019 and beyond.