课程大纲
回顾与数据模型设计原则
- 理解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.