by Helen Clarke | Nov 20, 2018 | PowerPivotPro
Have you ever needed to get data out to an internal customer quickly to meet an urgent business need, in an easy to access, updateable format? Of course! There are lots of ways to do this, and I’ve tried various… This post first appeared...
by Sakiko Stickley | Nov 13, 2018 | PowerPivotPro
Navigating the sea of data One of the many things which amaze me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For example, receivables not being paid… This post first appeared...
by Parker Stevens | Nov 8, 2018 | PowerPivotPro
It’s sometimes difficult to find things that Power BI can’t do. There always seems to be a solution no matter the task at hand. A little while ago I was wondering to myself if it was possible to embed a… This post first appeared...
by Krissy Dyess | Nov 6, 2018 | PowerPivotPro
I watched a video from Guy in a Cube’s Patrick featuring Marco Russo where they walked through an example using a technique to debug DAX measures using VAR/RETURN – I loved this! https://www.youtube.com/watch?v=9SV2VnYbgg4 The video made me recall another Blog… This...
by Fred Kaffenberger | Nov 3, 2018 | PowerPivotPro
This is a quick tip on automated testing with Power Query. I loved Nar’s post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality. For… This post first appeared...
by Doug Burke | Oct 30, 2018 | PowerPivotPro
What do you get when you combine Power Query with Amazon Web Services? You get a powerful new data source for your business needs and open a world of analytics possibilities. I’ll have some of that! I am certainly not… This post first appeared...
