(Livestream Replay) Pro User Excel Add-In - MonkeyTools (with Ken Puls)

Come hang out as Ken Puls (Excel Guru) showcases his fantastic pro user Excel plug-in [Monkey Tools]! This tool is fantastic for helping users build better BI models for use in both Excel AND Power BI. Just SOME of the features include many "sleuthing" features to investigate and optimize parts of your model or report. One of my favorites honestly is the Dynamic Calendar Creator! Watch the stream to learn about all this and more.

GUEST BIO 📄

Ken Puls is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. A blogger, software developer, author and trainer with over 20 years of accounting and IT experience, Ken's passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Learn more about Ken at the links below!

RELATED CONTENT 🔗

Ken's Twitter
Ken's LinkedIn
Company Website
Company Blog
MonkeyTools

Reviewing the Performance Analyzer in Power BI

Video by: Reid Havens

Provides a walk through of the new Performance Analyzer in Power BI. The Performance Analyzer captures operations that occur while a user interacts with a report.

Additionally, I built a Power BI report off the exported data. This report summarizes those operations so users can see detailed information about each visual. Additionally, it includes the underlying performance events for all user operations. Report operations are broken down into three primary categories: Report Canvas, Data Shape Engine (DSE), and Data Model Engine (AS). More details about these operations can be found in the report.

P3: Coffee Talk: PowerPivot Utilities

Welcome to the latest PowerPivotPro Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on a Slack channel and are then lightly edited for publication. In this installment of our Coffee Talk series, we’ll be chatting with The Power Pivot Utility team: Bertrand d’Arbonneau and Marco Russo, along with P3’s Reid Havens and  Matt Allington. Let’s introduce everyone.

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.