Chapter PD: An Intro to Power Business Intelligence for the Excel Pro


Saturday, April 28, 2018

8:00am - 9:00am : Registration and breakfast
9:00am - 12:30pm : Seminar in session 
10:20am - 10:35am : Coffee break
 PD hours: 
3.5 hours - limited to 50 attendees 
$140 plus GST


Eaglequest Golf and Country Club
7778 - 152nd Street Surrey


The changing landscape of analytics and why you should attend:

While Excel remains very much relevant today, and will continue to do so, Power BI Desktop adds another dimension to your reporting ability. With the “Get Data” experience based on the same Power Query technology as in Excel 2016, and the “Modelling” experience built on Excel’s Power Pivot, it is an easy tool to pick up and learn.

Where Power BI really shines, however, is when you get to its rich visualization layer. This layer allows rapid development of sliceable and interactive reports that will make your manager’s eyes pop. And with a click of a button you can publish your reports to be consumed on whatever form factor your end users desire; PC, web or mobile.

This course will introduce you to getting and transforming data, as well as some of the rich visualizations that Power BI has to offer. It will also include a demo of publishing and sharing your reports with others.


This is a hands-on course, and requires that you install Power BI desktop before you arrive. You can acquire the latest version of this free software here:

For attendees with any level of experience – those creating Business Intelligence or those managing a team who are.


About your Presenter: Ken Puls, FCPA, FCMA,

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.

Ken has also been an active participant in many Web forums since 2002, and hosts a website at, which provides code samples for working with Excel, other Microsoft Office applications and free utilities. In fact, NASA has even made use of this site, using some of Ken's PDFCreator examples to automate the production of PDF reports which monitor the power supply levels on the International Space Station.

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 March of 2013 Ken was also recognized as one of the “Top 20 Under 40” Business and Community Leaders on Vancouver Island, and in November 2014, he was also recognized as a Fellow in the CMA Society, an honour given to less than 2% of CMA’s in their lifetime.

Ken has a passion for teaching people how to build business intelligence, specifically focusing on Excel and Power BI. He gets most excited about the topics he knows will save YOU time and make you more efficient. Your software should work for you, and that’s his focus.



Sorry, registration for this event is now closed.