Blog
Oracle Analytics – Cumulative Sum
I can teach you analytics! Oracle 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 MoreVertica Analytics – Cumulative Sum
I can teach you analytics! Vertica 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 MoreYellowbrick Analytics – Cumulative Sum
I can teach you analytics! Yellowbrick 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 MoreAzure Synapse Analytics – Cumulative Sum
I can teach you analytics! Azure Synapse 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 MoreAmazon Redshift Analytics – Cumulative Sum
I can teach you analytics! Amazon Redshift 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 MoreGoogle BigQuery Analytics – Cumulative Sum
I can teach you analytics! BigQuery 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 MoreDatabricks Analytics – Cumulative Sum
I can teach you analytics! Databricks 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 MoreSnowflake Analytics – Cumulative Sum
I can teach you analytics! Snowflake 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 MoreThe Day We Joined Data Across All Systems
Did you hear about Microsoft, Amazon, and Google announcing that they can now join data across all systems? Of course not, because they are years away from that capability. However, I am announcing that one day, everyone will join data across database platforms, and that day can right now if you want. To prove this,…
Read MoreRow_Number Analytic Across All Databases
I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many ways to pinpoint specific rows in a dataset, such as the first or last sale per product or the highest or lowest grade…
Read MoreMySQL Analytics – ROW_NUMBER
I can teach you analytics! MySQL is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read MorePostgres Analytics – ROW_NUMBER
I can teach you analytics! Postgres is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read MoreGreenplum Analytics – ROW_NUMBER
I can teach you analytics! Greenplum is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read MoreNetezza Analytics – ROW_NUMBER
I can teach you analytics! Netezza is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read MoreIBM DB2 Analytics – ROW_NUMBER
I can teach you analytics! DB2 is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read MoreOracle Analytics – ROW_NUMBER
I can teach you analytics! Oracle is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read MoreVertica Analytics – ROW_NUMBER
I can teach you analytics! Vertica is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read MoreYellowbrick Analytics – ROW_NUMBER
I can teach you analytics! Yellowbrick is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read MoreSQL Server Analytics – ROW_NUMBER
I can teach you analytics! SQL Server is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you…
Read MoreAzure Synapse Analytics – ROW_NUMBER
I can teach you analytics! Synapse is built for analytics, and this week, I will show you row_number, a not-so-distant cousin to rank. I used to think that the row_number analytic was harmless and somewhat useless, and boy, was I wrong. The row_number is one of my favorite analytics, and I will show you many…
Read More