[SQL Interview] Differences Between RANK() and DENSE_RANK()
In a data analyst interview, various questions can be asked to evaluate your data analysis… Read More »[SQL Interview] Differences Between RANK() and DENSE_RANK()
[SQL Interview] Differences Between LEAD() and LAG()
In a data analyst interview, various questions can be asked to evaluate your data analysis… Read More »[SQL Interview] Differences Between LEAD() and LAG()
SQL LAG Function Example: Analyzing Cancellation Rates in BigQuery
Introduction In this article, we will use the LAG function in BigQuery to analyze commission… Read More »SQL LAG Function Example: Analyzing Cancellation Rates in BigQuery
[BigQuery] Mastering SQL for JSON Data Handling: A Practical Guide
Introduction: The Significance of JSON in Data Analysis In today’s digital age, JSON (JavaScript Object… Read More »[BigQuery] Mastering SQL for JSON Data Handling: A Practical Guide
Understanding Looker Joins: Relationships & Examples
Looker, a powerful business intelligence tool, employs data modeling to help organizations analyze and visualize… Read More »Understanding Looker Joins: Relationships & Examples
How to use Aggregate Awareness in Looker
Here’s a blog post on leveraging aggregate awareness in Looker using web traffic data tables… Read More »How to use Aggregate Awareness in Looker
Creating Persistent Derived Tables (PDTs) in Looker: An Overview of Errors and Solutions
This article explores the creation of Persistent Derived Tables (PDTs) in Looker, detailing why we… Read More »Creating Persistent Derived Tables (PDTs) in Looker: An Overview of Errors and Solutions
How to use SQL SET/DECLARE Statements (with example)
In this post, we’ll explore how to declare and assign variables using the SET and… Read More »How to use SQL SET/DECLARE Statements (with example)
SQL date functions with examples
In this article, we’ll learn how to handle dates using SQL. We’ll take a closer… Read More »SQL date functions with examples
Thesis Writing Basics (2.2) Purpose, Advantages and Considerations of Mixed Methodology
This article summarizes the paper “Bridging the Qualitative-Quantitative Divide: Guidelines for Conducting Mixed Methods Research… Read More »Thesis Writing Basics (2.2) Purpose, Advantages and Considerations of Mixed Methodology