Power Pivot in Excel: Erstelle leistungsstarke Datenmodelle

Course Overview

• Course Title: Power Pivot in Excel: Erstelle leistungsstarke Datenmodelle
• Instructor: Sebastian Glöckner
• Target Audience:
  • Excel users with basic knowledge
  • Beginners looking to learn Power Pivot
  • Users with experience in creating simple pivot tables
• Prerequisites:
  • Basic knowledge of Excel functions such as cell formatting, simple calculations, and working with tables
  • Power Pivot is available in specific Excel versions and does not work on Mac

Curriculum Highlights

• Key Topics Covered:
  • Setting up and activating Power Pivot in Excel
  • Importing data from various sources into Power Pivot
  • Creating dynamic pivot tables
  • Logically linking tables within the data model
  • Using slicers to enhance report interactivity
  • Working with calculated columns and simple DAX functions
  • Creating implicit and explicit measures
• Key Skills Learned:
  • Managing and analyzing large datasets in Excel
  • Integrating multiple data sources into a single model
  • Creating dynamic and interactive reports
  • Performing complex calculations and analyses
  • Automating data updates
  • Improving report performance

Course Format

• Duration: 3.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • 1 article
  • 20 downloadable resources
  • Access on mobile and TV
  • Certificate of completion