ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics) header
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics) profile picture

Data Engineer โ€ข Trainer & Educator โ€ข Helping you become job-ready in Data Analytics | SQL โ€ข Power BI โ€ข Python โ€ข Excel Sharing Interview Prep + Career Tips

New Delhi ๐Ÿ‡ฎ๐Ÿ‡ณ
Joined December 2020
Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)Photo by ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ (@Adje_Analytics)
๐Ÿ“Š Today I haveCreated a Pharmacy Sales & Payments dataset today. Explore it on Kaggle and share your honest feedback. Your suggestions will help me improve it. ๐Ÿ™Œ @kaggle @KaggleDatasets ๐Ÿ”— kaggle.com/datasets/akalyanbโ€ฆ โ€“ at New Delhi, India
1
3
20
1,277
Self Join = ek table ko khud se join karo. Employee vs Manager salary compare karne ke liye use hota hai.
2
144
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
Quick Python cheatsheet.
2
12
54
4,548
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
All SQL Joins
17
82
2,839
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
INTERVIEW TIPS: These Interview tips could be helpful to somebody out there so please share them. #interview #tips
1
34
1
192
13,378
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
Random shit HR Interview Questions You Must Know
26
318
5
2,527
92,199
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
If your upcoming data analyst interview has you stressed, make sure you know: โ€ข Window functions in SQL โ€ข DAX measures in Power BI โ€ข STAR method behavioral stories โ€ข Basic data cleaning in Python Master these and youโ€™ll stand out. Follow for daily interview prep.
1
2
18
640
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
18 websites to get remote jobs in 2026 1. dice .co 2. remote .co 3. devsnap .io 4. remotive .io 5. remoteok .io 6. flexjobs .com 7. upwork .com 8. whoishiring .io 9. justremote .co 10. remotefront .io 11. wellfound .com 12. powertofly .com 13. skipthedrive .com 14. authenticjobs .com 15. weworkremotely .com 16. jobspresso .co 17. remotework .io 18. hired .com Start now!
1
40
190
12,472
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
Python Ecosystem
4
49
2
326
9,792
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
COVER LETTER SAMPLE
8
29
7,951
Boost your analytics skills with these essential Excel formulas ๐Ÿ“Š I always rely on XLOOKUP and SUMIFS to handle complex datasets quickly ๐Ÿ’ก. Master these tricks to save time and work smarter every day ๐Ÿ’ป. Let me know your favorite function below โœจ #DataAnalytics #Excel โ€“ at New Delhi, India
1
6
33
2,010
Data Engineering Beginner vs Expert Guide Starting Data Engineering and wondering what you should learn first? Save this if youโ€™re building your Data Engineering roadmap. #DataEngineering #Pyspark
1
41
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
Corporate Rat Race...๐Ÿ€ โ€‹There is nothing wrong with your CV, People are just hiring their friends and families. People have connections & you just dont have Thats it.๐Ÿ˜‘
105
341
30
2,334
85,796
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
You don't need 50 SQL functions to get hired. You need 5 things: โ€ข JOINs โ€ข GROUP BY โ€ข CASE WHEN โ€ข CTEs โ€ข Window functions Master these and most interview questions become variations of the same idea.
1
7
22
766
PySpark Tip โšก Use repartition() when you need to increase or redistribute partitions. But remember: repartition() triggers a shuffle. #PySpark #SQL #DataEngineering
1
9
275
Data Engineering Tip ๐Ÿš€ Don't reload everything every day. Use incremental loading to process only new or changed records. #ETL #DataEngineering
2
114
Data Engineering Tip ๐Ÿ’ก Never trust raw data blindly. Validate NULLs, duplicates, data types and unexpected values before loading data. #DataQuality #DataEngineer
1
2
10
289
Learning Data Analytics? Stop collecting tutorials. Start solving problems, working with real datasets and building projects. Your portfolio should demonstrate what you can actually do. #DataAnalytics #SQL
1
8
281
Learning Data Analytics? Stop collecting tutorials. Start solving problems, working with real datasets and building projects. Your portfolio should demonstrate what you can actually do. #DataAnalytics
1
2
12
373
15 Power Query tricks every Excel user should know! ๐Ÿš€ Clean, transform, merge, combine & automate your data workflow. Less manual work. More powerful insights! ๐Ÿ“Š Save this for later. ๐Ÿ”– #Excel #PowerQuery #DataAnalytics #PowerBI
1
8
47
1,132
ADITYA KALYAN | DATA Engineer ๐Ÿ‡ฎ๐Ÿ‡ณ retweeted
๐Ÿ“Œ KEY COMMUNICATION SKILLS FOR CAREER DEVELOPMENT Your ability to communicate can influence how people perceive you, trust you, and recognize your potential. ๐Ÿ”ธ๏ธ Active Listening โ†’ Give others your full attention and understand before responding. ๐Ÿ”ธ๏ธ Clear Speaking โ†’ Express your ideas confidently, logically, and without unnecessary words. ๐Ÿ”ธ๏ธ Written Communication โ†’ Write professional emails, reports, and messages that are clear and effective. ๐Ÿ”ธ๏ธ Public Speaking โ†’ Present ideas with confidence and engage your audience. ๐Ÿ”ธ๏ธ Emotional Intelligence โ†’ Recognize emotions and adapt your communication to different situations. ๐Ÿ”ธ๏ธ Giving and Receiving Feedback โ†’ Share constructive input and use feedback to improve. ๐Ÿ”ธ๏ธ Persuasion and Influence โ†’ Build convincing arguments and gain support without being pushy. ๐Ÿ”ธ๏ธ Conflict Resolution โ†’ Address disagreements respectfully and focus on solutions. ๐Ÿ”ธ๏ธ Non-Verbal Communication โ†’ Use body language, eye contact, and tone to reinforce your message. ๐Ÿ”ธ๏ธ Adapting to Your Audience โ†’ Adjust your style to connect with different personalities, roles, and cultures. Your expertise gets you noticed. Your communication skills help you turn that expertise into influence and opportunity. ๐Ÿ’ช ๐Ÿ“ฉ Free Guide: Master the 12 soft skills that drive successโ€”and start applying them today. ๐Ÿš€ ๐Ÿ‘‰ Get your free copy: betteryoubrief.substack.com/โ€ฆ #CommunicationSkills #CareerDevelopment #ProfessionalGrowth
1
14
75
1,533