manual data

On Manual Process & Reporting

Data automation has been popular business buzzword jargon as of late, and to some extent, rightfully so! It saves time, creates seamless integration between applications, and can provide always-on, real-time information for making appropriate decisions. But data is only as good as the story it tells, and automation often hinders the storytellers that it aims to serve. Until machine learning surpasses human capabilities, there are key aspects of manual, hands-on project management that can't be effectively replaced by automation (though I'm sure some will try).

Un-Automate Your Data

Let's step back and talk about Metal Toad's project managers and the project status snapshot. Once a week, the team goes through and updates a simple high-level spreadsheet with each project's pertinent data that our leadership team cares about. They supplement that with a short narrative-form email highlighting each project's health. The goal is that the task of updating the snapshot itself is quick and doesn't feel like too much of a grind, though there may be some work involved coming up with the information to populate the snapshot. Our PMs are busy people, so time spent compiling reports needs to be truly valuable. This seems like the perfect situation for some data automation, right? Pull some budget data from our time tracking tool, check our client satisfaction app for unhappy customers, integrate Jira and Trello for backlog sizing and velocity, and spit it all out with the push of a button...

Check Your Work

Yet the project snapshot remains a very intentional manual labor of love for two primary reasons. One is that the data presented to leadership may look the same, but the context behind the numbers can only be fully understood and the narrative effectively communicated when the process of reporting is completed with some old-fashioned brainpower. The other reason is that through the manual compilation of project data, each project manager is forced to double-check their team's work and examine the fidelity of their data. It's a great exercise in proactive project management and preemtive risk identification rather than the burnout-inducing practice of relying on PM firefighting mode, and it triggers actions like sending invoices, checking in with clients on their satisfaction, updating burndown charts, creating budget projections, completing stage gates, and other basic practices that are essential to agency health.

Context is king in communication, and the only way to create context is to understand the data you're communicating. The best way to fully understand that data is to do the work of compiling it yourself!

Date posted: December 16, 2014

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <cpp>, <java>, <php>. The supported tag styles are: <foo>, [foo].
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.

Metal Toad is an Advanced AWS Consulting Partner. Learn more about our AWS Managed Services

About the Author

Adam Edgerton, Alumni

As the Director of Project Management & Operations, Adam leads Metal Toad's operations and project management teams. That means he's involved with day-to-day operations, big-picture planning and operational projects, company process, managing/mentoring/leading project managers, organization-wide resourcing, and parts of just about every other facet of the business. Previously over several years of project management roles at the Toad, he worked with a number of industry leading-organizations including the Linux Foundation, DC Comics, FEARnet, KEEN footwear, PBS, ABC, Technicolor, and the Philadelphia Philharmonic Orchestra.

When not hard at work at Metal Toad, Adam enjoys cycling, climbing mountains and rocks, hiking, backpacking, running, and generally being active outdoors. With the small bits of time left after work, cycling, and various outdoor adventures, his other hobbies include cooking, traveling, photography, reading and writing, learning new web languages, watching movies, and enjoying music. He's also the founder of PDX Digital PM, Portland's meetup group for digital project managers and producers.

Adam grew up in Alaska and came to Oregon for college. He graduated with double-honors from the University of Oregon with a degree in Business Administration and a concentration in Marketing. After graduation, he spent 6 months working with an event marketing agency traveling the country to marathons and triathlons and explored 44 states in the process, but Oregon still came out on top of his list of places to live, and he is happy to call Portland home.

Have questions?