Text Files to BI with Ken Puls

Dear friends,

This time we have an exceptional opportunity that won't happen everyday. Ken Puls is traveling all the way from Vancouver, Canada to speak to you in our BI user group. This is a fantastic opportunity to meet Ken who is an Excel MVP for many years, author of books and international speaker. This is the Ken's first time in New Zealand, and we are very happy to have him here, so join us to meet Ken and also learn from him some great features of Power Query and Power Pivot.

Power Query and Power Pivot are two add-ins to the Microsoft Excel product that allow you to read, reshape and relate data in order to create robust and update-able models. In this session I’ll show how these tools can be used together to build a business intelligence solution out of text files.

About Ken

http://photos1.meetupstatic.com/photos/event/8/6/9/f/600_445954463.jpeg

Before stepping into Exelguru 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 www.excelguru.ca, 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 was awarded the prestigious Microsoft Most Valuable Professional – Excel award in October 2006; a distinction he holds to this day. 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.
“I’ve never met anyone as knowledgeable and passionate about Excel as you.”
It’s something that Ken has heard frequently, and something he takes great pride in. He has a passion for teaching and Excel, and gets most excited about the topics he know will save YOU time and make you more efficient. Your software should work for you, and that’s his focus.