Intersection of data, technology, and business
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…
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…
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…
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…
How to set up CUDA and Tensorflow on a Windows PC
In this article, we will learn how to run Tensorflow on a CUDA-compatible Nvidia graphics cards on a Windows 10 PC. If you are just getting started with deep learning and Tensorflow, setting up your development environment can be quite challenging. There are often compatibility issues with different versions. For…
Snowflake Basics for Beginners
In this first issue we will talk about Snowflake — one of the hottest IPO of 2020. We will understand basics such as the evolution of data management systems, concept of a relational database, and what is a data warehouse. We will then review key differentiators of Snowflake. Snowflake has…
AWS Certification Preparation Guide
AWS certifications is a fantastic way to learn AWS and gain in-demand credentials. Let us see how. How to prepare for AWS certifications? In this article, we will describe how to prepare for AWS Solutions Architect certification and AWS Cloud Practitioner exams. Our goal is to help you prepare in…
SQL Tutorial for Beginners
This is a beginner level introduction to Structured Query Language (SQL). In this article you will learn following concepts: History of relational databases (RDBMS) and SQLThe concept of tabulating data in rows and columns.Structure of a simple SQL statementUnderstand the flow of query execution and components of the SQL statement…
Newsletter
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…
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.…
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…
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…
Resources & Reference
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…
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…