Blog – Page 16 – Software connecting all databases

Coffing Data Warehousing - Federated Query and ETL Software, Training, and Books

Before you watch this video take note of where you are because this is a day to remember forever, the most significant change since the cloud is at the desktop and server level connecting all systems. The only way forward is to make all systems one. Last Thursday, the hybrid-cloud took a giant leap forward by combining the database that is 100X faster than legacy systems with the server that allows the desktops to come alive.

The question of the day should be Yellowbrick or Snowflake. As the great playwright William Shakespeare once penned, “To be or not to be, that is the question?” If Shakespeare were alive today, the real question would be, “To be or not to be competitive.”

I can teach you, Yellowbrick! I have never seen analytic queries perform faster than on a Yellowbrick Data Warehouse. Today we are going to learn how to use dates. I will teach you date fundamentals and show you some clever tricks that will help you master dates.

Today you will witness moving and joining data across every platform in your enterprise faster than magic. The Nexus Desktop with a Nexus Server puts the business user on the same playing field as the data scientist. Combine Nexus with Yellowbrick and you get the greatest hybrid-cloud strategy on today’s market. Watch a billion-row table query in one second. Watch joins across all platforms, and watch how easy everyone from the business user to the ETL teams migrate with a button click.

Have you ever seen a query on a billion row table come back in one second? Have you ever seen data migration for thousands of tables set up in 30-seconds? How exciting will it be to join tables from 10 systems with the press of a button? Come see what happens when you put the best desktop and server software next to a Yellowbrick Data Warehouse!

I have never seen analytics run faster than on a Yellowbrick Data Warehouse. Today we learn about Last_Value, which helps with trending.

While Yellowbrick Data Warehouse offers the #1 Price/Performance in the industry, Coffing Data Warehousing’s Nexus products make it quick and easy to move millions of rows out of Teradata, Oracle, SQL Server, DB2, Snowflake, or Redshift, and join and query multiple tables across different systems at blistering speeds. Join us on Thursday, November 12 where our…

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…