DataAI Gal

Data Analyst| Open to work opportunity| Upskilling for Data Science And Data Engineering|Let's grow together in Data World ❤️✨ | Follow on Medium👇

[DataAI Gal @nishtha_ds]

Hi,
If you’re a Data Analyst, Product person, or Founder
using data to make smarter decisions,
I’d love to connect.

Working on sharpening my analytics + storytelling skills
and learning how AI can level up data work.

[DataAI Gal @nishtha_ds]

For non-members, the link is provided in the article to access the full content.

[DataAI Gal @nishtha_ds]

After spending time reading reports, observing real hiring patterns, and reflecting on how the role has changed, I realised something important.
The data analyst role isn’t disappearing.
It’s being rewritten.
Read This:
https://t.co/1OXQuzfA4g

[DataAI Gal @nishtha_ds]

When you group by country and region,
each row represents a region within a country.
The same region can now appear multiple times.
Different granularity. Different insight.

[DataAI Gal @nishtha_ds]

#Day4 : 𝐆𝐑𝐎𝐔𝐏 𝐁𝐘 is not just syntax.

It defines the level at which truth is measured

𝐒𝐄𝐋𝐄𝐂𝐓 𝐫𝐞𝐠𝐢𝐨𝐧, 𝐒𝐔𝐌(𝐫𝐞𝐯𝐞𝐧𝐮𝐞)
𝐅𝐑𝐎𝐌 𝐬𝐚𝐥𝐞𝐬
𝐆𝐑𝐎𝐔𝐏 𝐁𝐘 𝐫𝐞𝐠𝐢𝐨𝐧;

This answers a different question than:

[DataAI Gal @nishtha_ds]

𝐒𝐄𝐋𝐄𝐂𝐓 𝐜𝐨𝐮𝐧𝐭𝐫𝐲, 𝐫𝐞𝐠𝐢𝐨𝐧, 𝐒𝐔𝐌(𝐫𝐞𝐯𝐞𝐧𝐮𝐞)
𝐅𝐑𝐎𝐌 𝐬𝐚𝐥𝐞𝐬
𝐆𝐑𝐎𝐔𝐏 𝐁𝐘 𝐜𝐨𝐮𝐧𝐭𝐫𝐲, 𝐫𝐞𝐠𝐢𝐨𝐧;

When you group by region,
each row represents one region
with total revenue for that region.

[DataAI Gal @nishtha_ds]

𝐒𝐄𝐋𝐄𝐂𝐓 𝐀𝐕𝐆(𝐂𝐎𝐀𝐋𝐄𝐒𝐂𝐄(𝐝𝐢𝐬𝐜𝐨𝐮𝐧𝐭, 𝟎)) 
𝐅𝐑𝐎𝐌 𝐬𝐚𝐥𝐞𝐬;

Assumptions should be explicit.

#SQL #DataLogic #DataAnalytics

[DataAI Gal @nishtha_ds]

#Day3 : NULL is 𝒏𝒐𝒕 𝒛𝒆𝒓𝒐. And it 𝒊𝒔 𝒏𝒐𝒕 𝒇𝒂𝒍𝒔𝒆.

𝐒𝐄𝐋𝐄𝐂𝐓 𝐀𝐕𝐆(𝐝𝐢𝐬𝐜𝐨𝐮𝐧𝐭) 
𝐅𝐑𝐎𝐌 𝐬𝐚𝐥𝐞𝐬;

This 𝒊𝒈𝒏𝒐𝒓𝒆𝒔 𝑵𝑼𝑳𝑳 𝒗𝒂𝒍𝒖𝒆𝒔 by default. If missing data means no discount, your logic should explicitly state this.

[DataAI Gal @nishtha_ds]

If you don’t define what you’re counting,
the metric can be technically correct
and still be business-wrong.

Logic decides correctness.

#SQL #DataAnalytics #DataLogic

[DataAI Gal @nishtha_ds]

#Day2 : SQL is not just about writing queries.
It’s about understanding the question first.

𝐂𝐎𝐔𝐍𝐓(*) counts 𝒓𝒐𝒘𝒔.
𝐂𝐎𝐔𝐍𝐓(𝐜𝐨𝐥𝐮𝐦𝐧) counts 𝒏𝒐𝒏-𝒎𝒊𝒔𝒔𝒊𝒏𝒈 𝒗𝒂𝒍𝒖𝒆𝒔 in that column.

Both return numbers.
They answer different questions.

[DataAI Gal @nishtha_ds]

@RealBenjizo B. 7

[DataAI Gal @nishtha_ds]

#Day1
Logic is the real skill. Anyone can learn tools. Few can break a problem down cleanly.
Good analysis starts before SQL is written.
Before charts are built, it starts with asking the right question.
That’s where real data work happens.
#DataAnalytics #SQL

[DataAI Gal @nishtha_ds]

“In the middle of difficulty lies opportunity.”
~Albert Einstein

60 days to turn pain into purpose.
Less noise, more focus.
Everything still has time to change

Let's do this🙏🏼🙌🏼

[DataAI Gal @nishtha_ds]

Hi,
If you’re a Data Analyst, Product person, or Founder
using data to make smarter decisions,
I’d love to connect.

Working on sharpening my analytics + storytelling skills
and learning how AI can level up data work.

[DataAI Gal @nishtha_ds]

Go check out my new article that I published - The Unseen Challenge: Why Model Context Protocol (MCP) is Becoming an Industry Standard for AI
Link: https://t.co/QH1fYOm1Td

[DataAI Gal @nishtha_ds]

When people are absent and conversations fall silent, I turn to learning🤷🏼
Even if my purpose feels hidden, I believe the author of my life hasn’t forgotten me🙄
Perhaps my chapter just begins a little later😑
And until then, knowledge will stay by my side🙃🤌🏼

[DataAI Gal @nishtha_ds]

Restart wasn’t a choice. It was survival
This is my story of restarts.
https://t.co/KNbAE4Zq7H

[DataAI Gal @nishtha_ds]

The Last 10 Most Asked SQL Interview Questions in this series
https://t.co/TnzMnrEuz4

[DataAI Gal @nishtha_ds]

@its_ShubhamK Done😊

[DataAI Gal @nishtha_ds]

@its_ShubhamK Welcome to Medium, Shubham. Following you right away. Here is mine..Do check if you get time 😊 https://t.co/Ol1RiYUEsB