Writing ๐ โGuidebook to landing a Data Analyst jobโ. || MS Dynamics 365 CRM & Data || If you learn of my death, pray for me. || Aspiring full house husband.
Data Analytics Interview Preparatory kits
====Data Analytics fit=====
Thread 1 will focus on;
๐Vizualization based questions (PowerBI, Tableau)
๐Questions on connecting to data sources.
โ ๏ธ Be familiar with the most common data sources like Databases, flat files and Web.
1/n
It's an amazing time for Women in banking in Nigeria ๐ณ๐ฌ.
Congratulations to all the amazing women who continue to break barriers and inspire us all.
Access Holdings - Bolaji Agbede
GTBank - Olusanya Miriam
Zenith - Adaora Umeoji
Fidelity - Nneka Onyeali-Ikpe
FCMB - Yemisi Edun
Iโve been told you want to learn PowerBI free ๐. I have compiled a list of all the best videos on YouTube to help achieve your dreams of being a PowerBI developer.
[Thread] ๐งต
โDecisions in my career are based on 3 things;
- Work culture
- Opportunity for growth
- Good remuneration
As long as this organization's goals still aligns with mine in term of this 3, I don't have any reason to leave. I must admit that so far, I love what I'm seeing.โ
For a detailed Data Analyst Portfolio, you want to cover analytics in atleast 3 of these sector;
๐Sales (Analyse a company's sales,Revenue, profitability etc)
๐Finance (P&L statement, Balance sheet etc)
๐Transportation (Rail, Air, Sea or Road all works)
๐Health (Try Malaria,
Data Analyst Interview Series.
Combined Power BI interview Questions and answers.
20 Questions and Sample Answers.
1. What do you know about DAX & have you used it in the past?
โ โI have extensive experience with DAX. Over the years I have used aggregate functions like SUM,
Typically I would ignore tweets like this, but because of the danger of allowing this this โsingle storyโ fester, Iโll address the โtruthโ behind the brown zincs, and the reason why Ibadan is so special. Certainly top 3 city in Nigeria (not number 3 ๐คญ).
Since this tweet is from
As someone who has aced about 85% of Data Analytics interviews I have done with Nigerian, UK and the US companies, I think I qualify to advice people on how to pass their Data Analytics interview.
Hopefully, I can do a thread about it one of these days.
Data Analytics Interview Preparatory kits
====SQL fit=====
Thread 2 will focus on
๐ SQL and Databases based questions
๐ Questions about your SQL Skill
โ ๏ธ Here they want to understand the level you `claim' you are. It is important to give a conservative, yet confident reply.
Most of my friends that didn't Japa with us, have made significant career moves in the last 2 years. The massive Japa has opened doors in mid-management that would typically be closed.
I have multiple friends who are now Managers at different consulting firms, a few others at
Some people hate that some of us with relatively big accounts do not talk about how being in Nigeria is a bane to reaching your career goals in life. To them, Nigeria is a threat to everything good but who are you not to see it? You are either in bed with politicians or on
For years we all knew the definition of โEnglish filmโ in Nigeria. Aside from Ranson Noah, Omotola, Desmond, and Mercy Johnson, every other A listed was from one part of the country. You can watch a popular Nigerian movie and at the end, when it's time to show the cast and crew
My dear Nollywood,
We are slowly pivoting towards a tribal trajectory.
As I skim through, all the amazing language based titles, coming out of the industry.
I cannot help, but see a subtle race, to showcase whose culture is best.
As much as we desire to tell our stories
When my father died, bar 1 or 2 people, we had little financial help from family, and that almost made me resentful.
Months later I asked myself โwhich one of your uncles is rich enough to help you without his own nuclear family suffering for it?โ.
The answer was no one. Most
Do you want to be a Microsoft Data Engineer?
I have compiled a list of some of the best free tutorials on YouTube that can help you achieve your dream.
โAzure
โMS Fabric
โAzure Synapse Analytics
โSSIS & SSAS
โAzure Data Factory
โAzure Databricks
A thread ๐งต
I spent the most of 2021 & 2022 helping people secure international jobs without securing one myself.
Two of my international recruitments were placed on hold after I had completed the interviews and negotiated salary.
When it was my time, Allah said โUK or US?โ
Alhamdulillah.
This action summarizes Phil Jones as a defender. Not the most gifted player, probably not good enough for a team like Man Utd, but you could never doubt his commitment or his willingness to give it all his got.
I don't have a problem with 2 non-religious people getting married but if you're both religious and of separate faith, one would have to bow to another.
If as a religious Muslim man, you marry a religious non-Muslim and you believe your children will somehow end up as Muslims
โณPower BI developer Interview preparatory kit. ๐๐
Below are some of the most popular questions and the "shortest" way I would answer them.
A thread...
๐ Are you comfortable meeting with clients/business for presentation and to collect requirements ?
This is real life.
Bigotry will not ease this suffering, neither will lies and hate. Stealing government funds in hard times such as this is callous, greedy, and wicked. Nigerians must redefine their relationship with those they entrust with their commonwealth.
Hi Data Community,
I'll be offering free individual interview preparatory sections for Data Analytics & Data engineering roles.
Reach out and let make sure that interview feels like a movie you have seen before. You've learnt the skills, lemme show you how to land the job.
Personally, I can't code for shit ๐ญ
My Python is shit,
SQL is shit,
DAX is shit,
JS is shit too
But I understand data structure, I can come up with methodology like it's witchcraft, and to back it all up, I understand computational thinking. That's all I have always needed ๐ค
Both of them are "success".
The God that gave Daud and Suleiman the riches of this life will still serve them the best of the next world.
Allah's mercy and bounties are limitless, why settle for one when you can have both????
To put this Funke Akindele and Toyin Abraham matter to a rest. Let go with the data ๐, after all I'm the data G.
Scope: Top 30 grossing movies.
If we go by their box office performance;
in terms of box office quantity, we will quickly see that Funke has produced or played a
To understand SQL JOINS there are 4 prerequisite things I believe you must know
1) Structured Data
2) Tables
3) Rows and Columns
4) Primary Keys and Foreign Keys.
A thread ๐งต
I have a flat mate thatโs studying Data Analytics, heโs always trying to teach me every new thing he learn. He was trying to explain Data Cleaning to me yesterday. Oti su mi.
When you start your career and start making money, take a lesson from the Igbo & not the Yorubas.
Donโt start using all your savings to buy land. Spend it on developing what brings in money for you first (business or skill). Your wealth would grow faster this way, if Allah wills
Happy Birthday Mubarak Adigun.
Peace be upon me the day I was born, the day I die, and the day I will be raised back to life!
Send me plenty money
0086023574 (Sterling Bank)
Mubarak Adigun/Staff Account
At Access Bank, it took me two years to get to a point where I could afford things most of my colleagues could.
Nigba ti Olorun gbe aranse de bayi ๐ซ ๐ซ ๐ซ ๐คญ, mo kan begbe pe ni.
I wasn't born into wealth, so, beyond having fun and enjoying myself, the plan is to never know poverty again.
Ki elemi sha magba bayi, kosi ma koโdi aimase siwa ๐.
ULTIMATE POWER BI INTERVIEW QUESTION & ANSWER part 1.
RT & Share.
Here are some of the most common questions asked during Data Analyst Interviews covering Power BI. I would advise that you study this religiously for your PowerBI related interviews.
๐งต
1. What do you know
@SirJarus
My supervisor told me before I travelled โNigeria is half filled, half emptyโ, it's all about how one chooses to view it; half filled or half empty.
If you ask me this question on a date, that's the end of our date, you're most likely going to be a problematic person.
How about you just observe my relationship with God and man, and see where i stand with Allah and his messanger?
ARE STRUGGLING WITH SQL? Read this!!
To understand SQL JOINS there are 4 prerequisite things I believe you must know
1) Structured Data
2) Tables
3) Rows and Columns
4) Primary Keys and Foreign Keys.
A thread ๐งต
Just to add that while it is very good to build in public, you can also build a great career in Data and other field in extension if you donโt.
Iโve got great Data guys doing amazingly well and donโt even have any presence.
So donโt feel pressured if you feel uncomfortable.
Dear DataFam,
Let crack the basics of writing SQL today.
FOR ME, there are 3 fundamental concepts to understand before cracking SQL;
- Columns (The Alphabetical part)
- Rows (The numeric parts)
- Tables (single combination of the Rows and columns)
20 MOST COMMON SQL INTERVIEW QUESTIONS.
Did you know that SQL is one of the most used programming language across different tech roles in the world.
If you want to land that dream job, you have to learn SQL.
Thread.
โ What are the differences between a view and a table in
In sha Allah this year Iโll be introducing a lot of people to side analytics jobs so we can all make extra bucks.
Just keep developing that PowerBI and SQL skill ๐.
Follow who know road but HOLD YOUR T FARE.
I wasn't born into wealth, so, beyond having fun and enjoying myself, the plan is to never know poverty again.
Ki elemi sha magba bayi, kosi ma koโdi aimase siwa ๐.
If you learn data analytics from someone that isn't practicing it in reality, you would end up focusing on so many irrelevant stuff.
"Learn SPSS"... se you want to go and write research paper for a university ni ๐คฃ.
Can I load 5 million rows of data into SPSS ๐คฃ๐คฃ๐คฃ
โState of originโ is such a badly used concept, and should be scrapped.
Someone is born in Oyo, to parents born in same Oyo, but you said their state of origin is Delta. How does that make any sense?
Also, it entrenches tribalism.
State of residence is a better system.
FLASH: Governor of Lagos State, Mr
@jidesanwoolu
today received Aminat Yusuf Imoitsemeh, the
@LASUOfficial
Law Graduate that finished with an all-time record CGPA of 5.0, Aminat visited Mr Governor in company of her Parents, Mr and Mrs Yusuf at the Lagos House, Marina.
2 of the most common interview questions for Data Analysts and how to structure your response.
โIntroduce yourself.
๐ Focus on making sure you cover the following;
โyears of experience
โSector of experience (Banking/health care etc)
โArea of experience (Data
Below are some of the things I knew or wish I had known before 30.
- Donโt beat yourself up over past mistakes. For a human that might live another 70 years, you have barely scratched the surface of your being.
- Identify what makes you happy and what motivates you and clitch
Data Challenge Alert โ ๏ธ๐จ
RT and Share.
Create a Data Visualization (using Tableau, PowerBI or Python) to show and rank the most influential Actors in Nigeria.
I will leave you to decide what KPIs you want to use to make this decision and create the data points yourself.
Let do a challenge, for the next 13 days, Iโll pick one Data Analyst interview question and discuss how to answer it in detail.
By day 13, I would have covered 15 of the most common questions in sha Allah. Let learn together.
What Azeez learnt from me in 1 year took me over 3 years to learn with YouTube and Udemy.
Donโt listen to him. Attend bootcamps and get a mentor, you donโt wanna be an headless chicken.
Once you collect your salary, push 80k to a piggyvest account immediately you get paid.
You're left with 250k.
- Kick the 100k you will need to another account. You're left with 150k
- Set aside 40k for your other bills, you already leave in a free house, the least you can do
Common questions in a Data Analyst Interview and how to approach them.
โ QUESTION
How do you communicate your findings to non-technical stakeholders?
๐ HOW TO APPROACH THE QUESTION
As a Data Analyst, you will often be the technical person in cross functional teams, you will
Let do a challenge, for the next 13 days, Iโll pick one Data Analyst interview question and discuss how to answer it in detail.
By day 13, I would have covered 15 of the most common questions in sha Allah. Let learn together.
An x friend from SE that I personally wrote his CV, prepared him for 3 stages of interviews, till he got a job that paid him over 1m in salary and I didn't collect 1 naira from him, called me a bigot for not supporting Obi.
I have forgiven, but I'll not forget.
Hasbiyallahu ๐.
The Prize are as follows;
- Best in Data Storytelling -
#10
,000
- Best Innovation -
#10
,000
- Best UI/UX -
#10
,000
3rd Place -
#20
,000
2nd Place -
#40
,000
1st Place -
#50
,000
Best in Data Storytelling -
@iam_daniiell
@KingTaiwo_
Spot on.
If you do the big 4 for 4 years, and spend like a year as a senior associate, you might be able to get Assistant Manager in a Bank. That AM took someone else 12 years to get as a star boy in the bank.
All over the world, people would rather avoid Jehovah Witnesses when they come to preach than just say โNoโ.
Ever wondered why?
Jehovah's Witnesses are well-trained in the act of evangelism. They didn't just pick up their Bible and start walking around looking for who to preach
My first 3 Tableau Dashboards from over 4 years ago when I decided to learn Tableau ๐คญ(14 days challenge).
I'm a PowerBI man by the way.
The journey has been good.
My first 3 Tableau Dashboards from over 4 years ago when I decided to learn Tableau ๐คญ(14 days challenge).
I'm a PowerBI man by the way.
The journey has been good.
@ridwandimejiojo
If you donโt trust them, you help from a distant. Donโt allow them to become everyday visitors of your house, especially if they didnโt use to check up on him them too.
Talk mostly on the phone, send money through transfer, let them know you canโt help on days when things are
๐How to stand out in very meeting.
I worked with a guy we all considered to be very smart, he wasn't necessarily technically exceptional, but he stood out in every meeting.
After studying him closely, I realised that he had two approaches for standing out in every meeting;
I remember one story like that.
When I was in Access Bank Training School, I decided to celebrate birthday for all my classmates as a way of cheering them up(those were tough times for most). On their birthday, Iโll take out money from my pocket and a few like minds without
What we are trying to build with
@muslimtechhub
is a platform that transcends any form of division within Islam. A platform that gives Muslims the opportunity to learn different technological skills and be gainfully employed.
How can you contribute;
- Follow, RT and share