Inmon vs Kimball Data Warehouse Approaches

The terms Kimball and Inman may be old but still relevant in the age of the Modern Data Stack. But in the technology industry, the new is often built on the foundation of the old. The same can be said about the Inman vs Kimball model of the Enterprise Data Warehouse. Bill Inman recently had … Read more

Tableau DATEDIFF Function Complete Guide

In this article we will learn how to use Tableau DATEDIFF function. DATEDIFF function is used to calculate the difference between two date/time points. There are multiple ways of doing date calculations in Tableau. Using Arithmetic operation on date field Using DATEDIFF function Using date function in SQL. In this article, we will focus on … Read more

Power of Tableau’s DATEADD Function

In this article we will learn how to use Tableau DATEADD function. DATEADD function is used to add or subtract a time interval (hour, days, minutes) to a date. There are multiple ways of doing date calculations in Tableau. Using Arithmetic operation on date field Using DATEADD function Using date function in SQL. In this … Read more

Issue 04 – One Database Will Never Happen

In this issue, we will cover. There are many databases and tools but where is the data platform? There are only three roles in data Data visualization color guide The Future of the (Modern) Data Stack Indexes in Postgres Why "one database" will never happen and how data platform helps? A few years ago, I … Read more

Issue 03 – State of data jobs and VC funding

In this issue, we will cover. The distribution of data jobs by primary technical skill (spoiler – Python & SQL win by a wide margin). The rise of operational analytics. Inspiring Tableau data visualizations Big data, big money Free learning resources on deep learning and a data engineering bootcamp Which data skills are in demand? … Read more

Issue 02 – BI Unbundling, Data Podcasts, Emissions

In this issue, we will talk about the need for unbundling of the Business Intelligence layer. The lack of love for the semantic layer (relative to visualization) has been a net negative for data professionals. We will look at example of a data visualization from McKinsey. This chart will highlight what makes a visualization pop. … Read more

Issue 01 – Snowflake, Scaling MySQL, AWS Flashcards

In this inaugural issue we will cover Snowflake, cloud computing flash cards, and books and resources about data science. Snowflake is hot and for good reasons. It is the first major relational database that is targeting some of the toughest challenges of data professionals: data sharing, collaboration, and analytics. There have been many solutions to … Read more

Snowflake Introduction

What exactly is Snowflake? Snowflake is a cloud-based data warehousing platform. Snowflake is built on top of the public cloud. Snowflake is a SaaS (Software as a Service) offering. Unlike traditional data warehouse options, Snowflake provides a unique data warehouse. It is not only easier to set up, faster, and more flexible. Snowflake has become … Read more

Tips for Avoiding Null Value Errors in Tableau

If you have worked with Tableau, you may seen ‘null’ values appearing in your data. In this complete guide to Tableau and null values we will cover following topics. What are null values? Null values means values that do not exist. Null value means absence of value. Here is a real-world example of why null … Read more

Excel vs Tableau – Pros and Cons

In this article, we will understand how Tableau differs from Excel – the world’s most used Business Intelligence tool. If you are reading this article, chances are, you like Tableau and/or Excel. Both Tableau & Excel are fantastic tools. Comparing the two tools is like comparing a philips screwdriver with a flathead. Both Tableau and … Read more