Monday, 6 May 2013

What is a Data Analyst? What do Data Analysts do?

I've had a bit of a trawl through the internet to see if I could find a concise description of what a data analyst is and what a data analyst does and it seems the internet is a bit lacking in this space so I thought my first dabble in the blogging world could be about this field which I've spent 7 years of my career in.

So what is a data analyst?
Well they are usually someone who comes from a stats or maths background and at a very minimum have strong skills in Excel. Typically they will have either good SQL or SAS experience or both, mainly in querying, extracting and manipulating data. They will have come across a variety of business intelligence and reporting tools in their career such as Cognos or Business Objects. In addition, if they have dabbled in modeling, they will have surely come across SPSS or SPSS Modeler.

What are the favourite file types of a data analyst?
Well that's a pipe delimited text file because it has the least error rate when converting text to columns using a delimeter. However, a data analyst will be comfortable in a variety of file types; text, csv, dat, xls and so on, and importing them into a database be that Excel, Access, SQL, SAS, SPSS or some other tool.

So what does a data analyst do?
They act as an intermediary between the business and the reporting/business intelligence/data warehousing team as someone with a high degree of flexibility to create ad hoc reporting, analysis and marketing list/campaign extraction. The role is important as it enables stakeholders to get fast and accurate data out of a business's data warehouse via someone who isn't bogged down in maintaining it.
They usually deal with senior stakeholders; gathering requirements and then fishing around the databases to answer these questions. They also deal with third party data, such as purchased contact lists, to do data matching (ie current customers) and to wash out records such as those on the Do Not Call Registers. Another role they perform within marketing is to provide campaign response analysis and dashboards for the various activities undertaken which aren't so easily provided by a business' data warehouse team.
In short, they become company data experts and the go-to-person within the company for any requirements out of the norm.

What is the sign of a good data analyst?
Well in short, really good analytical skills and the ability to access the necessary data (ie they know the various languages). However, the real differentiator between a good data analyst and a really good data analyst is their stakeholder management skills. It's a process of gathering requirements, providing feedback on the viability of those requirements, educating stakeholders on the data warehouse, coming up with timelines, delivering to those, adding value to the process, the list goes on. It's these skills that really make a difference within a business because it's where the business' data really comes to life through stakeholder engagement.

That's great but how does a business benefit from this type of role?
Well businesses generally collect a lot more data than they ever use in a meaningful way. Opening up a businesses data warehouse to stakeholders via a data analyst means that you have a coming together of data and ideas. Cognos has been attributed with opening up the data warehouse to everyone in the company and it does a really good job of that. Where a data analyst steps in is bringing the understanding of a data warehouse to everyone in the company - it creates that two-way conversation and makes it possible for people to really have confidence when trying to support their ideas in an evidenced based manner.
So in short, data analysts link ideas with data and that my friend is where you find opportunity.

4 comments:

  1. Amazing, I liked your subject as its really confusing for some of us as job seekers to differentiate between Database Analyst, Data Analyst, Business Analyst... Thanks again.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Dear Peter,
    This is a good detailed summary of data analysis jobs. I can say that I've analyzed data in .xls, .txt, .csv, and .sbdat formats. I've used alot of SAS, some SQL, but there is also R, JMP, MatLab, and SAP. Of course, it's hard to cover everything in seven paragraphs. But I appreciate your guidance with regard to business data analysis. My experience has been in health outcomes data analysis.

    ReplyDelete
  4. An extreamly useful summary. BRAVO!

    ReplyDelete