Blog
Databricks Analytics – GROUP BY GROUPING SETS, ROLLUP, and CUBE
I can teach you analytics! Databricks is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreSnowflake Analytics – GROUP BY GROUPING SETS, ROLLUP, and CUBE
I can teach you analytics! Snowflake is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreData Migration Best Practices
Introduction As a professional in the field, I have helped some of the largest financial institutions and insurance companies migrate multiple on-premises database systems to the cloud through software that has taken my team decades to build. The first lesson I learned is that if a company wants to move data from legacy or on-premises…
Read MoreYellowbrick Analytics – Moving Average
I can teach you analytics! Yellowbrick 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 MoreA Client Server Architecture is the Only Data Solution
The best software architecture in the world is a client-server architecture. Because data comes in all sizes, it is paramount that users can do everything with small to midsize data from their PC or laptop but schedule huge amounts of data to run on the server. Sometimes, you need to ride in a car, and…
Read MoreIBM DB2 Analytics – Moving Average
I can teach you analytics! DB2 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 MoreOracle Analytics – Moving Average
I can teach you analytics! Oracle 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 MoreMySQL Analytics – Moving Average
I can teach you analytics! MySQL 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 MorePostgres 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 More