課程簡介
介绍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
Course - Power BI DAX Fundamentals
機器翻譯
討論我們的問題
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - 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
Course - 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
Course - 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.