The Analyst

Data Analyst helping beginners master Excel, SQL & Python 💡 | Daily tips & roadmaps | DM for resources | Abuja | Lafia

[The Analyst @dev_awizee]

New to Excel? Stop manually typing dates!

Use =TODAY() for current date or =EOMONTH(A1,0) to get the last day of any month

Saves time when preparing monthly reports

Who else struggles with dates in Excel?

Drop a 🔥 if this helps

Reply 'EXCEL' for my free 7-Day Excel Roadmap.

[The Analyst @dev_awizee]

Starting Data Analysis in 2026 ?

Most beginners waste weeks on VLOOKUP

Do this instead:

Press ALT + H + O + I + W (auto column width)

Use XLOOKUP (it’s VLOOKUP but better)

=XLOOKUP(lookup_value, lookup_array, return_array)

Save this

Reply 'EXCEL' for my 7-day Excel roadmap

[The Analyst @dev_awizee]

Hot take: Learning Power BI without learning proper data cleaning first is a waste of time

Garbage in, garbage out

Focus on cleaning first, then visualization

Who agrees?

#PowerBI #DataAnalysis

[The Analyst @dev_awizee]

Excel Tip: Use PivotTables instead of manual summing for sales reports

Drag Region to Rows, Amount to Values → Done in 20 seconds

Nigerian analysts, this one sweet pass garri 😌

Reply 'PIVOT' for my top 5 Pivot tricks

#ExcelTips #DataAnalysis

[The Analyst @dev_awizee]

Relatable beginner struggle:

You finally understand VLOOKUP today… then tomorrow you forget everything 😭

Who else has been here?

The secret? Stop watching only

Practice daily small tasks

Reply “VLOOKUP” if you want a practice file

#ExcelTips

[The Analyst @dev_awizee]

Be honest (especially if you’re in Abuja/Lagos):
How long have you been “learning data”?

A. 0-3 months
B. 3-6 months
C. 6-12 months
D. 1 year+ but still stuck

Vote + reply your stage

#DataAnalysis #Beginners

[The Analyst @dev_awizee]

Beginner Roadmap to First Data Job(2026 edition)

Master Excel & Google Sheets

Learn SQL (focus on joins & aggregations)

Basic Python (Pandas)

Build 3 portfolios projects

Start applying even with 0 exp

Part 1/5

Want the full roadmap?

Reply “ROADMAP”
#DataCareer #SQLTips

[The Analyst @dev_awizee]

Python one-liner every beginner should know:

df.isnull().sum() → shows all missing values instantly

No more manual checking!

Save this

Reply 'PYTHON' for my free Python for Data roadmap

#Python #DataAnalysis

[The Analyst @dev_awizee]

Saturday reminder to every beginner in Abuja and Naija:

You don’t need to be a genius

You just need to be consistent

30 minutes daily > 5 hours once a month

Your data analyst era is coming

Keep pushing 💪

Who’s practicing today?

Reply “I’m in”

#DataCareer #Motivation

[The Analyst @dev_awizee]

Power BI Hack for beginners:
Use “DAX” → CALCULATE + SUM instead of basic sum

It makes your sales dashboards dynamic (especially useful for Nigerian market trends).
Try it today

Reply 'POWERBI' for my free dashboard template

#PowerBI #DataAnalysis

[The Analyst @dev_awizee]

Beginner question for you:
What’s the one thing stopping you from consistent data practice?

No laptop?

No data to practice on?

No time?

Fear of coding?

Be honest

Reply below

I read every one

#DataAnalysis #BeginnerFriendly

[The Analyst @dev_awizee]

Thread: How to clean messy Excel data in under 10 minutes

1/ Remove duplicates

2/ Text to Columns for addresses/phone numbers

3/ Find & Replace “N/A”, “-”, empty cells

4/ Use TRIM() and PROPER()

Who needs this?

Drop “CLEAN” below 👇

#ExcelTips #DataAnalysis

[The Analyst @dev_awizee]

Hot take: Most fresh graduates don’t need another certificate

They need to learn Excel + SQL properly and start building portfolios with real Nigerian datasets (NNPC, NIMC, Dangote data style)

Certificates without skills na scam

Change my mind

#DataAnalysis #CareerAdvice

[The Analyst @dev_awizee]

Free resource for beginners:

My curated list of 10 Nigerian-relevant datasets you can practice with (budget, sales, population, etc.)

Comment “DATASETS” and I’ll send it to you

No gatekeeping here

#DataAnalysis #FreeResources

[The Analyst @dev_awizee]

SQL Tip that changed how I analyze data:

Always use COUNT(*) with GROUP BY instead of guessing

Example:

SELECT Department, COUNT(*) as Employee_Count
FROM Employees
GROUP BY Department;

Beginners, save this

Reply 'SQL' for my free SQL Roadmap

#SQLTips #DataAnalysis #Career

[The Analyst @dev_awizee]

Quick poll for beginners

What’s your biggest struggle right now?

A. Cleaning data in Excel
B. Writing basic SQL queries
C. Understanding Python
D. Building dashboards in Power BI

Vote and reply with your choice

I’ll drop targeted tips for the winner

#DataAnalysis #SQLTips

[The Analyst @dev_awizee]

Beginner's learning Data 💪

If your Excel data is scattered, here’s a quick fix:

Select your data → Data tab → Remove Duplicates

Saves you hours of!

Who else wastes time on dirty data?

Drop 🔥 if this helped

Reply 'EXCEL' for my beginner cleaning checklist

#ExcelTips

[The Analyst @dev_awizee]

@Tomi__juice Lol Ai 😂😂
Na Ai prompting color be that 😂😂

[The Analyst @dev_awizee]

@ezekiel_aleke It's tableau

[The Analyst @dev_awizee]

@awizee_1 Amorim messed man utd up