Learn & Query On
The only active analytics company helps Microsoft SQL Server customers discover, manage and share SQL in a collaborative environment.
It feels like every conference talk, blog post, podcast or marketing message that I get these days is touting the amazing benefits of Data Science, Machine Learning (ML) or Artificial Intelligence (AI) (or if you are old school, you probably recall the marketing and promotion of many similar techniques as “Statistical Modeling”).
When we first built Workbench for our own use, we had no idea that 10s of 1000s of users would come to rely on it for their daily tasks across a host of on-prem and cloud analytics platforms. We hear daily from users who have loved having access to such a robust (and free!) product for the past 10 years, but we have also heard many requests for new features, new platforms and for additional support which was a challenge for us to provide…
Chicago, Illinois, August 6, 2019 — Aginity, the “active analytics” company, announced it is working with Microsoft to help enterprises discover, manage, share and re-use analytic code for Microsoft Azure SQL Data Warehouse, the leader in price-performance in cloud analytics.
You’ve found Aginity Pro. And it’s helping. But you still might be writing code over and over again. (Think about it…you are and you know it).
We’ve tried to tell you, you really need to try out Aginity Pro’s active analytic catalog! But you still haven’t done it yet.
So today, I’m going to ramp up the persuasion. I’m sharing my top five ways you can get the most use of our active analytics catalog. Give it a try, and I bet it will make you and your team even more productive.
Partnership between the only active analytics company and cloud-based data warehouse rewrites how organizations find, share and use analytic code.
Aginity Launches First of its Kind SQL Team Experience Built to Share and Reuse Code Making Teams More Productive
Trusted Analytics Management Leader Debuts “Aginity Team” Today
We’ve been working on it for months. We’ve pulled a few (OK, more than few) late, pizza-fueled nights at the office. And today, we’re thrilled to say:
Learn how to become a rock star SQL analysts, data engineer or data scientist.
For Data Engineers
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.
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.
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
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..
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!