Client
Talemy
Disciplines
Databases UX Design
Timeline
1 month 01.2022 to 02.2022
Collaborator
Luna Nguyen Camellia Tran Bui Huong Thao
Deliverables
Business Infrastructure
Talemy Internal Workspace
A [UX] E-TAL
Talemy is a startup that provides human resources consulting services, particularly headhunting. Every day, internal employees deal with a large number of clients and candidates. Talemy needs methods for capturing and storing data that would be useful in the future while also reducing the number of human data entry operations.
The Talemy Internal Workspace is a collection of Google Documents and Sheets, but it utilizes formulas and Google Apps Script to automate the workflow, assisting consultants with their everyday operations.
Client
Talemy
Disciplines
Databases UX Design
Timeline
1 month 01.2022 to 02.2022
Collaborator
Luna Nguyen Camellia Tran Bui Huong Thao
Deliverables
Business Infrastructure
Talemy Internal Workspace
A [UX] E-TAL
Talemy is a startup that provides human resources consulting services, particularly headhunting. Every day, internal employees deal with a large number of clients and candidates. Talemy needs methods for capturing and storing data that would be useful in the future while also reducing the number of human data entry operations.
The Talemy Internal Workspace is a collection of Google Documents and Sheets, but it utilizes formulas and Google Apps Script to automate the workflow, assisting consultants with their everyday operations.
Client
Talemy
Disciplines
Databases UX Design
Timeline
1 month 01.2022 to 02.2022
Collaborator
Luna Nguyen Camellia Tran Bui Huong Thao
Deliverables
Business Infrastructure
Talemy Internal Workspace
A [UX] E-TAL
Talemy is a startup that provides human resources consulting services, particularly headhunting. Every day, internal employees deal with a large number of clients and candidates. Talemy needs methods for capturing and storing data that would be useful in the future while also reducing the number of human data entry operations.
The Talemy Internal Workspace is a collection of Google Documents and Sheets, but it utilizes formulas and Google Apps Script to automate the workflow, assisting consultants with their everyday operations.
Introduction
Purposes
The primary goal of the internal workspace is to save data for the future. However, we went beyond that and sought to optimize internal employee operations as well.
Introduction
Purposes
The primary goal of the internal workspace is to save data for the future. However, we went beyond that and sought to optimize internal employee operations as well.
Introduction
Purposes
The primary goal of the internal workspace is to save data for the future. However, we went beyond that and sought to optimize internal employee operations as well.
Challenges
Despite being a relatively new startup, Talemy had already accumulated a considerable amount of data. However, internal employees encountered difficulties in locating existing data such as CVs and client information. This often results in the inadvertent duplication of data, leading to a dataset that is not only disorganized but also hampers effective decision-making.
Moreover, due to the resource limitations, coding a comprehensive database was not a viable option at that time. Therefore, we had to utilize on Google Workspace capabilities and our extensive experience with Google Sheets to tackle these data management challenges.
Create a Database Management System that is user-friendly and promotes optimization and data-driven decision-making
Challenges
Despite being a relatively new startup, Talemy had already accumulated a considerable amount of data. However, internal employees encountered difficulties in locating existing data such as CVs and client information. This often results in the inadvertent duplication of data, leading to a dataset that is not only disorganized but also hampers effective decision-making.
Moreover, due to the resource limitations, coding a comprehensive database was not a viable option at that time. Therefore, we had to utilize on Google Workspace capabilities and our extensive experience with Google Sheets to tackle these data management challenges.
Create a Database Management System that is user-friendly and promotes optimization and data-driven decision-making
Challenges
Despite being a relatively new startup, Talemy had already accumulated a considerable amount of data. However, internal employees encountered difficulties in locating existing data such as CVs and client information. This often results in the inadvertent duplication of data, leading to a dataset that is not only disorganized but also hampers effective decision-making.
Moreover, due to the resource limitations, coding a comprehensive database was not a viable option at that time. Therefore, we had to utilize on Google Workspace capabilities and our extensive experience with Google Sheets to tackle these data management challenges.
Create a Database Management System that is user-friendly and promotes optimization and data-driven decision-making
Discover
User Interviews
To gain insights into user needs and effectively document processes, my team and I interviewed internal employees (particularly department leaders) to learn how their team collects and stores data to decide what data to capture.
We interviewed:
Recruitment Service Department: client_database, candidates_database, etc.
Finance: deal_database, commission_database, etc.
Human Resources: application_database, employees_database, etc.
Marketing: campaigns_database, assets_database, etc.
Discover
User Interviews
To gain insights into user needs and effectively document processes, my team and I interviewed internal employees (particularly department leaders) to learn how their team collects and stores data to decide what data to capture.
We interviewed:
Recruitment Service Department: client_database, candidates_database, etc.
Finance: deal_database, commission_database, etc.
Human Resources: application_database, employees_database, etc.
Marketing: campaigns_database, assets_database, etc.
Discover
User Interviews
To gain insights into user needs and effectively document processes, my team and I interviewed internal employees (particularly department leaders) to learn how their team collects and stores data to decide what data to capture.
We interviewed:
Recruitment Service Department: client_database, candidates_database, etc.
Finance: deal_database, commission_database, etc.
Human Resources: application_database, employees_database, etc.
Marketing: campaigns_database, assets_database, etc.
Secondary Research
Having no prior experience with databases, this project became my learning ground. IBM Documentation proved invaluable, teaching me about data structures and relationships. My university studies in information systems, once deemed irrelevant, surprisingly became crucial.
Furthermore, I meticulously documented our database-building journey within Talemy, creating a valuable resource for future learning and development within the company.
Secondary Research
Having no prior experience with databases, this project became my learning ground. IBM Documentation proved invaluable, teaching me about data structures and relationships. My university studies in information systems, once deemed irrelevant, surprisingly became crucial.
Furthermore, I meticulously documented our database-building journey within Talemy, creating a valuable resource for future learning and development within the company.
Secondary Research
Having no prior experience with databases, this project became my learning ground. IBM Documentation proved invaluable, teaching me about data structures and relationships. My university studies in information systems, once deemed irrelevant, surprisingly became crucial.
Furthermore, I meticulously documented our database-building journey within Talemy, creating a valuable resource for future learning and development within the company.
Define
Data Collection
I planned the flow of data, including how it would be recorded, when it would be collected, and where it would be stored. The flow was based on interview insights and internal service documentation.
I also determined what outcomes need to be generated with the data to add the appropriate properties to our databases. For example: Candidate processing time is one of the primary indications of consultant efficiency, therefore recording the submission time for each interview step is important.
Define
Data Collection
I planned the flow of data, including how it would be recorded, when it would be collected, and where it would be stored. The flow was based on interview insights and internal service documentation.
I also determined what outcomes need to be generated with the data to add the appropriate properties to our databases. For example: Candidate processing time is one of the primary indications of consultant efficiency, therefore recording the submission time for each interview step is important.
Define
Data Collection
I planned the flow of data, including how it would be recorded, when it would be collected, and where it would be stored. The flow was based on interview insights and internal service documentation.
I also determined what outcomes need to be generated with the data to add the appropriate properties to our databases. For example: Candidate processing time is one of the primary indications of consultant efficiency, therefore recording the submission time for each interview step is important.
Database Schema
I drew out the schema to understand the interconnected nature of the data and to link them together to find and minimize duplicates, optimizing the collecting phase. (The image below shows ⅓ of the actual schema)
Database Schema
I drew out the schema to understand the interconnected nature of the data and to link them together to find and minimize duplicates, optimizing the collecting phase. (The image below shows ⅓ of the actual schema)
Database Schema
I drew out the schema to understand the interconnected nature of the data and to link them together to find and minimize duplicates, optimizing the collecting phase. (The image below shows ⅓ of the actual schema)
Design
Google Sheets
Naturally, lacking coding skills, we opted for Google Sheets. However, to introduce automation, formulas were essential. I took charge of creating and optimizing advanced formulas, aiming to minimize file storage and streamline workflows. Additionally, I employed color coding to visually distinguish disabled and crucial data fields, aiding our consultants during data entry.
Design
Google Sheets
Naturally, lacking coding skills, we opted for Google Sheets. However, to introduce automation, formulas were essential. I took charge of creating and optimizing advanced formulas, aiming to minimize file storage and streamline workflows. Additionally, I employed color coding to visually distinguish disabled and crucial data fields, aiding our consultants during data entry.
Design
Google Sheets
Naturally, lacking coding skills, we opted for Google Sheets. However, to introduce automation, formulas were essential. I took charge of creating and optimizing advanced formulas, aiming to minimize file storage and streamline workflows. Additionally, I employed color coding to visually distinguish disabled and crucial data fields, aiding our consultants during data entry.
AppScripts
When advanced automation was necessary, such as automatically updating data from 5 sheets into 1—a task beyond the capabilities of standard formulas—I turned to AppScripts.
Using AppScripts posed a steep learning curve for me, as I had no prior coding experience. I relied heavily on existing online solutions or merged code snippets from YouTube and Stack Overflow to create something that met my specific requirements.
AppScripts
When advanced automation was necessary, such as automatically updating data from 5 sheets into 1—a task beyond the capabilities of standard formulas—I turned to AppScripts.
Using AppScripts posed a steep learning curve for me, as I had no prior coding experience. I relied heavily on existing online solutions or merged code snippets from YouTube and Stack Overflow to create something that met my specific requirements.
AppScripts
When advanced automation was necessary, such as automatically updating data from 5 sheets into 1—a task beyond the capabilities of standard formulas—I turned to AppScripts.
Using AppScripts posed a steep learning curve for me, as I had no prior coding experience. I relied heavily on existing online solutions or merged code snippets from YouTube and Stack Overflow to create something that met my specific requirements.
Deliver
Handover
///coming-soon
Deliver
Handover
///coming-soon
Deliver
Handover
///coming-soon
Workshops
We created comprehensive documentation on how our consultants should utilize and leverage the existing database effectively. To facilitate a smooth transition, we organized a two-week learning session to familiarize the team with the new processes associated with our database.
Workshops
We created comprehensive documentation on how our consultants should utilize and leverage the existing database effectively. To facilitate a smooth transition, we organized a two-week learning session to familiarize the team with the new processes associated with our database.
Workshops
We created comprehensive documentation on how our consultants should utilize and leverage the existing database effectively. To facilitate a smooth transition, we organized a two-week learning session to familiarize the team with the new processes associated with our database.
Features
Files Management
///coming-soon
Features
Files Management
///coming-soon
Features
Files Management
///coming-soon
Rename Automation
///coming-soon
Rename Automation
///coming-soon
Rename Automation
///coming-soon
Errors Management
///coming-soon
Errors Management
///coming-soon
Errors Management
///coming-soon
Key Takeaways
Impacts
We have a total of 1,282,532 unique data records for clients, prospects, etc.
Data is easier to manage (discover, gather, and analyze), resulting in a more data-driven decision-making culture. We have several dashboards and were able to discover gaps in our services, leading to many successful projects later on.
Key Takeaways
Impacts
We have a total of 1,282,532 unique data records for clients, prospects, etc.
Data is easier to manage (discover, gather, and analyze), resulting in a more data-driven decision-making culture. We have several dashboards and were able to discover gaps in our services, leading to many successful projects later on.
Key Takeaways
Impacts
We have a total of 1,282,532 unique data records for clients, prospects, etc.
Data is easier to manage (discover, gather, and analyze), resulting in a more data-driven decision-making culture. We have several dashboards and were able to discover gaps in our services, leading to many successful projects later on.
Future Considerations
We want to improve the number of data connections and automation, but due to limited resources and skills, we have confined ourselves to the present versions.
Many errors occur during the initial period of launch. I was continually fixing (officially, an IT Help Desk). However, in later versions, I was able to automate many difficulties and delegate problem-solving tasks to Google App Scripts. For example, I was able to automate Google Sheets' errors (#ERROR!, #NAME!, etc.) using App Scripts.
Future Considerations
We want to improve the number of data connections and automation, but due to limited resources and skills, we have confined ourselves to the present versions.
Many errors occur during the initial period of launch. I was continually fixing (officially, an IT Help Desk). However, in later versions, I was able to automate many difficulties and delegate problem-solving tasks to Google App Scripts. For example, I was able to automate Google Sheets' errors (#ERROR!, #NAME!, etc.) using App Scripts.
Future Considerations
We want to improve the number of data connections and automation, but due to limited resources and skills, we have confined ourselves to the present versions.
Many errors occur during the initial period of launch. I was continually fixing (officially, an IT Help Desk). However, in later versions, I was able to automate many difficulties and delegate problem-solving tasks to Google App Scripts. For example, I was able to automate Google Sheets' errors (#ERROR!, #NAME!, etc.) using App Scripts.
Lessons Learned
Nothing is impossible. From starting with zero knowledge about databases to gaining a basic understanding, I was able to create something truly valuable.
Lessons Learned
Nothing is impossible. From starting with zero knowledge about databases to gaining a basic understanding, I was able to create something truly valuable.
Lessons Learned
Nothing is impossible. From starting with zero knowledge about databases to gaining a basic understanding, I was able to create something truly valuable.