Data Warehouse
Redshift vs. Snowflake
Redshift vs Snowflake In the following table, I shall highlight key features of the two data warehousing options Redshift versus Snowflake. In the case
The Library
The Modern Data library is our collection of resources for data-driven businesses.
Data Transformation
dbt 101: The fundamentals
If you are considering adding dbt to your data stack, it’s important to understand how it works and what value it will bring to your data team.
BI
Introduction to Power BI (Updated 2023)
An introduction to the Power BI platform updated with 2023 changes to help users better understand architecture, key concepts and the general workflow for building reports.
GA4
Export Google Analytics (GA4) Data to BigQuery
Examining the different methodologies available for exporting data from Google Analytics (GA4 Properties) into BigQuery and the pros and cons of each approach.
ETL
ETL Tool Evaluation: Paid Media
Let’s look at different ETL tool options for some common paid media data sources. In our evaluation we shall compare coverage, pricing, and sync frequency.
BI
Business Intelligence (BI) Tools: Selection Critera
Finding the right Business Intelligence (BI) Tool that will serve your organization’s needs can be challenging. There are a lot of options on the market with varying capabilities and features. Let us look at some key factors one needs to take into consideration when selecting a BI tool.
SQL
SQL Tip: Window Functions Can Produce Inconsistent Results
SQL window functions can be very useful when it comes to high power manipulation of your datasets. However, it is important to understand the importance of using the correct tie breakers to ensure you have consistent results.
Data Transformation
Upgrading to DBT 1.0: Helpful Tips
With DBT Cloud deprecating support for jobs running on versions earlier than 1.0, all DBT Cloud projects need to be upgraded from 0.x DBT versions
Snowflake
S3 to Snowflake: Parallel Processing Using Task Trees
Snowflake makes it easy to copy data from an S3 bucket (JSON, CSV, parquet) into a Snowflake table either using its bulk load option or Snowpipe, for