
James McGillivray
James McGillivray, Data Management and Analytics MCSE, has been working in Business Intelligence for over a decade. He spends his working hours building solutions that allow people to make informed decisions. quickly and accurately. He is a Director at South African Data Consultancy, Cobalt Analytics.
Before his career in data, James was an avid musical theatre student and musician. This love for performance has developed into a passion for developing and delivering presentations that are informative and enjoyable. James speaks frequently at Data Community Events, and has presented at some of the most well-known Data Events around the globe, including PASS Summit, SQL Bits and the Power BI World Tour.
James McGillivray's Sessions
The Fundamentals of DAX ContextsSQLBits 2025
Unlock the power of DAX by mastering context—row, filter, and evaluation. This session explores how context shapes calculations and how to control it effectively through hands-on demos, helping report developers build accurate, dynamic solutions in Power BI.
A Picture is Worth 1000 Words: The Visual Learner's Introduction to DAXSQLBits 2024
Unlock the potential of DAX. This session simplifies DAX concepts through engaging visuals. From fundamental DAX elements to mastering measures, understanding context, and thinking in DAX, it's all covered visually. Whether you're a data analyst, business intelligence professional, or data enthusiast, this session will empower you to confidently navigate DAX. Don't miss this opportunity to revolutionize your DAX skills and embark on a visually captivating journey to enhance your data-driven future.
The Fundamentals of DAX ContextsSQLBits 2024
Explore the heart of DAX with this unique session, as I take you on an African Safari-themed adventure, where stunning wildlife photography serves as the backdrop for understanding the intricacies of DAX contexts. We'll encounter row and filter contexts, just like wild creatures in their natural habitat. Through captivating visuals, you'll uncover how these contexts shape DAX calculations and measure outcomes. Whether you're a data analyst or a business intelligence enthusiast, this session ensures a memorable and educational experience. Understanding DAX Contexts is your gateway to mastering DAX while enjoying the captivating beauty of African wildlife. Don't miss this opportunity to embark on your DAX adventure.
Fabric Power HourSQLBits 2024
The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!
5 Things You Can Do to build better looking reportsSQLBits 2023
Power BI Design is a lot like an art form, a mythical beast to many IT professionals. We’re generally inclined to think very analytically about our jobs, and creativity does not always come naturally. Thankfully, there are some patterns we can apply to design reports which are clean, uncluttered, and user friendly. Learn the science behind design, and a series of logical steps to follow to ensure that your reports always meet the mark.
The Fundamentals of DAX ContextsSQLBits 2022
Understanding how DAX determines evaluation context is a critical skill for a Power BI Developer. Writing anything other than the most simple measures requires this skill. In this session we'll explore Filter Context and Row Context individually, and how they combine to form Evaluation Context. We'll have a look at a number of simple measures and visualise how the context affects them.
"Whats in a Name?", Data Stories to Impress the BardSQLBits 2020
Data on its own is useful, but boring. Data in story form makes people sit up and take notice. Learn to craft effective stories and maximise the impact of your data communication.
Power BI Report Design for the Aesthetically ChallengedSQLBits 2019
Have you ever looked at other people's Power BI reports, and wondered how they look so good? Designing an aesthetically pleasing report does not require a graphic designer, just the lessons you'll take away from this session.
4 Useful DAX Solutions for Business ProblemsSQLBits 2022
You’ve built a perfect Star Schema, and your data models are performing amazingly… but now you’re starting to run into business questions that the model isn’t designed to answer. Let's fix that.
Windowing Functions - A simple secret for making your data more beautifulSQLBits 2022
Windowing Functions are an underappreciated part of SQL Server. In this session we'll start with the absolute basics of windowing functions, but quickly ramp into the advanced analytical and query enhancing properties of these functions.
3 Ways to Debug DAXSQLBits 2022
Debugging DAX is hard. Really hard. But learning these 3 simple techniques will make it easier and allow you to spend less time on it, and more time on adding more value to your clients.
5 Things You Can Do to build better looking reportsSQLBits 2022
Understanding a little design theory can go a long way in improving the quality of your reports, and the amount of value you present to your clients. Learn 5 tips that will improve the aesthetic quality of your reports in a couple of simple steps.
A tale of two storiesSQLBits 2022
A holistic approach to presenting data through storytelling
Just Too Much Information: WTF is Cognitive Load, and why should it affect my reports?SQLBits 2022
Cognitive Load is a concept from Psychology about the amount of effort exerted when reasoning, thinking, or interpreting an input, whether visual, audible or otherwise. In this lightning talk we'll understand what this means in terms of reports, and what we should consider when designing to minimise the cognitive load for our consumers.
Simply the Best - A DAX Pattern for Top PerformersSQLBits 2022
Learn how to write a flexible and adaptable DAX measure to display the top performer within a category and to add an extra dimension to your DAX models.
The Fundamentals of DAX ContextsSQLBits 2022
Understanding how DAX determines evaluation context is a critical skill for a Power BI Developer. Writing anything other than the most simple measures requires this skill. In this session we'll explore Filter Context and Row Context individually, and how they combine to form Evaluation Context. We'll have a look at a number of simple measures and visualise how the context affects them.
"Whats in a Name?", Data Stories to Impress the BardSQLBits 2020
Data on its own is useful, but boring. Data in story form makes people sit up and take notice. Learn to craft effective stories and maximise the impact of your data communication.
Power BI Report Design for the Aesthetically ChallengedSQLBits 2019
Have you ever looked at other people's Power BI reports, and wondered how they look so good? Designing an aesthetically pleasing report does not require a graphic designer, just the lessons you'll take away from this session.