Elements of DAX with Brian Grant
The Elements of DAX video series is the brainchild of CSG Pro’s Brian Grant. In this series, Brian breaks down DAX into three steps....
27 July, 2020
Author: Brian Grant
Calendarfornia Dreamin – M Calendar Script for Power Query
People ask me all the time which M script calendar table I use in Power Query. Honestly, most of the time I just grab the most recent one I've used and add/remove columns as needed. Though I thought it might make sense...
08 May, 2020
Power BI Tutorial: Advanced Report Interaction Video Series
All you care about is understanding your data and making informed business decisions. Microsoft Power BI is a complex platform, with many features and user paths. You only need to know a few key components well to get the job done. The...
27 January, 2020
Power BI Tutorial: Getting to Know Power BI Video Series
Your main concern is understanding data and making data-driven decisions. You don’t know the ins and outs of Microsoft Power BI, but you need this tool for all things data. The CSG Pro Business User Video Series is a Power BI tutorial...
20 January, 2020
Power BI Tutorial: Basic Report Interaction Video Series
The CSG Pro Business User Video Series is a Power BI tutorial for, you guessed it, business users. Your main goal is to understand your data and make informed business decisions. You don’t have the time or energy to learn everything Microsoft...
13 January, 2020
Migrating from an Excel to SQL Data Source in Power BI
Working off of an Excel data dump can be a great way to get started building a report while the more official SQL table gets built. The problem is that when you are done, repointing from Excel data to SQL data is...
07 October, 2019
How Summary Queries Help you Understand DAX
BRIAN GRANT (CSG Pro) Brian will be reviewing how summary queries will help those new to DAX understand the intricacies of writing measures. Brian Grant is a masterful Analytics Consultant at CSG Pro by day, and a Power BI legend by night. Brian's passion...
22 May, 2019
Dial Sparklines for Table Visualizations
BRIAN GRANT (CSG Pro) In this presentation local DAX obsessive Brian Grant will show you how to use a CSG built Dial sparkline measure to quickly display goal to actual information in a highly compressed manner that will be an excellent addition to...
26 September, 2018
Bullet Chart Sparklines in Power BI
If the goal is an actual comparison, it's hard to beat the bullet chart. Highly efficient in terms of the amount of space they take up, with excellent data to ink ratio, they are both immediately intuitive yet data-dense without relying on...
28 August, 2018
Building Basic SVG Sparkline/Small-Multiples Measures in DAX
Sparklines and small multiples are incredibly powerful. They allow you to add a tiny simple graph to a table or a matric that conveys the basic idea or shape of the data in a way that is compact enough to allow for...
28 August, 2018
Building a DAX Time Intelligence Inspector
Creating and troubleshooting time intelligence measures in Power BI can be tricky work. Getting a measure to work at one granularity is hard enough, but when you start to look at rollup values it's difficult to be confident that you're getting the...
22 August, 2018