Introduction: When I started to explore the datasets, one thing I’ve noticed is that static charts are useful only up to a certain point; i.e., the raw numbers will not give the proper story. They help us understand the data initially, but as soon as someone wants to explore the information in more detail, we often end up creating multiple versions of the same chart. Why does interactivity matter? Let me explain with a simple example from the heart disease dataset. Suppose I

Introduction Whenever we work with real‑world data, especially medical data, the first thing we need to do is understand what the data is and how it look like. Before building any model, it’s important to check whether the dataset has unusual values, missing values, or anything that might affect the results later. Outliers are simply values that don’t fit in with the rest of the data — they may be much higher or lower than what we normally expect. In healthcare datasets, thes

Data visualization is an important skill for every data analyst. Instead of looking at large tables of numbers, charts and graphs make data easier to understand. They help people quickly spot trends, patterns, and important information. Python offers useful tools like Pandas, Matplotlib, and Seaborn that make it simple to create charts and turn raw data into clear and meaningful visuals. In this article, we'll explore the Popular charts that every beginner data analyst should

In Healthcare, data is often available in large quantities with messy and inconsistent format. When I explored this dataset, I noticed missing values, inconsistent formats, outliers, and unstructured clinical measurements. This blog mainly focuses on transforming raw healthcare data into meaningful insights using Python for data cleaning and feature engineering, followed by building interactive dashboards in Tableau. The main goal of this blog, before building dashboards or

When I started working on a diabetes dashboard data, I wanted something simple: a clean web app where I could explore data, detect outliers, visualize patterns, and run a machine learning model with a known and easy language python. Streamlit is a remarkable Python library that lets you turn a normal Python script into a fully interactive web application. In this blog, I’ll walk through everything I did — from installing packages, building the app, adding caching and navig

Hello everyone! Welcome to another Interesting Tech Update on Analytics! Recently, I came across an interesting update about chDB in the TDLR Newsletter, which motivated me to explore it further. Until now, I’ve mostly worked with server‑based SQL engines such as PostgreSQL, MySQL, and SQL Server. I’ve also used serverless SQL engines on many challenge platforms like DataLemur, LeetCode, and HackerRank. These platforms typically use in‑process SQL engines, which don’t

Healthcare organizations generate huge amounts of patient and provider data daily. In this blog, we use Python to analyze the HC Dataset from Kaggle, focusing on patient discharge trends, provider specialties, and ambulatory visit patterns. Key insights include variations in length of stay (LOS), discharge dispositions, and visit volumes, which help hospitals optimize staffing, improve operational efficiency, and improve patient care.

I. The Goal: Testing the Hype In my last post, I documented how I built a custom dataset by pulling live data directly from Wikipedia. It was a process of turning messy web tables into a structured CSV file. Today, I’m putting that data to work to answer a question many of us have: Are record-breaking box office numbers a consistent new trend or are we just seeing a few lucky hits? By looking at the last 30 years of cinema, I wanted to see if the "Billion Dollar Club" is actu

Introduction: Challenging the Traditional Analytics Workflow Usually, the roadmap for building a data portfolio follows a very specific, linear path. The formula is familiar to almost everyone entering the field: Find a pre-cleaned dataset on a portal like Kaggle. Download the static CSV file. Clean any minor remaining errors using Excel, SQL or Power BI. Visualize the results in a standard dashboard. It’s a safe and effective process for learning the basics. However, as

As I began my journey as a Data Analyst, I often found myself questioning a fundamental part of the job: If I have already done the math, why do I need the picture? I was meticulously calculating means, variances, and correlations for every dataset that crossed my desk. I felt that if the math was accurate, the story was told. Why spend hours perfecting a chart when the 'truth' was already sitting there in the totals? That skepticism vanished the moment I came across Anscomb

Decoding the Silent Language: How Visuals Turn Bio-Data into Action Your body is constantly speaking to you, but it speaks in a language of numbers that most of us can’t instinctively understand. Every heartbeat and sleep cycle is a data point in the vast experiment of the "Quantified Self". As a Data Analyst, I believe our job is to act as translators. If we use the wrong visual "lens," the story of our health becomes noise. But with the right representation, we can finally

The "Why": From Reporting to Empowering As a data analyst, I’ve realized that insights are often "trapped" within the technical environments where they are created. In my previous analysis, I utilized Tableau to create a visual representation of the heart disease data. While Tableau is exceptional for discovery, I realized that for a clinical tool to be truly interactive and "live" in a custom web environment, a doctor or researcher needs a workspace that exists on their own

Python makes data analysis simple and complete. You can clean data, merge files and databases, run statistical tests, and even prepare it for charts and models—all in one tool, for free.

Hi team! Check out my latest blog on why data cleaning is critical for accurate visualizations and better business decisions. I also show a real-world COVID-19 dataset case study using Python.

The Python hackathon gave me hands-on experience analyzing the Flatten COVID-19 dataset in Jupyter Notebook—the digital lab book where data scientists prototype Python, R, and more. Before writing a single line of code, I learned the first rule of data analysis: deeply understand your dataset first. Dataset Reality Check: This wasn't hospital lab data. It contained self-reported COVID-19 symptom surveys from Ontario residents during early 2020, split across 3 evolving schemas

Example visualizations with Vega-Lite. Introduction In the world of data science and analytics, clear and concise visualization is key to uncovering insights and communicating findings effectively. While tools like Tableau are widely used for their drag-and-drop interface and interactivity, Altair stands out in the Python ecosystem as a declarative statistical visualization library that's both intuitive and powerful for coders. Built on the Vega-Lite grammar, it enables users

Visual storytelling in data analysis is the practice of using visuals—charts, graphs, plots, and annotated figures—to communicate...

Imagine you're sitting on an enormous pile of data, wishing you could instantly spot trends, outliers, or weird patterns? Whether you're...

Suze Orman once said, “Cleanliness is a state of purity, clarity, and precision. ” This not only applies to our day-to-day cleaning, but...

Joins Joins in the data world means combining two tables horizontally. Join functions/queries help us to consolidate two separate tables...