My Workflow as a Data Analyst Working in the Philippines
1 Video View·Oct 22, 2024
"What are the stages of a typical data analyst workflow? What are the steps involved? What are the crucial parts of the workflow?
In this video, we will explore my workflow as a data analyst working in the Philippines. This is to give you an idea of the tasks if ever you wish to start your career as a data analyst."
Hello, welcome to my channel. I'm Joy, a senior data analyst based in the Philippines.
I'm working as a data analyst for almost five years now.
Our office is in Taguig City, but my clients are based in abroad.
Currently, we have a hybrid setup. We come to the office once a week.
For this video, I will describe how is the usual workflow of data analyst.
My workflow has six stages.
First is I gather requirements from the client or business stakeholders via online meeting.
This is to get information on the requirements,
like what story they want to see on the dashboard,
meaning the flow of information being visualized to better understand the data.
Next agenda in the meeting is where to get the data's single source of truth
and other functionalities of the dashboard,
like how the data is being filtered by the user.
Is it per month, per region, among others.
This is when you have to be specific with the requirements gathering
as creating the visualization and other functionality building
will affect the project's timeline.
Next is data collection.
This is the stage when I acquire credentials to the databases
and permissions to folders of offline data if there are any.
This is also when I update my stakeholders on the data access
in case they need to escalate the process.
Next is coding, the heavily technical part of the workflow.
I use both SQL and Python for pulling data from different sources.
SQL for databases and Python for everything else.
This step involves cleaning, formatting,
and aggregating data prior to visualization
and requires logical and critical thinking
as some data has to be calculated based on business requirements.
Once the data is good to go,
I start building visualizations like charts, maps,
or tables using the preferred tool of the stakeholder.
This is when the stakeholder's feedback on the interface of the report is crucial
as they will be the one to present its contents.
This may take a while depending on the layout or functionality revisions.
After visualizing the data and the client is happy with the look and feel of the dashboard,
I start the validation phase wherein I check
if the dashboard shows accurate data and different views and filters.
This step is very crucial to avoid presenting faulty data.
Last step is to reset your mind.
It is important to take breaks as much as possible to avoid burnout.
For me, it's going to coffee shops to play games while drinking coffee.
I hope this gives you an idea on how we work as data analysts.
If you have questions, feel free to comment below.
Thank you for watching!

