Who Cares if Big Data Is Dead!
· ☕ 5 min read
Newsletter Issue 20: 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
Newsletter Issue 17: 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
Newsletter Issue 16: 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
Newsletter Issue 6: Cheatsheets and decision trees to find the best visualization for your data and purpose
Setting Up Data Collection
· ☕ 3 min read
Newsletter Issue 5: 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.