Dev

A professor called his students for a 3D video tutorial on Principal Component Analysis. Students entered the class wearing 3D glasses. They came out of the class without those 3D glasses. There is the explanation. #machinelearning

@NanaPhio Communication Attention to detail Decision making

As we enter a new week, what top three skills can make someone stand out as a data analyst?

@nalinrajput23 Extensions

what’s stopping you from coding like this?

@femininow Hey, let's connect.

If you're in data let's connect

@TheAnalystbro Hey 👋

Hey algorithm, connect me with people who love: 📊 Data Analysis 📈 Data Science 💻 Excel, SQL, Power BI & Python 🔍 Problem-solving 🧠 Critical thinking 📚 Continuous learning 📕 Data books 📝 Analytics projects 🔬 Research & insights 📖 Data storytelling 📢 Sharing knowledge It's Friday, let's connect 👋

@SumitM_X I always get curious reading these questions. Like what should be our point of consideration? So much confusion.

Which Query has better performance ? SELECT DISTINCT dept FROM emp; vs SELECT dept FROM emp GROUP BY dept;

@Umesh__digital @SumitM_X Yes, that is what I thought. But I guess the first option is the go-to option.

1) more efficient and less overhead compared to the union all method plus it is cleaner and easier to read 2) Union ALL usually runs two query in this case and scanes the while table twice. However, for large data sets union all may provide some benefits as "OR" degrades the indexing performance for large datasets.

Which SQL Query has better performance ? SELECT * FROM emp WHERE dept = 'IT' OR dept = 'HR'; vs SELECT * FROM emp WHERE dept = 'IT' UNION ALL SELECT * FROM emp WHERE dept = 'HR';

@infiniteloop44 @SumitM_X Thanks.

Both queries are different. 1. WHERE salary = NULL • The Result: Returns nothing (Empty set). • The Logic: In SQL, any comparison to NULL using a standard operator (=,>,<) results in a state called UNKNOWN. • The "Why": Since NULL represents an unknown value, the database logic is: "I don't know what the salary is, and I don't know what this other thing is, so I can't say they are equal." Even NULL = NULL is false (or rather, unknown) in SQL. 2. WHERE salary IS NULL • The Result: Returns all rows where the salary column is empty/null. • The Logic: This uses a specialized comparison operator designed specifically to check for the presence of the NULL state. • The "Why": This is the proper syntax to ask the database: "Does this cell have a value or not?

SELECT * FROM users WHERE salary = NULL; SELECT * FROM users WHERE salary IS NULL; Are both these queries same?

Is it just me or did you guys also get heavily confused learning performance metrics?

how about we all make 12 MONTHS - 12 PROJECTS in 2026 ?? who's up with me ?

@_devJNS Python in a way. But I still consider C to be the first.

you wrote your first Hello World in which programming language?

There has been a massive delay in plans. A few things came up. But looking forward to getting things back on track.

Back from a break. Let's focus on learning and upskilling. Have a couple of unfinished projects. Some of them are Power BI projects, while others are ML projects. Will be sharing updates regarding the projects every Friday/Saturday. #keepongrinding

Suggest me a good medium to learn Tableau

@AbrahamOkah2 Project Management

If you are Interested in these Tech career paths, please state it below and I'll share with you free courses to start! •Business Analytics •Cyber Security •Data Analytics •Digital Marketing •Project Management •Front-End Engineering •Software Engineering •UX/UI Design

@ezekiel_aleke Yes

Every Excel users know these formulas: SUM AVERAGE XLOOKUP VLOOKUP IF LEN TEXTJOIN Do you know them?

@ahdebee The first goal is 100+. Will build consistency till then.

@tanuutweets Let's go!!!

Let's connect until I reach 1000😺 I will fb.

@ahdebee Hello

@ezekiel_aleke Same, $2100

Dear Data Analyst. What’s the cost of your Data Analysis knowledge? SQL = $200 DAX = $300 Excel = $200 Python = $300 Tableau = $200 PowerQuery = $300 Data Modeling = $300 Data visualization= $200 Presentation skill = $300 Joins and SubQueries = $300 Mine: $2100

@Femi_forge Happened with me. A few years back I used to think SQL is one of the toughest things to learn. Now, the scenario is totally different.

It’s funny how learning works —what’s confusing you today will be the same thing you’ll confidently explain to someone tomorrow.