Snowflake - Software connecting all databases

Federated Query and ETL Software

Like a fine wine, the Nexus and Nexus Server have taken 18 years to build, and they keep getting better. Your competitors better hope you haven’t given Nexus to your employees because you now own the future of data access. You can check out a free trial of Nexus at https://coffingdw.com/download-nexus. There are four skills…

Tom Coffing will show off the Nexus Desktops coordinating with the Nexus Server to join data across platforms with a single click of the mouse.

The Art of War is attributed to the ancient Chinese military strategist Sun Tzu and remains the most influential book in East Asian warfare and Western cultures. This book explains Chinese military tactics, from strategy and weapons to rank, discipline, and training techniques. What is truly unique is that Sun Tzu wrote this book in the 5th century BC. During the Sengoku period (c. 1467–1568), the Japanese daimyō named Takeda Shingen (1521–1573) became almost invincible in all battles without relying on guns because he studied The Art of War. The book even gave him the inspiration for his famous battle standard “Fūrinkazan” (Wind, Forest, Fire, and Mountain), meaning fast as the wind, silent as a forest, ferocious as fire, and immovable as a mountain. The new art of war is the Virtualization of data because the tactics allow businesses to wage war on their competition. Virtualization is the ability to join data no matter where it resides without any technical expertise, and it makes organizations fast as the changing winds of business, ferocious enough to light their sales on fire, silent to secretly understand the relationships the data is telling them, and as immovable as a mountain because their business is on solid grounding.

The question of the day should be Yellowbrick or Snowflake. As the great playwright William Shakespeare once penned, “To be or not to be, that is the question?” If Shakespeare were alive today, the real question would be, “To be or not to be competitive.”

The Ides of March is best known as the date on which Julius Caesar was assassinated at the Theatre of Pompey by members of the Senate in 44 BC. I think that 2020 is the year that we make the Ides of March a good thing. During March, I am going to allow you to migrate and move any amount of data to Snowflake for FREE.

I can teach you Snowflake analytics! Today we are going to learn about Ntile. Each Ntile partition is assigned a number starting at one increasing to a value that is up to the Ntile partition number specified. So, with a Ntile of 4, the partitions are 1 through 4. Then, all the rows are distributed as evenly as possible into each partition from highest to lowest values. Normally, extra rows with the lowest value begin back in the lowest numbered partitions.

I can teach you analytics! I have never seen a database do analytics better than Snowflake. This week we are working on the Cumulative Sum, which is interchangeable with the word CSUM. You use a Cumulative Sum (CSUM) to get a running total with subtotals and grand totals.

Its the data gods that say, “Go Forth and Pivot”. The Nexus has 1,000 features on 1,000 different database platforms, and feature number 942 is pivoting. Business users and senior management love to see a pivot report, especially when it has sum totals, subtotals, and horizontal and vertical grand totals.

I can teach you analytics! I have never seen a database do analytics better than Snowflake. These analytic lessons are the perfect opportunity for you to learn analytics like the back of your hand. If you want your career stock to soar, then invest in yourself and learn these analytic lessons. You are about…