Who Cares if Big Data Is Dead!
· ☕ 5 min read
What really matters is the quality of the data, the data literacy at the organization, and the motives behind using data analytics.
data
SQL Renaissance
· ☕ 3 min read
SQL is dead. Long live SQL. Why SQL is thriving even after 48 years. Resources to learn and master SQL.
Which Data Pipeline Orchestration Tool Is Right For You?
· ☕ 6 min read
With diverse data sources, multi-cloud, and data mesh scenarios becoming increasingly common, a misfit data pipeline orchestration tool can multiply your woes.
Types of SQL Joins: Inner, Left, Right, and Full
· ☕ 7 min read
Various types of SQL Joins: inner, left, right, full, and cross. Understanding SQL joins will help you in making them fast.
Data Visualization Chart Cheatsheets
· ☕ 3 min read
Cheatsheets and decision trees to find the best visualization for your data and purpose
Setting Up Data Collection
· ☕ 3 min read
Examines the effort-cost spectrum for data collection approaches from do-it-yourself to fully-outsource-it w.r.t. team's ability/budget.
📌 SQL vs. NoSQL Database: When to Use, How to Choose
· ☕ 12 min read
Difference between SQL and NoSQL database. When to choose NoSQL over SQL. Decision tree to pick from RDBMS, key-value, wide column, document, graph dbs.
Pandas Apply: 12 Ways to Apply a Function to Each Row in a DataFrame
· ☕ 12 min read
How to efficiently iterate over rows in a Pandas DataFrame and apply a function to each row. 5 simple yet faster alternatives to Pandas apply and iterrow methods.
📌 Scalable Efficient Big Data Pipeline Architecture
· ☕ 11 min read
Scalable and efficient data pipelines are as important for the success of data science and machine learning as reliable supply lines are for winning a war.