Restructure Your Data Table for Improved Compression
I was relaxing during my vacation thinking some more about column compression in Power Pivot.
Content Type: Blog Post
Quickbooks Analysis via QQube!
For a couple years now, we’ve been quite a bit bigger than the two-person operation of our early days. Like I mentioned in a previous post, there are now somewhere between 15 and 20 people who work for us in some capacity ranging from full-time to part-time.
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.
The High Cost of Poor Equipment
Over the last 12 months I have engaged with may people from lots of different companies on the topic of Power Pivot.
Giving Back: “Steal” this Reference Card!
A long time coming… The Finalized 8-Page “Reference Card V2” – Download it for Free Below Yes, this took me forever. I first posted about it more than
Interview with Kamal Hathi of Microsoft, plus “AMA!”
Director of Product Management, Microsoft BI
Share and Refresh Power Query & PBI Get Data with Local Links
The concept of parameter tables in Power Query will be familiar to some and new to others. A parameter table is a way that you can “pass” values to Power Query (and also Power Pivot) and these values can then be used in your queries and/or the data model.
Complex Customer Cohort Retention Using PRODUCTX
Post by Rob Collie First, a Few Quick Updates…
Power Query as an SSIS Alternative
One of the many things I love about Power Pivot and Power Query is that these tools have put BI into the hands of users
Two Tricks to Make Your Cube Formula Scorecards Drama-Free!
Guest Post by Andrew Todd Cube Formulas: Ultimate flexibility for your reports but lots of drama to update… A while back, I was tasked with finding a way to automate […]
Power BI Desktop New Feature: Bi-Directional Relationships!
An article on the Power BI Desktop New Feature by the experts at P3 Adaptive .