How I help companies turn data into insights

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 their data into insights.

But what exactly does my job entail? What does a BI Consultant actually do?

Photo by Scott Graham on Unsplash

Well, as with any consultant, the client is looking to solve a problem but doesn’t have the requisite expertise to do so. So they’re looking to ‘consult’ an expert.

For me, as a BI consultant, there are 2 typical scenarios that account for the majority of the jobs I work on. A…

No matter the size or industry, there’s simply no excuse not to

Photo by Jonathan Francisca on Unsplash

Make smarter business decisions

Let’s start off with the whole “raison d’être” of BI, to help you gain insights from your data to make smarter business decisions. That’s right, those charts and graphs in dashboards aren’t just pretty images, they’re actually giving you a visual representation of how your business is performing. There’s no burying your head in, and trying to make sense of, a whole bunch of numbers.

To demonstrate just how beneficial it is to visualise your data, here’s a test I did in a previous video that illustrates this point perfectly.

In a second I’m going to show you 12 different…

Uncovering the ways some sellers manipulate the review system and rank their products on Amazon.

As anyone who has ever bought anything off Amazon knows, product reviews are very important. As buyers — after the product photos and the product title — reviews have the biggest influence on our purchasing decision. Providing us with supposedly honest opinions of previous purchasers.

But, for sellers, the importance of reviews takes on a whole different dimension. Whereas, for buyers, it’s simply a question of whether or not to buy a particular product (one you know you can easily get a refund for), for a seller the stakes are far higher. …

A product review based on my 6 major differentiators of BI tools

I’ll be evaluating Data Studio based on 6 different criteria. They are, for me, the 6 major differentiators of BI tools. They are:

  1. Connectors
  2. Data management
  3. Calculations
  4. Data visualisation
  5. Interactivity
  6. Publishing

1. Connectors

Photo by fabio on Unsplash

So, connectors are the data sources that the tool will let you ‘connect’ to. With Data Studio, these are separated out into 2 different groups. Google provided connectors and those created by 3rd party developers that are offered via the Data Studio platform.

Let’s start with the Google connectors. The majority of them are for products and services within the Google ecosystem, so things like Google Analytics, Ads, Sheets…

A guide to some of the crucial KPIs for measuring performance

Image via Adobe Stock under license to Adam Finer.

If you have a website but you’re not analysing its performance. Or you are but you’re a bit lost amongst all of the different reports in Google Analytics then let me give you a helping hand. First…

What is 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 and pasting a few lines of code into your website. Then it starts to record visit and visitor data. What pages are visited, for how long, that kind of thing.

There are actually…

Office Hours

If you’re considering a career in BI, I recommend you start here

Image via Adobe Stock under license to Adam Finer.

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 online services and social media. But not all companies have the necessary resources in-house to make sense of it all. To wrangle all that data together then to analyse and visualise it in order to gain valuable insights and make smarter business decisions.

That’s why Business Intelligence skills have become some of the most valued and highly sought-after in today’s jobs market. …

Let’s break down some basics of Business Intelligence

Like any industry, Business Intelligence has its own jargon and terms that can be confusing if you’re unfamiliar with them. Here I’m going to break down 7 of the most common terms in BI that everyone should know.

1. Data Silo

Photo by Meredith Petrick on Unsplash

A data silo is a standalone source of data that’s not connected to any others or to a centralised data repository.

Basically, most businesses generate tons of data in different places through all of their different activities. From simple Excel files and on-premise databases to social media profiles and web SaaS (Software-as-a-Service) services. You can even have different data silos within different…

Effective data visualisation is essential for making your reports as easy to understand as possible. It’s time to up your data viz game.

Photo by Carlos Muza on Unsplash

Throughout my career I’ve built hundreds of dashboards for some of the world's biggest brands, in all different industries. Here I’m going to share with you the 7 most important things to consider and implement when designing business dashboards to up your data viz game. My top tips, if you will.

1. Plan Ahead

Adam Finer

I’ve been working with data for around 25 years, a BI professional for the past 10. Nerd and proud, I want to help you do more with data.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store