|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analytics-with-excel-and-power-bi/
课程评论：没有评论
课程名称：Excel与Power BI的数据分析 课程概述：本课程是针对商业和数据分析的入门级课程，旨在培养几项关键能力，包括数据认知、Excel中的统计应用、商业智能软件以及机器学习的基础知识。课程的第一部分聚焦于数据趋势认知，涵盖不同领域、分析类型和工具，以及一些专业术语的理解。学习结束时，你将对数据类型、数据科学家的角色有较全面的了解。 接下来，我们将探讨Excel中的统计应用。完成这一部分后，你将能够进行描述性统计结果的解释，计算概率，选择样本和变量，并理解假设检验在解决商业问题中的重要性。 课程的第三部分将介绍Power BI，这是一个用于商业智能的自助工具。你将学习如何对数据进行简单转化，使用DAX建模，以及如何进行数据可视化。 在讲解数据与商业分析时，机器学习也是不可忽视的主题。课程结束时，你将对机器学习的工作原理及其应用领域有较深入的认识。 完成本课程后，你应该能够自信地在组织中实施商业智能解决方案，利用Excel或Power BI工具改善当前的报告系统，为业务决策提供更深入的信息。虽然本课程仅有约5小时的视频内容，但预计你需要花费约20小时来完成课程并深入理解内容。这其中包括多项活动，可能需要反复观看教程，以确保获得所需的知识。
This course is an introduction level course to business and data analytics. The aim is to address several competencies, Data awareness, statistical applications in excel, business intelligence software and machine learning awareness.The first competency is data trend awareness. What are the different fields? What are the different analysis types and tool? and what are the general buzz terms? By the end of this section you should have an advanced level of awareness on the types of data, the role of a data scientist and the types of. After this we ill look at Statistical application in Excel. By the end of this you should have the ability to carry out an interpenetrate the results from Descriptive Statistics, calculate probability and select samples and variables, Understand the power of hypothesis testing to solve business problems all within ExcelWe will then move into power bi, and self-service tool for business intelligence. You will learn how do to simple transformations on data, how to model data using DAX and how to visualize dataWhen discussing data and business analytics you can not overlook machine learning. By the end of this course you will have an advanced level of awareness on how this works and where it can be applied.By the end of this course you should feel comfortable Implementing business intelligence solutions to your organisation using tools such as Excel or Power BI that improve the current reporting system and add greater depth to the information to aid in the business decision making process.Although this course only has 5 hours or so of video material, the reality is you should expect to take about 20 hours to really complete the course and gain full understanding. There are many activities to complete and it might be necessary to revisit tutorials to ensure you gained the knowledge that you want.
