Excel - The Business Intelligence Toolkit - Power Pivot Beyond The Basics

Mike Thomas
Instructor:
Mike Thomas
Date:
Tuesday, October 20, 2020
Time:
10:00 AM PDT | 01:00 PM EDT
Duration:
60 Minutes

More Trainings by this Expert   Product Id : 503348

Price Details
$150 Live
$290 Corporate Live
$190 Recorded
$390 Corporate Recorded
Combo Offers
Live + Recorded
$289 $340 Live + Recorded
Corporate (Live + Recorded)
$599 $680 Corporate
(Live + Recorded)
Price Detail Options
Overview:

Mastering when to use a Calculated Column and when to use a Measure is key to reporting success and selecting the wrong one can result in poor report performance and incorrect results. But what are Calculated Columns? What are Measures?

Why you should Attend: Your data is only as good as the information you can derive from it. Power Pivot enables you to gain better business insights and make more informed business decisions.

If you want to take your reporting capabilities to the next level by learning how to leverage the calculation functionality of Power Pivot, this is a must-attend training session!

Areas Covered in the Session:

  • Creating Calculated Columns
  • Using Calculated Columns to build a Slicer
  • When to use a Calculated Column v when to use a Measure
  • Working with Dates
  • The Lookup Function

Learning Objectives :
  • In this training, you will learn, using practical examples, how to use the DAX formula language to create and add calculated information to your Pivot Tables, providing you with even greater insights into your data

Who Will Benefit:
  • This training is aimed at users of Excel (2010 and above for Windows) who are familiar with the basics of Power Pivot and who wish to learn how to add calculations to their Pivot Tables
  • IMPORTANT NOTE: Power Pivot may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department


Speaker Profile
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 He founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.

Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organisations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.


You Recently Viewed