M/Power Query “Sets Up” DAX, so Learn DAX (and Modeling) First
You should advance to Intermediate in DAX before advancing to Intermediate in Power Query / M, and then to Mastery of DAX before Mastery of M.
Category: Data Strategy
New Reports From Existing Datasets
Learn how to upload a Power BI desktop file to PowerBI.com by following these short, simple steps.
Roundtable: Better IT/Biz Relations in the Power BI Era
New Feature: Roundtable. Welcome to an experimental new feature here at P3 Adaptive , where members of the team discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on our Slack channel, and are then lightly edited for publishing on Friday.
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.
Designing for Usability in Power Pivot and Power BI
An article on improving the usability in Power Pivot and Power BI as well as where the current program is at now and how to improve key flaws.
BI for Everyone: Tear Down the Wall Between IT and Business
President Reagan in his famous “Tear down this wall” address, asked for the Berlin wall to be brought down. Believing that freedom and security go together.
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.
Red Nose Special: 24 Distinctive Ways to Die
An article on the 24 Distinctive Ways to Die by state.
Insight as a Service – Your Next Career?
Is Your Brain More Valuable Than You Know? ***Update: May 2015 This article is now three years old. I’ve been gone from my last company now for more than two […]
DAX – Top-Selling Product using FIRSTNONBLANK()
First of all, apologies for being so late. I feel like a total zombie, we got to our house in Ohio 22 hours after we arrived at the airport in Tel Aviv.
Beta-Testing the “ROI Quadrant”
If you’ve been around Business Intelligence for the past ten years, you’ve seen a LOT of Gartner’s Magic Quadrant. You can see the 2012 version here on Microstrategy’s web site.
DAX – Weighted Averages: Another Use of SUMX()
Another Question from the Mr. Excel Forums Got a question on the forums the other day. It took some extra twists and turns but the simplest version of the question is worth covering here: how do I perform a weighted average?