Hiring a reports analyst

Topic Views - 3472

Workforce Planning Regional Manager

Betclic


Hello,

I’m in the process of hiring a reports analyst for a growing WFP department. I have some very promising CV's but feel we need to test the technical abilities of the applicants as part of the recruitment process. However the capabilities of me and my current team is below what we are looking to hire so I worry that any tests we come up with will be far too easy and not actually give us any idea of who's the most capable.

Are there generic tests/websites that have advanced excel and reporting tests available? If not has anyone any advice on how I should proceed. In the UK I would have used certain specialist agencies but I am now based abroad (Malta) and there is no scope for using foreign agencies (and these kind of positions just do not exist in Maltese agencies)

Thanks in advance for any feedback


CSI Coordinator

Enterprise Rent A Car


Hey Luke

I am assuming that the position will be looking at forecasting, scheduling that kind of thing.

If so I spoke to our Resource Planning Department and asked the same question, they basically said they would ask them several questions to determine knowledge, such as what is a service level, why is it important, what is the industry average service level.

Then throw in some scenario based questions which can be based on actual events, such as ok your service level is 88% but half an hour ago it was 66% would you send people home?

That way you can gauge their understanding of the role and how they deal with situations that are important to you.

Hope that helps.

Joe


Workforce Planning Regional Manager

Betclic


Hi Joe,

Thanks for the response but perhaps I should have been clearer, it’s not a WFP type position I am looking to fill-I already have capable people doing these kinds of roles. It’s a role that is responsible for the reports we produce, so the tracking of performance and productivity, KPI’s etc.

We cover about 15 different languages and markets and each one has a set of daily reports, which at the moment are all collated and formatted manually on excel-this takes hours and hours a day so I want someone experienced thsat can come in and help us refine our reporting process’s and cut out a lot of the manual admin side of it. The role I’m looking to fill is also referred to as an MI analyst.

But like I said thanks for the response anyway...if you have any further feedback please let me know

Cheers

Luke


CSI Coordinator

Enterprise Rent A Car


Hey Luke

Ah ok your right that is a fair more specialized area of expertize.

So would the role involve taking the raw data you produce, create pivot tables and vlookups to produce the desired results quicker that kind of thing?

Joe


Planning & Control


Hmmm that sounds like a good conundrum.

If you are looking to hire someone with skills you won't recognise, you either need to test what they are capable of (and this will be tricky, since you might not recognise the best solution) or perhaps see how quickly they can solve a series of medium difficulty problem.

As an example if there is a report that you currently do, that takes an hour, look for someone who can do it in 10 minutes. This will allow you to establish their skills to a point. Normally if someone has high skills, they will be fast using the more basic of those skills.

Alternatively if you want to test their creative skills a little more, you could take perhaps 4 existing reports and consolidate them into a single screen/page report, highlighting info which they feel is important. This is the approach I personally would take, as there is no point having someone who can run reports in no time, and have a high skill set, if they lack the analysis skills to identify the points of interest.


Workforce Planning Regional Manager

Betclic


Hi Joe,

Yes that's much more like what we do currently and need to improve on-we do an alright job at the moment, we produce the reports we need to but it takes a huge amount of resource. So ideally I’m after proficiency tests for an experienced MI analyst

Luke


Partner

Scintella Solutions


Hi Luke,

I think that you would do better writing a requirements document, and have put that out to tender with some web developer organizations. From the complexity that you describe you need a fairly robust database and with what sounds like loads of clients in different places access to the data might be much easier to accomplish via web based solution. This solution may be a lot less expensive than hiring an employee whom you may find difficult to manage as you don't have the technical experience to get the best out of him or her. You should look for some one with php and MySQL development experience. If you get stuck I may be able to recommend some people to you.


We're you able to g...
We're you able to get some test data and what kinds of test questions did you utilize. Interested as I have to go through the same. Appreciate details.
Cheers

Helper

Call Centre Helper

Pivot Tables
If you are looking at Excel competence, how about giving them two tables of data that they have to join together for example with VLOOKUP and run a pivot table on.

Then ask them to show the data in a bar chart or graph. Give them limited time, (perhaps no more than an hour, so that you get a good idea of the competences.

advance excel
For report analysis there is much knowledge about advance excel . as there number of type scenario in data analysis .

Want to add a comment?

Not found what you were looking for?

1. Try searching through our site.
2. Still not got an answer?

Why not ask the Call Centre Helper Community? Click here to ask your question