0
$\begingroup$

I work in a professional services company and would like to get some analytics on how discipline the fee earners post their times to the system may have an impact to the revenue.

One area that I am thinking of is to see if there is a correlation between how late the time entry is posted after the work was done and whether that time entry is being written off (i.e. does not make it to the bill to the client).

Is this a reasonable thing to analyse? If so, what technique should I be looking at to analyse this, e.g. correlation, regression, clustering, etc?

If there are other things that I can analyse as well, please let me know.

I am quite new to this data analytics/mining/science so please guide me. I have some understanding of R language which will be my primary language in analysing the data (and SQL to get the data).

Thank you.

Improve this question
$\endgroup$

1 Answer 1

Reset to default
0
$\begingroup$

If you visualize the lateness of time posting over the revenue, you will see the clear picture and understand the correlation.

What you need is to create the corresponding columns in your tables.

Improve this answer
$\endgroup$
3
  • $\begingroup$ Thanks. What visualzation is appropriate for this kind of analysis? $\endgroup$
    – iKnowNothing
    Commented Jul 15, 2018 at 6:46
  • $\begingroup$ Start with a simple scatter plot, x=lateness, y=revenue. $\endgroup$
    – Timur
    Commented Jul 15, 2018 at 7:15
  • $\begingroup$ Thanks. If I want to answer the question "what is the relationship between the lateness of time posting and the probability of the time will get written off", what technique should I use? Is it Binomial Distribution or something else? $\endgroup$
    – iKnowNothing
    Commented Jul 18, 2018 at 6:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.