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 👇

@ekanemjr_99 What English is this

Whatsapp no want rest 😂😂 No more "can we chat on whatsapp" so you can collect her number😂😂. I don go secure my trademarked username before person use am.

@ccyberzoid It's a programming language that is used in complex statistics, data analytics and visualisation just like python the only difference is that R has a single domain, with focus being that of dealing with data while python is general purpose

Can anyone explain to me what is R? All i saw about it was that it's a programming language that's used in statistics

@DabereNnamani Why is the check out longer, is the cashier slow this keeping customers waiting or customers choose the checkout because of better service delivery, or the ckeckpoints all work on a certain product category ( then the where line is always long has more customers)?

You walk into a store and notice one checkout line is always longer than the others. What's the first question you'd ask before suggesting a solution? Drop your answers.

@just_sahitya_ C 😂😂

which programming language you learned once but never touched again?

@Gamingtronium 😂😂 bro thought his computer could be a server

Bro became the final boss of vibe coding 💀

@officialladi_T You know what I've learnt from your query, that SELECT TOP 10* is correct in almost rediculed you😂😂 in other databases we used to LIMIT

Day 4 of learning SQL I almost skipped practice today, but I reminded myself that practicing for a few minutes is better than not practicing at all. For practice, I'm using Microsoft SQL Server with a retail supermarket dataset. One thing I realized today is that SQL isn't just about memorizing syntax. The real challenge is knowing when and how to use each query to answer a business question.

@isha_singh06 Windows eats 4gb of RAM in idle time,

I'm a Windows user, Give me one reason to switch to Linux.

@ccyberzoid I learned it in C, never knew it also existed in python😂 Good work bro,📍Tip pythons power is in its Libraries, there are many of them depending on what you want to focus on

@TheeAnalyst_ke Yeah it is! Instead of using the keyword switch it's just called match though

Hey Everyone, I also managed to finish Week 1's tasks of CS50 Python by @Harvard! These were quite good I felt like being challenged with my programming skills and hope to see more with Week 2. #Python #CS50 #Harvard #DataAnalytics #DataAnalysis #DataTwitter #LearningInPublic

@itsaaroshi Tokens

I'm a Claude user. Give me one reason to switch to Codex

@dev_awizee Another optimisation would be calling only columns you need if the table has many columns, this reduces execution time and scales safely

SQL Tip that changed everything for me: Always start with SELECT * FROM your_table LIMIT 10; before writing long queries Saves you from running expensive mistakes on big company data Who else has been burned before? Drop a 🔥 if yes #SQLTips #DataAnalysis #BeginnerData

@Femiforge It's called a critical activity, if it's not done you building a noise instead of insights

Data cleaning is harder than building dashboards.

@the_codewala Lee chose it for people to identify urls

Web devs: Do you know why URLs have two slashes (//) after http:? 🤔 Not 1. Not 3. Why 2?

@0xNyrox Check my page you'll find a project

@0xNyrox I've never used meta base, but you could try streamlit, power bi is a drag and drop but streamlit you actually build it from scratch with python code, it's a good one✨

Someone asked me yesterday if I've used a data visualization tool called "Metabase". I haven't, but it got me curious. Has anyone here used it? How does it compare to tools like Power BI or Tableau? Also, apart from the popular ones, what other visualization tools do you use or recommend? Always looking to learn from everyone

@folaoftech ChatGPT agreeing with everything 😂😂

Your friend has been spending way too much time with AI. 😂

@officialladi_T You guys write with AI 😂😂

When you finally write a piece of code without AI and it actually works

@DabereNnamani People forget what problem am I solving and ask themselves what can my dashboard contain

The best analysts don’t start with dashboards. They start with questions. Which of these do you think people skip most often?

5 questions every analyst should ask before touching a dataset. Most analysis goes wrong before a single formula is written. It starts with asking the wrong questions. Here are 5 questions I always recommend: • What problem am I solving? If you can’t clearly define the problem, your analysis won’t have direction. Data without purpose is just noise.

@vheeorji22 It depends on the occasion, so both

Claude or chat GPT ???

@Faruqmayorwa 😂😂

SQL Data Cleaning. Cleaning this SQL dataset has been giving me a headache. 😔😭