J.A Olaoye
@JA_Olaoye
Followers
10,722
Following
2,927
Media
1,996
Statuses
29,006
Data || AI || Business Process Automation || LinkedIn:
Earth
Joined November 2014
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Oprah
• 612869 Tweets
اليوم الوطني
• 267582 Tweets
Papa
• 245924 Tweets
HYUNJIN AT VERSACE MFW
• 198050 Tweets
اسرائيل
• 183821 Tweets
Jill Biden
• 95747 Tweets
#النصر_الاتفاق
• 69248 Tweets
Pimienta
• 38551 Tweets
ابراهيم عقيل
• 35588 Tweets
#GeForceSummer
• 30629 Tweets
I'M VOTING
• 30624 Tweets
YOU'RE GOING TO JAIL
• 28188 Tweets
対象作品
• 27821 Tweets
双葉社フェア開催
• 24620 Tweets
OBGYN
• 22111 Tweets
Vaticano
• 21358 Tweets
Sevilla
• 19655 Tweets
Seyran
• 15847 Tweets
#KızılcıkŞerbeti
• 14565 Tweets
Bergoglio
• 11865 Tweets
Pinned Tweet
If you’re still not clear on how to set up your SQL learning environment. Here is a link for you to get started from end to end in simple steps.
Remember to subscribe
. Enjoy!!!
To get going is easy:
1. Download SQL Server
2. Install SSMS
3. Download adventureworks OLTP .bak file
4. Restore the adventureworks file.
Use to start your learning and use the adventure works to practice.
11
101
356
1
10
47
Python is the language. Data Engineering is the calling. Learn it with dedication. If you're starting look for these guys Corey Schafer or Mosh on YouTube. You may do the Mosh free YouTube first before heading to Schafer. Don't thank me later. Just learn.😊
172
2K
8K
If you want to learn SQL without doubt. Check this guy out... "Kudvenkat beginners SQL on YouTube". It has about 150 videos.
He has arranged the Playlist in such a way that if you're judicious with your learning,
#SQL
will no longer be a threat to you. Don't thank me later 😊.
35
928
3K
You guys make it very difficult to evangelize.
He frustrates the devices of the crafty, So that their hands cannot carry out their plans against Sanwoolu. Thank you Lord for the imminent victory
#sanwoagain
2K
276
1K
66
694
2K
Power Bi + Excel +Tableau + SQL
Project based + Certification 3-months Mentorship program coming to you soon...
176
336
2K
Aspiring Data Analyst, don't be tempted to jump to R or Python or fancy things as a beginner. only few companies rely on Python or R for their daily business operations reporting. They will be using either Power BI, Excel, Tableau, or even Looker, SQL. Don't waste your effort now
44
236
1K
I am planning to build a pool of Data Analyst and Data Engineers around Africa that will serve Africa. So let's keep learning and relating.
104
120
999
Excel - 2 to 3 weeks
SQL - 2 to 3 weeks
Power BI - 2 to 3 weeks.
The above lifts you off the ground only. Learning is a lifelong thing in this journey. My message is to newbies and those aspiring.
22
251
926
Data Analyst share your portfolio or screenshot of visualization you developed.
I want to see something. Don’t be shy. Share your work. The globe is watching.
208
177
918
Okay you need Mentorship in Data Analytics and Data Engineering only. I will help as time permits.
154
107
824
SQL zero to Hero!!!! Don't thank me later....
17
291
806
Learn a SQL
Learn a SQL
Learn a SQL
Learn a SQL
Learn a SQL
Please ensure you have SQL skill.
I plead with you.
45
124
695
Data engineers are scarce. Data Analyst who love connecting things. Take charge.
You can start with learning simple tools like SSIS, Focusing more hours on python and narrow into Pandas, Spark... Just to familiarize yourself with the concept of Data Pipeline.
22
138
588
@BlackSalawowo
@LLins___
Lol, you people think throwing data stat around is cool? Where did you get this your % from?
6
3
546
If you're starting out as a data analyst, start with Excel. If you already know excel basics go straight to learning and working with PIVOT TABLE, Chart building, and dashboarding in Excel. Start this week. Start!!!
27
149
583
There was a time when I was on fire sha...
Badges and Certifications are everywhere. 😉
Where I have reached is through sweat and blood, plus the Grace of God.
43
53
538
When I started gaining confidence in my Data Analytics journey, I used
@Upwork
to get gigs that trained me well enough to face real job. Use gigs to build profile. Take internship seriously.
16
71
453
Last year, I mentored some to get certified, trained many to learn Power BI and SQL in a bid to kick start their Data Analyst career path or Data Engineering. Advice many on where to start the journey. I will do more this Year God willing.
43
45
427
Those of you learning SQL, which Student ID would be missing in the result set?
319
58
408
To learn SQL easily, I find MS SQL SERVER, a simple way to get started. Why?
All you need to start is:
1. Install the DB engine( Developer version) it is free for life...😊
2. Install SSMS
3. Download and restore a complete dummy adventureworks bak file that simulates a company
10
128
408
This is a gold mine for learning SQL, but people don't like free things.
5
147
386
2023... I will push as many as will be willing to switch their career to Data Analytics and Data Engineering So help me God.
@biwatechnology
will be the handle to drive this course with my full support. The race for 2023 begins now!!!
That is my next level.
39
50
357
To get going is easy:
1. Download SQL Server
2. Install SSMS
3. Download adventureworks OLTP .bak file
4. Restore the adventureworks file.
Use to start your learning and use the adventure works to practice.
For those learning
#SQL
#adventurework
dataset is all you need. Hence learn SQL with
#SQLServer
for your quick learning and feelings of a business wise dataset free of charge.
2
6
27
11
101
356
What should I do as a total beginner pursuing Data Analytics?
1. Know it isn't a quick money scheme.
2. You must be resilient.
3. Technologies to focus on are:
a. Excel, b. SQL, c. Power BI/Tableau.
4. Don't run from pillar to post joining all lessons. Focus on 1 at a time.
9
102
333
@fatiabubakarr
There is an easy solution for that though. Just return home. The other reasons why people japa are not improving or getting better by the day. Feeling lonely/bored abroad, no need to complain. Just "UnJapa".
17
13
321
You think SQL is difficult to learn because you're in a hurry to finish the videos, so you can post the certificate. It doesn't work that way. If it's not clear enough, go for the 2nd or 3rd rounds of watching. Learn with purpose, not for certificate of completion.
24
65
339
Aspiring Data Engineers, familiarize yourself with the following concepts/ technologies:
1. Basics of Excel.
2. GRIND SQL to intermediate level
3. Data Modeling, Data Warehouse/Data Lake.
4. Python Basics
5. Python Pandas/pyspark
6. Extract Transform Load
6. AWS or Azure Cloud
9
114
322
Nice Dashboard ideas...
1
84
318
Data Analysts go for it.
4
138
323
Your goal is becoming a data analyst? Leave python for now as a beginner and grind SQL. Yes, I said grind SQL.
23
65
311
Set the tone straight for 2023.
Here are the targets for this year if you're starting off as a Data Analyst or Data Engineer.
• SQL
• Power BI/Tableau
• Excel
• Python**
Put your pledge and stand by it. Good luck.
15
87
306
Power BI + SQL and a very cool Excel skills are enough to be proud that you're skilled as a data analyst. I said so.
16
53
294
@MigunaMiguna
you are the best of them all. When I say all I mean all. Kudos Africa is watching...we need more of your type. Courageous and no sugar coating.
12
81
292
If your goal is to become a data engineer. Don't waste time doing
#PowerBI
. Rather, focus on SQL, Python, cloud computing (Azure, AWS, GCP), and data modeling.
In python don't have the mindset of conquering python. Learn the basic programming rules and move to key libs for DE.
8
87
270
You can practice those skills you acquired while learning EXCEL, Power BI, and SQL here.
Take advantage of this resource.
2
150
271
@ahmednasirlaw
This is not Putin remember the sayings of our ancestors:
That says
“who the Gods want to kill, they first make him mad”
it more that than an external force.
2
31
276
When I switched my career to the data field, I was about 33 years. It was puzzling to make this decision, confusing to even know where it will lead me to, but I decided because I was convinced it’s my only way out my then situation. Thank God I decided.
After delving into it,
21
60
276
@OgbeniDipo
Legit. Start with Excel or Power BI follow it with SQL. I suggest Python over R. Do certifications DA100 for Data Analyst and DP900 Azure Data fundamentals for SQL.
11
58
259
Many People switching their career to the data path are learning through sweat and blood.
May your efforts pay off. 💵 💰
Keep going.
16
36
258
@tokunbo_wahab
@LAGESCOfficial
Unregulated scrap metal market is creating infrastructure sabotage. Create a state policy to ban sales of scrape metal the way we have it now.
We need sanity we must have sanity.
12
55
245
@Chie_buzor
@OJ_Banty
@Morris_Monye
What if as the plane is about to land opponents drop the plane. You no even fight war...?
17
4
228
Ideally, Excel + Power BI + SQL + Soft Skills (communication....) skills are good enough for a Data Analyst to kick start their career.
16
46
236
Data Analyst, go learn Data Modeling, Normalization and Denormalization.
That struggle is because you have not understood the above concepts.
6
53
239
FOR FREE: Here is a full detailed well-structured SQL Training. Just get your bundles and learn from zero to expert. At your own pace and terms.
3
97
235
My Data Analyst, Data Science, Data Engineer, Business Intelligence Dev learn SQL. Use this link to learn SQL from zero to Hero. If it's not clear and you want a one-on-one drill, DM.
7
104
233
SQL is not difficult by the way. All you need is someone who will explain the concepts to you. It's a very easy to learn.
34
31
218
Work on SQL project at least 5 hours a week as a learner. There is no way you won’t be good at it after 3 months.
8
24
214
Hope because I was quiet for a day or 2 you aspiring Data Analyst and Data Engineers haven't lost your morales. It's still early. How is 7am quick touch base on Saturday on SQL for absolute beginners? Group will be very small just 20 people per batch. To fast track your learning.
112
30
206
Learning SQL does not really require stress of which DB did you learn with. Just learn SQL. But I personally recommend SQL SERVER DB. Check my pin tweet.
18
28
201
When I felt like I have the confidence to complete a data Visualization in Power BI, SQL, I took to LinkedIn I was writing about the project I gave myself and competed. Some of my connections reached out to give me gigs. Don't keep your work, no one will know you.
5
38
199
When I started off my career in the data space about 7 years ago, it was not so clear to me what I was doing, ai just kept grinding.
Today, by God’s grace, when we talk about data, I’ve worked in different regions of the world. Advised top management using data and got results
10
11
205
If you're a new learner in any of these tools: Excel, Power BI, SQL, Quicksight, Tableau and you are facing challenges understanding certain concepts, please put the concepts below this tweet. Let break the concepts down. I am trying to see how we can co-learn.
43
64
205
#SQL
understanding check:
From query 1 and 2 will the result set be different or same? If same, different explain why/how. Examples are okay too.
59
33
202
@254_icon
Do not start with such sentence at the Archives in Tao. You may not get the opportunity to get to the 2nd line…
5
4
207
I don't know what to tell you again. But in all you do, learn SQL. You will be more marketable.
9
30
201
Data engineers are needed everyday. Many run away from this JD because it requires a lot to hone the skills. However, it is not impossible to start from knowing nothing to becoming a pro.
Start by knowing:
- Python
- Data Modeling
- Data lake/warehouse
- ETL/ELT
- SQL
9
51
198
Learn SQL like your life depends on it. In short, your life as a seasoned data analyst depends on it.
13
33
198
@LLins___
That airport is crazy. Not just Nigerians alone. The officials are corrupt but want to act like they are working. Very silly officials. Sorry for that experience man.
3
16
185
This is still true for most people. But don’t budge.
Learn Excel- done ✅
Learn Power BI/Tableau -done ✅
Learn SQL - done ✅
Do projects (few done) although those few are not enough… keep doing.✅
Then…….?
This the stage most people give up on the journey.
No
8
52
197
@TundeTASH
Want to learn Data Analytics with Power BI and Tableau? Use this link you will get introduction to the Software for free with certificate.
Want to know about Business Intelligence chat me up.
19
53
191
@usman_fadilu
@NuruddeenLemu
Educate yourself. Many times many Muslims have claimed that "Jesus is not Lord" and this is core to the Christian faith, we don't hear them stoned or Christian saying that is blasphemous. But turn the claims, blood will flow. Know that no one has the monopoly of violence.
5
8
180
Tech is still changing lives. Data Analytics or Data Engineering is not as difficult as you think. All it requires is endurance, and persistence. You must define a way to grow a tough skin that if I don't stop, I will win. That's all you need as you grind the data skills.
5
52
192
@ruffydfire
Nigerian youth did
#endsars
of the most coordinated protest in Nigeria’s history. When the heat and time is ripe again, they will come out in numbers. Let government keep building the pain. Protest usually is about a breaking point. When it reaches , it will be organic.
20
23
192
SQL Server, Oracle, Postgres, or MySQL, just learn SQL first.
14
38
180
@OpeBee
Moving 200+ humans around to me looks like the hierarchy of the community and our security architecture in that region need to answer serious questions. We need to be serious for once. This is repeating because no one paid for the Laxity of Chibok girls. Too annoying!!!
14
29
188
No one can ever claim to know all the concepts in Data Analytics before getting their first job. I said it No one.
Hire them like that. They will grow. Just measure grit and hire.
5
40
177
You want to be good in SQL? Look into data modeling first. Then go back to SQL. Don't thank me.
8
24
168
Do you want to pursue a career? Go online and search for the requirements for jobs in that career. Write down the skills needed. Check the skills you already have map out those you want to learn. Work on it over time and build your confidence in it. Attain and occupy the role.
4
42
160
It is never too late to start all over again. I started at the age that is 30+... now I am extremely happy I switched.
Just start. This is a new week, draw out the plan. No matter what, let the journey start. It's not necessarily rossy but be determined.
9
29
162
Displaying your SQL skills might be tricky. However, here is how you may show your prowess in using the too:
1. Develop business use cases.
2. Write SQL query to answer the business questions/uses cases.
3. Create database objects like views, stored procedures for 2 above.
4.
3
38
152
Learn Excel- done ✅
Learn Power BI/Tableau -done ✅
Learn SQL - done ✅
Do projects (few done) although those few are not enough… keep doing.✅
Then…….?
This the stage most people give up on the journey.
No interview, no opportunities are coming…
See, go back to
14
47
152
@OJ_Banty
@Morris_Monye
Trench pass trench oooo. Trench of Naija police slap and nuke explosion no be same ooo. Make man no reach where water go pass garri ooo.
3
2
146
If I mentor you, you must get your certification. I don't care if your relatives or friend are preaching portfolio. Nothing is wrong with portfolio + certification.
20
12
146
S- Structured
Q- Query
L- Language
Aka... Sequel.
Learn it 📢📢📢📢📢📢📢
Good morning. I won't rest until you start. So let me know if you have started and what are the challenges you are facing learning Sequel?
22
20
146
After I settled in Tech properly, I established myself with a Masters degree in computing and Information systems.
I was not joking that I wanted to switch path. I meant it and wanted to be known for it. Go all out. No jokes. The main point is that get your goals right.
9
23
145
You need SQL as a Beginner Data Analyst than you need Python. Don't be deceived or waste too much time on skills you need as a senior/intermediate. Start your career path stress free.
4
33
143
You are expecting to be good with
#SQL
, but you're watching training tutorials while sleeping on the bed... are you normal? Sit upright and Practice what's been taught.
23
17
145
@bwireluther
@LarryMadowo
Because the "Masters" made it look like so. If Europeans are moving freely, Americans moving freely. Why Africa? Share information across the continent. Give Africans more opportunities. If Nairobi is not working move to Accra or Yaounde or Lagos. Be spoilt with choices.
3
28
137
Except you're doing some scientific analysis, these charts/visuals are your best bet:
1. Pie
2. Line
3. Donut
4. Bar
5. Treemap
6. Fill map
6. Stacked Bar
7. Table
Business users are mostly comfortable with them.
IMO, if you give a biz-user Boxplot, they'll think you are mad.
9
42
140
@Og_temmy17
Abi nah, since APC card carrying members have their own heavens, he'll and their of special offers across Lagos.
1
1
128
So, you started the Data Analytics journey, and you're totally confused and frustrated if you will ever master the trade? Let me tell you something. Yes, you will master it. The key is repetition. Keep repeating it. It will be clear soon. Do not stop.
6
29
134
@St_Vin
@BBCAfrica
All countries have actually been doing this. Nigeria is late to the party.
3
3
133
@OgbeniDipo
Data Science, Data Analytics or Business Intelligence.
If you are interested in
@MSPowerBI
or
@tableau
courses, visit: to learn for free with a certificate issued.
11
48
130
Aspiring Data Analyst:
- Spend 2 weeks to learn Excel (understanding the basics)
- Spend another 2 weeks learn Power BI (Basics)
- Spend another 2 weeks learn SQL (basics)
After all the basics, ensure you devote time to build projects now. For you to be top notch DA practice.
9
46
134
My Active Certifications:
1. CERTIFIED AWS SOLUTIONS ARCHITECT
2. AZURE DATA ENGINEER ASSOCIATE.
3. MCSA (Microsoft Certified Solutions Associate)
4. CERTIFIED MICROSOFT POWER BI DATA ANALYST
6. TABLEAU DESKTOP DEVELOPER
7. AZURE CLOUD FUNDAMENTAL
HELLO
#AI
13
15
134
To complete just a single online course online is so daunting.
You're seriously focused for 1 to 2 days and unserious for a month.
You know it's you I am talking about, just raise your hands ✋️.
56
11
132
@YTBalogun
@AishaYesufu
So we are competing who is more foolish? I thought Nigerians rooted clueless GEJ and PDP out to get to breathe fresh air? Now we competing on who is more clueless.
5
3
121