New Reports From Existing Datasets
Learn how to upload a Power BI desktop file to PowerBI.com by following these short, simple steps.
Tag: Data Strategy Plays
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 […]
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?
Aged Debtors–Dynamic Banding in DAX
Guest post by David Churchward [Twitter] Having hit the P&L and Cash Flow in previous posts, it seems only reasonable to move on to Balance Sheet aspects. The die-hard “non-accountant” Excel […]
VLOOKUP Week: Who Needs VLOOKUP Anymore?
A couple of years ago at lunch, Bill remarked to me that VLOOKUP was the “scariest” feature in Excel