The only architecture able to accomplish the ability to federate, migrate, and query great is to implement an intelligent Windows Server, which we call the Nexus Server.  The Nexus Pro desktop automatically builds federated queries, can join Excel to production tables, writes the SQL for the user, and allows the user to query every database platform on the market. Still, the Nexus Server runs the jobs for the user.

Read More

Teradata is taking all of the awards for Data Warehouse Analytics.  You should consider consolidating users on Teradata and use the platform for your major analytic jet engine.  With a few clicks of the mouse, my Nexus and NexusCore Server can make the migration to Teradata easy.

Read More

Federated queries are a combination of hardware and software working together like dance partners that make it an art.  A federated query joins tables together from different systems.  Federated queries are the definition of accessing any data, at any time, anywhere. 

Read More

The number one goal in today’s cloud market is for users to be able to access any data, at any time, anywhere.  That usually takes the skill of a data scientist, but how would you like to point-and-click to join Excel to any table from any database? As a data warehouse manager at the largest bank in the world told me, “The Nexus Super Join Builder puts the business user on the same playing field as a data scientist.”

Read More

I can teach you Snowflake analytics!  Today we are going to learn about Cume_Dist. Cume_Dist returns the cumulative distribution of a value within a set of values. It represents the number of rows with values less than or equal to that row’s value divided by the total number of rows. The returned value of the CUME_DIST function is greater than zero and less than or equal one.

Read More

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.

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 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

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