In our discussion on creating a C3 chart a few weeks ago, we generated a great deal of discussion. The concept of cohort analysis obviously hit home and quite a few of you wanted to know more. Specifically, we received numerous requests for guidance on preparing data for this type of analysis. In today’s post, […]

We are delighted to continue our exploration of Spreadsheet Fundamentals with a tutorial on LOOKUP functions. In this lesson, we dive into the fundamentals of retrieving and combining data seamlessly from various datasets using Excel and Google Sheets. Whether you’re dealing with massive data or merging information from different sources, mastering these lookup functions will […]

Today we’re continuing our focus on spreadsheets by delving into one of the most essential functions in both Google Sheets and Excel: the mighty IF statement. Whether you’re a beginner or an experienced data expert, mastering the art of IF statements will greatly improve your ability to process and analyze data. Let’s take a deeper […]

In this installment of “My Favorite Analyses,” we explore Customer Lifetime Value, critical to understanding the value a customer creates.

There are three top skills Data Analysts need to be successful: strategic abilities, technical proficiency, and data design expertise. Here’s a look at what those skills mean and how to build them.