I talk about whatβs happening in the world of Data, Analytics, and AI β in a way thatβs easy to understand and fun to explore.
Joined November 2025
- Tweets 55
- Following 142
- Followers 69
- Likes 26
20 Photos and videos
Pinned Tweet
Think you're ready for an Amazon Data Analyst interview? π
Try solving this SQL challenge:
Find customers whose average rating is higher than the average rating of their membership type.
This tests:
β
CTE
β
GROUP BY
β
JOIN
β
Comparing individual rows against group aggregates
A very common SQL interview pattern asked in top product companies.
Can you solve it before checking the solution? π
#SQL #DataAnalytics #AmazonInterview #SQLInterview #DataAnalyst #LearnSQL #TechJobs #InterviewPrep
1
240
Built this Subscription Performance Dashboard using Google Data Studio π
Tracked key business metrics including user growth, conversion rate, active subscriptions, revenue trends, and bureau-score-wise subscription performance.
Focused on transforming raw data into business insights using SQL dashboard storytelling.
Every dashboard is one step closer to becoming better at solving real-world data problems. π
Feedback is appreciated.
#DataAnalytics #SQL #LookerStudio #GoogleDataStudio #PortfolioProject #DataVisualization #DataScience
37
Donβt Make this Mistake #sql while solving WINDOW function in #sql
#SQL #DenseRank #SQLInterviewQuestions #WindowFunctions #DataAnalytics #LearnSQL #DataAnalyst #SQLTutorial #AdvancedSQL #DataScienceWithSushant
1
27
1
42
20 followers.
A small number to many,
but a meaningful milestone for me as a new creator.
Every connection, like, and follow is motivation to keep learning, sharing, and building in public.
Grateful for every single person who decided to join this journey.
Onwards to more learning, more value, and more growth π
#BuildInPublic #DataAnalytics #CreatorJourney
69
Just hit 10 followers.
It may seem small, but as a new creator, this means a lot.
Every big journey starts small.
This is a reminder to keep showing up, keep learning, and keep building.
Onwards to the next milestone π
#BuildInPublic #DataAnalytics #CreatorJourney
4
1
87
Currently using ChatGPT (Go plan).
Thinking of trying Claude or Gemini as well.
For people whoβve used all 3:
β« Coding / SQL help
β« Data analysis
β« Learning complex concepts
β« Content creation
β« Overall reliability
Curious to hear real experiences, not marketing takes.
#ChatGPT #Claude #Gemini #AI
1
47
How to start your Machine Learning journey?
Start here π
β
Learn basic Statistics & Probability
β
Master SQL (non-negotiable)
β
Learn Python for data analysis
β
Get comfortable with data cleaning & EDA
β
Understand core ML algorithms
β
Build real projects
Most people jump straight to models.
The real edge comes from mastering data first.
#MachineLearning #DataScience #SQL #Pytho
45
Hey X algorithm π
Looking to connect with people in the data & analytics world.
Working with:
β’ SQL
β’ Excel
β’ Google Data Studio
β’ Python
β’ Tableau
β’ Data Science
If you're building, learning, or working in analytics/data β letβs connect and grow together.
#DataAnalytics #SQL #Python #DataScience #Tableau
40
A simple Spark SQL trick for fixed attribution windows.
Instead of manually calculating the end timestamp, let SQL handle it.
Why this is useful:
β
Push notification attribution
β
Event window analysis
β
Post-campaign engagement tracking
β
Cleaner than hardcoding both timestamps
Small SQL trick. Big analytics impact.
#SparkSQL #SQL #DataAnalytics #DataEngineering
32
Iβm still under 100 followers.
If you are too, reply below and follow others in the thread.
Letβs help each other cross 100 π€
#creatorcommunity #DataScience #datanalysts
1
29
I want to create a table with below columns.
user_id,
campaign_name,
campaign_type and
campaign_date (yyyy-mm-dd hh:mm:ss)
will below code work -
CREATE TABLE push_notification_master
(
user_id STRING,
campaign_name STRING,
campaign_type STRING,
campaign_date DATE
)
The answer is NO
I have to use campaign_date TIMESTAMP in place of DATE.
#DataScience #sql #table #dataanalytics
25
Data Science with Sushant retweeted
May 24
Different ways you can join tables in different data analysis tools:
β’ Excel: Power Pivot
β’ Power BI: Data Modeling
β’ Power Query: Merge
β’ SQL: JOIN
β’ Python: pd.merge()
My Sunday gift to you.
Repost to educate someone todayβ€οΈ
6
33
108
4,181
All data analyst over here..
What are you planning to build / learn tomorrow?
#monday #data #analytics
30
"Not all churn is equal. Cohort analysis tells the real story"
Built a Subscription Cohort Retention Dashboard in Google Sheets today π
It tracks cancellation behavior by subscription week to answer:
β
Which cohorts have higher churn
β
How quickly users cancel
β
Whether newer cohorts are retaining better
How to read it:
β Columns = Subscription week
β Rows = Cancellation week
β Cells = % of that cohort cancelled
Turning raw subscription data into actionable retention insights.
#DataAnalytics #CohortAnalysis #RetentionAnalysis #ChurnAnalysis #GoogleSheets #DashboardDesign #AnalyticsEngineering #DataVisualization #SQL #BusinessAnalytics
45
Data Science with Sushant retweeted
May 21
Data Science Roadmap π
Stage 1: Python
Stage 2: Statistics Probability
Stage 3: NumPy Pandas
Stage 4: Data Cleaning
Stage 5: Data Visualization
Stage 6: SQL
Stage 7: Machine Learning
Stage 8: Feature Engineering
Stage 9: Model Evaluation
Stage 10: Deep Learning Basics
Stage 11: Deployment MLOps
Stage 12: Real-world Projects
Most people stop after plotting graphs π
(pls save and repost if you found this useful)
3
57
343
9,614
Explored a neat SQL trick to generate the last X days dynamically using sequence() explode() in Spark SQL π
No need for calendar tables or hardcoded dates anymore π
WITH date_range AS (
SELECT
DATE_SUB(CURRENT_DATE(), seq) AS analysis_date
FROM (
SELECT
explode(sequence(0, 6)) AS seq
)
)
SELECT *
FROM date_range;
1
46
58
Want to become a strong Data Analyst?
Master these SQL concepts firstπ
β’ JOINs β especially LEFT JOIN & CROSS JOIN
β’ WITH clause (CTEs) β makes SQL cleaner & reusable
β’ Ranking Functions β ROW_NUMBER() is a must-know
β’ COALESCE β extremely useful for handling NULLs
β’ CASE WHEN β powerful for categorization & custom ordering
Most analysts know SQL.
Good analysts know how to structure SQL well.
#SQL #DataAnalytics #DataAnalyst #Analytics #Learning #DataScience #Tech #100DaysOfCode #BusinessIntelligence
45