{ Ken Puls }
Canada

15 x Microsoft MVP
FCPA, FCMA
My Data Summit

  • About The Speaker

    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.

  • Summit Session

    Rapid Excel BI Model Development
    06th September 2022 | 17:05 to 18:00 hrs – Azerbaijan Time (GMT +4)

    In this session, Ken will show you how he can build a complex Excel BI model leveraging Power Query and Power Pivot very quickly. From sourcing data to creating Calendar Tables, Measures and more, you'll be amazed at how fast it can be done if you have the correct (Monkey) tools at your disposal.

  • Masterclass

    Topic : Master Your Data with Power Query
    (Live/Recorded Masterclass Session with Live Q&A)

    Note : It will be a mixed live/recorded version where attendee will receive the login credentials for the course one prior to the event. After watching recorded masterclass, Live Q&A session via Zoom/Teams will be held as mention on the below date. Note that the attendees will be granted with a full year of access to the recorded version of Masterclass (but without the Q&A part.)

    Q&A Session Length : 2 days x 4 hours per day (+/-aprox.)
    Date : 08th September 2022 & 09th September 2022
    Time : 18:30 to 23:00 hrs – Azerbaijan Time (GMT +4)

    In this course, you’ll learn how Power Query can clean up, reshape and combine your data with ease – no matter where it comes from. Converting ASCII files into tables, combining multiple text files in one shot and even un-pivoting data is not only simple, but an investment in the future refreshable with a single click when next needed.

    If you need to learn one skill in Excel today, how to work with Power Query is it. Not only will it change the way you "Get & Transform" data in Excel, but it's also the system used to collect data for Power BI, meaning these skills are transferable to other programs.
    ✔ Review of Essential Tools
    ✔ Importing Data
    ✔Appending and Merging Tables
    ✔ Pivoting, Un-Pivoting and Transposing Data
    ✔ Conditional Logic
    ✔ Best Practices

    {Click here to register now for masterclass}