Non-IT to Data Analytics Roadmap
Coming from a non-IT background? You can still become a Data Analyst.
Here's the roadmap I'd follow:
→ Excel — Data cleaning, Pivot Tables, VLOOKUP/XLOOKUP
→ SQL — Joins, CTEs, Subqueries, Window Functions
→ Power BI — Dashboards, DAX, Data Modeling
→ Statistics — Mean, Median, Trends, Correlation
→ Projects — Build 3 real-world business projects
→ Resume + LinkedIn — Showcase your skills and projects
→ Interview Prep — Practice SQL, business scenarios and explaining your projects
→ AI Tools — Use AI to learn faster and solve problems efficiently
One thing I'd tell every non-IT aspirant:
Don't spend months collecting certificates.
Learn the skills. Build projects. Practice interviews. Start applying.
Your degree may be from a different field, but your skills can open doors to analytics.
Save this roadmap. Start today.
Learning Data Analysis in 2026?
Here are 9 YouTube channels to add to your learning list:
1. Data with Baraa
2. Luke Barousse
3. Chandoo
4. Isaac Emmanuel
5. Lean Skill Daily
6. How to Power BI
7. Josh Aharonoff
8. Excel Dictionary
9. Excel Macro Mastery
Save this list
You've learned Excel, SQL, and maybe Power BI. You've watched tutorials, too.
But when it's time to build your first project, you get stuck on one question:
“Where do I find data to practise with?” 🤔
Here are 5 websites where you can find FREE datasets to build your data analytics portfolio. 👇
✅ 1. https://t.co/3w7Ji0M5Ry — https://t.co/goO0fqaAxa
Government datasets on agriculture, health, education, climate, and more.
✅ 2. Kaggle — https://t.co/WtjEj9ENHI
Explore datasets, learn from other analysts, and practise with real-world problems.
✅ 3. IEEE DataPort — https://t.co/QEi2M1l9r3
Research and scientific datasets for more technical projects.
✅ 4. UNdata — https://t.co/LRup6m2Brv
Explore global data on population, trade, health, and development.
✅ 5. DataHub — https://t.co/8R2k1naih8
Discover datasets from different sources for your next project.
Here's your challenge: Pick ONE dataset, ask a business question, analyse the data, and share your findings.
You don't need to keep watching tutorials before you start building. Put what you've learned into practice! 🚀
Which of these websites have you used, or which one are you checking out first? Drop it in the comments. 👇
#DataAnalytics #DataAnalyst #FreeDatasets #BuildYourPortfolio
After you're done praying, now carry your phone, find a comfortable position:
These websites allow you to search for scholarships based on your qualification, preferred country and course of study.
1. DAAD Scholarship Database 🇩🇪 For undergraduate-related opportunities, Master's, PhD and research funding in Germany. https://t.co/J4dD1QVTkp
2. Erasmus Mundus Catalogue 🇪🇺 For international students looking for joint Master's programmes in Europe, including programmes offering full scholarships. https://t.co/ogcF2DUWJT
3. Commonwealth Scholarships 🇬🇧 For eligible students from Commonwealth countries, including Nigerians, seeking postgraduate study opportunities.
https://t.co/C5UtEDSwcO
4. Chevening Scholarships 🇬🇧 For eligible Nigerians seeking fully funded one-year Master's programmes in the UK. https://t.co/et2xOGdjYp
5. FindAMasters 🎓 Search for Master's programmes and explore funding opportunities offered by universities. https://t.co/tAaVbY1a67
6. FindAPhD 🔬 For PhD programmes, funded doctoral positions and research opportunities.
https://t.co/C5V3gwAt7B
7. EducationUSA 🇺🇸 For official guidance on studying in the United States, university funding and scholarship opportunities.
https://t.co/lig6OIYNkm
8. Study Australia 🇦🇺 Explore Australian universities, courses and scholarship information for international students. https://t.co/2Dk1W04AFV
9. University of Toronto Scholarships 🇨🇦 Explore undergraduate awards, including the Lester B. Pearson International Scholarship. https://t.co/1ZnbGSwN2v
10. Study in Japan 🇯🇵 Explore Japanese government scholarships, including MEXT opportunities. https://t.co/vG4ZTvF0LO
Always apply through verified portal.
Teach your Nigerian child money at 8, not at 18:
Give them a monthly allowance. Not tied to chores. Their own.
Make them split it into three jars: spend, save, give.
Let them make bad decisions in the spend jar. That is where the lesson lands.
Every quarter, walk them through what the save jar has become, and where the give jar went.
By 14, they understand budgeting better than most adults. By 18, they will not blow the university stipend in month one.
The curriculum for this is one Saturday morning a month. Nothing more.
I've just completed this Call Center Report project.
I'll write the detailed GitHub repo and post, soon. But until then, you can feed on the aesthetics, and I'm also open to constructive criticisms, questions and gigs.
@ezekiel_aleke how's my performance sir?
#DataAnalytics
At this juncture, I need to add AI to my title
While a lot of people are scared about AI taking their jobs, the clever people are looking into incorporating AI to their workflow
Cos why can't I call myself an AI Data analyst when I leverage on AI to solve business problems? 😌
One mistake I made when I started learning data analytics was not building my portfolio early enough. 🥲
I kept learning and practising, but I didn’t start showcasing my work early.
If you’re learning data analytics, don’t wait until you’re job hunting.
Here are 5 free tools/sites you can explore:👇
1️⃣ Data Science Portfolio: https://t.co/0RbWPyVnuG
2️⃣ Linktree: https://t.co/uvDnyOQfny
3️⃣ Strikingly: https://t.co/GreXZZqozX
4️⃣ GitHub: https://t.co/TqpXM3gqZE
5️⃣ Google Sites: https://t.co/OKf6ddrXsa
You don’t need a perfect portfolio to start. Start with what you have, add your projects, and improve it as you grow.
Haven’t built your portfolio yet? Start building early!
Which platform are you currently using for your portfolio?
#DataAnalytics #DataAnalyst #DataAnalyticsPortfolio #LearnDataAnalytics #TechTwitter
My bi-annual First Class Giving is open to “66 Recipients”.
If you are a Nigerian university student in 2nd, 3rd, final year or graduated in 2026, sitting on a first-class GPA, this is for you. Excellence should not be invisible.
How to enter:
1. Comment a screenshot of your current GPA / statement of result
2. Hide your phone number, address and account details
3. We will validate your student ID in the DMs before any support goes out
Supporting excellence. Not noise. Do not DM me!
Happy Independence. Nigeria Forward 🇳🇬 💚
If I had to start learning data analytics from zero again, I honestly wouldn’t do it the same way.
There are things I spent too much time trying to understand, things I learned too early and things I wish I had focused on first.
So if I had to start over, this is the order I’d follow 👇
Your supervisor asked you to come up with a project topic, and now you’re confused because every topic you find has already been researched.
Relax!!!
You’re looking for a “new topic” what you need is a research gap.
Let me show you how to find one and turn it into a project topic. 🧵👇
How to create a GitHub repository for your Data Analytics project 🧵📊
If you're building projects for your portfolio, don't just keep the files on your laptop.
Put your work somewhere people can actually see it.
Here's a simple setup:
Go to Google and type:
"join our team" "remote" "[SKILL]" intitle:careers
Replace 'SKILL' with your actual skill and hit enter.
Now, you'll see jobs for your skill companies posted on their websites.
But don't stop there...
🚀 My first project as a Data Analytics Intern at DecodeLabs!
I recently completed a data cleaning project using a 1,200-row sales dataset.
Using Excel & Power Query, I:
• Cleaned and standardized data
• Handled missing values
• Fixed data types
• Validated total prices
• Checked for duplicates
• Standardized dates & text formatting
One key lesson: a dataset can look clean and still need cleaning.
A good analyst looks deeper. 👀😅
The cleaned dataset is now ready for analysis.
First project. First milestone. More to come. 📊