by Gil Raviv | Oct 26, 2018 | Data Chant
This is the first post of a series of bonus exercises that will accompany my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. The topics of these bonus exercises will usually cover areas that are already discussed in the book. They...
by Matthew Mowrey | Oct 25, 2018 | PowerPivotPro
The Microsoft Data Platform (and probably any BI tool) and FP&A seem to have at least one thing in common: it’s hard to find qualified people. I hear it all the time. I don’t think I consciously concluded that I… This post first appeared...
by Paul Hansen | Oct 23, 2018 | Power BI
We are excited to announce that we have just released the October update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release:… This post first appeared...
by Fred Kaffenberger | Oct 23, 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 Matt Allington | Oct 22, 2018 | Excelerator BI
There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers. When this happens, you only get half the page to visualise the actual data. But on the flip side, if you don’t have the slicers it can be harder for the report...