Revenue Reporting

Lukket Opslået Oct 11, 2007 Betalt ved levering
Lukket Betalt ved levering

Please reference the sample tables and queries provided:

+ ispCustomer: where all the standard customer data is located.

+ ispService: where all the standard service data is located.

+ vw_ispCustomerServiceRateMapRateRateItemSpons: where all the standard service type list pricing is located.

+ vw_ispCustomerContactServiceContractSponsorID: where all the standard service type contract override pricing is located.

+ Active Customers as of [url removed, login to view]: shows a snapshot of active customers as of the specified date.

+ Contract MRC's with Base and Active on [url removed, login to view]: shows contract override monthly recurring charges by Base Station and active as of the specified date.

+ List MRC's with Base and Active on [url removed, login to view]: shows list monthly recurring charges by Base Station and active as of the specified date.

Service Provider should be proficient with Microsoft SQL Server 2000 scripting (Transact-SQL, Visual Basic, etc.), and one or more of the following.

Crystal Reports.

Microsoft SQL Reporting Services.

Excel Queries and SQL Views.

This job will need to be completed ASAP and no later than 10/31/2007.

The purpose of this project is to create a report, or series of reports that will show the overall growth of our company revenue during a user-specified date range. Toward that

end, this report must be composed of the following elements.

+ Current customer count by Base Station.

+ Current customer count by Market.

+ Historic (based on user-specified date) customer count by Base Station.

+ Historic (based on user-specified date) customer count by Market.

+ Current Service Type count by Base Station.

+ Current Service Types count by Market.

+ Historic (based on user-specified date) Service Type count by Base Station.

+ Historic (based on user-specified date) Service Types count by Market.

+ Current Service Category count by Base Station

+ Current Service count

+ Current monthly recurring revenue by Customer.

+ Current monthly recurring revenue by individual Service.

+ Current monthly recurring revenue by Service Category.

+ Current monthly recurring revenue by Base Station.

+ Current monthly recurring revenue by Market.

+ Historic monthly recurring (based on user-specified date) revenue by Customer.

+ Historic monthly recurring (based on user-specified date) revenue by individual Service.

+ Historic monthly recurring (based on user-specified date) revenue by Service Category.

+ Historic monthly recurring (based on user-specified date) revenue by Base Station.

+ Historic monthly recurring (based on user-specified date) revenue by Market.

+ Recurring revenue growth during a user-specified date range by Service Category.

+ Recurring revenue growth during a user-specified date range by Market.

+ Non-recurring revenue growth during a user-specified date range by Service Category.

+ Non-recurring revenue growth during a user-specified date range by Market.

+ Recurring and non-recurring revenue growth during a user-specified date range for the entire company.

+ Gross adds and gross losses by Service Type during a user-specified date range.

We have already begun the process of creating a query framework that pulls this data in a fairly static format. We now require a service provider, utilizing one of the aforementioned reporting tools, who will unify this data and make the query process more dynamic. Service Provider, please use the keyword "rosebud" when responding to this proposal (so we know you are not a bot), and be prepared to provide IM username when project begins.

Projekt ID: #185185

Om projektet

2 bud Remote projekt Aktiv Nov 17, 2007