Blog

I can teach you analytics! Snowflake is built for analytics, and this week, I will show you CUME_DIST, a not-so-distant cousin to RANK. You can now unlock the power of data insights and uncover hidden trends by mastering CUME_DIST, a vital statistical tool that reveals your dataset’s cumulative distribution of values. All of these examples…

I can teach you analytics! Greenplum is built for analytics, and this week, I will show you CUME_DIST, a not-so-distant cousin to RANK. You can now unlock the power of data insights and uncover hidden trends by mastering CUME_DIST, a vital statistical tool that reveals your dataset’s cumulative distribution of values. All of these examples…

I can teach you analytics! MySQL is built for analytics, and this week, I will show you CUME_DIST, a not-so-distant cousin to RANK. You can now unlock the power of data insights and uncover hidden trends by mastering CUME_DIST, a vital statistical tool that reveals your dataset’s cumulative distribution of values. All of these examples…

After working with Teradata, Microsoft, and Oracle, among many other database vendors, I realized each held supreme power over their customers. Databases were never meant to cooperate or communicate, so once a vendor locked in a customer, that customer was at their mercy. I worked with every database vendor, and the experience was often horrible.…

I can teach you analytics! MySQL is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! Postgres is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! Greenplum is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! Netezza is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! DB2 is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! Teradata is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! Yellowbrick is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! Vertica is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! Google BigQuery is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All…

I can teach you analytics! Google BigQuery is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All…

I can teach you analytics! Databricks is built for analytics, and this week, I will show you the amazing moving difference. The moving difference is one of the most incredible aspects of analytics, but it cannot seem very clear unless it is explained correctly. With power comes incredible responsibility. I won’t disappoint you. All of…

I can teach you analytics! Azure Synapse is built for analytics, and this week, I will show you the amazing moving difference commands. The moving difference is one of the most incredible aspects of analytics, but it can seem confusing unless it is explained right. With power comes incredible responsibility, so I won’t let you…

I can teach you analytics! SQL Server is built for analytics, and this week, I will show you the amazing moving difference commands. The moving difference is one of the most incredible aspects of analytics, but it can seem confusing unless it is explained right. With power comes incredible responsibility, so I won’t let you…

I can teach you analytics! Oracle is built for analytics, and this week, I will show you the amazing moving difference commands. The moving difference is one of the most incredible aspects of analytics, but it can seem confusing unless it is explained right. With power comes incredible responsibility, so I won’t let you down.…

I can teach you analytics! Snowflake is built for analytics, and this week, I will show you the amazing moving difference commands. The moving difference is one of the most incredible aspects of analytics, but unless it is explained right it can seem confusing. With power comes incredible responsibility so I won’t let you down.…

I can teach you analytics! MySQL is excellent at analytics, and this week, I will show you the RANK, DENSE_RANK, and PERCENT_RANK commands. You will also learn about PARTITION BY and how to use a derived table to filter your rank commands. All of these examples have come from my books and training classes. Please…