Find Jobs
Hire Freelancers

Build utilization dashboard in Tableau

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 17776903

About the project

11 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 server troubleshooting of dashboards and backup of Data, Hands on experience on ODI-11G, Pentaho for migration of Data. And for reporting used OBIEE 11g, tableau and [login to view URL] knowledge of Red Hat Linux, Centos and Solaris. Oracle 11g Databases.  ETL Technologies: ODI-11G, Pentaho  BI-Technologies: Tableau, obiee-11g,Power-BI,Excel  SQL scripting (BTEQ, TPT, Macros)  Process automation (Shell scripts)  Creating handover documentation (Stream Info, Failure Resolution)  Backup/Recovery, performance tuning of mission critical 24/7 databases  Working knowledge of Red Hat Linux, Oracle Enterprise Linux, Solaris and AIX  An effective communicator with excellent relationship building & interpersonal skills, analytical, problem solving & organizational abilities.  Thrives in fast-paced environment, readily adapting to evolving business and technology challenges. Other Technologies: WordpressWeb,Andriod,AWS,Hadoop,R language Regards Hammad
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
11 freelancers are bidding on average $173 USD for this job
User Avatar
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 work and further discussion.
$222 USD in 2 days
5.0 (13 reviews)
4.6
4.6
User Avatar
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/django. My area of expertise is building financial models (Stock Markets) , Image Processing and building models for food, healthcare and telecom sector, Classification/Prediction/Clustering, NLP and Chatbots. Specifically, I have worked for log on stock data and model building for the same. I understand the project requirement and will deliver the desired product within the time specified. I would like to hear from you. Thanks Shivam
$250 USD in 3 days
5.0 (1 review)
2.0
2.0
User Avatar
I have gone through your requirements and I possess the ability to accomplish your task in a proper and professional way
$160 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 packages in R for data analysis (Fluent in Tidyverse, Lubridate, H2O, rpart, party, caret, forecast, tm, sqldf, rserve packages to name a few) Exposure on Big data using technologies like Hadoop, HDFS, HIVE, Pig and/or traditional relational databases. My interests include Data Visualization, Data cleaning, slicing and dicing the data, and transforming data suitable for analysis and finding patterns in data, Predictive Modelling, Time Series Forecasting and use cases covering Machine Learning. Domain expertise in Banking, Healthcare, and Retail.
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 sciences domain  Data Analytics/Visualizations tools – Domo, Tableau, Alteryx (Basic), Excel, Intermediate SQL  Social/Digital Media Data Aggregator Tools – Sprinklr, Sysomos, Radian 6, Omniture and IMS PADDS  Professional communication skills include fluency in English and Limited working proficiency in French  Hold PGDM (Post Graduate Diploma in Management) in Marketing and Operations from a premiere B School Looking forward to hear from you and getting started on creating a Tableau Dashboard
$200 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Washington, United States
0.0
0
Payment method verified
Member since Sep 16, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.