Posts by Tom Coffing
Yellowbrick Analytics – What is a Moving Difference?
You use a Moving Difference (MAVG) to compare the difference between the value from two different rows.
Read MoreYellowbrick Analytics MAVG
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.
Read MoreYellowbrick Analytics CSUM
I can teach you analytics! I have never seen a database do analytics faster than Yellowbrick. 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. In each example, you will see an…
Read MoreYellowbrick Analytics – Part 2 – Ranking Data
Learn how to rank data using SQL on the fastest database on the planet.
Read MoreYellowbrick Analytics Row_Number
I can teach you analytics! The Yellowbrick database does analytics lightning-fast. These analytic lessons are the perfect opportunity for you to become an analytic guru. If you want to be number one in your department then the Row_Number command is what you need. Get ready for your career to soar like a bird. Each week…
Read MoreTeaching a Snowflake SQL Class Remotely this Week.
Over the next two days, I am teaching Snowflake SQL remotely to Ivy League students. I have taught close to 1,000 SQL classes over the past 30 years, and I have written over 75 books covering SQL on every database platform. I have never seen SQL so robust as I have with Snowflake. Almost every…
Read More2 minutes! Teradata to Snowflake Migration.
Here are three reasons why Snowflake is changing the Cloud computing world. Every single SQL statement I have ever seen from every other database vendor works on Snowflake. I have never seen anything like that in the 30-years of teaching SQL. Why is this nearly impossible feat important? Companies can instantly migrate data to Snowflake…
Read MoreNexus – Big Data Product of the Decade
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 MoreResult Sets Now Create Tables
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 MoreThe Nexus Multi-Systems Tree
A large bank was consolidating on Teradata and needed Oracle, SQL Server, and DB2 users to move critical data to their Teradata sandbox. We invented the Nexus multi-database tree, where you can see two systems trees side by side. Users can click-and-drag to move a single-table or an entire database, which creates the table(s) on the Teradata system.
Read MoreGoogle BigQuery
A sizeable primary healthcare provider requested the Nexus Pro and Nexus Server to migrate data from their Teradata and SAP HANA systems directly to Google BigQuery. This herculean effort might take some software companies years to develop, but we expect to finish with 30-days.
Read MoreConsolidate Software
In good times and in bad, it is essential to save money. So many companies are using dozens of different tools to access data, and the penalty is millions of dollars per year. And the truth of the matter is most of these tools don’t share reports or queries with others. It is every man and woman for themselves. It may sound too good to be true, but you can give everyone a much better toolset, and allow everyone to be on the same team. You also need your people to access data both on-premises or in the cloud. And unfortunately, in today’s climate, you need a tool where everyone can perform all of their duties from home, but execute the work from an internal Server.
Read MoreFederate, Migrate, and Query Great
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 MorePhysically Work from Home but do so Virtually at the Corporate Office
They say you can’t be in two places at one time, but I beg to differ. You can work from home, but access data across any platform as if you were sitting in your corporate office. The future of computing is accessing any data, at any time, anywhere, and doing so from your home. You do this with laptop software coordinating with a Server.
Read MorePivot, Spreadsheet, Graph, and get Analytics on Data
Query any system and then take any answer set and Pivot, or place it in a Spreadsheet, Graph/Chart it in a dashboard, or add over 80 analytic functions. Nexus makes your PC a database and analytic engine.
Read MoreMove to Teradata
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 MoreThe Art of Federated Queries
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 MoreMove data to Snowflake for FREE
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 MoreNexus – 1000 features on 1000 databases – Joining Excel
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 MoreSnowflake Analytics – Part 11 Cume_Dist
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