Wiki source code of Power BI
Last modified by Dimitri Rupp on 2026/06/11 09:30
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{box cssClass="floatinginfobox" title="**On this page**"}} | ||
| 2 | {{toc/}} | ||
| 3 | {{/box}} | ||
| 4 | |||
| 5 | = BI Community Doku = | ||
| 6 | |||
| 7 | {{info}} | ||
| 8 | **Bereich:** Power-BI-Lernpfade, Konzepte und Best Practices fuer Power BI bei SPL Tele. | ||
| 9 | **Zielgruppe:** Power-BI-Power-User, BI-Entwickler, Datenanalysten. | ||
| 10 | {{/info}} | ||
| 11 | |||
| 12 | == Lernpfad == | ||
| 13 | |||
| 14 | Empfohlene Reihenfolge fuer Einsteiger ins SPL-Tele-Power-BI-Universum: | ||
| 15 | |||
| 16 | {{mermaid}} | ||
| 17 | flowchart LR | ||
| 18 | L1[1. Lizenz<br/>fuer Power BI] --> L2[2. Datenmodell<br/>Grundlagen] | ||
| 19 | L2 --> L3[3. Power Query<br/>Bedingte / Calculated Cols] | ||
| 20 | L3 --> L4[4. DAX<br/>Measures] | ||
| 21 | L4 --> L5[5. Visualisierung<br/>Drillthrough] | ||
| 22 | L5 --> L6[6. Spezial-Themen<br/>Kalendertabelle / Pivoting] | ||
| 23 | L6 --> L7[7. Externe Ressourcen] | ||
| 24 | |||
| 25 | classDef base fill:#e3f2fd,stroke:#1976d2,stroke-width:1px | ||
| 26 | classDef tech fill:#fff3cd,stroke:#b85c00,stroke-width:1px | ||
| 27 | classDef vis fill:#c8e6c9,stroke:#2e7d32,stroke-width:1px | ||
| 28 | classDef ext fill:#ffe0b2,stroke:#b45f06,stroke-width:1px | ||
| 29 | class L1,L2 base | ||
| 30 | class L3,L4,L6 tech | ||
| 31 | class L5 vis | ||
| 32 | class L7 ext | ||
| 33 | {{/mermaid}} | ||
| 34 | |||
| 35 | == Inhaltsverzeichnis == | ||
| 36 | |||
| 37 | === 🎫 Lizenzierung & Zugang === | ||
| 38 | |||
| 39 | * [[Lizenz fuer Power BI>>doc:IT-Wiki.02-Tools.PowerBI.Lizenz-fuer-Power-BI.WebHome]] — Pro-Test, Verlaengerung via Rimo, Free/Pro/PPU/Premium-Vergleich | ||
| 40 | |||
| 41 | === 🗄️ Datenmodell-Grundlagen === | ||
| 42 | |||
| 43 | * [[Datenmodell>>doc:IT-Wiki.02-Tools.PowerBI.Datenmodell.WebHome]] — Beziehungen, Star/Snowflake, Best Practices | ||
| 44 | * [[Kalendertabelle>>doc:IT-Wiki.02-Tools.PowerBI.Kalendertabelle.WebHome]] — Time-Intelligence-Voraussetzung | ||
| 45 | |||
| 46 | === 🔄 Power Query / Transformation === | ||
| 47 | |||
| 48 | * [[Bedingte Spalten (Conditional Columns)>>doc:IT-Wiki.02-Tools.PowerBI.Bedingte-Spalten-(Conditional-Columns).WebHome]] — IF/THEN-Regeln im Power Query Editor | ||
| 49 | * [[Berechnete Spalten (Calculated Columns)>>doc:IT-Wiki.02-Tools.PowerBI.Berechnete-Spalten-(Calculated-Columns).WebHome]] — DAX-basierte Row-Context-Spalten | ||
| 50 | * [[Pivoting & Unpivoting>>doc:IT-Wiki.02-Tools.PowerBI.Pivoting-und-Unpivoting.WebHome]] — Tabellen-Transformation | ||
| 51 | * [[Aktualisierung von Queries>>doc:IT-Wiki.02-Tools.PowerBI.Aktualisierung-von-Queries.WebHome]] — Refresh-Mechanismen | ||
| 52 | |||
| 53 | === 📐 DAX & Measures === | ||
| 54 | |||
| 55 | * [[DAX>>doc:IT-Wiki.02-Tools.PowerBI.DAX.WebHome]] — Sprache, Operatoren, Best Practices | ||
| 56 | * [[Measures>>doc:IT-Wiki.02-Tools.PowerBI.Measures.WebHome]] — Filter-Context-Berechnungen | ||
| 57 | |||
| 58 | === 📊 Visualisierung & Interaktion === | ||
| 59 | |||
| 60 | * [[Drillthrough>>doc:IT-Wiki.02-Tools.PowerBI.Drillthrough.WebHome]] — Detail-Page-Navigation mit Filter | ||
| 61 | |||
| 62 | === 📚 Externe Ressourcen === | ||
| 63 | |||
| 64 | * [[Nuetzliche Ressourcen>>doc:IT-Wiki.02-Tools.PowerBI.Nuetzliche-Ressourcen.WebHome]] — Lernpfade, Buecher, Onlinekurse, Sample-Datasets | ||
| 65 | |||
| 66 | == Schluessel-Konzept: Row Context vs. Filter Context == | ||
| 67 | |||
| 68 | Das wichtigste Konzept zum Verstehen von DAX: | ||
| 69 | |||
| 70 | |=Konzept|=Wo aktiv|=Was es tut | ||
| 71 | |**Row Context**|**Calculated Column**, **CALCULATE FILTER**, **Iterator-Funktionen** (SUMX, FILTER)|Verarbeitet **Zeile fuer Zeile** — kennt nur die **aktuelle Zeile** | ||
| 72 | |**Filter Context**|**Measure**, **Slicer / Filter**, **Visual-Kreuztabellen**|Verarbeitet **aggregierte Mengen** unter den **aktiven Filtern** | ||
| 73 | |||
| 74 | Beide zusammen ergeben das Power-BI-Modell. Wer den Unterschied versteht, schreibt richtige Measures und vermeidet Calculated-Column-Anti-Patterns. | ||
| 75 | |||
| 76 | == Zielgruppen-Wegweiser == | ||
| 77 | |||
| 78 | |=Rolle|=Empfohlener Einstieg | ||
| 79 | |**Neuer Power-BI-User**|Lizenz → Datenmodell → Bedingte Spalten | ||
| 80 | |**Report-Entwickler**|DAX → Measures → Drillthrough → Datenmodell-Best-Practices | ||
| 81 | |**Datenanalyst**|Power Query → Pivoting → Calculated Columns vs. Measures → DAX | ||
| 82 | |**Architekt**|Datenmodell → Nuetzliche Ressourcen → Power-BI-Architektur (Workspaces) | ||
| 83 | |||
| 84 | == Related pages == | ||
| 85 | |||
| 86 | * [[Power BI Architektur>>doc:IT-Wiki.01-Data.Reporting.PowerBI.WebHome]] | ||
| 87 | * [[Fabric>>doc:IT-Wiki.02-Tools.Fabric.WebHome]] — die naechste Generation der Datenplattform | ||
| 88 | * [[Externe User in Power BI>>doc:IT-Wiki.06-Security-und-Compliance.Externe-User-in-Power-BI.WebHome]] | ||
| 89 | |||
| 90 | ---- | ||
| 91 | |||
| 92 | |||
| 93 | = In diesem Bereich = | ||
| 94 | |||
| 95 | {{children/}} | ||
| 96 | |||
| 97 | |||
| 98 | ---- | ||
| 99 | |||
| 100 | == Verwandte Themen == | ||
| 101 | |||
| 102 | {{include reference="IT-Wiki.Makros.Verwandte-Themen.WebHome"/}} | ||
| 103 | |||
| 104 | ---- | ||
| 105 | **Status:** Migriert — Team-Review ausstehend · **Owner:** //(festlegen)// · **Letzter Review:** 2026-06-11 |