Elvis | Analytics✨

Maths + Computer Science student who fell in love with data 📊 Now turning that into a career in Data Analytics Here I share: 📊 Data tips & tricks 🛠️ Tools — SQL, Python, Power BI 🚀 My journey from student to analyst If you're into data or just starting out -let's connect 👇

@Tech_p001 That's for legends💪

@TheeAnalyst_ke Vs code

Where do you actually write most of your Python code? ♾️Google Colab, 🌐Jupyter, or ✨VS Code? What's your choice, and why? #python

@c_aulli What country are you from

Good morning Techies Relax the work and enjoy your day ☺️

@Raynerdtech They are physically aren't they😂

So you guys are also on Jiji? I thought Jiji was only for selling physical products

My advice if you're learning Excel: Learn VLOOKUP first because you'll still find it in older workbooks. Then switch to XLOOKUP for most new work. If you found this useful, bookmark for later😉

VLOOKUP and XLOOKUP aren't as complicated as they seem. Imagine one table has Customer IDs, while another has customer names. There are thousands of rows, and they're not in the same order, so copy-pasting isn't an option. That's where VLOOKUP and XLOOKUP come in. A thread🧵👇

Why many analysts prefer XLOOKUP: ✅ Looks left or right ✅ Doesn't break when columns are inserted ✅ Built-in "Not Found" message ✅ Cleaner syntax

That's where XLOOKUP comes in. Formula: =XLOOKUP(A2,F:F,G:G,"Not Found") Instead of counting columns, you simply tell Excel: • Lookup range • Return range

The limitation? VLOOKUP can only search left → right. If the value you want is to the left of your lookup column, VLOOKUP won't work. An option maybe changing column to the right of the lookup column

Formula: =VLOOKUP(A2,F:G,2,FALSE) Breakdown: • A2 → value to find • F:G → where to search • 2 → return the 2nd column • FALSE → exact match

Let's start with VLOOKUP. It looks for a value in the first column of a table and returns information from another column. Example: You have Customer IDs. You want Customer Names. VLOOKUP finds the matching ID and returns the name.

@ccyberzoid Good morning

@TheeAnalyst_ke Good morning Elvis!

Good morning Everybody ☀️ A new day to be proud of in the near future I wish you a productive day

@PeterFatd1 SELECT Name, Salary From Employees Where Salary>(SELECT AVG(Salary) from Employees)

SQL Interview Challenge! Can you write a query to find employees earning above the average salary? No AI. No Google. Just your SQL skills. Drop your solution in the comments and let's see how many different approaches we can come up with! 💻🔥 #SQL #DataAnalytics #LearnSQL #SQLChallenge #DataAnalyst #Programming #TechCommunity

@dark_coderz Bro is used in git quietly

Bro disappeared like he never existed

@Chiemela_Alien I hate it too😭

I hate this 😂😔

@didicoding There are points you'll want peace ✌️

Bro to bro The longer you stay in tech, the less you pretend to know everything.

@Femiforge Looking for a job

Everyone in tech is in one of these 3 steps: 1. Learning 2. Looking for a job 3. Earning money Which step are you on right now? Let people help you.

Consistency and competency

@aminnnn_09 Ship a saas

You have 30 days. You can only choose ONE. A. Build five small apps B. Read five AI books C. Contribute to open source D. Ship one SaaS Which gives you the biggest career boost?

@rohntwts 😂😂😂

I know this is how Anthropic made the new Fable 5, but I just can't prove it yet.