Latest Stories

“When you become an effective evangelist, you don’t just promote your organization—you set an example for other employees. You show that you are a passionate, engaged ...
Analytics Leadership

Data Evangelism: Not Just A Leap Of Faith

The first iteration of your shiny new data warehouse is up and running, and folks are loving it. For example, Marketing is thrilled at how easy it is to pull up the data ...
Best Practices

What Is A Single Source Of Truth (SSOT) And Why Do You Need One?

Data is a good news/bad news situation. The good news is that companies have more information at their disposal than ever before. The bad news is that they may not know ...
Being Data Driven

Collaboration: The Core Of A Data-Driven Organization

“It’s the most wonderful time of the year,” sang Andy Williams about the Christmas season, but a “wonderful time” might not be how analysts working in ecommerce and ...
Being Data Driven

How Ecommerce Analysts Can Prep For The Holiday Season

You've spent a bunch of time figuring out the best data stack for your company.  It was hard work, and occasionally it was frustrating, but mostly it was fun. 
Data Stack

How To Propose A Data Stack

If you work with data of any real size, chances are you’ve heard of ETL before. If not (or if you just like having your memory refreshed), here’s a summary: ETL is a ...
ETL

What Is Data Transformation, Anyway?

There’s nothing more aggravating for a data analyst than sweating over a great analysis or dashboard only to have it go unused.
Best Practices

Why Data Analysts Should Adopt A Product Mindset

If you're thinking about creating a data warehouse from scratch, one of the options you are probably considering is Amazon Redshift. Redshift is very powerful, but ...
Redshift

A Redshift Pricing Guide For CTOs

Every week, analysts around the globe are working hard to create data warehouses.
Best Practices

Analyzing Business Needs: The First Step In Your Data Warehouse Project

Some people think you only need a data warehouse if you have huge amounts of data.  That used to be true. It's not anymore. These days, any business that uses ...
Data Warehousing

Why You Need A Data Warehouse

Let's Look at Data At Leading Financial Tech Startup LendStreet is a consumer financial health platform that offers loans to assist Americans who are  deeply indebted. ...
Being Data Driven

How Financial Tech Company LendStreet Embraces Financial Data

You need a data warehouse, but should you take the traditional ETL route or opt for a modern ELT approach? When it comes to usability, there's no question: ELT data ...
Data Warehousing

Views: The Key To A Successful ELT Data Warehouse

Why Your Shopify Data Needs a Warehouse A data warehouse is a place to store data solely for the purpose of analysis. That may not seem that interesting—and it isn’t—but ...
Data Warehousing

Shopify Business Intelligence And Data Warehousing Step-by-Step

Good analytics is no match for bad data. Bad data wins every time.  That's why we're talking about the tools to create a clean, efficient, and accurate ELT (extract, ...
Data Management

Top 7 Best ELT Data Pipeline Tools

If your business is engaging in data and analytics, you may have used SQL (or Structured Query Language) or even developed an ETL process (or Extract, Transform, Load). ...
ETL

SQL And ETL: The Dynamic Data Duo

Your company has reached the point where the only way to analyze your data on the scale needed to help your business succeed is to build or buy a data warehouse. How do ...
Data Warehousing

How To Estimate Cloud Data Warehouse Costs And Compare Pricing

Until recently, data warehouses were largely the domain of big business. With a data warehouse, you could consolidate and analyze vast amounts of information, deriving ...
Data Warehousing

Understanding Data Warehouse-as-a-Service Benefits Today And Tomorrow

Salesforce is a powerful tool for managing your sales processes. But if you're serious about using your business data to drive your organization, at some point you're ...
Data Warehousing

How To Build A Data Warehouse For Salesforce Without Breaking The Bank

This tutorial was authored by Ahmed Shaaban, a MeasureMatch partner.
MySQL

MySQL Replication For Analytics And Visualization: A Panoply Tutorial

Xero is widely recognized as the best online accounting software for small businesses. Similar to Google Ad Analytics, Xero is a lightweight and easy-to-use analytics ...
Data Analytics

Top 6 Xero Analytics And Reporting Tools For SMBs

Google Ads is all about efficiency. The formula for success is simple: target the right audience with the right ads at the right price. The better you do at each of ...
Data Analytics

How To Find Google Ads Negative Keywords At Scale

Reporting tools play a vital function in business operations, allowing analytics teams to generate constantly updated snapshots of vital areas of the business, which can ...
Data Analytics

Top 25 Reporting Tools And How To Choose The Best Option

Top 5 Alternatives to Alooma
ETL

Top 5 Alooma Alternatives: Comparing Pricing And ETL Features

Data Analytics

How To Analyze DynamoDB Data In Power BI

Work smarter, better, and faster with monthly tips and how-tos.