Learn & Query On

I love analytics
Blog
Dan Kuhn

Giving Analytics the Love it Deserves

There is a movement that’s happening. An analytic movement. Analytics is one of the most important and valuable assets to an organization—next to you, of course. Yet we don’t seem to give analytics the love it deserves. This motivated us to take a deeper look at how we treat analytics today and how we can uncover its potential and showcase its value.

Read More »
News
Chris Coad

Banorte Uses Aginity To Maximize Analytic Return and Reduce Risk

CHICAGO, June 12, 2019 /PRNewswire/ — Aginity, Inc., the active analytics catalog company, today announced that Banorte, one of Mexico’s largest banking and financial services companies, is using Aginity Enterprise to maximize analytic return and reduce business risk. During the initial pilot Aginity showed how to significantly increase the productivity and consistency of Banorte’s analytic output, resulting in more minds innovating across the organization and building off of each other.

Read More »
Catalog SQL
Blog
Jeff Schlitt

Top 5 Ways to Optimize Your Catalog in Aginity Pro

We all have our own ways of organizing stuff at home and at work. My friend swears by bullet journaling, my boss juggles multiple Google calendars and productivity apps, and my daughter keeps a simple to-do list. There’s no right or wrong answer here. We all have different ways of keeping a grip on our life.

Read More »

Aginity Academy

Learn how to become a rock star SQL analysts, data engineer or data scientist.

For Data Engineers

Lesson 1

Redshift Utilities: Generate DDL and Search Table Metadata

MPP databases require you to figure out how to navigate their system tables. We’ll show you a few examples how to work with system tables to reverse engineer DDL and search for tables using wildcards.

Lesson 2

Generating SQL to Profile Table Data

Leveraging what we learned in Lesson 1, we will expand the concept to use system tables and prior scripts to generate code that profiles a Redshift table. Check out this lesson to learn more.

Lesson 3

Building a Random Number Generator to Create an Image

Feeling creative? Check out this  lesson to learn how to build a random number generator in Redshift and create an image of Aginity’s Enterprise Product Manager George L’Heureux.

For Business Analysts

Lesson 1

Calculate Internal
Rate of Return on Redshift

Internal Rate of Return (IRR) is a calculation frequently used to estimate an investment’s rate of return. Take this lesson to figure out how to use Redshift SQL to perform this calculation..

Lesson 2

Create Basic Recency, Frequency and Monetary Segments

RFM (Recency, Frequency, Monetary) analysis is highly used marketing model for behavior based customer segmentation. It groups customers based on their purchase history. Learn how to do this in SQL!