Abhishek @data_guy16

Husting founder | Here to Dominate | Unrealistically obsessed with winning Joined January 2025

Tweets

2K
Followers

127
Following

36
Likes

176

Abhishek @data_guy16

a week ago

After every merge run df.shape One-to-many joins silently multiply rows. Most bugs in data work come from joins nobody checked. Want the full system to go from zero to hired as a data analyst in 90 days? 👉 topmate.io/abhishek_kumar…

0 0 0 8 0

View Details

Abhishek @data_guy16

a week ago

7 → histplot, boxplot, lineplot, heatmap First chart is always sns.heatmap(df.corr())

1 0 0 29 0

View Details

Abhishek @data_guy16

a week ago

Every Python function I use daily in a real data job. Not a tutorial. Not a course. Just what actually shows up when you're working with data professionally.

1 0 0 30 0

View Details

Abhishek @data_guy16

2 weeks ago

Spent the first 3 years learning formulas I never used. The next 11 I used these 15 on repeat. Learn them deeply. Use them on real data. Everything else is a bonus. Want Excel, SQL, Power BI, and Python in one structured 90-day system? 👉 topmate.io/abhishek_kumar…

0 0 0 17 0

View Details

Abhishek @data_guy16

2 weeks ago

•INDIRECT → dynamic cross-sheet references, no VBA needed • LARGE/SMALL → top N and bottom N values in seconds • TEXT → format numbers and dates as readable labels • GETPIVOTDATA → pull Pivot values into fixed reports that never break

1 0 0 24 0

View Details

Abhishek @data_guy16

2 weeks ago

Used Excel for 14 years across finance, ops, consulting, and data analytics. Most formulas are a waste of time. These 15 solved 90% of every real problem I faced. 🧵

2 0 0 50 0

View Details

Abhishek @data_guy16

2 weeks ago

What actually gets you hired: ✅ 1–2 real portfolio projects ✅ GitHub with clean README ✅ SQL you can write from scratch ✅ A dashboard hiring managers can open ✅ Ability to explain your analysis in plain English Full 90-day system to get there 👇 topmate.io/abhishek_kumar…

0 0 0 28 0

View Details

Abhishek @data_guy16

2 weeks ago

What NOT to learn until you have a job: • Deep learning — you're an analyst, not a data scientist • Spark/Hadoop — only at massive scale • R — Python covers everything, bigger job market • Certifications — projects beat every certificate