Srilekha Mylavarapu·Sep 19, 2025Building an ETL pipeline using AirflowYou have got a messy CSV and a few lines of pandas that clean it. This micro‑guide shows how to turn that script into a tiny, scheduled…
Srilekha Mylavarapu·Sep 1, 2025Using SQL to answer business questions: From raw data to insightsIn any business, sales data is one of the richest sources of insight. But raw tables don’t mean much on their own.We need structured…
Srilekha Mylavarapu·Feb 27, 2025Sentiment analysis using Python | VADER NLTP methodOften times, part of data analysts’ job is to analyze the unstructured text. Data Analysts do not always analyze numbers,they need to bring…
Srilekha Mylavarapu·Sep 30, 2024Automating data reporting with PythonThis article discusses automating data reporting on a periodic basis using Python. Data analysts are often expected to spend about 30% of…
Srilekha Mylavarapu·Sep 21, 2024Importing Any Dataset into MySQL Workbench Using Python: A Step-by-Step GuideThis article is about importing datasets into MySql workbench. Most commonly, the datasets are shared in an excel file. MySQL workbench…
Srilekha Mylavarapu·Mar 8, 2024Landing the first data analyst jobHow many of you thought following a youtube channel and adding a couple of projects on to your profile with a fancy portfolio would…