The Data Wrangler: Tips for Easy Data Preparation Part I

The Data Wrangler: Tips for Easy Data Preparation Part I

Posted on January 23, 2015 0 Comments

Product management organizations are often focused on markets and competition, but nothing is more satisfying—and arguably more important—than working with clients to see our products solving real business problems around data analysis. So I take a genuine interest in our customers struggling with data integration challenges, and I often spend hours with a customer making sure that they get the most value they can from Progress® Easyl™.

These customer use cases help me and my colleagues learn more about the real-world applications for Easyl, and we often discover tips that can help other customers. Let me share one of these with you today.

Data Blending from Different Data Sources

I recently worked with a Progress® OpenEdge® customer to help them create analytical reports using Easyl. One thing you quickly discover is that normalized databases aren’t exactly optimized for reporting. So you often have to de-normalize the data, creating views that simplify the reporting process itself, while making it easier to mine, analyze and visualize the resulting data.

Easyl has some great ways to do this. For example, you can create “virtual” data set relationships that join data across tables—even if those tables are in completely different data sources, like an OpenEdge application and Salesforce.com. By joining these tables in the cloud, Easyl enables you to enhance the data in one table with data in a second table.

Easyl Templates to Build Blended Reports

As a practical example, I used Easyl to access the Customer table of an ERP system, which contains basic contact information about each customer account. Then I created a relationship (which is stored in Easyl as part of my “blending template”) between the Customer table and related customer account records in my Salesforce.com Accounts table. As a result, I am now able to augment the Customer table of the ERP system with data from Salesforce—in this case Annual Revenue, Number of Employees, and Website.

This “virtual view” across disparate data sources illustrates just how easy it is to build blended reports when you have the right tools! The following image shows you the customizable template I created.

Progress Easyl screenshot

Progress Easyl includes templates that can be customized for easy, fast reporting.

Stay Tuned for More in this Series

You’ll want to stay tuned to this blog from Rich for more installments in this new series, filled with insider tips on how to do data prep, data cleansing and data analysis easier and faster.

Rich has years of experience leading consulting engagements for Fortune 1000 clients that include Cisco, Microsoft, Seagate, and McKesson, and is an alum of PeopleSoft, Oracle, and Informix. Most recently, Rich was nominated by President Barack Obama to serve on the Internal Revenue Service Oversight Board.  Read the full announcement here: White House Announces More Key Administration Posts.

Learn more about Easyl now.

Or go ahead and get started now with a trial download of Progress Easyl.

Make sure you also check out Part II and Part III of my Data Wrangler series.

Rich Julius

Rich is the Principal Product Manager for Progress Easyl, a cloud-based data integration and blending tool that enables you to create reporting data sets and data marts “on-the-fly” quickly and easily. Rich has spent two decades working with data-driven applications and marketing automation, and served in senior management roles at a number of Silicon Valley companies before settling in North Carolina. Rich has led consulting engagements for Fortune 1000 clients including Cisco, Microsoft, Seagate and McKesson, and is an alum of PeopleSoft, Oracle, and Informix. Rich was nominated in 2015 by President Barack Obama to serve on the Internal Revenue Service Oversight Board.

Comments

Comments are disabled in preview mode.
Topics

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation