Category: BI For Beginners

You should use color scales to show trends in cohort tables

How to run cohort analyses in Excel or Tableau

Cohort analyses are critical for understanding the performance of certain KPIs across different segmentations. The issue with creating cohort analyses is the complexity in going from raw data to insightful visuals.

In this post I’m going to take you step-by-step through the process I use to create insightful cohort analyses for my clients using Excel and Tableau.

how to make your databases more bi-friendly

22 tips for making your databases more BI-friendly

Do it right the first time - database design

Most entrepreneurs I meet have ambitious goals of trying to change the world. When you ask them about their road map it almost always includes plans to build a monolithic company with hundreds if not thousands of employees.

The road to build such a company is a long one with critical milestones along the way. Achieving milestones like product-market fit, growing a user base and bringing innovation to the market requires cutting corners and sacrifices which bring short term gains at the cost of long-term pains. One of these areas is the BI-friendliness of your company’s databases.

In this post I’m going to share 22 tips that you should share with your R&D team so that they can make your databases more BI-friendly. This will save the company a huge amount of time and money in the long-run.

Let’s get started.

How to predict new sales revenue

The step-by-step guide to predicting your SaaS sales

One of the responsibilities I had as the Director of Business Performance at Yotpo was to predict the amount of new business the sales department would generate each month. I got quite good at getting within only a few percentage points of the actual amount without needing to build complex models or machine learning.

In this post I’m going to show you my process and how you can start becoming a Nostradamus in your own organization.

The complete guide on how to run a data audit for your startup

What is a data audit?

A data audit is a process in which a company prepares a detailed report on the overall health of its data infrastructure and analytical capabilities.

The main goal of the data audit is to align the management on the current state of the company’s business intelligence; in other words, what information and resources are available to managers that want to make data-driven decisions. This is critical for strategic planning and determining risk within the company.

Say for example a company lacks visibility into the performance of its salesforce. If the company plans to scale this area of the business aggressively, everyone needs to be aligned that certain decisions will need to be made without data.

Knowing what can and can’t be calculated is critical for a company, and a data audit addresses this need.

Advanced Email Marketing Funnel Analysis

How to get real value from analyzing your email funnels

Email marketing is one of the most popular channels used today by online businesses for sales, brand awareness and growth. Email can be deceptively simplistic from an analytics perspective which results in a lot of missed opportunity when it comes to understanding what’s working and what’s not.

My goal in this post is to show you how to look at your email funnel so that you can quickly and easily identify key insights for increasing conversions.

Segment & Mixpanel Analytics Stack

The analytics stack every startup should implement on day one

As a business consultant I get to meet many startups. Some are just starting out while others are mature businesses with dozens of employees. More often than not these startups have poorly implemented data infrastructure, if they have infrastructure at all.

I get it… analytics is not top of mind for most startups. Getting to product-market fit, driving enough traffic to your site and hiring your founding team are pressing matters. The reason I’m so bullish on starting early with building a professional data infrastructure is for the simple fact that the more data you have, the more answers you have. The more answers you have the faster you can move. Early business intelligence becomes a force multiplier that will result in massive savings in both time and money in the long run.

In this post I’ll guide you through setting up a professional analytics stack that is not only much simpler to setup than you think, but that costs nothing more than a day or two of dev resources.

Cohort Analysis

The Complete List of Resources on Cohort Analysis

Most senior analysts and product managers are familiar with the concept of cohort analysis but it is still foreign to many analysts and decision makers. Cohort analysis is a powerful tool that has to be leveraged by companies hoping to survive and thrive.

My goal with this post is for it to be your one stop shop for everything related to cohort analysis. This is the first version of the post but I plan to keep it updated.

Version 1 contains 40 links to different resources related to cohort analysis. These 40 resources are split into two lists. The first list contains links to 32 pieces of content on different blogs, YouTube and Slideshare. The second list contains 8 questions posted on Quora.

When Should Your Company Start A Business Intelligence Team?

The number of variables that entrepreneurs need to contend with while building their companies is difficult to fathom. Hiring, firing, scaling growth, company culture, negotiating with banks, VCs and partners, and a number of others fall into the “obvious” bucket. Building a competent and valuable business intelligence group within the organization undoubtedly falls into the “not so obvious” bucket.

Most companies simply don’t have BI top of mind or decide to put it off to sometime in the future. Others see BI as a nice to have rather than a must.

So when should a company start a business intelligence team?

The short answer is from day 1. For the long answer keep on reading.