Welcome to the latest PowerPivotPro Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on a Slack channel, and are then lightly edited for publication. In this installment of our Coffee Talk series, we’ll be chatting with DAX heavy hitters: Austin Senseman, Matt Allington, Kasper de Jonge, and Marco Russo. Let’s introduce everyone.
Kasper de Jonge, Program Manager at the Power BI team at Microsoft and passionate BI practitioner with deep knowledge of the Business intelligence market, specializing in Microsoft BI, Cortana Analytics and Azure data stack. As an active member of the Microsoft BI community he shares his findings and knowledge on Power BI through his blog https://www.kasperonbi.com, several white papers and sessions at conferences like SQLPass, SQLBits, Ignite and many other events around the world.
Marco Russo, Founder at SQLBI, Business Intelligence consultant and mentor. His main activities are related to data warehouse relational and multidimensional design, but he is also involved in the complete development lifecycle of a BI solution. Marco is also an author and, in addition to his many BI-related publications, has authored books about .NET programming. He is also a speaker at international conferences such as TechEd, PASS Summit, SQLRally, and SQLBits.
Matt Allington, BI Professional with over 30 years’ experience in the Consumer Packaged Goods industry, Principal Consultant here at PowerPivotPro, owner of the company Excelerator BI and author of “Learn to Write DAX – A Practical Guide to Learning Power Pivot for Excel and Power BI” and “Supercharge Power BI – Power BI is Better When You Learn to Write DAX”.
Austin Senseman, VP Operations here at PowerPivotPro, trying to keep this company running like a well-oiled machine
Welcome and Introductions
New DAX features (as of Sep. 2017)
Old vs New DAX
Measurename = VAR var1 = EXPRESSION
VAR var2 = EXPRESSION
VAR var3 = IF(var1 > 10, var1 / var2, var2)RETURN var3
Common Student Struggles
Forget bending spoons with your mind – there’s no money in it.
It takes a special kind of mindset to “bend” data (and software!) to the human will. As this article demonstrates, we at PowerPivotPro can twist Power BI into a pretzel if that’s what an organization needs. (A robust, trustworthy, industrial-strength pretzel of course).
The data-oriented challenges facing your business require BOTH a nimble toolset like Power BI AND a nimble mindset to go with it. And as Val Kilmer / Doc Holladay once said, we’re your huckleberry.