The two concepts in our Big Data vision is the user’s desktop and the database server. The Nexus desktop allows a user to access any data, at any time, anywhere from their desktop or laptop, no matter whether they are at the office, a coffee shop, or home. The Nexus Server sits in between the many different database platforms, both on-premises and on every cloud, and manages and controls the data movement between systems. Users use the desktop to build anything and everything, but they have the option to run it from their desktop or the Server.Read More
An international semiconductor company was running a complex query on Teradata and wanted automatically to create a table on their MySQL system. We came up with two solutions:Read More
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.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 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. 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
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
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…Read More