Build utilization dashboard in Tableau

Please see the attached sample data. The sample data has four columns ID (integer), Vehicle (text), Event (set to either 'Start' or 'End') and Time, a date/time stamp. Each entry represents the start or the end of a unique trip and each trip ID will have a single start and end entry (two entries per trip). The timestamp is incremented into 15 minute intervals. The sample data spans a single month.

A dashboard in Tableau that shows a utilization graph needs to be built from this data. Utilization is defined as (Hours trip is in progress/Total Hours selected in interval). The dashboard should allow the user to select a start and end range of data, a vehicle from a drop-down menu (only one can be selected at a time), and select from one of two reporting options: Utilization by DOW or Utilization by TOD

Utilization by DOW (Day of Week):

A graph will be displayed that shows the average (mean) percent utilization by day of week (Sunday, Monday, Tuesday, Wednesday... etc). Percent utilization is the amount of time the vehicle is reserved (has an active trip), by 15 minute intervals. For example, if the date range the user has selected spans 14 days and one Sunday had 12.75 hours of utilization and the second Sunday had 8.25 hours of utilization, the graph should show 43.75% utilization for Sundays ((12.75 hours + 8.25 hours = 21 hours / 48 hours (two Sundays) = .4375). Monday and each subsequent day would display the appropriate value for those days.

Utilization by TOD (Time of Day):

With the TOD option selected, the user should also get the option to filter by day of week (Sunday to Saturday). By default all DOWs should be selected and the user can include some or all of them.

The TOD graph functions similarly the DOW graph, but uses a 24 hour scale along the X-axis, rather than seven days of the week. With a particular date range selected, the user can see the average (mean) percent utilization at a given time of day, in 15 minute intervals. For instance, if a two day date range is selected, and day 1 has a trip from 08:00 to 13:00 and day 2 has a trip from 06:00 to 10:00, then the utilization should be:

Before 06:00 - 0%

06:00-08:00 - 50%

08:00-10:00 - 100%

10:00-13:00 - 50%

After 13:00 - 0%

The DOW filter should allow the user to examine one or more days of the week. For instance, the user may only want to look at Sundays, or may want to look at the hourly utilization that occurred Monday-Friday only and exclude Saturday and Sunday trips. Regardless of the time period selected, utilization will always be defined as (Hours trip is in progress/Total Hours selected in interval).

Ultimately, many months of data will be analyzed using this dashboard. The format will be identical to the sample data (including rounding to 15 minute intervals) but the dashboard should be able to account for data that spans multiple months or years.

Ultimately this is being used in Tableau 2018.1 if this makes a difference.

Habilidades: Tableau

Ver más: tableau monitoring dashboard, tableau dashboard usage stats, tableau usage reporting, tableau server create custom admin views, tableau usage dashboard, tableau server status dashboard, dashboard usage statistics, tableau postgres dashboard, please someone give excel dashboard, please enter keystrokes per hour, build dashboard using flex database, please build twitter site, vtiger build dashboard, build dashboard adobe air, build wireless weight scale, build google dashboard, build analytics dashboard, google analytics build dashboard, please build website, build dashboard webpage

Información del empleador:
( 0 comentarios ) Washington, United States

Nº del proyecto: #17776903

Adjudicado a:


Hi, Review my profile.  4 Years of experience as BI/ETL Developer and Oracle Business Intelligence Certified professional. Adept in preparing data for analysis, Creating dashboards deploying dashboards on serv Más

$155 USD en 3 días
(0 comentarios)

11 freelancers están ofertando el promedio de $173 para este trabajo


Hi, Hope you are doing great. I have expert knowledge in Tableau designing and development. I have created many dashboards using this tool. I read your requirements, will do your dashboard. Please message me for sample Más

$222 USD en 2 días
(13 comentarios)

I have a good hands on working with Advanced R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboards and Web Applications using flask/ Más

$250 USD en 3 días
(1 comentario)

Hi, I can do your project in a day and hand it over to you today itself. I have seen your dataset and it wont be difficult for me to provide you the best [login to view URL], I am an experienced Tableau consultant with 3+ year Más

$112 USD en 1 día
(1 comentario)

I have gone through your requirements and I possess the ability to accomplish your task in a proper and professional way

$160 USD en 3 días
(0 comentarios)

Having extensive experience in designing various types of Dashboards in Tableau. Excellent troubleshooting and data understanding and testing capability ensure the designed dashboard or report is error free.

$222 USD en 7 días
(0 comentarios)

Hi, I would be able to create the Tableau dashboard as per the requirement. Could you please let me know if you have any VM/RDP to connect to for development? Cheers, Ranjana

$150 USD en 3 días
(0 comentarios)

I have more the 6 year of data & business intelligence consulting for industries in banking, insurance, oil & gas, FMCG, pharmaceuticals clients and expertise in Tableau BI successful projects

$155 USD en 3 días
(0 comentarios)
$111 USD en 5 días
(0 comentarios)

Experience in Data Analysis, Data Preparation for Statistical Analysis, Data reporting and providing insights over the data using statistical tools such as SAS / R / SQL /Excel and Tableau. Good hand over various pack Más

$166 USD en 3 días
(0 comentarios)

Hi Employer, I am the best fit for this project as I have  More than 5 years of experience in Consulting projects in Business/Data Analytics, Secondary Research and business development in Healthcare and Life scie Más

$200 USD en 3 días
(0 comentarios)