 Back to Blog

Justin Butlion

Justin Butlion is the founder of ProjectBI. Justin has over 10 years of experience working in hi-tech as a marketer, entrepreneur, and business analytics specialist.

Articles by

Justin Butlion

An all-in-one business intelligence service for DTC Shopify businesses

I'm pleased to announce that projectBI has a new and improved service offering.

January 4, 2023

projectBI Update: Productized services and a new website

June 4, 2021

Project Management

Agile Approach to Project Execution: Everything You Need To Know

May 13, 2021

Which metrics will help a product owner make the best decisions?

January 29, 2021

Business Operations

Zapier + Asana: How to use automation to create your daily to-do list

January 17, 2021

BI For Beginners

What is a metric in Google Analytics?

January 13, 2021

How to analyze and optimize a SaaS sales team

January 11, 2021

My 2021 goals for ProjectBI

January 2, 2021

The Retention Curve: How best to measure user retention

December 14, 2020

BI For Beginners

The Business Analyst's Motivational Handbook

December 11, 2020

BI For Beginners

User Segmentation: best practices, common mistakes and how-to guide

December 7, 2020

KPI dashboard guide: How to plan, and build a KPI dashboard [example]

December 6, 2020

Marketing Analytics

SEO tracking and reporting guide for marketing analysts

November 30, 2020

BI For Beginners

Analyst Q&A: How do I keep everyone happy?

November 26, 2020

Customer lifetime value (CLV): Advanced concepts & ideas for growing LTV

November 23, 2020

BI For Beginners

How to build a traffic dashboard: 4 methods from easy to challenging

November 19, 2020

What's next for ProjectBI?

November 16, 2020

Churn Analysis: A guide for SaaS founders

June 7, 2020

BI For Beginners

Introduction to Mixpanel: An online course for analysts and product managers

May 21, 2020

Introducing MeasureMatch

April 14, 2020

BI For Beginners

5 business analyst skills to know and master in 2020

March 7, 2020

Planned vs. Executed: How to conduct an efficiency analysis

March 5, 2020

How to go from CSVs and TXT files to SQL-based analyses and reports

March 3, 2020

Why I'm shutting down the data jobs board

March 2, 2020

Your first 90 days as head of analytics [Downloadable e-book]

February 16, 2020

Project Management

10 tips to improve communication as a service provider

February 11, 2020

The ultimate analytics stack for startups [2020 edition]

January 29, 2020

Project Management

The most important lessons I've learnt as an analytics consultant

January 22, 2020

BI For Beginners

Business analyst salary ranges around the world

January 19, 2020

BI For Beginners

How to accelerate your career as an analyst

January 7, 2020

BI For Beginners

How to create a historical sales report in Google Sheets

December 24, 2019

BI Infrastructure

[Case Study] Advanced Google Analytics reporting for SEO agencies

December 18, 2019

BI Competency Status: how to reach the gold standard of business intelligence

November 29, 2019

BI For Beginners

Introduction to CRM analytics for SalesForce, HubSpot and other CRMs

November 26, 2019

Marketing Analytics

Your marketing team is failing, here's how you can prove it

November 11, 2019

BI For Beginners

What is retention rate? A definition, guide & FAQ

November 2, 2019

BI For Beginners

The feature adoption funnel: How to track and measure feature adoption

October 28, 2019

BI For Beginners

How to find an outlier in a dataset using Tableau or Excel

September 1, 2019

Multi-touch attribution: An implementation guide

August 25, 2019

Project Management

Project management principles: How to master project management

July 29, 2019

Advanced marketing automation concepts and optimization hacks

June 14, 2019

BI For Beginners

How to become a business analyst - A step-by-step guide

May 25, 2019

6 ideas for enhancing your product analytics

May 14, 2019

The Master Data Source (MDS) Model

May 13, 2019

BI For Beginners

The Ultimate Guide To Saving Your Startup Millions of Dollars In 2019

May 7, 2019

BI For Beginners

Primary or secondary data analysis: which method should you choose?

March 18, 2019

BI For Beginners

SQL for dummies: How to learn SQL fast, for free, in 30 days or less

November 26, 2018

BI For Beginners

Product analytics case study: how to measure user retention

November 21, 2018

BI For Beginners

The LinkedIn Business Development Dashboard Hack

November 3, 2018

BI For Beginners

The Business Operations Playbook: How to implement ops in your startup

October 19, 2018

BI For Beginners

What is Tableau? - A guide and tutorial for analysts

October 3, 2018

BI For Beginners

How to build a content analytics dashboard [Google Analytics & Tableau]

September 24, 2018

BI For Beginners

12 business analyst interview questions and how to answer them

September 13, 2018

BI For Beginners

How to normalize data in Excel, Tableau or any analytics tool you use

September 10, 2018

BI For Beginners

How to track, monitor and analyze your life like a business analyst

September 7, 2018

BI For Beginners

What is a data dictionary? [Downloadable Example Template]

August 6, 2018

Business Operations

3 advanced hacks for getting more value from Intercom

July 27, 2018

BI For Beginners

The complete guide to measuring product usage for startups

July 20, 2018

BI For Beginners

How to measure employee retention

May 9, 2018

BI For Beginners

How to enrich event data to help you answer all your questions

May 7, 2018

BI For Beginners

The complete guide to hiring your first business analyst

April 27, 2018

Project Management

8 tips to drastically improve your project management skills

February 23, 2018

BI For Beginners

How to run cohort analyses in Excel or Tableau

February 10, 2018

BI For Beginners

Database design for business intelligence: how to setup a DB for analysts

December 25, 2017

SaaS Metrics For Beginners

Buffer has a growth problem and this is what they should do about it

December 16, 2017

BI For Beginners

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

December 7, 2017

BI For Beginners

Data audit guide: how to run a data audit at your startup

November 22, 2017

BI For Beginners

How to analyze email funnels to increase conversion

November 8, 2017

BI For Beginners

The analytics stack every startup should implement on day one

November 4, 2017

BI For Beginners

Cohort Analysis Resources: Learn how to perform cohort analyses

October 25, 2017

BI For Beginners

When should your company start a business intelligence team?

July 8, 2017