The Solution | Alteryx Analytics Application

The goal for this project was first to understand the business needs. We had to consider any legal obligations, business logic, platform access, and the best software to develop an automated tool to be utilized by the U.S. Department of Transportation for their official audit. We decided to use Alteryx due to its ability to integrate relational and non-relational data and build complex data models that can be automated and deployed to a front-end visual tool that end-users can easily access.

We integrated data from, SalesForce, Teradata, Oracle, SQL Server 2008 R2, and SAP using Alteryx. We conducted a rigorous data normalization process aligning and applying logic business logic across data extracted from all platforms. One of the hurdles we faced while developing this application was language conversion. How would we convert foreign languages without disrupting the risk of a security breach using third-party software? We used the translator macro within Alteryx.

Once this process was complete, we compiled all data elements and began that data visualization process. Developing a reporting tool in Alteryx with the complex data models we used was not the most straightforward task. In addition, the reports had to be in a letter format which is much different from other reporting objectives.

We used an incredibly complex data model to input data in text fields based on cascading parameters. We used Delta’s pre-developed branding guidelines to design the overall reporting structure and deployed it to Alteryx Gallery for testing. We completed the application functional development and awaited approval from Delta’s team. Once approved, we conducted a thorough training for Delta’s corporate Business Intelligence (BI) team and field team leads. This application is still currently being used for audits and field crew.