Posts Tagged ‘analytics’
Snowflake Analytics – Part 5 – MDIFF
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 MoreSnowflake Analytics – Part 4 – MAVG
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 MoreSnowflake Analytics – Part 3 – CSUM
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 MoreNexus – 1,000 Features on 1,000 Databases – Pivot
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 MoreSnowflake Analytics – ROW_NUMBER
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 MoreAnalytics: There is No ‘I’ In Team
The Nexus Query Chameleon and the NexusCore Server are a winning combination. With these two together, you’ll have your entire IT and Business Users working on the same page. And when that happens, you will certainly see that while there is no ‘I’ in Team, there is an ‘I’ in Genius!
Read More