Ken Puls – Pragmatic Works – Building BI with Pivot Tables

Instructor

KEN PULS

Chartered Professional Accountant, Author and Trainer

Microsoft Excel MVP Ken Puls is a Chartered Professional Accountant, author and trainer. With 20 years of experience as a corporate controller and business owner, he has been exposed to many business systems, databases, and analysis tools, leading to a career of building Excel-driven applications to harness data and turn it into management information.

System Requirements

• All Pivot Table tasks can be performed in any version of Excel. Tasks related to Power Query require installation of the free Power Query tools in some versions of Excel. Tasks related to Power Pivot can only be performed if Power Pivot is installed in your product. Details to activate these tools can be found below:
  • Excel 2010
    • Power Pivot: Can be downloaded and installed in any SKU of Office 2010. Ensure that your Power Pivot version is version 11.0 or higher (not version 10.5.x).
    • Power Query
  • Excel 2013
    • Power Pivot: Requires Excel 2013 Professional PLUS, Excel Pro PLUS (subscription) or a standalone Excel license
    • Power Query
  • Excel 2016
    • Power Pivot: Requires Excel 2016 Professional PLUS, Excel Pro PLUS (subscription) or a standalone Excel license
    • Power Query: Built in to all versions of Excel

What to Know Before Class

This is a course aimed squarely at beginner/intermediate Excel users looking to take their skills to the next level. Before starting this course, you should be comfortable working in Excel. Knowledge of a variety of formulas can be helpful, although is by no means necessary. While those comfortable with Pivot Tables are likely to pick up new tricks to make their lives easier, the course is designed to take someone with absolutely no Pivot Table knowledge and teach them how to collect, clean and set up the data, present it in Pivot Tables and build dashboards using Pivot Charts. A basic understanding of Excel functions is helpful, but not necessary for this course. The target audience of this course is for power users who are learning DAX for the first time.

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.