The project aimed to uncover key insights into how remote work dynamics have evolved during the COVID-19 pandemic, ultimately providing actionable recommendations for optimizing remote work practices based on employee experiences and preferences.
PROJECT OVERVIEW
This personal project analyzes survey data from Maven Analytics Sample Datasets, collected from 1,512 respondents in New South Wales, Australia. Conducted from August 2020 to April 2021, the survey aimed to capture shifts in remote work experiences and attitudes during different stages of the COVID-19 pandemic. The analysis provides insights into the evolving dynamics of remote work and its long-term implications.
THE PROCESS
Step 1️⃣: Review and Define Goals
I started by thoroughly reviewing the raw data to understand its structure and content. I defined clear goals and key questions that I aimed to address, ensuring they aligned with my overall project objectives.
I started by thoroughly reviewing the raw data to understand its structure and content. I defined clear goals and key questions that I aimed to address, ensuring they aligned with my overall project objectives.
Step 2️⃣: Select Metrics and Clean Data
I identified the most relevant metrics that would provide meaningful insights. Using the ETL process in Power Query Editor, I cleaned and transformed the data to ensure accuracy and consistency for analysis.
I identified the most relevant metrics that would provide meaningful insights. Using the ETL process in Power Query Editor, I cleaned and transformed the data to ensure accuracy and consistency for analysis.
Step 3️⃣: Select Effective Visual Type
I developed initial visualizations to present the data in a clear and impactful manner. I iterated multiple times to refine these visuals, ensuring they effectively communicated the insights I intended to share.
I developed initial visualizations to present the data in a clear and impactful manner. I iterated multiple times to refine these visuals, ensuring they effectively communicated the insights I intended to share.
Step 4️⃣: Eliminate Clutter
I streamlined the visualizations by removing unnecessary elements that might distract from the core message. I focused on clarity and simplicity to enhance understanding.
I streamlined the visualizations by removing unnecessary elements that might distract from the core message. I focused on clarity and simplicity to enhance understanding.
Step 5️⃣: Optimize Layout for Focus
I designed the layout to guide the viewer’s attention to the most important insights. I used strategic placement and design elements to highlight key data points and trends.
I designed the layout to guide the viewer’s attention to the most important insights. I used strategic placement and design elements to highlight key data points and trends.
Step 6️⃣: Refine Titles and Subtitles
I revised titles and subtitles to effectively convey the insights and findings. I ensured that they were engaging and informative, drawing attention to the most critical aspects of the analysis.
I revised titles and subtitles to effectively convey the insights and findings. I ensured that they were engaging and informative, drawing attention to the most critical aspects of the analysis.
THE INSIGHTS
How much time do employees spend on various activities when working in person versus remotely?
Insight: Employees spend 3.8% more time on work when they work remotely, benefiting from an average of 1 hour saved each day on preparing for work and commuting. This time saved is often reallocated to work tasks, spending time with family, and managing domestic responsibilities, enhancing both productivity and personal well-being.
Insight: Employees spend 3.8% more time on work when they work remotely, benefiting from an average of 1 hour saved each day on preparing for work and commuting. This time saved is often reallocated to work tasks, spending time with family, and managing domestic responsibilities, enhancing both productivity and personal well-being.
What are the biggest barriers of working in the office while your colleagues are working remotely?
Insight: The most commonly reported barriers include difficulties in collaboration and frequent interruptions. To address these challenges, it's essential to find a better balance between collaboration and focus work. Designing an activity-based working environment can help allocate spaces for heads-down focus work and separate areas for collaborative activities, enhancing productivity and communication for all employees.
Insight: The most commonly reported barriers include difficulties in collaboration and frequent interruptions. To address these challenges, it's essential to find a better balance between collaboration and focus work. Designing an activity-based working environment can help allocate spaces for heads-down focus work and separate areas for collaborative activities, enhancing productivity and communication for all employees.
What is employee productivity like when working remotely?
Insight: 64% of employees reported increased productivity when working remotely, indicating that they were able to accomplish more tasks and achieve higher efficiency compared to working in a traditional office setting.
Insight: 64% of employees reported increased productivity when working remotely, indicating that they were able to accomplish more tasks and achieve higher efficiency compared to working in a traditional office setting.
How do employees believe working remotely could benefit the company?
Insight: 68% of employees believed that remote work could benefit the company by enhancing productivity and increasing employee satisfaction and retention.
Insight: 68% of employees believed that remote work could benefit the company by enhancing productivity and increasing employee satisfaction and retention.
What is the future trend in employees' willingness to return to the office?
Insight: The trend indicated a growing preference for hybrid work models, with most employees considering a 50% remote work arrangement as ideal. This approach allows them to enjoy the flexibility of remote work while still having opportunities for in-person collaboration and social interaction in the office.
Insight: The trend indicated a growing preference for hybrid work models, with most employees considering a 50% remote work arrangement as ideal. This approach allows them to enjoy the flexibility of remote work while still having opportunities for in-person collaboration and social interaction in the office.
