Professional Development · IT & Digital · Module 8: Power Pivot and DAX

Introduction to Power Pivot and the Data Model

4 Abschnitte1 Karteikarten-Decks1 Quizze

Understand the Power Pivot add-in, the xVelocity in-memory engine, loading data to the Data Model, defining relationships between tables, the star schema, and building PivotTables that span multiple related tables without VLOOKUP.

Inhaltsübersicht

  • What Is Power Pivot and Why Does It Exist?
  • Enabling Power Pivot and Loading Data to the Data Model
  • Relationships, the Star Schema, and the Diagram View
  • Building PivotTables from the Data Model
construction site, windmill, energy, wind power, technology, construction crane, crane, heavy equipment, pivot point, crane boom, cab, counterweights, hydraulics, mobile, wind energy, power supply, construction
Pixabay – Pixabay License

📚 Vollständiges Lernmaterial mit 4 Abschnitten, Karteikarten und Quizzen verfügbar nach Anmeldung.

Jetzt kostenlos lernen →

Related Topics

Interaktiv lernen mit Karteikarten & Quizzen

Melde dich an und lerne Excel for Professionals — Beginner to Power User mit intelligenten Wiederholungen, Quizzen und KI-Lernhilfen. 7 Tage kostenlos.

Kostenlos testen
Learn Introduction to Power Pivot and the Data Model — Excel for Professionals — Beginner to Power User IT & Digital | Summary, Flashcards & Quiz