I can teach you Yellowbrick analytics! I have never seen a database perform analytics faster than Yellowbrick. Yellowbrick can load billions of rows and still perform thousands of queries simultaneously. The analytic we will learn about today is CUME_DIST.

Read More

I can teach you Yellowbrick analytics!  I have never seen a database perform analytics faster than Yellowbrick.  Today you are going to smile when you learn about NTile. NTILE is an analytic function. It divides an ordered data set into a number of buckets indicated by expr and assigns the appropriate bucket number to each…

Read More

In July 1799, Rosetta Stone, discovered during Napoleon Bonaparte’s campaign through Egypt, became one of the British Museum’s most famous objects. But what is it, and why is it important to computing?

Read More

I can teach you Yellowbrick analytics! I have never seen a database do analytics faster than Yellowbrick. Last week we taught you Lead, and this week we are teaching you Lag.

Read More

Snowflake has the most extensive and expensive software IPO in history, and this skyrocketed further for an evaluation of 70 billion dollars. What is crazy is that Snowflake is losing money year after year.  Yes, they have yet to have a single quarter of profitability. This article will talk about the eight things Snowflake understands…

Read More

We are excited to announce that Coffing DataWarehousing will be sponsoring the upcoming modern data virtual analytics experience on the topic entitled “ANSWERS FOR A WORLD THAT CAN’T WAIT” where data visionaries share their playbook for building a data strategy that works. Date: Tuesday, Sep 29, 2020 Duration: 2-hour virtual summit! Join Coffing DataWarehousing and…

Read More

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 More

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 More

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 More

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 More

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 More

A fortune 100 company had changed its on-premises strategy to the cloud and needed to move its on-premises systems to the AWS cloud.  It wanted to migrate its Netezza, Oracle, and Teradata systems to Amazon Redshift, Snowflake, MySQL, and Postgres. At the time, they decided that their best choice was to use Amazon’s Data Migration Services (DMS).  After finding that DMS was not reliable enough for this massive project, they began a Proof of Concept with the Nexus Pro desktop and Nexus Server combination.

Read More
NExus core server makes data movement easier for DBAs, IT, and business users.

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

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 More