The Analyst

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

[The Analyst @dev_awizee]

Just completed the Data Analyst Bootcamp 2026!

Gained strong skills in data analysis, visualization, stats, and turning data into insights

Feeling pumped and ready for new challenges!

Big thanks to the instructor @Alex_TheAnalyst and everyone who supported me

#DataAnalytics

[The Analyst @dev_awizee]

🚀 FREE TECH BOOTCAMP!

Not sure which tech path to choose?
Join BrainTech Academy and discover the right one for you.

📅 Oct 24 | 🕖 7–9PM WAT
💻 Google Meet | 💰 FREE

👉 https://t.co/fE2JxC3VVb

#BrainTechAcademy #TechBootcamp #DataAnalytics #Networking #Ai #sotfwareDev

[The Analyst @dev_awizee]

Bookmark and reshare for others to benefit from it too

[The Analyst @dev_awizee]

🚀 FREE TECH BOOTCAMP!

Not sure which tech path to choose?
Join BrainTech Academy and discover the right one for you.

📅 Oct 24 | 🕖 7–9PM WAT
💻 Google Meet | 💰 FREE

👉 https://t.co/fE2JxC3VVb

#BrainTechAcademy #TechBootcamp #DataAnalytics #Networking #Ai #sotfwareDev

[The Analyst @dev_awizee]

4/4
Step 4: Add a Slicer for Month.

Now you can filter your report with a click and quickly see how sales change across months.

That's it.

You just built a report your manager can actually use.

Reply PIVOT if you learnt something new.

#ExcelTips #DataAnalysis

[The Analyst @dev_awizee]

Thread: How to build your first useful Pivot Table in 4 minutes (no YouTube needed)

1/ Select your data → Insert → PivotTable

2/ Drag “Product” to Rows, “Sales” to Values

3/ ...

4/...

You now have a report your manager can actually use.
Reply PIVOT
#ExcelTips #DataAnalysis

[The Analyst @dev_awizee]

3/4

Step 2: Drag Product → Rows

Step 3: Drag Sales → Values
Then check the Values field.

Make sure it says SUM of Sales, not COUNT of Sales.

[The Analyst @dev_awizee]

2/4
Step 1: Select your data
Go to:
Insert → PivotTable
Excel will create a new PivotTable for you.

[The Analyst @dev_awizee]

1/4
Want to build your first useful PivotTable in just 4 minutes?
No YouTube tutorial needed. 👇

[The Analyst @dev_awizee]

What’s the one Excel or SQL thing you keep Googling every single week?

I’ll drop a 30-second explanation for the most common answers.

No judgement.

We all have that one formula.

#ExcelTips #SQLTips #DataAnalysis

[The Analyst @dev_awizee]

Hot take:
You don’t need “big data” or machine learning to get your first data job in Nigeria.

Most companies just want someone who can clean a messy Excel file, write a simple SQL query, and explain to oga.

Master the basics first

Fancy tools later

#DataCareer #DataAnalysis

[The Analyst @dev_awizee]

SQL beginners, this one line will save you hours:

SELECT DISTINCT city
FROM customers;

That’s how you see unique values without scrolling 10,000 rows.

Use it before you start grouping or joining.

Reply SQL
#SQLTips #DataAnalysis

[The Analyst @dev_awizee]

What’s the one data skill you wish someone explained to you in simple English when you started?

I’ll pick the top 3 replies and make a thread this weekend.

Drop it below.

#DataAnalysis #LearnData

[The Analyst @dev_awizee]

Ctrl + T turns any messy range into an official Excel Table.

Now your formulas auto-expand and your charts update when you add rows.

One shortcut.

Looks 10x more professional.

Try it on your next file.

#ExcelTips

[The Analyst @dev_awizee]

Quick poll for data newbies:

How do you currently practice?

A. YouTube tutorials only
B. Copying dashboards from Instagram
C. Real datasets (Kaggle, company files)
D. I don’t practice, I just watch

No judgment.

Vote.

#DataAnalysis

[The Analyst @dev_awizee]

Python beginners: stop writing this

df = https://t.co/iEufEGTBX1_csv("file.csv")
print(df)

Do this instead:

df = https://t.co/iEufEGTBX1_csv("file.csv")
print(df.head())
print(https://t.co/tqVQW0K1be())
print(df.describe())

[The Analyst @dev_awizee]

You don’t need to be a genius

You need 45 focused minutes a day for 90 days

That’s how people go from “I don’t know Excel” to first data internship

Just consistency

If you’re starting this weekend, reply “START” and I’ll send the 90-day beginner roadmap
#DataCareer #LearnData

[The Analyst @dev_awizee]

Python code every data beginner should run:

import pandas as pd
df = https://t.co/iEufEGT47t_csv("yourfile.csv")
print(df.head())
print(https://t.co/tqVQW0JtlG())

That’s how you stop being scared of Python

One file
Two lines
You already started

Reply PYTHON

#PythonForData

[The Analyst @dev_awizee]

What’s currently blocking you from becoming a data analyst?

A) I don’t know where to start
B) I start but I don’t finish
C) I have skills but no portfolio
D) I have portfolio but no interviews

Vote + tell me your situation in the comments.

#DataAnalysis #DataCareer

[The Analyst @dev_awizee]

Your first Power BI dashboard should have ONLY 4 things:

One big number (KPI)
One trend line
One breakdown (bar or pie)
One filter

Don’t add 15 visuals.

You’ll confuse yourself and the manager.

Reply PBI for a simple starter dashboard template idea.

#PowerBI #DataAnalysis

[The Analyst @dev_awizee]

Hot take:
You do not need Python to get your first data job in Nigeria.

Excel + SQL + one clean project + the ability to explain “so what?” will beat a half-finished pandas notebook.

Python can wait.
Clarity cannot.
Agree / disagree below.

#DataAnalysis #NaijaCareer