Author Profile – Ken Puls

Ken Puls, FCPA, FCMA

One of the founding partners of Skillwave.Training, Ken is the President and Chief Training Officer of Excelguru Consulting Inc.

Before stepping into Excelguru Consulting Inc. full time in May 2015, Ken spent over twenty years working in public practice accounting and industry as both Controller and an IT Director. Ken has led the installation of over a dozen systems conversions and implementations of various types, and been exposed to a vast amount of business systems, including point-of-sale systems, databases, and analysis tools, some of which he wrote from scratch.

Today, Ken is regarded as one of the world’s most passionate trainers and leading experts in Microsoft Excel, Power Query and Power BI.

 

Publications

In addition to his blog, Ken is co-author of two books, as well as a contributor to several others including:

Cover of M is For Data Monkey

M is for Data Monkey

Co-Author of THE book for Excel and Power BI Pros to learn the Power Query technology

Cover of RibbonX

RibbonX

Co-Author of the guide to providing your own custom user interface for Microsoft Office documents and Applications

Cover of Excel Insights

Excel Insights

Author of the Power Query chapter "Combine All Files in a Folder"

Cover of Power BI MVP Book

Power BI MVP Book

Author of the chapter "Creating Calendar Dimensions with Power Query"

Software Products

Monkey Tools – Build better, faster.

Monkey Tools is an Excel add-in containing a set of tools to help you, as a business intelligence author:

  • Build models more rapidly
  • Follow recommended practices
  • Document your work
  • Audit files that you receive
While primarily targeted at the Excel analyst, many of the tools can also be used to read and analyze Power BI files as well!

Monkey Tools features:

  • QueryMonkey (insert useful new queries into your data model)
  • DestinationSleuth (provide information on query load destinations)
  • QuerySleuth (understand query relationships)
  • TimeSleuth (benchmark query refresh times)
  • PivotSleuth (diagnose Pivot Table field issues)
  • DAXSleuth (working with DAX measures)
  • ModelSleuth (details and statistics on your queries and data model)
  • And more!
View of QuerySleuth from Excelguru's Monkey Tools

Monkey Tools 'QuerySleuth'

Trace Query Dependency chains, indent your M code and modify queries right from the Excel user interface.

View of DAXSleuth from Excelguru's Monkey Tools

Monkey Tools 'DAXSleuth'

Trace DAX dependency chains, see where your measures are used, indent and modify your measures - without ever leaving Excel!

Monkey Tools 'PivotSleuth'

Review your PivotTable to prevent or fix the root cause of the dreaded "Relationships between tables may be needed" message!

Learn more (and even download a free trial) at Excelguru.ca.

Awards & Accolades

In recognition of his contributions to the online community Ken has been recognized with the prestigious Microsoft Most Valuable Professional award every year since 2006. In 2013 Ken was recognized as one of the “Top 20 Under 40” Business and Community Leaders on Vancouver Island, and in 2014, he was also recognized as a Fellow of CPA Canada, an honour given to less than 4% of CPA’s in their lifetime.

About Excelguru Consulting Inc.

The Excelguru website provides an extensive catalogue of Knowledge Base articles, Ken’s technology blog (where he shares much of his experimentation and observations of different technologies, particularly Power Query), and a free help forum for questions on Excel, VBA, Power Pivot and PivotTables, Power Query, Power BI and more.

Magic-Tricks-for-Data-Wizards-1.png

ARE YOU IN?

15K+ subscribers have already claimed their free eBook.

Sign up and get your FREE copy