Understanding the difference — For Data Scientists and Data Analysts, SQL is a must-know skill. Writing a correct and optimized SQL query is sometimes a work of art. …

A conceptual description of Normalization techniques. — “Data” is at the core of every software application. Hence, the success and usability of any software are highly dependent on how the data has been organized. There can be multiple ways to organize data depending upon the type of business use cases that the software is dealing with. E.g…

Understanding the Suite... — PowerBI is a Business Intelligence platform from Microsoft which provides interactive visualization capabilities enabling users to create their own reports and dashboards in a very simple and intuitive way. It's a collection of apps and services that helps in importing, preparing, aggregating, and presenting data in a meaningful way. Gartner.com…

A guide for building Intuition for scalable system design — Imagine that you are the owner of a grocery store. You have one billing counter. Customers come into your store, pick stuff and get in line at this billing counter to pay. You have an employee named John, behind the billing counter taking care of customers. John is a happy-go-lucky…

One of the most crucial business configurations in any PV Safety system is the configuration of Products and Licenses. This article explains the basic concepts of this configuration taking Oracle’s Argus Safety as an example Safety system. Product A PV company is in the business of manufacturing and selling medicinal products…

Simplifying the jargon around APIs — This article talks about Application Programming Interfaces (APIs). Today, APIs are at the very center of modern software development. They are becoming so common that phrases like “Hey! Use an API for this” or “There is already an API” are frequently used in conversations of software people. In fact, the…

Playing with Git — “There is no such thing as Truth. Everyone has his own version of it” Have you ever saved your files with date-time stamps in file names? I guess most of us have done it to save a version of our existing files. This is required when we have certain changes…

My experience as a parent of a lovely kid who happens to be in the spectrum! — I am a parent of a 9-year-old autistic kid. For me, like many other parents, Autism has been an arduous journey going through countless diagnoses, therapy sessions, multiple interactions with special education teachers, formation and implementation of Individual Education Plans(IEPs), and days/nights filled with exhaustion, despair, and glimmers of hope.

The real meaning behind Measures of Central Tendency and Measures of Spread — Let's do a think-experiment. Imagine that the world around you just froze. Nothing is changing. Everything is on a standstill. Is there anything, that is meaningful? Anything you can learn? Nothing. A stopped world is equivalent to a no world! The world exists because it “changes”. Rotations and revolutions of…