Blog

Understanding Skew and Kurtosis (Why Extremes Matter) In Blog 1, we met Carl Friedrich Gauss (1777–1855), the mathematician who taught the world how to measure uncertainty. At the beginning of the 19th century—around 1800 to 1820—Gauss was trying to solve a practical problem. Astronomers kept measuring the same stars and planets and getting different answers.…

Understanding Skew and Kurtosis (Why Extremes Matter) In Blog 1, we met Carl Friedrich Gauss (1777–1855), the mathematician who taught the world how to measure uncertainty. At the beginning of the 19th century—around 1800 to 1820—Gauss was trying to solve a practical problem. Astronomers kept measuring the same stars and planets and getting different answers.…

Mathematician Carl Friedrich Gauss Solves Astronomers’ Problem Variance and standard deviation weren’t invented for business. They were invented because astronomers kept getting different answers. In the early 1800s, scientists were trying to calculate the exact orbits of planets and comets. They would measure the same star night after night… and the numbers never matched perfectly.…

Mathematician Carl Friedrich Gauss Solves Astronomers’ Problem Variance and standard deviation weren’t invented for business. They were invented because astronomers kept getting different answers. In the early 1800s, scientists were trying to calculate the exact orbits of planets and comets. They would measure the same star night after night… and the numbers never matched perfectly.…

A major government agency that loves its Teradata Enterprise Data Warehouse has made it ten times more powerful by purchasing a Universal Nexus license. When you combine the greatest data warehouse database company with software that works across all databases, you have the perfect one-two punch. What is a Universal Nexus License? A Universal Nexus…

A major government agency that loves its Teradata Enterprise Data Warehouse has made it ten times more powerful by purchasing a Universal Nexus license. When you combine the greatest data warehouse database company with software that works across all databases, you have the perfect one-two punch. What is a Universal Nexus License? A Universal Nexus…

At Coffing Data Warehousing, we’ve always believed that the smartest query tool in the world is the one that gets out of your way. Nexus has connected every major database on the planet, from Teradata to Snowflake, Oracle to Databricks, and allowed users to join, migrate, and analyze data faster than ever. Now, we’re taking…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

What Is a Derived Table? A derived table is a temporary result set created inside a SQL query. It exists only for the life of that one query. You build it using a SELECT statement and give it a name so you can join to it just like a normal table. If you calculate anything…

A derived table only lives for the life of a single query. It is created by the user and populated with a SELECT statement. The derived table must always have a name and require an alias for any calculated columns, such as those used for aggregation. Most derived tables join to other tables so they…

Good morning! I am reaching out to all Training, Learning, and Development staff to introduce myself in hopes of becoming the best teacher you have ever hired to train your employees. What makes me a special teacher is that I teach two types of classes on the opposite extremes. I can teach your marketing and…

Imagine running a query and getting not just results, but an entire dashboard built for you instantly. No dragging. No dropping. No tweaking settings. Just answers—presented visually in charts and graphs before you even lift a finger. That’s exactly what Nexus does. Nexus isn’t just a query tool; it’s a game-changer. The moment your query…

In today’s data-driven world, optimizing performance and reducing storage costs are top priorities for businesses using Teradata. One of the most effective ways to achieve both is by implementing Multi-Value Compression (MVC), a feature that can significantly reduce storage requirements without impacting performance. However, manually configuring MVC across an entire Teradata system can be a…