Blog| Coffing DW

Federated Query and ETL Software

I can teach you Yellowbrick analytics! I have never seen analytics perform faster than on Yellowbrick. Today we are going to learn about First_Value. This analytic seems too simple at first, but I will show you how to use First_Value to look for trends. First_Value will display the first value of a specific column residing…

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.

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…

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.

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…

Since Yellowbrick takes the lead in analytics, we will learn the LEAD command.

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…

You use a Moving Difference (MAVG) to compare the difference between the value from two different rows.

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.

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…

Learn how to rank data using SQL on the fastest database on the planet.

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…

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…

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.