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
- Tweets2.8K
- Following998
- Followers1.4K
- Likes30.1K
Pinned Tweet
📊 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
Want to become a Data Analyst?
Learn SQL, Excel and Power BI.
Then build projects using real-world datasets.
Skills + practice + projects = stronger preparation.
#DataAnalytics #SQL #DataScientist #DataAnalyst #Excel #PowerBI
PySpark Tip ⚡
Use cache() when you reuse an expensive DataFrame multiple times.
But don't cache everything. Storage is a resource!
#PySpark #DataEngineering #SQL #DataScientist #DataAnalytics
Excel Tip 📈
Master these functions:
• XLOOKUP
• SUMIFS
• COUNTIFS
• IFERROR
• FILTER
They can make everyday data analysis much easier!
#Excel #DataAnalytics #EXCEL
SQL Interview Question 🔥
How would you find the second-highest salary in each department?
Can you solve it using a window function?
#SQL #Interview #DataEngineer
A Data Engineer doesn't just move data.
They build reliable pipelines, handle failures, maintain data quality and make data accessible for analytics.
#DataEngineering #DataEngineer #DataAnalytics #SQL
Python Tip 🐍
Use enumerate() when you need both the index and value while looping through a list.
Write cleaner Python code.
#Python #DataEngineer #SQL #Programming
5
249
SQL Tip 💡
Use CASE WHEN to apply conditional logic in SQL.
It's useful for categorizing data, creating flags and building business reports.
#SQL #DataAnalytics #PowerBI #Tips #Sqltips
7
358
One question for Data Analysts 👇
What's more challenging?
A. Writing complex SQL
B. Building Power BI dashboards
C. Understanding business requirements
D. Data cleaning
#DataAnalytics #SQL #DataScientist #PowerBI
5
276
🚨 SQL Interview Question.
Can you spot what's wrong with this query?
It looks correct, but there's a hidden SQL trap involving "NOT IN" and "NULL" values.
Think carefully before answering!
Drop your answer below 👇
#SQL #DataEngineering
2
159
Dear @X algorithm
Tech professionals, let's connect. 🚀
What are you learning right now?
SQL, Python, Power BI, PySpark or Tableau?
Drop your answer below.
Follow @Adje_Analytics for more.
#TechCommunity #SQL #DataAnalytics #dataengineer – at New Delhi, India
1
4
127
Spot the error in this SQL query. 👀
Drop your answer in the comments 💬
#SQL #Subqueries #LearnSQL #AdityaKalyan
2
14
790
ADITYA KALYAN | DATA Engineer 🇮🇳 retweeted
🚨 BREAKING: Claude can now turn your messiest spreadsheet into a working WEB DASHBOARD in a single afternoon. Completely free.
Here are 7 prompts to build it from raw data to charts:
ADITYA KALYAN | DATA Engineer 🇮🇳 retweeted
SQL tip 💡
Rename your result columns with AS so people can read them.
SELECT SUM(sales) AS total_sales
FROM orders;
“total_sales” is much clearer than “SUM(sales)”. Your future teammates will thank you 😄
Connect 100 data sources → you get a data pipeline. 🚀
Nice schema, low latency, clean data.
That's the data engineer love story. ❤️
#DataEngineering #ETL #Pipelines #DataAnalytics #SQL #memes #Analytics
4
143
Day 1 | SQL Subqueries
Spot the error in this query. 👀
Drop your answer in the comments 💬
Answer tomorrow.
Follow @Adje_Analytics for more.
#SQL #Subqueries #LearnSQL #AdityaAnalytics #DataAnalytics – at New Delhi, India
