登录
91031
Business Analytics with Excel 1年访问权限（不含考试）
iLEARN Innovative Learning 提供的 Business Analytics with Excel 1 年访问权限（不含考试）英语在线课程
本课程提供使用 Excel 进行商业分析的实践培训，提供数据分析方面的实践经验。它非常适合希望做出数据驱动型决策的专业人士。
Excel 商业分析课程将通过让您掌握强大的 Excel 技能来促进您的分析事业。您将学习数据分析和统计的基础知识，探索关键的统计概念以获得有价值的见解，并通过执行级仪表板展示您的发现。
Excel 商业分析课程由 ILX 集团提供。
访问期限
- 1 年平台访问权限
Business Analytics with Excel 在线课程详情
- 12 个月的在线课程访问权限
- 本课程预计需要约7 小时完成
- 评估项目
- 课程结业证书
Objectives
- 了解商业分析的含义及其行业重要性
- 掌握 Excel 分析函数和条件格式的基本原理
- 掌握分析复杂数据集的透视表和切片
- 使用情景管理器、求解器和目标搜索解决问题
- 使用 Excel 将统计工具和概念应用于数据集
- 使用图表和仪表盘展示你的发现
- 学习如何使用 Power BI 进行分析和数据可视化
Who it is aimed at
本课程对 IT 开发人员和测试人员、数据分析师、初级数据科学家、分析专业人员、BI 和报告专业人员、项目管理人员、学生以及在任何行业从事数据工作的专业人员都大有裨益。
Contents
商业分析入门--了解商业分析在当今专业领域的重要意义，以及为什么数据分析在各行各业的战略决策中发挥着主导作用。
数据分析基础--条件格式化和重要函数 使用透视表和切片分析数据
仪表板 - 学习展示数据结果的各种方法，并掌握 Power BI 的技能，这是微软目前提供的用于数据分析和可视化的最佳工具。
使用 Excel 进行商业分析- 学习如何利用 Excel 中的一些高级功能来最大限度地利用数据。
使用统计进行数据分析- 熟练掌握移动平均线、假设检验、方差分析和回归等统计工具和概念。
项目 - 课程包括两个实践项目，旨在提高实际环境中的数据分析技能。第一个项目的重点是为一家电子商务公司创建一个销售仪表板，使用户能够控制按产品类别和发货时间表对趋势进行分析。第二个项目是为一家制药公司设计一个仪表板，允许用户交互查看按品牌和地区划分的销售和佣金数据。
Prerequisites
本课程没有先决条件。不过，希望学员具备使用 Microsoft Excel 的基本知识。
Teacher language
Certificate type
No, all prices on the website are excluding VAT. However, remember that VAT is always not applicable in the following cases:
billing to a non EU company or citizen billing to a non Italian EU company with a valid VIES VAT idYou can check the VAT id on VIES portal at this link: https://ec.europa.eu/taxation_customs/vies/
The website implements this rules automatically. However, you or your organization could be exempted by VAT application for other legal reason. In such a case contact us (info@innovativelearning.eu) so that we can analyze and confirm your case. If so, please don't submit subscriptions using the website: your request will be handled through manual order handling processing.
With the purchase of e-learning packages with 30 days and 1 year of duration, exam doesn’t have to be necessarily taken within the closing date of the account on the e-learning platform. The validity of the exam voucher code is 12 months starting from the issue date.
During the purchase process it is possible to register data and details of each participant.
The activation date of the package can be selected during the purchase process on our website. The days of access to the course, indicated in the title of the product, will be calculated starting from the selected date. Payment must be completed before the activation date.
30 days, 120d or 1 year are to be considered as the period, so the days, during which it is possible to access the purchased training courses on our e-learning platform. These periods start on the activation date selected during the purchase process on our webiste. The activation date can be chosen and selected within 30 days from the purchase date. If you need more flexibility, do not hesitate to contact us.
The main difference between these packages, beyond the duration of access, is that the 30 days and 1 year packages include the exam, while the 120 days package does not include the exam.
Exam voucher code is usually issued at the activation of the e-learning course, anyway it can also be issued at the end of the e-learning course of sent after 24/48 hours from the order date. In case of purchase for exam only, exam voucher code is issued at purchase confirmation, always after the receipt of payment.