Before getting into the topic lets first know what is Tableau and Why it is used? What Is TABLEAU? Imagine you are a manager at a growing company. Every day, information comes in from different places sales reports, customer feedback, website visits, and financial records. Soon, you have thousands of rows of data in the form of spreadsheets and databases. Looking at all this raw data feels like trying to read a huge pile of puzzle pieces without seeing the full picture. Th

The term DATA OBSERVABILITY was first coined in 2019. How I define Data observability is that how it allows you to continuously monitor your data and data systems. It helps you spot problems early, understand what caused them, and resolve them before they affect reports, dashboards, or decision making. Data observability monitors a dataset's volume and freshness. Data observability ensures that all expected data is present and refreshed at the correct time. It uses exceptiona

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

Geospatial Data in modern digital systems Geospatial data has become a cornerstone of modern digital systems. From ride‑sharing apps and logistics platforms to urban planning tools and environmental monitoring systems, location‑aware data powers decisions across industries. Geospatial data represents objects, events, or phenomena that have a location on Earth. This location can be expressed in many ways: Points (e.g., a store location) Lines (e.g., a road or river) Polygon

Learn how PostgreSQL window functions enable advanced data analytics without collapsing rows. This blog uses the Titanic dataset to demonstrate ranking, running totals, segmentation, and trend analysis using real-world SQL examples.

From NON - IT to Data Analytics... Could This Be Your Story Too? Photo by Deng Xiang on Unsplash Have you ever sat at your desk and thought, “I’m doing my job well… but is this really what I want to do long term?” If yes, trust me you’re not alone. I was working in the financial sector , handling daily operations, transactions, and reports. Everything was stable. Everything was familiar. But somewhere along the way, I started noticing something interesting, every decision wa

Yes, another blog on how to prepare a visual, borinnggg! But hear me out. As you start building visuals, you often try to visualize data in the same basic charts. But we are often pushed to visualize the same old data in some new light. As I was racking my brain for a new way to visualize simple data, I stumbled upon the Word Cloud visual, which I had created during my primitive days and wondered why not give it a try. And to my surprise the feedback was completely positive.

Sprint-2: Butterfly Chart from Scratch: Visualizing Age and Gender Patterns in Sepsis Data Butterfly chart is a great way to compare the...

Sprint-2: Unveiling Sepsis Patterns Across Age and Gender Segregation of sepsis and non-sepsis patients according to age group and gender...

My journey through Sprint-1: turning medical data into insights that could save lives. What is Sepsis? Sepsis is the body’s extreme...

Hey Everyone, Happy to connect you all once again through my writing...! Recently I have come across a situation...

PostgreSQL, a powerful open-source relational database, offers many features that simplify backend development and data handling. One...

PostgreSQL's query planner is pivotal in executing queries efficiently. By leveraging the EXPLAIN ANALYZE command, developers can gain...

In a multi-tenant or secure data environment, it's not enough to just control who can access a table. You often need to control which...

What is Data Analysis? Data Analysis is the process of inspecting, cleaning, transforming and modeling data to discover useful...

Welcome back to the SQL series! We now dive into a critical feature in SQL databases— Views . Views offer an abstraction over database...

Stored procedures in PostgreSQL provide a powerful way to encapsulate complex logic, manage transactions, and handle data efficiently. In...

In the previous blog, we learned about SQL triggers and discussed DML triggers in detail, covering all the combinations of BEFORE and...

Indexes are vital components in SQL databases, enabling faster data retrieval and improving query performance. This blog explores what...

In the world of databases, SQL (Structured Query Language) is essential for performing various operations that allow users to manage...