I can teach you Snowflake analytics!  I will bet you have never seen a listagg analytic! Some major companies use the listagg analytic for their email marketing campaigns.  They cleverly find out the last three web pages the customer went to on their website, and then they send them a customized email offering sales on the products they were viewing last. Let me show you exactly how it works.

Read More

I can teach you Snowflake analytics!  I have never seen a database do analytics better than Snowflake.  Last week we taught you Lead, and this week we are teaching you Lag. You use a Lead to place the value from the next row on the current line of the answer set.  You can then see today’s value, and on the same line, see tomorrow’s value.  You do the opposite for the Lag.  You can see today’s value, and on the same line, see yesterday’s value. 

Read More

I can teach you Snowflake analytics! I have never seen a database do analytics better than Snowflake. This week we are working on the Lead. You use a Lead to place the value from the next row on the current line of the answer set. You can then see today’s value, and on the same line, see tomorrow’s value.

Read More

I can teach you analytics!  I have never seen a database do analytics better than Snowflake.  This week we are working on the Moving Difference, which is interchangeable with MDIFF. You use a Moving Difference (MAVG) to compare the difference between the value from two different rows.  For example, you can see your Daily_Sales from this Monday, and then see the difference between the Daily_Sales from last Monday. 

Read More

I can teach you analytics!  I have never seen a database do analytics better than Snowflake.  This week we are working on the Moving Average, which is interchangeable with the word MAVG. You use a Moving Average (MAVG) to look for trends.  A MAVG shows you the AVG of values in a moving window, which means a certain amount of rows.  If the moving window is a three, then the MAVG calculates the AVG for the values for three rows.  You can then see trends by analyzing which results were higher and which were lower.

Read More

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.

Read More

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. 

Read More

We are proud to offer Universal ODBC – our new connection method that allows users to connect to and interact with any current or future ODBC data source in the universe.  

Nexus has always been able to interact with over 25 major data sources natively, but not brand-new data sources.  With Universal ODBC, users can now connect to any data source, display the database layout in our Unified Systems Tree, execute SQL, and interact with result sets in exactly the same way they can from any of our native connection methods.  All that is needed is an ODBC driver.

There are so many new and exciting databases emerging daily, but until now, users have had limits to using the simple vendor-supplied “afterthought” query tools designed specifically for those systems. Nexus Universal ODBC allows users to query new cloud or on-premises databases on the day they’re released.

Read More

I can teach you analytics!  I have never seen a database do analytics better than Snowflake.  This week we are working on the RANK command. All of these examples have come from my books and training classes. Please do me a favor and tell your training coordinator that you know the best technical trainer in…

Read More

Moving data between systems is called ETL, which stands for Extract, Transform, and Load.  The ETL team almost always does the moving of data because load scripts are easier to learn than Latin, transformation is more difficult than brain surgery, and computing resources are about as easy to manage as cats.

Read More

Yes, the Snowflake Architecture and SQL book is on its way to your favorite book stores, such as Skillsoft, where you can read it online, or Amazon, where you can buy it. It is another masterpiece of information from Tom Coffing and David Cook, two of the most famous authors in the history of computers.…

Read More

  Yesterday – My Netezza troubles seemed so far away. Since IBM bought them now, they’re here to stay. Oh, I believe in yesterday. Suddenly, I’m not half the man I used to be. Why can’t I migrate off so easily? Oh, I believe in yesterday. Why it had to go, I don’t know, they…

Read More

The only thing better than having a data scientist on your team is to make everyone on your team a data scientist, and then provide an environment where they can collaborate. The greatest opportunity for your company in 2021 is to take advantage of the many different systems on the market and get a huge…

Read More

  Michael Dell was born in 1965 in Houston, to Lorraine Charlotte (née Langfan), a stockbroker, and Alexander Dell, an orthodontist.  Michael had an early interest in business, so at age eight, he applied to take a high school equivalency exam. At age eight, I was playing T-ball. By the time Michael was in college,…

Read More

If you could go back in time and you wanted to see Einstein cry, ask him to come up with a “Theory of Data Movement”, instead of a “Theory of Relativity.” Moving data between different vendor database platforms is close to impossible.

Read More

Part of the solution to the growing security challenge of the digital age is embracing technology that provides the tools for data to be stored and secured in a secure manner. Federated queries and searches play a heavy part in the solution.

Read More