Coffee Talk: DAX Pros
n today’s fast-paced digital world, information is power, especially when it comes to mastering the intricacies of software development and deployment.
Search Results for: best pract
Announcing P3 Adaptive Seattle/Northwest with Power BI!
Hardcore “trying on” the Power BI label. Today, even our national practice is doing about a 50/50 mix of Power Pivot vs. Power BI work.
Individual Excellence vs. Organizational Impact: Know the Difference!
What We Can Do With “Just” DAX and Modeling. It’s my experience-powered belief that you cannot get a Win of that size without leveraging DAX and Modeling.
The Ten Pitfalls of the Data Wrangler (aka the Wielder of M/Power Query)
Ten Pitfalls of the wrangling of using Power Query and how to avoid them, written by P3 Adaptive , Rob Collie.
Nerds-Turned-Bullies, the Rise of the Brogrammer, and Are Analytics Good for SQL People?
Today I want to go off-topic just a little bit, but in a way that I think is relevant to many of us as professionals. And then bring it home, so to speak, specifically at the intersection of Analytics and Databases.
Break your DAX Problem into Manageable Parts
One of the concepts I discuss in my new book Learn to Write DAX, is that you should break your DAX problems into manageable pieces so that you can solve the problem one step at a time.
Nested SUMX or DAX Query?
I was helping a friend out recently with an interesting problem. It all started with a SUM( ) that wasn’t behaving.
Consolidated Worksheets with Power Query
The more I use Power Query, the more I want to use Power Query – and of course the more I learn.
The “Ferrari” of PowerPivot Books
UPDATE: My book, which explains the PowerPivot formula language (DAX), in down-to-earth fashion tailored to the Excel audience, releases November 6, 2012. I wrote it to fill the “DAX for Excel people” gap that existed between all of the previous books. People have been asking me seemingly forever to do this, I finally got around to it.
Interview with JamieMac of Predixion Software
Me: “Can you PLEASE stop answering the question before I even ask it? It’s kinda freaking me out.” Jamie: “I knew you were going to say that.” It is a […]