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

October 20, 2020 - CA US



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

More Information