When should you use Power Pivot? When you want to clean, shape and transform data When you need to create complex calculations that aren't available in standard Pivot Tables. When you need anywhere, anytime access to your data When you need to access your data on a mobile device