premsolanki 
If you work with data long enough, you reach a point where spreadsheets stop being enough. Someone asks for “the same report, but for last month,” then “the same report, but by region,” then “can we see this every morning without emailing you?” That is usually the moment you start looking for a proper dashboard … Read more
If you sat down and logged what you do in pandas over a month, two operations would dominate almost everything else: splitting data into groups and summarising it, and sticking two tables together. Everything else is decoration. Get these two right and you can do most analysis work. The problem is that both of them … Read more
Every pandas tutorial starts with a clean dataset. Real work never does. Real work starts with a file called sales_final_v3_USE_THIS.xlsx where the header is on row four, prices are stored as text with currency symbols, half the dates are in the wrong format, and the region column contains “North”, “north”, “N” and an empty cell. … Read more
Superset can be confusing on day one, and it is usually for the same reason: people go straight to “create chart”, hit a wall, and conclude the tool is awkward. The wall is almost always the same. Superset separates your data from your charts more strictly than Excel or Power BI does, and until that … Read more
Nobody warns you about this part. You learn joins, you learn aggregation, you land a job, and then you discover that the field called district contains “Pune”, “pune”, ” Pune “, “PUNE”, “Pune ” and “Punr”. And a number. And, for reasons nobody can explain, the word “test”. Cleaning data is the majority of analytics … Read more
There is a specific kind of silence that happens when you run a query in front of someone. The spinner turns. You start talking to fill the gap. You mention that the table is quite large. Two minutes later you are apologising. Most slow queries are not slow because the database is weak or because … Read more
If you have ever downloaded a sentence transformer to cluster support tickets, pulled a dataset off the Hub to test a model, or run a quick sentiment pass over survey responses, you have used Hugging Face. Most of us treat it the way we treat GitHub or PyPI: infrastructure. Boring, reliable, always there. That changed … Read more
There is a moment in most analysts’ careers where they stop writing SQL that works and start writing SQL that is good. For a lot of people, that moment is window functions. Before you learn them, certain problems feel genuinely impossible in SQL. Rank each salesperson within their region. Show each month alongside the previous … Read more
Every analytics team has one. A dashboard that took three weeks to build, got a nice reception in the demo, and now gets opened twice a month, both times by the person who built it, checking whether it still loads. I have built a few of these. The uncomfortable part is that they were not … Read more
The brief The client came to me with a simple sounding problem: “our sales numbers do not match and we do not know why.” They had been running the business for a few years. Data had accumulated in the way it usually does, which is to say one file per month, exported from different systems … Read more