Tabla de Contenidos:
  • Supercharged reporting with Power Pivot
  • Thinking like a database
  • Introducing Power Pivot
  • The pivotal Pivot table
  • Using external data with Power Pivot
  • Working directly with the internal data model
  • Adding formulas to Power Pivot
  • Publishing Power Pivot to SharePoint
  • Wrangling data with Power Query
  • Introducing Power Query
  • Power Query connection types
  • Transforming your way to better data
  • Making Queries work together
  • Extending Power Query with custom function
  • The part of tens
  • Ten ways to improve Power Pivot performance
  • Ten tips for working with Power Query.