10 Mistakes to avoid when applying to jobs

🚩 Not having a professional help review your resume

🚩 Submitting a Word doc version of your resume instead of PDF

🚩 Having tasks/responsibilities under the Experience section instead of achievements

#jessithreads 🚩 Not quantifying your impact on your previous roles

🚩 Not using ChatGPT or a similar tool to improve your resume

🚩 Submitting 100s of applications with no response/rejections w/o stepping back to find out what’s wrong

[3-6]

Data Analyst Interview Questions Pt. 2 🗣️

Welcome to Part 2 of this series. After covering 40 questions on Excel, Python & SQL in Pt 1, this thread covers 30 questions on BI tools and Scenario-based analysis encountered in previous interviews. Read and do share #jessithreads BI Tools General Questions
41. Rate either your Tableau, Looker Studio or Power BI skills?
42. What’s your process for creating a new dashboard for stakeholders?
43. How would you improve user-friendliness on a dashboard?
44. How do you determine KPIs for a new dashboard project?

Data Analyst Interview Questions Pt. 1🗣️

Having done a fair share interviews at different hiring stages since transitioning to Data Analytics in 2021, here are 40 questions I've been asked. I split them into General questions, Excel, Python & SQL. Do read & share! #jessithreads General Questions
1. Talk to us about this project (from your portfolio)
2. What could you have done to improve the project?
3. How would you analyze a table with 1M rows?
4. What's a typical day like in your current role?
5. What’s a good feedback you received? - your strengths

Tips for Getting Recruiter inMails on LinkedIn 🧵

Talent hunters actively seek professionals on LinkedIn for roles. Remember, inMails are your ticket to HR screening, getting you closer to your dream job. Use these tips in conjunction with direct job applications. #jessithreads Before we kick off & so you know I’m not blabbing ☺️, these are recent inMails I received. I know others getting same. Note that not all jobs might be suitable for you. If you find a good fit and indicate interest, it gets you to the phone screening stage.

Writing a Winning Resume

I review 2-3 resumes per week. One common error I see is people having responsibilities in their “Experience section” instead of accomplishment statements. To correct that, please use this format:

“𝑫𝒊𝒅” 𝑿 𝒖𝒔𝒊𝒏𝒈 𝒀 𝒕𝒐 𝒈𝒆𝒕 𝒁

Details 👇🏽 1/ “Did”

This is the action word & can be replaced with other words to portray your accomplishments.

Examples:
Led, Created, Built, Improved, Supervised, Coordinated, Managed, Standardized, Reorganized, Established, Transformed

See end of thread for link on more action words

Building your Data Analyst/Scientist SQL portfolio - Google Cloud edition

1. Create a @googlecloud account
2. Find a public dataset on BigQuery
3. Use Google BigQuery to write SQL statements to pull the data
4. Create a GitHub repo & add your SQL queries

More 👇🏽 5. Take screenshots of your queries
6. Analyze the data in Excel or any BI tool
7. Do a write-up explaining your process with screenshots

Doing this will prove your exp. in SQL, GCP, GitHub & Excel/BI tool. See 2 links below - a BigQuery project & how to access public datasets.

Popular Question: “What industry should I focus on when starting out as a data scientist or analyst?”

A: My opinion is you should cast a wider net in the job market at first. At the interview stage for entry level roles, you’d be tested on your analytical skills.

More below👇🏽 2/ Companies are interested in how you can solve problems and how conversant you are with their existing Tech stack.

When I pivoted to DS & A, my first job in HR Analytics and I had no previous experience. Now, I can talk about HR metrics in my sleep.

I planned to do a thread about my wedding but kept putting it off. A lot of folks asked me how much we spent to help them plan towards theirs 💃🏽, so let me address that first. Total expenses came up to ~$22K (₦15M) incl. honeymoon expenses

Details x pictures👇🏽 2/ First of, when we started planning for the wedding back in April, I said we shouldn’t spend more than $7,400 (₦5M) for 100 guests 😭. I didn’t know I was joking with myself especially cos the wedding was in Lagos & was a 2-day event. Plus, we ended up with 200+ guests.

Popular Question: “How do I know when I’m ready to apply for a Tech job after months of learning?”

A: Once you’ve learnt the minimum required skills & have 2 solid projects (varies by field), you should be confident to start applying.

Want to read more? here’s my story 👇🏽 2/ I struggled a lot with that question when I was pivoting to Data Science & Analytics. After 3 months of learning, I had 2 awesome E2E Data Science projects with dashboards and still felt it wasn’t enough. However, I was lying to myself.

For folks moving to Canada 🇨🇦 soon on PR, here are some areas to consider based on your career/lifestyle goal:

✨ Tech; consider Toronto/GTA, Montreal, Vancouver
✨ Oil & gas: Alberta, Saskatchewan, Newfoundland
✨ don’t want to freeze to dea*h: Vancouver, Toronto

More 👇🏽 2/
• Enjoyment: Toronto, Montreal
• Low cost of living: AB, some cities in QC, SK
• Get jobs quick: QC, Winnipeg, some ON cities, SK, Calgary (source: @StatCan_eng lowest unemployment rates ‘22)

I’ll do a post of jobs you can easily get in 🇨🇦 prior landing your dream job soon

Last week, I got to 40K audience on Twitter & 30K on LinkedIn 🎉. When I decided to grow my audience in March, Twitter was 2.5K & LinkedIn was 7K+.

Some tips that helped me grow:

✨Be real
✨Have fun
✨Write daily
✨Use Analytics
✨Have a niche

Details below 👇🏽 ✨ Be real - a lot of what I share are from my experiences. Don’t lie or invent stuff for attention

✨ Have fun - I don’t stress myself posting daily. I post when I feel inspired to avoid burnout. Plus I’ve a FT job & also trying to be a first time Technical author 🥲

Are you looking to gain real-world Tech experience while learning or before you land a job?

Volunteering is a great way to do and you can include it on your resume.

Here’s a list of 13 organizations you can be a part of. For my data folks, there are specific ones for you 👇🏽 1/ Democracy Lab

They connect Tech for good projects with skilled volunteers. Each project has specific required roles.

Category: UI/UX, Data, Software Engr, Product Mgt etc.

democracylab.org

21 TIPS TO HELP YOU EXCEL IN A NEW JOB ✨

Starting a new role can be daunting especially if it's your first one. In this thread, I compiled a list of tips that have helped me excel within the first 6 months. Have fun reading & feel free to add more points or questions 👇🏽 Month 1

• Learn company culture, policies & other HR codes of conduct
• Register for health insurance, pension & other benefits (if applicable)
• Meet your manager 1:1 once a week if possible as you’ll most likely have questions piled each week

✨ My Data Analytics Roadmap ✨

My generic answer to those starting out as data analysts has always been start with Excel, SQL then move to a BI tool. That is vague. This guide has a list of major topics you should learn for each tool. Pay attention to the footnote.

A thread 🧵 2/ ✨My Data Analytics Roadmap contd. ✨

Python is optional but it’s a definite nice-to-have if dealing with big data. Please note that this list is not exhaustive. A major part of my learning has come from working on projects and reviewing codes others wrote.

this show reveals a lot of things happening in our current society that leaves a trail of broken people in its path called life cos:

• how are you in love with a stranger after less than 1 week of meeting them - not to talk of being intimate with them…

contd. • or is it my babe that’s looking for every means to attach herself with a man. depicts how desperate some people are for attachment or to “belong to a group” - herd mentality, which can be as a result of underlying issues

• also, my gender tends to forget that..

The other day while dressing up for work, my dress ripped a bit on the side. I got my sewing kit & while stitching it up, I remembered how my late mum had taught my sis & I how to sew in Junior high. Everything I am today, I owe to her. Yesterday made it 7 years she was gone. My acts of service to others now is due to all her selfless acts I saw over the years 😊. I remember back then in Covenant Uni, whenever she came to visit, she would prepare food for all my course-mates. You’d think it was my birthday. Everyone looked forward to her visits.

✨ Data Viz Inspiration ✨

In this thread, you’ll find numerous amazing dashboards done by these folks @addy_xls @Rita_tyna @JAEmmanuel9 @Sister_peace01 @_EightKing @GbemiAdekoya @thee_regent. Kicking it off, here is one from @addy_xls. She did this using Excel.

More on this 🧵 1.

https://twitter.com/addy_xls/status/1535207068881362944

A close friend did Flutterwave Graduate Trainee test recently. Most of the questions were on Microsoft PowerPoint and Excel. I saw the questions & I know that ~70% of the average Nigerian graduates would not be able to answer them w/o having to use Google. Not trying to shade

👇🏽 I’ve had to interact with graduates of Nigerian universities incl. Private unis. Most of them don’t need to use Excel till their final year and even when they do, they probably outsource the projects or use very basic functions. The Flutterwave questions were quite technical.

👇🏽

Are you getting overwhelmed with numerous resources on your data or tech journey?

I’ve seen people complain about this & I was also a “victim” when I started my “pivot to tech” journey in 2020. In this short thread 🧵, I will list a few things that helped me. 2/ What to do?

✨ Create a road map. E.g. as a data analyst, you’d need to learn Basic Stats, Excel, SQL & PowerBI or Tableau, write these out

✨Assign one course (at most two) to each skill

✨ Target one project after each course

✨Stick to the plan above & forget the noise

Is your LinkedIn profile helping you get referrals and job opportunities? Yes? No? If No, please read this thread 🧵and share with others! 2/ My LinkedIn profile has been getting me voluntary referrals and a lot of recruiter InMails that have led to interviews since 2020. In this thread, I talk about:
✨updating your profile pic, headline & other sections
✨mistakes to avoid
✨posting your work on LinkedIn

Yes, I pivoted from Engineering to Data Analytics in 7 months

What people don’t see:
✨ Spent 12-14 hours on Coursera during weekends
✨ Worked on projects after completing a course
✨ Applied to over 250 jobs, interviewed with 27 companies before accepting an offer

contd 2/

✨ Worked 10-hour days as a Tech Support Specialist (wanted an IT role) so I could have 3 days off to study

✨ Disturbed my siblings & friends to review my work regularly

✨ For my projects, I wrote articles, commented on my code properly, made dashboards & posted

contd.