Dev

84 posts

Dev

Dev

@modidev07

Computer Engineering Grad | Data Analytics & Data Science Enthusiast 📊 | Python | SQL | Power BI | Advanced Excel | Exploring real-world ML projects

Katılım Ocak 2024
14 Takip Edilen12 Takipçiler
Sabitlenmiş Tweet
Dev
Dev@modidev07·
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
English
2
0
5
622
Dev
Dev@modidev07·
Am I ready for the comeback?
English
0
0
0
7
Dev
Dev@modidev07·
Confusion is solved, finally.
English
0
0
0
3
Dev
Dev@modidev07·
Is it just me or did you guys also get heavily confused learning performance metrics?
English
1
0
0
17
Dev
Dev@modidev07·
@NanaPhio Communication Attention to detail Decision making
English
1
0
1
65
Nana Phiona
Nana Phiona@NanaPhio·
As we enter a new week, what top three skills can make someone stand out as a data analyst?
English
8
9
33
2.1K
Nalin
Nalin@nalinrajput23·
what’s stopping you from coding like this?
Nalin tweet media
English
92
6
153
7.1K
TheDataJoy©
TheDataJoy©@femininow·
If you're in data let's connect
English
60
14
196
8.4K
Josh | Data Strategist
Josh | Data Strategist@TheAnalystbro·
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 👋
Josh | Data Strategist tweet media
English
83
35
434
11K
Dev
Dev@modidev07·
@SumitM_X I always get curious reading these questions. Like what should be our point of consideration? So much confusion.
English
0
0
0
34
SumitM
SumitM@SumitM_X·
Which Query has better performance ? SELECT DISTINCT dept FROM emp; vs SELECT dept FROM emp GROUP BY dept;
English
20
6
122
40.6K
Dev
Dev@modidev07·
@Umesh__digital @SumitM_X Yes, that is what I thought. But I guess the first option is the go-to option.
English
0
0
1
92
Umesh Kumar Yadav
Umesh Kumar Yadav@Umesh__digital·
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.
English
1
0
2
2.2K
SumitM
SumitM@SumitM_X·
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';
English
17
8
168
50.3K
DesignToBuild
DesignToBuild@infiniteloop44·
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?
English
10
18
714
87.8K
SumitM
SumitM@SumitM_X·
SELECT * FROM users WHERE salary = NULL; SELECT * FROM users WHERE salary IS NULL; Are both these queries same?
English
123
70
2.5K
595.8K
spidey
spidey@lochan_twt·
how about we all make 12 MONTHS - 12 PROJECTS in 2026 ?? who's up with me ?
English
592
100
2.5K
85.1K
Dev
Dev@modidev07·
@_devJNS Python in a way. But I still consider C to be the first.
English
0
0
0
2
JNS
JNS@_devJNS·
you wrote your first Hello World in which programming language?
JNS tweet media
English
889
174
1.7K
89.9K
Dev
Dev@modidev07·
There has been a massive delay in plans. A few things came up. But looking forward to getting things back on track.
English
0
0
0
7
Dev
Dev@modidev07·
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
English
1
0
0
27
Dev
Dev@modidev07·
Suggest me a good medium to learn Tableau
English
0
0
0
9
Abraham Okah(info hub)
Abraham Okah(info hub)@AbrahamOkah2·
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
English
1.3K
118
1.8K
129.6K
Ezekiel
Ezekiel@ezekiel_aleke·
Every Excel users know these formulas: SUM AVERAGE XLOOKUP VLOOKUP IF LEN TEXTJOIN Do you know them?
English
12
17
131
6.5K
Dev
Dev@modidev07·
@ahdebee The first goal is 100+. Will build consistency till then.
English
0
0
0
3
Tanu
Tanu@tanuutweets·
Let's connect until I reach 1000😺 I will fb.
English
215
5
292
15.6K