
Fechado
Publicado
I need an interactive HR dashboard built directly in Google Sheets that highlights three core metrics: employee attendance, employee performance, and turnover rates. The data must be translated into easy-to-scan heat maps, so strong command of conditional formatting, pivot tables, and any helpful Apps Script automations is essential. Raw data will be supplied in separate Sheets tabs; your job is to design the layout, connect the data flows, and apply dynamic color scales that immediately flag positive and negative trends. Everything should refresh automatically when new rows are added. Deliverables • One Google Sheets file containing: – A clean “Data” area for each metric – A consolidated Dashboard tab with heat-map visualizations – All formulas, query functions, or scripts fully documented in-cell or in a short README tab • Quick hand-off video or Loom (≤5 min) walking through how to update and maintain the dashboard Completion is time-critical—I’d like to review an initial draft within the next couple of days and finalize ASAP.
ID do Projeto: 40298030
7 propostas
Projeto remoto
Ativo há 1 mês
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
7 freelancers estão ofertando em média ₹557 INR/hora for esse trabalho

With over a decade of experience in data management, analysis and advanced Google Sheets usage, I can confidently assure you that I am the right fit for your Google Sheets data analytics and HR Dashboard project. My mastery of both Google Sheets and Excel extends to pivot tables, conditional formatting, and App Script automations, just what your project demands. Having done similar projects in the past, my workflows are streamlined to optimize data flows from multiple sources like the separate sheets tabs in your project description, while ensuring a captivating interface with easy-to-read visualizations that you need. In addition to providing you with an efficient, consolidated HR dashboard that showcases employee attendance, performance, and turnover rates through informative heat-map visualizations, I will also ensure all the required metrics get automatically refreshed whenever new rows are added- eliminating any need for manual intervention. As an added advantage, I've also got expertise in producing short tutorial videos like Loom videos which will be perfect for handing over the project. Providing samples of my work grant unmatched visibility into what you should expect in terms of quality prowess as well as unlimited revisions to make certain that your project objectives are met spot-on. So why wait? Choose me today for a timely and superior completion of this important project!
₹400 INR em 40 dias
4,0
4,0

I am an expert statistician, Research Writer, and data analyst with more than eight years of experience. I have full command of Excel analysis, SPSS, STATA, R LANGUAGE, AND PYTHON. I am an expert in creating time series prediction models, working with survey data, conducting marketing analysis, building estimators, and medical analysis. I am a perfect match for your project share other details of the work so I can start working on your project. Will complete task on time.
₹600 INR em 10 dias
4,3
4,3

Hi, This is something I can help you with. I’ve built Google Sheets dashboards using pivot tables, conditional formatting heat maps, and Apps Script automation to track metrics like attendance, performance, and other HR data. I can structure your sheet with separate data tabs and a clean Dashboard tab that automatically pulls the data and highlights trends using dynamic color scales. The dashboard will update automatically whenever new rows are added, so you won’t need to adjust formulas each time. You’ll receive: • Organized data tabs for each metric • A dashboard with heat-map visualizations • Clear formulas/scripts documentation • A short walkthrough video explaining how to maintain it Since the project is time-sensitive, I can share an initial draft within the next 1–2 days. If possible, please share a sample of the raw data structure, so I can plan the dashboard layout accordingly. Best regards, Meena
₹575 INR em 40 dias
5,0
5,0

Hello, I can build an interactive HR dashboard in Google Sheets that tracks employee attendance, performance, and turnover rates, with dynamic heat maps to quickly highlight trends. Using conditional formatting, pivot tables, and Apps Script automations, I will connect your raw data from separate tabs, design a clean dashboard layout, and ensure all metrics refresh automatically when new rows are added. The deliverables will include a fully functional Google Sheets file with a consolidated Dashboard tab, documented formulas and scripts, and a short hand-off video (≤5 min) explaining how to update and maintain the dashboard. The project will be completed efficiently while keeping the dashboard intuitive and easy to use.
₹575 INR em 40 dias
0,0
0,0

Hi there, Actually I'm new on freelancer.com but I am fully ready to start immediately on your time-critical HR Dashboard. As a Data Automation Specialist, I specialize in building clean, serious, and highly professional Google Sheets dashboards. I will execute your exact deliverables quickly and accurately: Dynamic Data Flow: I will consolidate your raw tabs using efficient formulas (QUERY, ARRAYFORMULA) so the dashboard auto-refreshes instantly when new rows are added. Visual Heat Maps: I will design an intuitive layout with conditional color scales to immediately flag positive/negative trends in attendance, performance, and turnover. Complete Hand-off: I will include a clear README tab for all scripts/formulas and provide a concise (<5 min) Loom video walking you through the updates. I prioritize speed, data accuracy, and a modern UI. Please share a view-only link to your raw data, and I will begin working on the initial draft right away. Let's get this done! Best regards, Bella Haiqal Script Wizard
₹500 INR em 40 dias
0,0
0,0

Hello, I would be happy to build a clean and visually appealing Excel dashboard for you. I have strong experience working with Excel dashboards, data analysis, and structured reporting. My goal is not only to organise the data correctly but also to present it in a clear and engaging way using charts, graphs, and interactive elements. For your dashboard I can include: • Clean and professional layout • Dynamic charts and graphs • Automated calculations using formulas • Filters or dropdowns for easy navigation • A structured dashboard that updates automatically when data changes I focus on making dashboards that are not only functional but also easy to understand and visually attractive. If you would like, you can send a sample of the data and I can suggest the best dashboard structure for your needs. I am ready to start immediately and would be happy to discuss your requirements. Best regards, Bas
₹500 INR em 14 dias
0,0
0,0

Bengaluru, India
Membro desde mar. 13, 2026
₹100-400 INR / hora
₹1500-12500 INR
$30-250 USD
$250-750 USD
₹12500-37500 INR
₹750-1250 INR / hora
$30-250 USD
₹250000-500000 INR
₹1500-12500 INR
$250-750 AUD
€12-18 EUR / hora
₹600-1500 INR
$2-8 AUD / hora
₹750-1250 INR / hora
₹100-400 INR / hora
$250-750 USD
₹750-1250 INR / hora
$30-250 USD
$30-250 CAD
$30-250 USD