Business Intelligence – Data Science Review

Mastering USERELATIONSHIP() in DAX: A Deep, Practical, and Engaging Guide

December 23, 2025
/ Business Intelligence
/ By James

How to unlock alternate relationships and take full control of your data model’s behavior Power BI’s data model is built on relationships—those invisible highways that let filters flow from

Why DAX Exists: Measures as Templates and Windows as Context

September 5, 2025
/ Business Intelligence
/ By James

Do you struggle with DAX? If so, you’re not alone. The hardest part with DAX isn’t the syntax. It’s conceptualizing it mentally. What does “filter context” really mean? Why does a measure give

The Four Core DAX Measures

February 5, 2022
/ Business Intelligence
/ By James

When I first started working with Power BI, I often heard that you could get by with just four core DAX measures: Total Sales, Total Cost, Total Profit, and Profit Margin. At the time, that advice felt

Create Lookup Tables from Fact Tables Using Merge in Power BI

January 30, 2022
/ Business Intelligence
/ By James

When analyzing data, analysts should adhere to best practices. Once such best practice is to use a star schema for the data. At its basic level, a star schema contains one or more fact tables, and several

Tutorial: A Quick and Easy Mapping Table in Power BI

October 17, 2021
/ Business Intelligence
/ By James

I often work with annual reports, including financial statements for listed companies. I do it both for investing and for my job where I want to know the financial solvency of my clients and potential

Create Lookup Tables from Fact Tables in Power BI

October 3, 2020
/ Business Intelligence
/ By James

At some point, you'll need to create lookup tables from data sources. Excel users often clump all entities together in each row. This is a natural way for them to view the data and it's the easiest

Review: Power BI – Up & Running with Power BI Desktop

July 10, 2020
/ Business Intelligence
/ By James

Course: Power BI - Up & Running with Power BI Desktop Instructor: Chris Dutton Platform: Udemy.com Price: Varies Rating: 5 Stars (out of 5) Summary If you are struggling to learn

Introduction to Power BI – Training that Helps You Learn Quickly

June 12, 2020
/ Business Intelligence
/ By James

Power BI is an analytics program that helps people gain insights into data. It's not overly difficult to learn, but it has several powerful features that can make it overwhelming for newcomers. There

How to Get Started with Power BI

May 14, 2020
/ Business Intelligence
/ By James

Power BI is an analysis tool created by Microsoft. It is part of a class of software tools known as self-service business intelligence tools, which means that it is supposed to be easier than most analytics-based

Loading R Scripts Into Power BI

April 20, 2020
/ Business Intelligence
/ By James

R is a popular language for data science, although recently Python is winning the language wars. Still, R has its proponents (yours truly) and will continue in its use throughout the data science community.

Category Archives for Business Intelligence