In this video Brian Grant will walk you through just how easy these can be to create a Local ID in Power Query....
In this video Brian Grant will walk you through how you can leverage some more advanced features of the Power Query M language to combining conflicting customer names....
Basic aggregations are useful; but decision makers are going to want more and want it quickly. What they’re probably going to need next is time intelligence measures....
In this video I'm going to show you how to build an automated report which can surface these problems as quick as they show up. In the process you'll learn about structured values and see the different ways grouping can wrestle down...
In this video I'm going to not only walk you through the surprisingly simple way this problem is solved, I’ll also walk you through how to understand the solution and even use DAX to visualize it on the page....
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....
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...
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...
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...
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...
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...
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...
Since 1993, CSG Pro has built modern, scalable software and data solutions. Our data analytics consultants solve problems and ignite victories. We help you understand your data so you can make smarter business decisions. We build custom software applications that strengthen your process and your team.
©1993‐2021 CSG Professional Services, Inc. | Privacy Policy