Ayan Khan (@ayankhann15) 's Twitter Profile
Ayan Khan

@ayankhann15

Data Analyst • Excel | SQL | Python | Power BI | AWS • I spoke data joints and tell insightful stories

ID: 1594745617594589184

calendar_today21-11-2022 17:32:54

9 Tweet

1 Takipçi

16 Takip Edilen

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

day 1 of daily excel series to win the excel interviews real world data is always very messy and you just can't clean it manually one by one this is where text to columns will help you save a lot of time it is a feature that splits a single column of text into multiple

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

day 52 of 2026: → started working on a complex sql project → finished a 13 hour fast (5/30 done) → 9 hours data analytics job → solved 1 sql interview questions → trained upper back & lats → completed creatine intake → prayed 5/5 times → read quran (1 chapter) → thanked

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

day 2 of daily excel series to help you win the excel interviews yesterday we learned about text to columns feature and today I will show 3 very powerful text formulas that you'll definitely use every single time while cleaning messy data in analytics, you'll often need to

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

day 3 of daily excel series to win the excel interviews at my data analytics job, out of all the excel formulas i use many of them everyday but there are 4 super powerful formulas i just can't ignore & can't live without them and those are left, right, mid & len → len:

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

day 53 of 2026: → performed time-series analysis in a sql project → finished a 13 hour fast (6/30 done) → 9 hours data analytics job → trained triceps → solved 1 sql interview question → completed creatine intake → prayed 5/5 times → read quran (1 chapter) → thanked the

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

this post is for you if you are practicing data analytics there are two ways to learn data analytics either you enroll yourself in a boot camp or learn everything on your own through youtube and both of them don't guarantee you a full time job because in both ways, there are

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

day 55 of 2026: → continued working on the sql project → finished a 13 hour fast (8/30 done) → 9 hours data analytics job → solved 1 sql interview questions (humbled me) → completed creatine intake → prayed 5/5 times → read quran (1 chapter) → thanked the almighty for

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

day 56 of 2026: → finished a 13 hour fast (9/30 done) → solved 1 sql interview questions → trained chest (soreness at its peak) → completed creatine intake → prayed 5/5 times → read quran (1 chapter) → thanked the almighty for everything missed solving a sql question

Ayan Khan (@ayankhann15) 's Twitter Profile Photo

you don't need to know every single sql function these 50 sql popular & commonly used functions are enough and you should definitely know & practice them for interviews → count( ): counts the number of rows in a result set → sum( ): calculates the sum of values in a