Другое: Составить отчет по нужным параметрам (Exel) на англ языке

You’ve got a list of deployments and a schedule of Professional Services (PS) revenue recognition. Create a report showing volume of PS bookings (deferred revenue additions), revenue and third-party costs in the following perspectives:

1)by region of deployment (i.e. region of a client);
2)by in-house implementation and outsourced deployments;
3)by 5 main groups of deployment packages – Jump Start, Small, Medium, Large and Custom Deployment.


Extra task:

You have information about customers' MRR, which represents the dollar amount a client pays for a month of subscription usage. Using all the data provided calculate the Professional Services attach rate, i.e. the portion of deployment price in the whole deal volume. Keep in mind that generally (~ 80% of accounts) our clients buy annual subscriptions.



---------------------------------------

Note 1: to define a region for deployments ran by outsourced partners use a region of sales representative who sold a deployment, or any relevant data given.

Note 2: while closing January 2018 PS revenue an accountant got information from a PS manager that some deployments previously reported as Large were in fact Custom. You are preparing analytical source of truth both for FP&A and PS departments.