JEFFREY WANG (Microsoft Power BI) Jeffrey will go over important DAX concepts, programming patterns, debugging techniques, and common user mistakes. DAX has been repeatedly voted by users as one of the most powerful features of Power BI and at the same time one...
JEREMY BLACK & KIRILL PERIAN (Data Driven Solutions) Creating a multi-language reporting solution in Power BI presents a number of challenges along the way. Our team would like to share our experience with these challenges and some ways to overcome them, while highlighting...
RACHEL DYER (CSG Pro) Rachel Dyer is the Vice President of Analytics at CSG Pro with in-depth expertise of the Microsoft BI stack and dimensional modeling. She has a broad management background and strong communications skills, coupled with considerable technical experience in platform...
TED PATTISON (Critical Path Training) In this user group talk, Ted Pattison will deliver a fast-paced primer on the fundamentals of the M programming language. This session aims to provide a solid foundation for writing M code in the Advanced Editor when designing...
RON BARRETT (Audigy Group) Oracy is the ability to express oneself fluently and grammatically in speech. Literacy is the ability to read, write. Numeracy the ability to understand and work with numbers. Graphicacy is defined as the ability to understand and present information...
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...
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...
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...
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...
A generally best practice in Power BI is to avoid naming columns in ways that won't make sense to users so things like CustomerFirstName should be broken out with spaces between the words. The problem is that when faced with a big...
Getting a percent of total measure working in DAX, understanding how it's working in a non vague way can be quite a bit trickier. Really it is an ideal pattern to learn some of the underlying behavior of DAX. In this video, we...
When learning DAX, time intelligence formulas are an excellent place to start, and of the many formula patterns out there, “Year to Date” variations might be the best to learn first. The problem is, while writing them is fairly easy, understanding how...
