SSSVEDA DAY 7 – Every Team Needs Someone Who Understands Data

Oz has dedicated this episode to explaining the importance of ‘understanding data’. It is different from ‘doing data’ or ‘following instructions’.

Let’s get to it.

1 – What’s What

Following instructions is a mindless task. And often, in face of exceptions, it is improbable the set of instructions would cover them.

Doing data is about truly being engaged with data and with the tools that help with cleanse and analyze it. This involves understanding data generation processes, e.g. knowing where are the weak spots in them and how the analysis would need to be adjusted.

Understanding data falls in the middle. It revolves around an understanding of the business and its processes. People who understand data may not know about pivot tables or database queries, but they would know about the reports available. They would know about the business rules and how everything fits together. Most importantly, they would know what report can be trusted for what data.

2 – Why You Need Someone Who Understands Data

When Oz works for an organization, he goes as an outsider to develop solutions. Partnership with someone inside the organization who understands data helps get work done much more efficiently. Someone who understands data can anticipate the questions Oz might ask and would be able to warn about the credibility of certain sources.

This means that Oz would not have to analyze the processes end-to-end himself to understand data quality. This also means the solutions developed need not be complex.

3 – Why the Company Needs Someone Who Understands Data

Even if a company subscribes to a third party to provide some reports, these reports tend of focus on very specific aspects of the business. Then, when the company want something else, these third parties either can’t do it or will charge an exorbitant sum for it. But, if the company has people who understand data, then all they need is some data analysts to turn these already existing reports into a solution.

4 – Final Advice

Today, everything is data: sales, website visits, inventory levels, staffing. And playing with data is like playing with fire. Someone who understands data can help control this fire.

What’s next?

Share write your thoughts with us in the comments section below. And keep that data clean!

Also… Check Out Oz on Youtube

Jamani Arsalan


You may also like

April 9, 2011

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

October 26, 2014

Monte Carlo Simulation Formula in Excel – Tutorial and Download

September 17, 2012

The Excel Rollover Mini FAQ
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.