Custom Excel Sales Performance Report - Design and Development

CLOSED
Bids
26
Avg Bid (AUD)
$490
Project Budget (AUD)
$250 - $750

Project Description:
The Brief
This is an exciting project for highly skilled business/IT professional to design and create an intelligent and customized Excel sales report template for an established arts company.

The business problem:
As a theatre company, we produce and present four shows per calendar year. We receive daily raw sales data from a third-party ticketing organization (daily sales, refunds, etc) in Excel format, which we then use to track company performance. Our current company sales report format is:

- Time consuming to prepare (takes a staff member 60 mins a day to update and calculate sales KPIs)
- Provides little insight and is of questionable value
- Badly organized and difficult to interpret
- Is of little use

The expected solution:
The creation of a single, all-encompassing, intelligent and robust Excel document that utilizes raw data to provide automated insight and tracking of key sales KPIs. A key part of the project is to advise us on the best way to display and structure this report.

Working in close collaboration with the Marketing Director, you will analyze the business problem and devise a suitable sales report format addressing the below requirements:

Key Requirements
- Automation. We envisage that every day we copy/paste third-party raw data into a single excel document, which immediately produces an updated snapshot of our sales position, across all four shows.
- Visual graphs. The ability for management to quickly interpret complex information.
- Well considered. The design should be clean and efficient.
- Easy to Use. The ability for a junior member of staff to easily update.
- Dashboard and KPIs. Consolidate all metrics in a single dashboard.

Your Skills
- Ability to analyze complex data sets and leverage these to produce useable insights
- Highly competent in producing custom reports in Excel (for Apple) for business, including visual basic, macros, etc.
- Ability to manipulate data and solve complex business problems
- A solid understanding of the sales process, reporting best practice and sales analysis techniques
- Good communication skills
- English speaking

Attachments
- Proposed report structure, data and KPIs
- Design style of dashboard: klipfolio.com/solutions/kpi-dashboard-industry

Key Deliverables
- 1 x Excel document (based on above requirements)
- 1 x Skype session summarizing key features (if required)

Next Steps
If this project is of interest, please contact me, providing the below. This project will be awarded based on the strength of the details provided below.
- examples of previous work (custom business report with automation features)
- an outline of how you will approach the problem
- an example Excel layout of the report, taking into account the attachments provided and details above.

Skills required:
Data Processing, Excel, Marketing, Report Writing, Sales
Additional Files: Proposed+Report+Structure+and+Data.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire bharanisrihari
$ 777
in 15 days
Hire Premshanks
$ 733
in 3 days
$ 555
in 14 days
$ 444
in 10 days
$ 388
in 7 days
$ 250
in 5 days
$ 618
in 15 days
Hire sudewa
$ 666
in 15 days
Hire Goykhberg
$ 666
in 25 days
$ 525
in 3 days