Services & Solutions: Alteryx Server Usage Reporting

Jul 11 / Data Prep U (Michael Fratoni)
Drive Better Decisions with Alteryx Server Usage Reporting

Is your company leveraging Alteryx Server, and are you responsible for managing its success across various departments? With multiple Alteryx Designer licenses being used for data analysis, you need metrics to quantify success and a way to present this information effectively.

How can you obtain this crucial information?

The answer lies in exploring the depths of your Alteryx Server. All server data—including users, workflows, schedules, and results—is stored in a MongoDB database. Fortunately, Alteryx provides a couple of methods to access this data: through an ODBC connection or the deprecated Mongo Input Tool. The database is comprised of three parts, but the most useful information is found in the AlteryxGallery and AlteryxService databases. Once connected, understanding the schema (available here: Mongo Schema) is the next step.

With Alteryx, you can blend this data to create a clean, comprehensive table that can be visualized on Tableau or Power BI to showcase your team's server usage and analytics achievements.

Below, you will find a sample dashboard and a success story of how Data Prep U utilized this exact strategy.
Sample Tableau Dashboard illustrating Alteryx Server usage metrics and user activity.
Success Story: Internal Audit to Evaluate Spend and Efficiency

An accounting firm, handling vast amounts of data, invested in Alteryx Server to streamline its processes. As their license agreement neared renewal, they sought to understand the server's usage and the tool's utilization by their users to ensure smart spending and continued growth.

The Solution:

Data Prep U accessed the underlying MongoDB database of the Alteryx Server, parsing, blending, and joining various tables to present a clear picture of the server's utilization. By leveraging Alteryx for analytics, we ensured that the information was regularly updated.

A comprehensive Tableau dashboard was developed to visually present the gathered data, enabling decision-makers to easily interpret server usage metrics and user activity. This dashboard provided a clear, actionable view of the server's performance and user engagement.

To streamline the entire process, Alteryx workflows were scheduled to automatically gather and refresh the data. These automated workflows ensured that the dashboard always displayed the most up-to-date information without requiring manual intervention, making the process efficient and reliable.

Want To Learn More or Need Help?  Connect with Us!

We've been using Alteryx for many, many years, and we're here committed to delivering solutions and education that drive real-world impact. Reach out for assistance, and let's explore what we can achieve together.
Discover How We Can Transform Your Operations

At Data Prep U, our many years of experience across all industries have equipped us with the expertise to handle projects of any scale. Whether through education or strategic solutions, our work in the data analytics space is designed to deliver real-world impact.

Interested in elevating your analytics capabilities or learning more about our engagements? Schedule a time with us through our Microsoft Bookings Link to explore tailor-made solutions that can drive your business forward. Together, we can achieve extraordinary results.

Reach Out and Let's Get Started:
📧 Email: [email protected]
🔗 LinkedIn: Data Prep U
📅 Schedule a Meeting: Microsoft Bookings Link

Don't miss our next monthly post for more insights into how we're making a difference in the analytics landscape! 🚀