Wiki source code of Wiki Power BI
Last modified by Dimitri Rupp on 2026/06/11 10:30
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | {{warning}}**Archivierte Portal-Seite** der alten Struktur (vor IT-Wiki-Restrukturierung 2026-06-11). Die Inhalte sind in die neue [[IT-Wiki-Struktur>>doc:IT-Wiki.WebHome]] migriert.{{/warning}} |
| 2 | |||
| 3 | {{box cssClass="floatinginfobox" title="**Auf dieser Seite**"}} | ||
| 4 | {{toc/}} | ||
| 5 | {{/box}} | ||
| 6 | |||
| 7 | (% style="font-size:42px; font-weight:700; letter-spacing:-0.5px; line-height:1.1; margin:0 0 12px 0" %)**Wiki Power BI** | ||
| 8 | |||
| 9 | ((( | ||
| 10 | (% style="font-size:18px; line-height:1.5; margin:0 0 24px 0; max-width:780px; opacity:0.95" %)Die zentrale Wissensdatenbank fuer **Power BI**, **Microsoft Fabric**, **Rimo**, **SSoT** und alle BI-relevanten Themen bei SPL Tele. Hier findest du Architektur, Anleitungen, Datenmodelle, Prozesse, und Best Practices. | ||
| 11 | |||
| 12 | (% style="font-size:14px; opacity:0.85" %)📖 **59 Seiten** · 🏛️ **6 Hauptbereiche** · 📅 Letzter Stand: **2026-05-24** · 🏷️ Staging-Wiki (Lumi-Systems.io) | ||
| 13 | ))) | ||
| 14 | |||
| 15 | == 🧭 Bereiche == | ||
| 16 | |||
| 17 | (% style="margin-bottom:8px" %)Klicke auf einen Bereich, um direkt einzusteigen. | ||
| 18 | |||
| 19 | |=(% style="width:18%" %)Bereich|=Inhalt|=Direkter Einstieg | ||
| 20 | |(% style="background-color:#fff3cd; background:#fff3cd; font-size:16px; padding:12px" %)📊 **Power BI**|Reports, Lernpfade, DAX, Measures, Datenmodell, Drillthrough, Lizenzen, Best Practices|→ [[BI Community Doku>>doc:IT-Wiki.02-Tools.PowerBI.WebHome]] | ||
| 21 | |(% style="background-color:#e3f2fd; background:#e3f2fd; font-size:16px; padding:12px" %)🏛️ **Power BI Architektur**|Workspace-Konzept: Bereichsuebergreifend, Abteilungen, Projektspezifisch — Linemanager, Kelog, PMO, Buchhaltung|→ [[Power BI Architektur>>doc:IT-Wiki.01-Data.Reporting.PowerBI.WebHome]] | ||
| 22 | |(% style="background-color:#f4e4d6; background:#f4e4d6; color:#000000; font-size:16px; padding:12px" %)🚀 **Microsoft Fabric**|Lakehouse, Bronze/Silver/Gold, Notebooks, Dataflows, Pipelines, External Data Sharing, Security, FAQ|→ [[Fabric>>doc:IT-Wiki.02-Tools.Fabric.WebHome]] | ||
| 23 | |(% style="background-color:#c8e6c9; background:#c8e6c9; font-size:16px; padding:12px" %)🎯 **CPM & BE**|Continuous Performance Management & Business Excellence — Jira-Prozess, Betrieb & Wartung|→ [[CPM & BE>>doc:IT-Wiki.04-Abteilung-IT.Prozesse.WebHome]] | ||
| 24 | |(% style="background-color:#bbdefb; background:#bbdefb; font-size:16px; padding:12px" %)🗄️ **Rimo & SSoT**|Single Source of Truth, Rimo-Daten fuer Power-User, Datenquelle fuer das gesamte BI-Universum|→ [[SSoT>>doc:IT-Wiki.01-Data.Governance.SSoT.WebHome]] · [[Rimo Daten fuer Power User>>doc:IT-Wiki.01-Data.Exchange-und-Movement.Intern.Rimo-Daten-fuer-Power-User.WebHome]] | ||
| 25 | |(% style="background-color:#ffe0b2; background:#ffe0b2; font-size:16px; padding:12px" %)🔄 **Power Automate**|Excel-zu-SharePoint-Integrationen (UTS Integration Rejection, RAN Overview)|→ [[Power Automate Flows>>doc:IT-Wiki.01-Data.Exchange-und-Movement.Schnittstellen.WebHome]] | ||
| 26 | |(% style="background-color:#e1bee7; background:#e1bee7; font-size:16px; padding:12px" %)👥 **Externe User**|Onboarding-Prozess fuer externe Power-BI-Nutzer (PDF-basiert)|→ [[Externe User in Power BI>>doc:IT-Wiki.06-Security-und-Compliance.Externe-User-in-Power-BI.WebHome]] | ||
| 27 | |||
| 28 | == 🚀 Quick Start == | ||
| 29 | |||
| 30 | (% style="display:block; margin-top:16px" %)Du bist neu hier? Diese drei Schritte fuehren dich am schnellsten ins SPL-Tele-Power-BI-Universum: | ||
| 31 | |||
| 32 | (% style="margin-top:12px" %) | ||
| 33 | |=(% style="width:60px" %)Schritt|=Was|=Zeit | ||
| 34 | |(% style="background-color:#0078d4; background:#0078d4; color:white; font-size:18px; font-weight:700; text-align:center" %)**1**|🎫 **Lizenz besorgen** — Power-BI-Pro 60 Tage kostenlos testen, dann via Rimo verlaengern → [[Lizenz fuer Power BI>>doc:IT-Wiki.02-Tools.PowerBI.Lizenz-fuer-Power-BI.WebHome]]|3 min | ||
| 35 | |(% style="background-color:#0078d4; background:#0078d4; color:white; font-size:18px; font-weight:700; text-align:center" %)**2**|🗺️ **Architektur verstehen** — wie das Data-Universum bei SPL aufgebaut ist → [[Fabric Datenarchitektur im SPL>>doc:IT-Wiki.01-Data.Microsoft-Fabric-Datenarchitektur-im-SPL.WebHome]]|15 min | ||
| 36 | |(% style="background-color:#0078d4; background:#0078d4; color:white; font-size:18px; font-weight:700; text-align:center" %)**3**|📚 **Lernpfad starten** — strukturierter Einstieg in Power-BI-Konzepte → [[BI Community Doku — Lernpfad>>doc:IT-Wiki.02-Tools.PowerBI.WebHome]]|laufend | ||
| 37 | |||
| 38 | == 🗺️ Navigations-Karte == | ||
| 39 | |||
| 40 | (% style="margin-bottom:8px" %)Die komplette Hierarchie auf einen Blick: | ||
| 41 | |||
| 42 | {{mermaid}} | ||
| 43 | flowchart TB | ||
| 44 | HOME[Wiki Power BI<br/>📖 Portal] | ||
| 45 | HOME --> BI[📊 BI Community Doku<br/>Lernpfade + Konzepte] | ||
| 46 | HOME --> ARC[🏛️ Power BI Architektur<br/>Workspaces] | ||
| 47 | HOME --> FAB[🚀 Fabric<br/>Lakehouse + Tools] | ||
| 48 | HOME --> CPM[🎯 CPM & BE<br/>Prozesse] | ||
| 49 | HOME --> SSOT[🗄️ SSoT + Rimo<br/>Datenquellen] | ||
| 50 | HOME --> PA[🔄 Power Automate<br/>Integrationen] | ||
| 51 | HOME --> EXT[👥 Externe User] | ||
| 52 | |||
| 53 | BI --> DAX[DAX / Measures] | ||
| 54 | BI --> DM[Datenmodell / Kalendertabelle] | ||
| 55 | BI --> PQ[Power Query] | ||
| 56 | |||
| 57 | ARC --> BUE[Bereichsuebergreifend] | ||
| 58 | ARC --> ABT[Arbeitsbereiche-Abt.] | ||
| 59 | ARC --> PRO[Projektspezifisch] | ||
| 60 | |||
| 61 | FAB --> LH[Lakehouse] | ||
| 62 | FAB --> NB[Notebooks] | ||
| 63 | FAB --> DF[Dataflows / Pipelines] | ||
| 64 | FAB --> SEC[Security & Governance] | ||
| 65 | |||
| 66 | LH --> BR[Bronze] | ||
| 67 | LH --> SI[Silver] | ||
| 68 | LH --> GO[Gold] | ||
| 69 | BR --> BR5[5 Source-Lakehouses<br/>BMD / Rimo / Board / H3A / SharePoint] | ||
| 70 | |||
| 71 | classDef home fill:#0078d4,stroke:#005a9e,stroke-width:2px,color:white | ||
| 72 | classDef area fill:#e3f2fd,stroke:#1976d2,stroke-width:1px,color:black | ||
| 73 | classDef sub fill:#f5f5f5,stroke:#999,stroke-width:1px,color:black | ||
| 74 | classDef lh fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:black | ||
| 75 | classDef silver fill:#c0c0c0,stroke:#666,stroke-width:1px,color:black | ||
| 76 | classDef gold fill:#ffd54f,stroke:#b45f06,stroke-width:1px,color:black | ||
| 77 | |||
| 78 | class HOME home | ||
| 79 | class BI,ARC,FAB,CPM,SSOT,PA,EXT area | ||
| 80 | class DAX,DM,PQ,BUE,ABT,PRO,LH,NB,DF,SEC,BR5 sub | ||
| 81 | class BR lh | ||
| 82 | class SI silver | ||
| 83 | class GO gold | ||
| 84 | {{/mermaid}} | ||
| 85 | |||
| 86 | == 📐 Architektur in einem Bild == | ||
| 87 | |||
| 88 | So fliessen die Daten bei SPL Tele durch die Medallion-Architektur: | ||
| 89 | |||
| 90 | {{mermaid}} | ||
| 91 | flowchart LR | ||
| 92 | subgraph SRC[Quellsysteme] | ||
| 93 | S1[(BMD<br/>ERP)] | ||
| 94 | S2[(Rimo<br/>DWH)] | ||
| 95 | S3[(H3A)] | ||
| 96 | S4[(Board)] | ||
| 97 | S5[(SharePoint<br/>Excel)] | ||
| 98 | end | ||
| 99 | |||
| 100 | subgraph BRZ[Bronze] | ||
| 101 | B[5 Bronze-Lakehouses<br/>raw landing] | ||
| 102 | end | ||
| 103 | |||
| 104 | subgraph SIL[Silver] | ||
| 105 | S[spl_silver_lh<br/>121 Tabellen<br/>6 Schemas] | ||
| 106 | end | ||
| 107 | |||
| 108 | subgraph GLD[Gold] | ||
| 109 | G[spl_gold_lh<br/>business-ready<br/>RBAC] | ||
| 110 | end | ||
| 111 | |||
| 112 | subgraph CON[Konsum] | ||
| 113 | PBI[Power BI<br/>Reports + Semantic Models] | ||
| 114 | EXT2[Externe Apps<br/>Odoo / AI] | ||
| 115 | end | ||
| 116 | |||
| 117 | SRC --> BRZ --> SIL --> GLD --> CON | ||
| 118 | |||
| 119 | classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px,color:black | ||
| 120 | classDef brz fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:black | ||
| 121 | classDef sil fill:#c0c0c0,stroke:#666,stroke-width:1px,color:black | ||
| 122 | classDef gld fill:#ffd54f,stroke:#b45f06,stroke-width:1px,color:black | ||
| 123 | classDef con fill:#c8e6c9,stroke:#2e7d32,stroke-width:1px,color:black | ||
| 124 | |||
| 125 | class S1,S2,S3,S4,S5 src | ||
| 126 | class B brz | ||
| 127 | class S sil | ||
| 128 | class G gld | ||
| 129 | class PBI,EXT2 con | ||
| 130 | {{/mermaid}} | ||
| 131 | |||
| 132 | == 🏷️ Im Fokus == | ||
| 133 | |||
| 134 | (% style="margin-top:12px" %)Direktzugang zu den **meistgenutzten Seiten**: | ||
| 135 | |||
| 136 | * 🔑 [[SSoT — Single Source of Truth>>doc:IT-Wiki.01-Data.Governance.SSoT.WebHome]] — Grundsatz-Dokument der Datenverwaltung | ||
| 137 | * 🗺️ [[Microsoft Fabric Datenarchitektur im SPL>>doc:IT-Wiki.01-Data.Microsoft-Fabric-Datenarchitektur-im-SPL.WebHome]] — die Big-Picture-Architektur | ||
| 138 | * 📐 [[DAX>>doc:IT-Wiki.02-Tools.PowerBI.DAX.WebHome]] / [[Measures>>doc:IT-Wiki.02-Tools.PowerBI.Measures.WebHome]] — die Power-BI-Sprache | ||
| 139 | * 🗄️ [[Fabric Lakehouse Hub>>doc:IT-Wiki.01-Data.Processing.Lakehouse.WebHome]] — Bronze / Silver / Gold im Detail | ||
| 140 | * 👥 [[Externe User in Power BI>>doc:IT-Wiki.06-Security-und-Compliance.Externe-User-in-Power-BI.WebHome]] — Einladungs- und Onboarding-Prozess | ||
| 141 | * 📚 [[Nuetzliche Ressourcen>>doc:IT-Wiki.02-Tools.PowerBI.Nuetzliche-Ressourcen.WebHome]] — Buecher, Kurse, externe Lernpfade | ||
| 142 | * ❓ [[FAQ>>doc:IT-Wiki.02-Tools.Fabric.FAQ.WebHome]] — haeufige Fragen rund um Fabric | ||
| 143 | |||
| 144 | == 🎓 Lernpfade == | ||
| 145 | |||
| 146 | |=Rolle|=Empfohlene Schritte | ||
| 147 | |🆕 **Neuer Power-BI-User**|Lizenz → Datenmodell → Bedingte Spalten → erste Visualisierung | ||
| 148 | |⚙️ **Report-Entwickler**|DAX → Measures → Drillthrough → Datenmodell-Best-Practices → Linemanager-Pattern als Vorlage | ||
| 149 | |🛠️ **Data Engineer**|Fabric-Architektur → Lakehouse → Notebooks → Dataflows → Data Pipelines → Git Integration | ||
| 150 | |🔐 **Admin / Governance Lead**|Fabric Security for Admins → External Data Sharing → SPL Security Score → Workspace-Rollen | ||
| 151 | |📊 **Datenanalyst**|Power Query → Pivoting → Calculated Columns vs. Measures → DAX → Reports | ||
| 152 | |||
| 153 | == ℹ️ Ueber dieses Wiki == | ||
| 154 | |||
| 155 | |=Aspekt|=Wert | ||
| 156 | |🏷️ **Name**|Wiki Power BI — Knowledge Base | ||
| 157 | |📍 **Status**|**Staging** — Lumi-Systems.io XWiki | ||
| 158 | |||
| 159 | ---- | ||
| 160 | |||
| 161 | (% style="text-align:center; padding:16px; color:#666; font-size:13px" %) | ||
| 162 | //Wenn du Inhalte vermisst oder Fehler findest: Pull-Request oder direkt an Dimitri.// | ||
| 163 | //„Das Leben lernt vom Leben." — Lumi-Systems.io · Wien// | ||
| 164 | |||
| 165 | ---- | ||
| 166 | |||
| 167 | == Verwandte Themen == | ||
| 168 | |||
| 169 | //Kuratiert — kann direkt im Editor ergänzt werden:// | ||
| 170 | |||
| 171 | * [[Wiki BE>>doc:IT-Wiki.99-Archiv.Portal-WikiBE.WebHome]] | ||
| 172 | * [[PowerBI>>doc:IT-Wiki.99-Archiv.WikiBE-PowerBI-Platzhalter.WebHome]] | ||
| 173 | * [[Wiki Jira>>doc:IT-Wiki.99-Archiv.Portal-WikiJira.WebHome]] | ||
| 174 | |||
| 175 | {{include reference="IT-Wiki.Makros.Verwandte-Themen.WebHome"/}} | ||
| 176 | |||
| 177 | ---- | ||
| 178 | **Status:** Veraltet (Archiv) · **Owner:** //(festlegen)// · **Letzter Review:** 2026-06-11 | ||
| 179 |