|Register On Nairaland / LOGIN! / Trending / Recent / New|
Stats: 2,964,305 members, 7,193,083 topics. Date: Tuesday, 29 November 2022 at 11:17 PM
|Pro Tips For Becoming A Data Analyst by DataWiz: 12:40pm On Dec 25, 2021|
My name is John Wiz. I presently work as a data analyst for a large retail store with over 30 branches and presence in over 10 states. This post is intended to guide prospective data analysts as they journey through the world of data analytics. I am a Microsoft Certified Data Analyst Associate and my take home right now is over N450,000.00 per month based on my experience. It is also worth mentioning that on the average a data analyst earns around N160,000.00 based on salary data on Glassdoor. It's a good choice for those who want to transition into Managerial careers also.
You might be thinking if data analysis is a risk worth taking and would be relevant in years to come. It's okay to have this kind of thoughts especially when making a career choice or transitioning to a different career path. The good news is that there is no activity in life that does not generate data, this implies that to better understand the world we are there will always be need to process this data to gain valuable insights that can improve our standard of living and present new exciting opportunities to explore.
Who is a data analyst?
A data analyst is a person who collects, transforms, process, and analyse data in order to find insights, patterns and answers to business questions. Most organizations are seeing the need for a data analyst and over the past few years the value placed on the data analysts has increased. According to Glassdoor, data analysis is one of the top 10 skills to have at the moment as it cuts across all sectors of the economy. You are guaranteed to get your return on investment should you venture into it.
What skills do I need to become a data analyst?
Your skills are the qualities or competencies you possess to carry out your job effectively. As a data analyst you will require both interpersonal and technical skills.
What do I mean by interpersonal skills?
Interpersonal skills are social skills that help you relate well with others in your organisation. They are relationship management skills that helps foster a good work environment and softens the ground for you to use your technical skills. They include :
1) Communication skills: ability to explain things with clarity
2) Listening skills
3) Emotional Intelligence
4) Team work
5) Relationship management
What are technical skills?
These are sets of abilities or knowledge used to perform analytical tasks. These skills most times stand you out from the rest during the interview process. They include:
1) Proficiency in the use of spread sheets like Excel, Google sheets etc
2) Proficiency in Structured Query Language( SQL), SQL is the language we use to communicate with databases
3) Big data visualization tools like PowerBI, Tableau, Google Data Studio
4) Programming languages like Python or R
How do I learn these skills and how long will it take to get proficient at them?
Knowledge is everywhere these days. It takes grit to actually follow a plan and complete it. If you are really interested in becoming an analyst you can get lots of tutorials on youtube. But most of these courses on youtube are not well curated. So I will advise you start by registering for the Google Professional Data Analytics Course on Coursera https://www.coursera.org/professional-certificates/google-data-analytics This course has well curated contents by well-versed professionals that will teach you all the rudimentary things and skills you need to know to become a competent data analyst. They include spreadsheets, databases, roles in data analytics ,data analytics process, data analytics frameworks etc. You can apply for financial aid and do the course at zero cost. At the end of the course, Google will issue you a professional certificate and help you in your search for a job. In 6 months you should be done with the certification and be confident you can confidently apply for an entry level data analyst role
|Re: Pro Tips For Becoming A Data Analyst by FENZY24(m): 4:12pm On Dec 25, 2021|
Would like to connect with you, can I get ur digits ?
|Re: Pro Tips For Becoming A Data Analyst by Udoboss(m): 7:24pm On Dec 25, 2021|
I would love to learn
|Re: Pro Tips For Becoming A Data Analyst by nuel000: 12:53am On Dec 26, 2021|
What was your original field of study and hoe did you transition?
|Re: Pro Tips For Becoming A Data Analyst by DataWiz: 7:52pm On Dec 26, 2021|
I read Electrical Engineering. However, it doesn't really matter your field of study, as an analyst you just need to know the foundation, the data analysis process, and some software applications to aid your analysis and you are good to go. You can equally transition to a business analyst that helps businesses to investigate and analyse business situations, identify and evaluate various options for solving those business problems, define and elaborate business requirements that those options must have, then present a recommended course of action for business managers to adopt. For the role of a business analyst you will need to learn business analysis framework like LeanSigma etc. The good thing about all this is that whatsoever skill you learn is relevant and can be applied in other domains
|Re: Pro Tips For Becoming A Data Analyst by DataWiz: 8:00pm On Dec 26, 2021|
You can start by applying for registering for Google Data Analytics Course on Coursera https://www.coursera.org/professional-certificates/google-data-analytics This course has well curated contents by well-versed professionals that will teach you all the rudimentary things and skills you need to know to become a competent data analyst. They include spreadsheets, databases, stakeholders in data analytics ,data analytics process, data analytics frameworks etc. You can apply for financial aid and do the course at zero cost. At the end of the course, Google will issue you a professional certificate and help you in your search for a job.
Also you can equally register on kaggle.com Kaggle is a website for data analysts and data scientist. It is owned by google. There are a lot of beginner projects and tutorials to help you start your data analytics journey.
|Re: Pro Tips For Becoming A Data Analyst by nuel000: 10:14pm On Dec 26, 2021|
DataWiz:interesting �...for how long have u been working as a data analyst and how long did it take to get a good job after various certifications...and what certification would employers require if they were to hire a data analyst... thanks for ur anticipated response
|Re: Pro Tips For Becoming A Data Analyst by DataWiz: 10:35pm On Dec 26, 2021|
Good question. I have worked as an analyst for 4 years. However, years of experience shouldn't deter you from getting entry level roles or graduate trainee roles that only require your ability to learn quickly on the job, think critically and solve business problems in a logical, and step by step manner. I acquired most of my certifications in 2021. After acquiring my Google Data Analyst Certification, Microsoft Certified Data Analyst Associate Certification( Certification on Microsoft Power BI which is a business intelligence tool for data visualization) and Google Python Certification. I got a better job in 6 months that's triple of my previous earning. I also got some interviews with some big companies and I bargained for as much as N700k although I didn't plan to leave because I just resumed my current job not too long ago. I just wanted to test how much value companies place on me.
But for beginners you can actually do a Microsoft Azure Data Fundamental Certification. It's called DP900. There is also a well curated content by Microsoft to help you understand basic data concepts and prepare for the exam. Also your personal projects will be a plus during interviews as it shows your level of exposure. There are lots of data challenges on linkedin that provide datasets for data analysts to test their skill and increase their exposure.
I will be looking at data analytics managerial positions in 2022 so my focus will be on getting Google Project Management Certification and Project management professional certification from Project management institute. Then other certifications such as Microsoft Certified Data Scientist Associate and Microsoft Certified Azure Database Administrator.
2 Likes 1 Share
|Re: Pro Tips For Becoming A Data Analyst by darkelf: 11:11pm On Dec 26, 2021|
You gave a misleading and dishonest take
But continue sha
People will find out themselves in a hard and bitter way
|Re: Pro Tips For Becoming A Data Analyst by DataWiz: 11:23pm On Dec 26, 2021|
What's misleading and dishonest? The essence of the post is to properly guide aspiring data analysts. If there's anything you think I said that's misleading kindly let me know so I can clarify things if need be and others can learn from you too.
|Re: Pro Tips For Becoming A Data Analyst by nuel000: 11:28pm On Dec 26, 2021|
DataWiz:can I have your contact please, I need proper guidance on embarking on this data analysis, so I don't move haphazardly...it's part of my plan to transition into data analysis in 2022...good thing I stumbled on this
|Re: Pro Tips For Becoming A Data Analyst by darkelf: 11:28pm On Dec 26, 2021|
A data analyst doesn't really need Python/R skills at least for a start. SQL (PostGre and MS SQL), Excel, Tableau/Power BI are more important. In fact, they should start with SQL.
The Job market here in Naija is different. A lot of unemployed "Data Analysts" out there. Don't let Glassdoor and Coursera mislead you.
I will type more as I remember from experience
Beginners should focus more on racking up experience through projects and internships (even though unpaid)
|Re: Pro Tips For Becoming A Data Analyst by DataWiz: 11:38pm On Dec 26, 2021|
You didn't bother to read my post well and my response to the question on basic certifications one needs before applying for an analyst role. There is nothing misleading about my post. As a beginner you might not even require any of those technical skills to get a job. Your ability to learn fast and how smart or intelligent you are can help you scale through. You can always learn on the job, and most times, there are experienced hands within the company to handhold talents. As you grow you will require those technical skills to do your day's job with accuracy and speed. Having these skills gives you a very big advantage during interview compared to one without those skills. The thing is to have a plan and work towards that plan.
There is no day I do not use python, spreadsheet, powerbi or SQL. I use python to automate most of my work. That's why I advised to start with the Google Data Analytics professional certificate because it will take them from basic concepts of data, spreadsheets, SQL and databases, data visualization tools like Tableau and R programming in that progression, from beginners to advanced stage. I never said it's a guarantee for job placement but there is a very high chance of getting employed with this skill. Just learn and wait for opportunity to present itself. It will always come. Besides one should learn SQL only when you are well grounded in spreadsheets. Learning SQL before spreadsheets is a very wrong approach.
|Re: Pro Tips For Becoming A Data Analyst by darkelf: 12:07am On Dec 27, 2021|
That is your own opinion
Most would say start with SQL
And I read your post well
|Re: Pro Tips For Becoming A Data Analyst by COdeGenesis: 12:19am On Dec 27, 2021|
|Re: Pro Tips For Becoming A Data Analyst by darkelf: 12:34am On Dec 27, 2021|
Bros, I said most start learning analysis with SQL. I didn't say they use it alone
Please read carefully next time
|Re: Pro Tips For Becoming A Data Analyst by Unugwa12: 1:03am On Dec 27, 2021|
I am currently enrolled in the google certificate on Coursera, I am on R programming at the moment. I started the journey earlier this year.
What I need now is experience even unpaid internships I can use to learn
|Re: Pro Tips For Becoming A Data Analyst by DataWiz: 7:48am On Dec 27, 2021|
There are a lot of data challenges on lInkedin and kaggle you can participate in to test your skills while you wait for a job opportunity. You can add them to your cv as project you have completed. Here is a couple of them:
1) Onyx Data https://www.linkedin.com/company/onyxdata/ : Onyx data offers relevant datasets for data analysts every month. There is also a cash reward of 50 Euros and online scholarships for top 3 winners.
2) Maven Analytics https://www.linkedin.com/company/maven-analytics/ : Maven offers dataset monthly to help data analysts sharpen their skills
3) Festman Learning Hub https://www.linkedin.com/company/festman/
4) Dchallenger https://www.linkedin.com/company/d-challenger/
You can equally follow up with some HRs on linkedin and chat them up about some possible placements. Also aggressively apply for jobs on Linkedin, Indeed and Glassdoor. I am sure one will click soon. I will also be starting up a data challenge on Nairaland in January 2022 for data enthusiast. Just keep checking and follow me.
2 Likes 1 Share
|Re: Pro Tips For Becoming A Data Analyst by Unugwa12: 1:48pm On Dec 27, 2021|
Thank you boss
|Re: Pro Tips For Becoming A Data Analyst by azelab: 4:36pm On Dec 27, 2021|
I would like to be part of this?
|Re: Pro Tips For Becoming A Data Analyst by Chidoy: 7:25pm On Dec 27, 2021|
How much does it cost to learn it on coursera?
|Re: Pro Tips For Becoming A Data Analyst by Unugwa12: 4:40am On Dec 28, 2021|
u can always get financial aid, though it takes 15 days to process
For what to write in financial aid; just google "How to apply for Financial aid example"
Then tweak any example u see to suit you
Although there are 8 modules and you apply for financial aid each time you are going for the next module
|Re: Pro Tips For Becoming A Data Analyst by darkelf: 10:43pm On Dec 28, 2021|
You were right and I was wrong. I admit
May be helpful to others here
Note the following skills please - Excel, SQL, Tableau
|Re: Pro Tips For Becoming A Data Analyst by nuel000: 9:08am On Jan 13|
DataWiz:hello sir, I've discovered there is Google Data Analytics Professional Certificate and IBM data Analyst Professional Certificate which of these is more recognized and carries more authenticity?
|Re: Pro Tips For Becoming A Data Analyst by Laryfrosh: 11:49am On Jan 13|
Data analyst jobs are remote or they need to report at a physical location?
|Re: Pro Tips For Becoming A Data Analyst by Chidoy: 12:23pm On Jun 18|
DataWiz Thank you for this Tips.
After going through this your post, I enrolled on Google analytics course on January. By the grace of God I finished it toward the end of last month (may).
The challenge I have now is how to master those analytics tools like SQL, Tableau, R and python programming. And how to secure data analytics jobs.
Hoping to get your positive response. Thanks
|Re: Pro Tips For Becoming A Data Analyst by dbeautyful: 9:05pm On Jul 30|
So my subscription expired yesterday and would not auto-renew due to a card issue.
I renewed my subscription today and noticed that all of the history on my Google Data Analytics Professional Certificate course is gone, although it shows 2 out of the 8 modules completed (Please see attached screenshot). I also have my certificates for the 2 modules completed.
My questions are:
1. How do I get back the history (completed assignments, readings and videos watched)
2. Is it fine if I just continue where I stopped without worrying about the above.
|Re: Pro Tips For Becoming A Data Analyst by chimeremodlyn: 10:18am On Jul 31|
|Re: Pro Tips For Becoming A Data Analyst by chimeremodlyn: 10:19am On Jul 31|
By projects, what kind of projects and how do we come about the projects. Im talking about somebody who is a total novice
|Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health |
religion celebs tv-movies music-radio literature webmasters programming techmarket
Nairaland - Copyright © 2005 - 2022 Oluwaseun Osewa. All rights reserved. See How To Advertise. 338