Blog
Postgres Analytics – Moving Average
I can teach you analytics! Postgres is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze trends…
Read MoreGreenplum Analytics – Moving Average
I can teach you analytics! Greenplum is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze trends…
Read MoreVertica Analytics – Moving Average
I can teach you analytics! Vertica is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze trends…
Read MoreNetezza Analytics – Moving Average
I can teach you analytics! Netezza is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze trends…
Read MoreTeradata Analytics – Moving Average
I can teach you analytics! Teradata is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze trends…
Read MoreAmazon Redshift Analytics – Moving Average
I can teach you analytics! Amazon Redshift is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze…
Read MoreSQL Server Analytics – Moving Average
I can teach you analytics! SQL Server is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze…
Read MoreAzure Synapse Analytics – Moving Average
I can teach you analytics! Azure Synapse is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze…
Read MoreGoogle BigQuery Analytics – Moving Average
I can teach you analytics! Google BigQuery is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze…
Read MoreDatabricks Analytics – Moving Average
I can teach you analytics! Databricks is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use it to analyze your data, and…
Read MoreSnowflake Analytics – Moving Average
I can teach you analytics! Snowflake is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use it to analyze your data, and…
Read More1000 Techniques to Join Data Across Systems
Which is more difficult, landing on the Moon or joining tables across database platforms? It is probably more difficult to land on the Moon. However, everybody knows databases are proprietary and don’t talk with others. Over 20 years, we made it our business to integrate all database systems completely. Can we join data across database…
Read MoreAnalytic and Window Functions For All Systems (Over 100 Blogs)
I wish I had mastered ordered analytics and window functions early in my career, but I was afraid because they were hard to understand. After some time, I found that they are so easy to understand. I’ve curated a collection of my favorite and most powerful analytics and window functions in this blog post. These…
Read MoreMySQL Analytics – Cumulative Sum
I can teach you analytics! MySQL is built for analytics, and I will show you the cumulative sum this week. A cumulative sum is a running total of values progressively increasing or accumulating over time or across a dataset. It represents the summation of all values encountered up to a certain point or row in…
Read MorePostgres Analytics – Cumulative Sum
I can teach you analytics! Postgres is built for analytics, and I will show you the cumulative sum this week. A cumulative sum is a running total of values progressively increasing or accumulating over time or across a dataset. It represents the summation of all values encountered up to a certain point or row in…
Read MoreGreenplum Analytics – Cumulative Sum
I can teach you analytics! Greenplum is built for analytics, and I will show you the cumulative sum this week. A cumulative sum is a running total of values progressively increasing or accumulating over time or across a dataset. It represents the summation of all values encountered up to a certain point or row in…
Read MoreNetezza Analytics – Cumulative Sum
I can teach you analytics! Netezza is built for analytics, and I will show you the cumulative sum this week. A cumulative sum is a running total of values progressively increasing or accumulating over time or across a dataset. It represents the summation of all values encountered up to a certain point or row in…
Read MoreTeradata Analytics – Cumulative Sum
I can teach you analytics! Teradata is built for analytics, and I will show you the cumulative sum this week. A cumulative sum is a running total of values progressively increasing or accumulating over time or across a dataset. It represents the summation of all values encountered up to a certain point or row in…
Read MoreSQL Server Analytics – Cumulative Sum
I can teach you analytics! SQL Server is built for analytics, and I will show you the cumulative sum this week. A cumulative sum is a running total of values progressively increasing or accumulating over time or across a dataset. It represents the summation of all values encountered up to a certain point or row…
Read MoreDB2 Analytics – Cumulative Sum
I can teach you analytics! IBM DB2 is built for analytics, and I will show you the cumulative sum this week. A cumulative sum is a running total of values progressively increasing or accumulating over time or across a dataset. It represents the summation of all values encountered up to a certain point or row…
Read More