What Everyone Should Know About Data Dumps

08/26/2015

Comments

These days, it seems like everybody has an easy-to-access place to hold all the digital information that’s important to them. No, not smart phones! We’re talking about the personal data dump.

It Starts With A Question

It all begins innocently enough: the end-user makes a request to pull a collection of data out of your enterprise resource planning (ERP) system to help answer some ad hoc questions, or provide information to outside sources.

Everything works splendidly, the data is provided in a spreadsheet. The end-user does a quick sort here, a little filter there, maybe a couple of computed columns derived from the original data to help make it easier to present. Questions are answered. The end-user is happy. Life is good!

Then It Happens

Weeks later, some less-than-desirable enrollment numbers get presented in a departmental meeting and someone asks, “Where did that come from?”

“Why, it came from our ERP system, of course.”

“Well, then it must be right!”

Not so fast!

Yes, the data originated from the ERP system, but that was weeks ago. Since then, thousands of students have registered, added or dropped classes, changed majors, applied for graduation, and generally acted like students.

What started innocently as a helpful way to answer questions can become a nightmare when the misperception spreads across campus that enrollment figures are dreadfully low! Will there be budget cuts?  Staff reductions? The sky is falling!

Beware The Shadow

This scenario demonstrates the risks of a well-intentioned data dump: Every data dump performed creates the potential for a “shadow” database to be born. Why should you worry about shadows?  Consider:

  • The “shadow” data is no longer sourced from the ERP system, the authoritative system of record for the institution.
  • The data was only good for that moment in time and was likely created for a specific purpose that may not be the same the next time someone pulls data from it.
  • Data dumps are often raw and unprocessed. Once the data is separated from the processes that put it in place, it can be manipulated, misinterpreted, misleading, or meaningless.
  • The data may include unmasked, personally identifiable information.
  • The data is no longer as secure as when it resided in the ERP system. It can now be transported easily via email or USB flash drive, or stored on a poorly secured laptop computer.

While there may be times when it is appropriate to provide a data dump in response to a simple question, care must be taken to ensure the data is used only for its specific purpose within the proper time frame, remains well secured, and is properly labeled.

The Proper Way to Present Data

How should requests for such personal data dumps be handled? It’s always preferable to rely on your enterprise reporting solution for accurate reports and dashboards from authoritative data sources, including but not limited to:

  • ERP System
  • Operational Data Store (ODS)
  • Enterprise Data Warehouse (EDW)
  • Institutional Data Mart

Use reports and dashboards to provide the right data at the right time and context, from the right source. By doing so, you can provide meaningful results that include:

  • appropriate data elements
  • accurate, verifiable and auditable data
  • relevance for the target audience
  • compliance with regulations and standards
  • consistency over time
  • documented report description and notes
  • adherence to institutional data standards
  • freedom from human intervention or manipulation
  • automatic delivery
  • flexibility to display or print graphically
  • ability to analyze using multidimensional online analytical processing (OLAP)

Ultimately, it’s about providing the best solutions for our end-users. We all want to provide solutions that can be presented with confidence. The next time a data request comes to you, what solution will you choose: data dump or enterprise reporting solution?

Mike is a Professional Services Consultant for Higher Education at Evisions. He has been with Evisions since March 2015, and is located in Las Vegas, Nevada. In addition to Banner implementation expertise, he is also a certified Project Management Professional. Mike has over 30 years of experience in Higher Education and has worked with a variety of reporting and analytics tools. He has a Bachelor’s Degree in Business Information Systems and Business Administration from Eastern New Mexico University.

Related Posts

Student-Centric Higher Education: Why the Urgency?

Student-Centric Higher Education: Why the Urgency?

Institutions of higher education were designed to aid young men and women in their transition from high school graduate to college student, helping them navigate along the way. Administrators would recruit, admit, enroll, guide and pretty much handhold these students...

Data Sources & Reporting Tools: More Isn’t Better

Data Sources & Reporting Tools: More Isn’t Better

Higher Education is becoming more competitive each and every year. One area that continues to provide a potential advantage to an institution is data – data provided via reports, with the purpose of enabling timely decisions that will bring the institution closer to...

Evisions CO-OP: Top 10 Most Viewed Argos DataBlocks

Evisions CO-OP: Top 10 Most Viewed Argos DataBlocks

The Evisions CO-OP User Community is a collaborative place where clients can share ideas, experiences, development, forms, DataBlocks, and reports with their peers. To give you an idea of what fellow Argos users are doing and looking at, we present the Top 10 Most...

2 Comments

2 Comments

  1. Howard Mitsovz

    Thank you for this information provided. It was very helpful.

    Reply
    • Mike Schmidt

      Thank you Howard!

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Share This
X