Language 语言:Chinese 中文
14天行程码及健康码均为绿码方可参与线下培训
The European Chamber Tianjin Chapter is pleased to invite you to join Supply Chain Training - PowerBI Desktop: from Basic to Data Modeling on 16th June 2022. After many years of business transformation, Microsoft has been in the cloud for many years. It has been an excellent data integration with PowerBI. After years of iteration, it has been an international leader in data modeling and visualization. It has been in the cloud for many years, and has provided excellent data integration solutions for PowerBI since July 24, 2015. Data is the strategic asset of an enterprise. The use of PowerBI tools can help enterprises better explore enterprise data, insight into business laws, better find problems, early warning problems and solve problems.微软自 2015 年 7 月 24 日正式发布 PowerBI,历经多年迭代,已经成熟,日臻优异,并连续 多年位于国际商业智能分析平台领导者象限,PowerBI 集数据准备,数据建模,数据可视化及云端与移动端为一体,为现代企业数字化转型提供了很好的解决方案。 数据是企业的战略资产。通过 PowerBI工具的使用,可以助力企业更好发掘企业的数据,洞察业务规律,更好发现问题,预警问题和解决问题。
Learning PowerBI can greatly improve work efficiency, personal career development and create greater value for the company学习PowerBI可以大幅度提高工作效率,提升个人职业发展,同时为公司创造更大价值。
Powerbi course starts from the introduction and teaches you DAX formula and data modeling!PowerBI课程从入门开始,教会您DAX 公式以及数据建模!
Course Suitable for 课程对象
- working in operation management and supply chain management从事运营管理和供应链管理
- Data analysis数据分析
- Small size of class, ensure more discussion and case research小班授课,更多讨论和案例研究
课程内容
1. 入门基础知识
-
工具安装界面介绍
-
元素简单介绍
-
菜单功能介绍
-
获取数据体验 - Excel 文件
-
可视化初步体验
-
Power Query 编辑器初步体验及介绍:
-
替换值,例如:性别,数字与文本做替换
-
替换值,替换大数据表的单元值
-
添加列,例如:相除
-
添加自定义列,例如:利润率
-
拆分列,转置,索引,透视,删除最后行,向下填充,合并列,逆透视
-
数据可视化 - 可视化对象详解:漏斗图,卡片图,切片器
-
筛选器视觉级筛选器,页面级筛选器,报告级筛选器, TOP N 筛选器
- 建立关系:1:1,1:N,N:M
2. DAX 公式
3. 数据建模
时间安排:
08:50 - 09:00 签到
09:00 - 12:00 上午培训
12:00 - 13:00 午餐
13:00 - 16:30 下午培训
16:30 - 17:00 问答及自由交流
Payment付款方式:报名后请将培训费汇款至以下账户,并在银行转账单上附注TJ20220616 或 联系商会工作人员付费
A/C Name: 中国欧盟商会
A/C No.: 7110210182500027543
China CITIC Bank 中信银行京城大厦支行
北京市朝阳区新源南路6号京城大厦
Cancellation Policy 取消政策:
If you cannot attend an event for which you have registered, please cancel your registration or notify us no later than 72-hour prior to the event. 如您因故无法参加活动,请提前至少72小时在线取消或联系工作人员。
Disclaimer 免责声明:
Participants must maintain proper social distancing norms and abide by the Tianjin Municipal Government’s Epidemic Prevention and Control Rules (eg. wearing masks and so on). If you do not follow the relevant regulations, the European Union Chamber of Commerce in China accepts no responsibility for any of your physical discomfort caused during and after the event. Thank you for your cooperation. 参与活动时,参会人应与他人保持适当距离(防疫考虑)并遵守天津市政府颁布的疫情预防控制要求(例如佩戴口罩等)。如您违反要求,中国欧盟商会对于您在活动中或者活动后的身体不适,不承担任何责任。 感谢您的理解和配合。