Posts filed under PowerPivotPro

P3: My Top 5 Power BI Visual Design Practices: Transforming Good to GREAT

Article by: Reid Havens

Hello again P3 nation, today I’d like to drop some reporting knowledgeI’m going to share some of my best practices for Power BI Reporting I’ve developed over the years. As many of you are aware, a large part of the BI developer’s / analyst’s job is to not only create the report, but also to make sure it looks good, tells a story, pops, or my personal favorite “is aesthetically pleasing”.

Finger-Pointing_thumb.jpg

P3: DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers

Article by: Reid Havens

Guess how many articles are here on PowerPivotPro.com?  Go ahead and think of a number, I’ll wait. The answer, at time of writing, is 923.  Rob alone has published 715 articles!  And these date all the way back to 2009. A lot of these articles are “old,” but folks, the DAX engine is still 99% the same today in Power BI (and Excel 2016) as it was when it first “hit the shelves” in Spring 2010....

P3: Power Query (M)agic Part 1: Always Have Good References

Article by: Reid Havens

P3 friends…for those of you in the know (and for those who aren’t), Power Query (or PQ for short) is one of the cornerstones of the Microsoft BI Suite. It’s a tool built into Excel 2016 and Power BI Desktop that allows us to extract our data (78 data connectors and GROWING), transform our data (it’s more than meets the eye), and finally load our data into a Data Model. Wait…so PQ extracts, transforms, and loads data? Those words spell out ETL as an initialism!

Posted on May 23, 2017 and filed under Beginner, Power Query, PowerPivotPro.

P3: Using Power Update as a Time Machine for Excel (AND NOW Power BI Desktop) files!

Article By: Reid Havens

Many of you may know of our wonderful business partners over at PowerON. Among the services and software they offer is a powerful tool called Power Update that essentially automates the refresh (AND publishing!) of Excel AND Power BI Desktop files.

Posted on May 11, 2017 and filed under Tools & Software, PowerPivotPro.