課程簡介
回顧與數據模型設計原則
- 理解Power BI中的數據建模層
- 星型與雪花型模式概念
- 創建與管理表之間的關係
DAX(數據分析表達式)簡介
- DAX語法與數據類型
- 計算列與度量值的對比
- 常用DAX函數:SUMX、CALCULATE、FILTER、RELATED
高級DAX與業務邏輯
- 時間智能函數(YTD、MTD、QTD)
- 條件邏輯與動態計算
- 排名、累計值與比較指標
數據轉換與優化
- 使用Power Query進行高級轉換
- 高效合併多個數據源
- 通過查詢摺疊與關係提升性能
增強的可視化與交互性
- 自定義視覺對象與市場擴展
- 鑽取、書籤與假設參數
- 創建分頁與動態報表
Power BI中的性能與治理
- 數據集管理的最佳實踐
- 優化刷新計劃與查詢性能
- 實施行級安全性(RLS)
實踐項目:構建銷售智能儀表板
- 使用DAX度量值開發KPI
- 設計基於模型的儀表板以獲取業務洞察
- 應用治理與共享最佳實踐
總結與下一步
最低要求
- 瞭解Power BI界面和報表創建
- 使用Power BI構建儀表板的經驗
- 對數據關係和篩選器的基本熟悉
受衆
- 商業智能專業人士
- 數據分析師和報表專家
- 從事數據可視化和分析工作的開發人員
客戶評論 (5)
內容很艱難,但我必須付出的額外努力説明我更好地記住和理解 Power BI。
Melvin - TLI Group
課程 - Power BI DAX Fundamentals
機器翻譯
討論我們的問題
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
課程 - Power BI for Developers
機器翻譯
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
課程 - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
Anne-Cecile Jacquot - Ameropa
課程 - Excel to Power BI
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.