How to Create A Real Time Dataset on Power BI.com
How to Create A Real Time Dataset on Power BI.com
Category: Importing Data
A Star (Schema) and a SWITCH for Drill-Down Income Statement Design
When I was first introduced to PowerPivot five or six years ago, I knew it would serve me well in my FP&A function.
Power Query (M)agic: Consecutive Days
Hello P3 Adaptive World! My name is Krissy Dyess and I have had the most amazing experience working as a full-time consultant at Power Pivot Pro since April 17, 2017!
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.
Sort Your Data on Load for Improved Compression
My last 2 blog posts have been about data compression – that theme continues today. In December I blogged about the basics of compression and impacts that columns have on file size and did some testing with randomised data.
Restructure Your Data Table for Improved Compression
I was relaxing during my vacation thinking some more about column compression in Power Pivot.
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.
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.
Introducing Power Update!
An article on the introduction to Power Update by the experts at P3 Adaptive .
Excel 5-Calendar Date Table
For some time, I have been looking around for a fairly complete date table in Excel for use with PowerPivot.
Workarounds for “Canceled Due to Memory Pressure”
You can run into this error via a number of different routes, but one way or another, your computer ran out of memory while PowerPivot was trying to do something.
Datamarket: Quick Followup
“There are people out there whose jobs force them to be the place where two sources of data meet, and they are the ones who integrate and cross-reference that data […]
- 1
- 2