课程大纲
介绍Power BI
- Power BI及其组件概述
- 了解Power BI生态系统
- Power BI桌面的安装和设置
连接数据源
- 从Excel、数据库和云源导入数据
- 使用Power Query进行数据转换
- 整理和修整财务数据
数据建模和DAX
- 建立表之间的关系
- DAX公式简介
- 构建计算列和度量值
创建报告和仪表板
- 用可视化设计财务报告
- 有效使用表格、图表和KPI
- 通过切片器和过滤器增加互动性
发布和共享报告
- 向Power BI服务发布报告
- 安全共享仪表板
- 调度数据刷新和设置警报
Power BI认证准备 (PL-300)
- 考试概述和目标
- 练习题和考试技巧
- 推荐学习资源
财务分析最佳实践
- 优化Power BI中的表现
- 设计用户友好的仪表板
- 常见陷阱及如何避免它们
总结和结论
要求
- 对财务数据和报告有基本了解
- 熟悉Excel或类似的电子表格工具
观众
- 金融分析师
- Business情报专业人员
- 寻求利用Power BI进行数据驱动决策的Finance团队
客户评论 (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.