Project Title: Google Sheets Dashboard for Operations Management Insights

Client's Goal:

A global leader in health services, sought to harness the power of data for effective operations management Their objective was to create a dynamic dashboard that leverages existing data sources, process flows, and working documents. This dashboard was envisioned to provide a holistic view of key metrics, enhance decision-making, and streamline operational processes.

Contribution to the Project:

As a Data Analyst and Dashboard Developer, my mission was to transform the client's vision into a reality. Here's a summary of my contributions to the project:

Dashboard Design: I meticulously designed a powerful, visually appealing dashboard within Google Sheets. This dashboard serves as a central hub for critical operations management insights.

Data Integration: Leverage expertise in Google Suite, seamlessly integrated existing data sources into the dashboard. This included data from various working documents, process flows, and other data repositories.

Data Visualization: Employed advanced data visualization techniques to create five dynamic charts. These charts illuminate key aspects of the operation, including the number of worked hours by resource, percent average progress across projects, the team role with the most resources, the number of tasks assigned to each resource, and the number of worked hours by team role.

Search Functionality: To enhance user experience, I implemented a VLOOKUP feature and utilized COUNT and COUNTA formulas. This functionality allows users to search for a specific resource ID and instantly access essential information. Upon searching, the dashboard displays the number of projects associated with the resource, the percentage of completion, the resource's name, completion of quality assurance (QA), and a Google URL link for detailed insights.

Metrics at a Glance: At the top of the dashboard, prominently showcased key metrics, including the total number of projects, available resources, total stages, and the overall task completion rate. This quick reference area provides an immediate snapshot of the operation's health.

Project Success:

The successful completion of this project has empowered client to make data-driven decisions and optimize their operations management processes.

The dashboard I developed serves as a valuable tool that:

Provides instant access to critical operational metrics.

Enhances transparency and accountability within the organization.

Streamlines decision-making by presenting data in an easily understandable format.

Saves time and effort in data retrieval and analysis.

Supports actionable insights through data summarization and visualization.

This project stands as a testament to the power of data when harnessed effectively. It has enabled the client to stay ahead in a highly competitive industry and drive continuous improvements in their health services operations.