You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.
In most projects, we leverage .yxdb files stored on the disk on the Alteryx server. But when a project calls for very granular reporting on large datasets, Calgary files can be used to speed up performance, allow for more granular reporting, and leverage macros in Alteryx, which broaden reporting capabilities.
Rather than reading large data into your workflow and then filtering it out, Calgary files allow you to only read the relevant records of data.
Our client had weekly sets of sales data, each containing hundreds of millions of rows from thousands of stores across the timeframe of two years. Their existing ecosystem was in Alteryx gallery but transfer over the internet or intranet remained a huge bottleneck in the company’s workflows. They were handling 1B+ rows of data!
Because of their reporting requirements, there were no opportunities to aggregate data in .yxdb format since the company wanted to slice it by every dimension. In flat-file format, these reports would take a couple of hours to complete. Using Calgary files, the same reports only take thirty seconds to a minute to complete.
Prior to the reporting layer, we implemented some pre-processing workflows to create these Calgary databases. These Calgary database files are fed into the workflow using the Calgary Join tool.
This tool takes an input file and performs joins against a Calgary database where an input record matches a Calgary database record based on user-defined join criteria.
We then used an extract macro to pass in filters and only scan data that are required, rather than reading in all data and then filtering down in workflow.
Calgary macro has its own filters that can be controlled by user selection. Being able to control the query streamlines the process. The workflow runs faster, as the macro gets rid of extraneous fields and allows end-users to focus only on necessary fields.
Reporting with Calgary files is comprehensive and intuitive. Unlimited filtering capabilities and historical data access are available reporting capabilities.
These capabilities when combined with reporting, geo-spatial, or other Alteryx components can provide powerful analytic functions on large data volumes much faster than traditional workflows.
Have a similar project? Chat with us today!
Stay updated on the latest articles, events, and more
Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.
Press release
The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader.
Webinar
In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.
Webinar
The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.
Event
Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit
Press release
Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.
Webinar
Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)
Webinar
Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.
Success story
C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.
Success story
Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.
Success story
Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.