• Building BI with PivotTables

    Building BI with PivotTables


    Learn how to master Business Intelligence and PivotTables with this self-paced video course Ken Puls created with the fine folks at Excel.TV. Building BI with PivotTables is the best, most comprehensive online course to quickly increase your data and Excel skills, and master Excel reports! Wrangle, crunch, and visualize your data with eight comprehensive modules that will turn you into a Business Intelligence master.

    Topics covered include:

    • Module 1: The Value of Pivot Tables - Learn about the Business Intelligence lifecycle
    • Module 2: Pivot Compliant Data Sets - Learn the perfect data layout and easily connect to your source data
    • Module 3: Pivot Table Look & Feel - Learn the best sorting techniques to show top and bottom metrics, and more
    • Module 4: Sourcing Data - Master Power Query to manipulate data and consolidate data across platforms
    • Module 5: Pivot Table Calculations - Learn statistical calculations, variances and differences
    • Module 6: Slicing and Filtering - Slice and dice your data
    • Module 7: Pivot Table Dashboards - Keep those pivots in sync and tricks for extracting key info
    • Module 8: Data Refresh and Security - Securing your data

    As an added bonus, when you sign up for the course you receive a free digital copy of Ken's and Miguel Escobar's book, M is for (Data) Monkey. This book shows how to use Power Query to get difficult data sets into both Excel and Power Pivot for dashboards and reports.

    If you believe you can build better business intelligence and reports, if you want to differentiate yourself in your office by having the best skills for the job, or if you love getting your hands dirty with data, then this is the course for you!


    View the full course details and register for the course on the Excel.TV website.


    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!


    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts


    Complex counting help

    The table in the latest file needs refreshing - I should have done that myself - sorry....

    p45cal Today, 05:45 PM Go to last post

    Complex counting help

    Hi p45cal - I think there is still some error in the logic but your suggestion of using Power Query has been invaluable. I have been researching that...

    Mr_E_Man Today, 05:35 PM Go to last post

    Complex counting help

    Attached adjusted accordingly....

    p45cal Yesterday, 11:31 PM Go to last post

    Complex counting help

    Hi p45cal - the specific "DT" function is the only one that does not get counted for the keypad on the 2nd or 3rd reference, it is different...

    Mr_E_Man Yesterday, 05:55 PM Go to last post

    Complex counting help

    The attached contains a table at cell I6, which agrees with your totals except for the keypad count of the first site (1185) where I have counted the...

    p45cal Yesterday, 03:05 PM Go to last post