Excel Based Dashboard

Closed - This job posting has been filled and work has been completed.

Job Description

I need a dashboard created for work. The kicker is, I need it by 5:00 PM Central tomorrow! It shouldn't be too difficult. I also need to hire someone who will be available to make adjustments as I need it, within the next two weeks. I will pay for that work separately at the negotiated rate.


Dashboard name – Carondelet St. Joseph’s PT Performance
Master Start / End Date Selector (Default) will automatically select time frames for all graphs, and tables will allow for date range selection changes to specific sections without altering master date selector



Total Trips
• Line Graph with plot points for each date (x axis), trips (y axis)
• Goal line (y axis) input selector on Data worksheet
• Start / End Date Range Selections (drop down lists)
• Must have axis labels and graph label
• Hover over plot point data popup functionality
o Includes data information & trip change values & percentage change


Adjusted Trips
• Line Graph with plot points for each date (x axis), trips (y axis)
• Goal line (y axis) input selector on Data worksheet
• Start / End Date Range Selections (drop down lists)
• Must have axis labels and graph label
• Hover over plot point data popup functionality
o Includes data information & adjusted trip change values & percentage change


TPPLH
• Vertical Bar Graph with plot points for each date (x axis), TPPLH (y axis)
• Goal line (y axis) input selector on Data worksheet
• Start / End Date Range Selections (drop down lists)
• Must have axis labels and graph label
• Hover over plot point data popup functionality
o Includes data information & TPPLH values & percentage change
Productivity
• Line Graph with plot points for each date (x axis), percentages (y axis)
• Start / End Date Range Selections (drop down lists)
• Must have axis labels and graph label
• Hover over plot point data popup functionality
o Includes data information & productivity values & percentage change


RTA 10”, RTC 25”, RTC 30”
• Speedometer style gauges (red, yellow, green sections; 0% to 100%)
• Start / End Date Range Selections (drop down lists)
• Must average calculate the average percentage for the date ranges indicated
• Must have data and graph labels
• Positioned at the top


Delays & Cancellations (both on 1 graph)
• Vertical Bar Graph with plot points for each date (x axis), Delays (y axis fill area from base to value), Cancellations (y axis line, color to contrast fill area)
• Goal line (y axis) input selector on Data worksheet for both delays and cancellations
• Start / End Date Range Selections (drop down lists)
• Must have axis labels and graph label
• Hover over plot point data popup functionality
o Includes data information & delay & cancellation values & percentage change for both


Performance Table
• Start / End Date Range Selections (drop down lists)
• Y axis Total Trips, EC trips, Adjusted trips, TPPLH, Productivity, RTA 10”, RTC 25”, RTC 30”, Delays, Cancellations; X axis dates selected maximum days possible 14
• Positioned at the bottom

Gauge & table examples
http://www.microstrategy.com/DashboardGallery/Dashboards/RevenuePerformanceManagementDashboard.asp

Vertical Bar Graph example
http://www.microstrategy.com/DashboardGallery/Dashboards/customers/bmo/
http://www.microstrategy.com/dashboardgallery/dashboards/healthcare/revenue-cycle/

The dashboard MUST be scalable and continue to work as additional data is added.

I will be available by phone and email to the selected contractor for clarification questions. I think the posting covers the majority of the details and should leave little room for uncertainty.

Thank you.

Other open jobs by this client