BI Career
Getting Started as a BI Consultant - A Simple Method
If you’ve got the necessary skills and are looking to make a living in Business Intelligence, one option could be to go freelance and start your own consulting business....
Learn BI Online
Business Intelligence Articles
Practical tutorials, career advice and plain-English guides for learning business intelligence, analytics, SQL, dashboards and reporting.
Recommended path
Want a structured route into BI?
The BI Analyst Starter Program brings SQL, dashboards, data modelling, real projects and portfolio building into one clear learning path.
Article
What is Business Intelligence?
There’s often confusion as to what Business Intelligence (BI) is and what differentiates it from data science or just straightforward data analysis.
.png)
Article
AI Is Coming for Data Scientists — Is Business Intelligence Next?
And a Microsoft study I came across pushed me to put these thoughts together.
.png)
BI Jobs
How to Build an Analyst Project Portfolio That Gets You Hired
As an aspiring BI analyst, breaking into the field can feel overwhelming. Because the competition is fierce and most candidates have similar skill sets and experience....
BI Basics
The Skills You Need To Succeed In Business Intelligence
In todays’s business world, companies from all industries and of all sizes generate tons of data. Whether it’s in Excel files, on-premise databases or in the cloud with...
BI Career
7 Steps To Your First Business Intelligence Analyst Job
If you’re looking to start or transition to a career as a Business Intelligence analyst I’m going to talk about 7 steps that I would take if I were looking for my first...
Data Analysis
How To Analyse Website Performance With Google Analytics
Google Analytics is a web analytics service offered by Google that lets you track and analyse your website traffic. It’s a free to use tool that you install by copying...
BI Basics
7 Business Intelligence Terms Everyone Should Know
Like any industry, Business Intelligence has its own jargon and terms that can be confusing if you’re unfamiliar with them. In this article I’m going to break down 7 of...
.png)
BI Jobs
BI Analyst vs. Data Scientist. Which is right for you?
BI Analyst and Data Scientist. What exactly is the difference? In this article, I’ll break down for you what the jobs entail, the skills you need, the tools you use and...
BI Tools
GA4 Quota Limits. Why your Looker Studio Reports Are Broken
By the power of Google magic, they’ve managed to transform your beautiful GA4 reports in Looker Studio into this…
Data Analysis
What Are Metrics And Dimensions?
In this article we’re going to take a look at one of the basic concepts of data and data analysis: metrics and dimensions.
BI Tools
5 Reasons YOU SHOULDN'T USER EXCEL for Interactive Dashboards
If you’re looking to build an interactive dashboard using Excel…what on earth are you thinking?!
.png)
Article
Database vs. Data Warehouse vs. Data Mart vs. Data Lake
What exactly is a database? How does a database differ from a data warehouse? How does a data mart relate to a data warehouse? And what on earth is a data lake? In this...
.png)
Article
Why Most People Fail as a BI Consultant (And How to Avoid It)
So, you’re thinking about becoming a Business Intelligence consultant?
Data Analysis
Simple Segmentation Analysis Tutorial
In this article we’ll be looking at how you can use segmentation analysis to go beyond the basic Business Intelligence processes and dive deeper into your data to gain...
Case Studies
How This One Company Saved Over $2M / Year With A Simple Dashboard
BI is not only used by companies to help generate more revenue. It can also help save money by making businesses more efficient.
BI Career
What Does a BI Consultant Actually Do?
I’ve been working with data for over 25 years now and in BI specifically for around 10. Currently I’m a BI consultant and help companies realise their projects and turn...
BI Tools
Google Data/Looker Studio. It's free, but is it any good?
In this article I’m going to be reviewing Google’s BI tool, Data Studio. It’s completely free to use but is it any good? Let’s find out.
BI Jobs
5 Data Sources Every BI Analyst Should Know
As a BI analyst, during your career, you’ll work with loads of different data sources and types.
.png)
Article
How I Would Become a Business Intelligence Analyst Today
If I woke up tomorrow and had forgotten everything I’ve learned over the last 15 years working in Business Intelligence, this is exactly what I would do.
Article
The A to Z of BI - Business Intelligence For Beginners
If you’re curious to learn more about Business Intelligence, I’ve put together a quick A to Z for you. If you think I’ve missed anything, let me know in the comments...
BI Tools
How to Choose a BI Tool | 6 Major Differentiators
For anyone starting out in Business Intelligence looking to onboard a new Business Intelligence tool, the range of different solutions out there on the market can seem...
BI Tools
GA4 Vs. UA - Main DIFFERENCES & TIPS For Migrating Reports To GA4
From July 2023, all Google Analytics Universal Analytics properties will stop collecting and processing data. This means that any reports you have using this data will...
.png)
Data Analysis
Building GA4 Reports Using BigQuery
A few months back, out of the blue, Google imposed strict quota limits on the Google Analytics 4 API which threw a rather large spanner in the works for a lot of...
Data Analysis
Basic Predictive Analytics Using Simple Linear Regression
In this post I’m going to show you how to conduct some basic predictive analytics in Excel or Google Sheets using a technique known as linear regression . There’s some...
Data Analysis
What Are KPIs? Top Tips for Defining Performance
KPIs are the lifeblood of Business Intelligence and defining what yours are is the first important decision you’ll need to make when starting your Business Intelligence...
BI Tools
7 Data/Looker Studio Hacks Everyone Should Know
If you’re a Data Studio user looking for ways to speed up your reporting workflow whilst getting the most out of the tool, I’ve got 7 pro tips and hacks to help you do...
BI Basics
5 Reasons Every Business Needs BI
I believe that every business needs to implement Business Intelligence in one form or another and, in this article, I’m going to give you 5 good reasons why.
BI News
Google Just Killed Data Studio
Yes, it’s official, Google has just killed Data Studio. Let me explain…
BI Tools
How To Prepare Your Excel Data For Analysis | 5 Common Mistakes To Avoid
If you’ve ever tried to load your Excel data into a data analysis tool but got an error message or you’ve found that the data you loaded isn’t working as you thought it...
BI Tools
5 Awesome Resources for Data Analysts
If you’re hoping to start a career in Business Intelligence or Data Analysis, you’ll need to study, practice and hone your skills. Not only to build your project...
.png)
Article
Web Scraping with No Coding in Google Sheets
Did you know that you can use Google Sheets to scrape data from the web? And the best part? You don't even need to know how to code! In this article, I’ll show you how...