|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-business-intelligence/
课程评论：没有评论
课程名称：Excel 365中的商业智能与数据可视化 概述：本课程旨在教导学员如何使用Excel进行商业智能、数据可视化和数据分析，尤其适合未来的商业智能分析师和商业分析师，以及希望学习如何在Excel中进行商业智能分析和数据分析的人。课程内容涵盖了Excel提供的所有关键商业智能、数据可视化和数据分析工具，通过实际操作和样本数据的演示，使学员能够深入理解和应用这些工具。学员将掌握高级的Excel商业智能工具，学习如何分析数据趋势，并具备使用Excel进行数据研究、理解和解读数据的能力。此外，课程还将教会学员高级数据可视化和数据分析工具。 课程将涵盖以下主题： 1. Power Query 2. 数据透视表和数据透视图 3. Power Pivot 4. Excel仪表板 5. 预测分析 6. 情境分析 7. 求解器 8. 描述性统计 9. 相关性分析 10. 回归分析 在课程结束时，学员将参与一个项目，该项目将涉及对一位苹果翻新产品销售商的数据信息进行分析，具体步骤如下： 1. 使用Power Query导入数据并进行数据转换，并为数据分配格式。 2. 生成数据透视图。 3. 使用数据透视图创建Excel仪表板。 4. 提交仪表板。 通过本课程，学员将能够有效地运用Excel工具进行商业智能分析和数据可视化，提升其数据分析能力。
The course - Business Intelligence and Data Visualisation in Excel 365- is designed to teach excel applications for business intelligence, data visualisation and data analysis to prospective business intelligence analysts, business analysts and those who want to learn how to conduct business intelligence analysis and data analysis in Excel. The course covers all the key business intelligence, data visualisation and data analysis tools that Excel has to offer. And these tools are taught using practical, hands on demonstrations using sample data in Excel. Students will not only learn advanced Excel business intelligence tools but also learn how to analyse and study trends in data. The course will equip students with skills in business intelligence and will teach students how to study, understand and interpret data using Excel. The course will also equip students with advanced data visualisation and data analysis tools. The following topics are covered in the course:1. Power Query2. Pivot tables and charts.3. Power pivot4. Excel Dashboards5. Forecasting6. What-if-analysis7. Solver8. Descriptive Statistics9. Correlation Analysis10. Regression AnalysisThe course has a project at the end of the course. In this project students will deal with data on an apple refurbished product seller, provided by the instructor, and will do the following analysis:1. Import data with Power Query and transfer the data. This step will involve assigning formatting data.2. Students will generate pivot charts.3. Students will create an Excel Dashboard using pivot charts.4. Students will submit the dashboards.
