5 answers
6
Questions
Updated
409 views
How do you be a data analyst ?
Is there collaboration as a team?
What do you analyze in your career?
Is there any other requirements to enter this career, example: certification or degrees?
Login to comment
5 answers
Updated
Frederic’s Answer
Hey Mia! It's fantastic that you're considering a career in data analysis! 🎉 Just to give you an idea of the skills needed in this field, here's a breakdown of what you might find useful to acquire:
1. Strong understanding of Statistics and Business
2. Proficiency in programming tools like SQL, Python or R, and Excel
3. (Optional, but beneficial) Familiarity with visualization tools like Power BI, Tableau, or JavaScript D3
So in short, yes, data analysts need to work with other people in other positions as a team, but it depends on companies.
First, as a data analyst, you will need to use data (dataset) to help your employer to solve a problem. It could be a descriptive question ("why" question) or a prescriptive question ("what it will be" question). For example, why last month's sales volume is lower than usual (a descriptive question) or predict the sales volume of this new product (a prescriptive question).
But before that, you will need to understand how to solve this problem and what information you need to solve this problem. Based on that, you will need Statistics and Business knowledge to decide which method or algorithm to use in the case.
Next, you need to use database to export and clean the data. And then, analyze the data as with the methods that you and your team decided in the previous step.
Third, visualize the result into charts and tell your employers what data suggests you in the way they can understand. However, in some companies, visualization is assigned to Business Intelligence Analysts instead of to Data Analysts. That's why I put "Optional" above in the required skills part.
I think working on a data analysis project on hand is more important than having a certification or a degree for job seeking so that you can better understand how data analytics works and what a data analyst should do. However, you will always need to have a certification or a degree to show employers that you have solid skills of data analytics. So I suggest getting a degree in Data Analytics or Data Science.
1. Strong understanding of Statistics and Business
2. Proficiency in programming tools like SQL, Python or R, and Excel
3. (Optional, but beneficial) Familiarity with visualization tools like Power BI, Tableau, or JavaScript D3
So in short, yes, data analysts need to work with other people in other positions as a team, but it depends on companies.
First, as a data analyst, you will need to use data (dataset) to help your employer to solve a problem. It could be a descriptive question ("why" question) or a prescriptive question ("what it will be" question). For example, why last month's sales volume is lower than usual (a descriptive question) or predict the sales volume of this new product (a prescriptive question).
But before that, you will need to understand how to solve this problem and what information you need to solve this problem. Based on that, you will need Statistics and Business knowledge to decide which method or algorithm to use in the case.
Next, you need to use database to export and clean the data. And then, analyze the data as with the methods that you and your team decided in the previous step.
Third, visualize the result into charts and tell your employers what data suggests you in the way they can understand. However, in some companies, visualization is assigned to Business Intelligence Analysts instead of to Data Analysts. That's why I put "Optional" above in the required skills part.
I think working on a data analysis project on hand is more important than having a certification or a degree for job seeking so that you can better understand how data analytics works and what a data analyst should do. However, you will always need to have a certification or a degree to show employers that you have solid skills of data analytics. So I suggest getting a degree in Data Analytics or Data Science.
Updated
Nicole’s Answer
Hi Mia! Great question!
To add to the awesome answer that has already been provided, I would suggest to you that you consider getting involved in tasks that start with understanding what your data is. In other words, data exists because someone decides that there needs to be some sort of record of a transaction. That record of transaction is usually created by someone doing a task. That task could be the sale of an item, the creation of a song, a data entry task...it could be anything. But that anything then ends up being recorded somewhere...in a database somewhere.
What I am suggesting may sound a little weird but what I am trying to share is that is important to "know your data"...where it comes from and why. Knowing your data makes the work that you do around problem solving and visualizing a much more credible endeavor. I can say for myself, there was a time when I had a summer job doing data entry. I then learned that the information I was entering was ending up on a spreadsheet that calculated how many sales of a particular product happened in a given week.
Consider a summer job maybe? Where you work in a place where you get to enter or monitor how records (otherwise known as rows), how records get into a database. Understanding where they come from. Understanding what information in those records change...when and why. You may find that to be a helpful first step in your journey to becoming a great data analyst!
I hope you find this information helpful. Best of luck to you!
To add to the awesome answer that has already been provided, I would suggest to you that you consider getting involved in tasks that start with understanding what your data is. In other words, data exists because someone decides that there needs to be some sort of record of a transaction. That record of transaction is usually created by someone doing a task. That task could be the sale of an item, the creation of a song, a data entry task...it could be anything. But that anything then ends up being recorded somewhere...in a database somewhere.
What I am suggesting may sound a little weird but what I am trying to share is that is important to "know your data"...where it comes from and why. Knowing your data makes the work that you do around problem solving and visualizing a much more credible endeavor. I can say for myself, there was a time when I had a summer job doing data entry. I then learned that the information I was entering was ending up on a spreadsheet that calculated how many sales of a particular product happened in a given week.
Consider a summer job maybe? Where you work in a place where you get to enter or monitor how records (otherwise known as rows), how records get into a database. Understanding where they come from. Understanding what information in those records change...when and why. You may find that to be a helpful first step in your journey to becoming a great data analyst!
I hope you find this information helpful. Best of luck to you!
Updated
Alina’s Answer
I stumbled upon Data Analytics quite unexpectedly. Initially, I worked in the mental health sector and later transitioned into Human Resources through an Employee Assistance program provider. HR allowed me to combine my passion for human behavior and business. While pursuing my Masters in Public Administration with a focus on HR, I took statistics classes and performed well, but never imagined I'd use that knowledge extensively. Little did I know! My career journey led me to a HR focused position over a decade ago, and for the past five years, I've been immersed in Talent Data Analytics and Reporting. This experience has opened up a whole new world for my career growth. Utilizing data is essential in any industry, especially HR, for making informed business decisions and forecasts. I've discovered that I genuinely enjoy working with data, whether it's uncovering insights to guide the business or supporting employee engagement.
If you're interested in data and reporting, my advice is not to fear learning and using it. Often, people avoid data because they perceive it as difficult to comprehend or explain (thinking they're not good at science or math). If data intrigues you, consider taking courses to learn and stay updated on new technologies. Don't hesitate to dive in and experiment. Being flexible and open to trying new things is the key to discovering your capabilities and potentially unlocking a whole new career path.
A degree specifically in data science isn't always necessary, as it depends on the role you'll be performing. However, if you wish, you can certainly pursue more specialized degrees with a focus on Data Science.
If you're interested in data and reporting, my advice is not to fear learning and using it. Often, people avoid data because they perceive it as difficult to comprehend or explain (thinking they're not good at science or math). If data intrigues you, consider taking courses to learn and stay updated on new technologies. Don't hesitate to dive in and experiment. Being flexible and open to trying new things is the key to discovering your capabilities and potentially unlocking a whole new career path.
A degree specifically in data science isn't always necessary, as it depends on the role you'll be performing. However, if you wish, you can certainly pursue more specialized degrees with a focus on Data Science.
Updated
Phung’s Answer
Hello Mia!
You've got some fantastic questions! As a data analyst, your role can differ based on the stakeholders you collaborate with, and this might vary depending on the job you choose. You could work with sales teams to examine sales data, HR teams, data science teams, or product owners. In my role as a data analyst at an accounting firm, I assist audit teams in analyzing journal entry data and creating visualizations to better assess fraud risk, among other tasks. I also collaborate with product owner teams to develop ideas for enhancing our internal tools for data analysts. In short, you'll have plenty of opportunities to work with others. If you're new to the job market, a manager or senior colleague may be available to offer assistance and guidance on projects, ensuring that you're part of a team.
Regarding your second question, as a data analyst at an accounting firm, you'll be expected to analyze journal entry data and develop visualizations to help audit teams identify patterns and risks. You might work with messy, large datasets that require cleaning and organizing to make them valuable for your stakeholders. As others have mentioned, understanding the data is crucial for knowing how to clean and utilize it effectively.
Finally, having a certification or degree can certainly be beneficial for entering this career. However, I've also seen people succeed through self-learning, bootcamps, and other avenues. Personally, I studied accounting during my undergraduate years and later became interested in data analytics, leading me to pursue a master's degree in the field. This degree allowed me to network with others in the industry and secure a position at a big 4 accounting firm. While they seek candidates with data analysis degrees, having a background or experience in accounting is also valuable. Gaining diverse experiences beyond data analysis can be advantageous. You don't necessarily need multiple degrees, but consider applying for internships while in school to broaden your experience. It might not always be easy, so creating and showcasing your own projects can also help. For example, while pursuing my master's degree, I worked as a student ambassador, primarily making calls to students. I proposed using my skills to develop a program that analyzed the time spent on calls and the number of calls made each week by student ambassadors. I created this opportunity for myself and included it on my resume. Data analytics is a vast field with numerous possibilities.
Best of luck on your journey to becoming a data analyst!
You've got some fantastic questions! As a data analyst, your role can differ based on the stakeholders you collaborate with, and this might vary depending on the job you choose. You could work with sales teams to examine sales data, HR teams, data science teams, or product owners. In my role as a data analyst at an accounting firm, I assist audit teams in analyzing journal entry data and creating visualizations to better assess fraud risk, among other tasks. I also collaborate with product owner teams to develop ideas for enhancing our internal tools for data analysts. In short, you'll have plenty of opportunities to work with others. If you're new to the job market, a manager or senior colleague may be available to offer assistance and guidance on projects, ensuring that you're part of a team.
Regarding your second question, as a data analyst at an accounting firm, you'll be expected to analyze journal entry data and develop visualizations to help audit teams identify patterns and risks. You might work with messy, large datasets that require cleaning and organizing to make them valuable for your stakeholders. As others have mentioned, understanding the data is crucial for knowing how to clean and utilize it effectively.
Finally, having a certification or degree can certainly be beneficial for entering this career. However, I've also seen people succeed through self-learning, bootcamps, and other avenues. Personally, I studied accounting during my undergraduate years and later became interested in data analytics, leading me to pursue a master's degree in the field. This degree allowed me to network with others in the industry and secure a position at a big 4 accounting firm. While they seek candidates with data analysis degrees, having a background or experience in accounting is also valuable. Gaining diverse experiences beyond data analysis can be advantageous. You don't necessarily need multiple degrees, but consider applying for internships while in school to broaden your experience. It might not always be easy, so creating and showcasing your own projects can also help. For example, while pursuing my master's degree, I worked as a student ambassador, primarily making calls to students. I proposed using my skills to develop a program that analyzed the time spent on calls and the number of calls made each week by student ambassadors. I created this opportunity for myself and included it on my resume. Data analytics is a vast field with numerous possibilities.
Best of luck on your journey to becoming a data analyst!
Updated
Jennifer’s Answer
Hello there! Embarking on the journey to become a data analyst is an exciting one, full of opportunities to learn and grow. A good starting point would be to familiarize yourself with Excel and Google Sheets. Once you've got a good handle on these, it's time to dive into the world of code writing. Languages like SQL and Python will become your new best friends.
But it's not just about numbers and codes. A successful data analyst also knows how to weave data into compelling stories. Luckily, there are fantastic software programs, such as Tableau, that can assist you in mastering this art of data storytelling.
Don't worry about the cost of learning. The internet is brimming with free training resources. Additionally, you can find helpful books like "SQL for Dummies" on Amazon to kickstart your learning journey.
Remember, teamwork makes the dream work! Collaborating with fellow data analysts can greatly enhance data accuracy and the quality of the final product. As for me, I currently work with telecommunications data.
And yes, earning certifications can give you a significant boost on this journey. So, gear up and get ready to embrace the fascinating world of data analysis!
But it's not just about numbers and codes. A successful data analyst also knows how to weave data into compelling stories. Luckily, there are fantastic software programs, such as Tableau, that can assist you in mastering this art of data storytelling.
Don't worry about the cost of learning. The internet is brimming with free training resources. Additionally, you can find helpful books like "SQL for Dummies" on Amazon to kickstart your learning journey.
Remember, teamwork makes the dream work! Collaborating with fellow data analysts can greatly enhance data accuracy and the quality of the final product. As for me, I currently work with telecommunications data.
And yes, earning certifications can give you a significant boost on this journey. So, gear up and get ready to embrace the fascinating world of data analysis!