Find Jobs
Hire Freelancers

Build utilization dashboard in Tableau

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 17776903

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
11 freelancers están ofertando un promedio de $173 USD por este trabajo
Avatar del usuario
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 en 2 días
5,0 (13 comentarios)
4,6
4,6
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
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,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Washington, United States
0,0
0
Forma de pago verificada
Miembro desde sept 16, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.