|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/analyzing-and-visualizing-data-with-microsoft-excel-data-modeling/
课程评论：没有评论
课程名称：Microsoft Excel: 数据透视表、Power Query、Power Pivot/DAX 课程概述：本课程涵盖为微软70-779认证考试所需的可视化和内容分析技能（注意：该考试已不再提供，但相关主题非常值得学习！）。请注意：本课程与微软并无任何关联、认可或赞助。 课程评价： - Nora：“我喜欢这个课程快速穿越整个过程，如果你自认为是高级Excel用户，这正是我所期待的。非常愉快！” - Dilbag：“Phillip对内容的呈现方式令人赞叹。他对主题有深入的了解。我非常推荐这个课程。” - Amy：“我想补充的是，这是我找到的关于这个主题的最好课程。它深入探讨了每个材料。虽然很多课程只关注如何通过考试，但这个课程确保你能在现实中应用所学。我建议这门课给任何希望通过70-779考试并在工作中运用的人。” - Khalid：“优秀的老师，知识渊博，信息传递速度快，声音友好。我很幸运选择了这个课程；谢谢大家！” 如果您已经使用PC版本的Excel进行数据分析，但发现需要创建更高级的分析，想要组合不同的数据集或处理现有数据集，或者想节省时间，让您的分析自动与新数据更新，那么本课程将教会您微软希望您掌握的技能，并为您的简历添加一项工具，甚至可以申请微软认证。Excel是工作市场上最受欢迎的分析工具之一，具备高级使用能力将对您当前的工作及未来求职非常有用。 课程分为三个部分： 第一部分 - 创建数据透视表和数据透视图 这一部分涵盖了Excel中最有用但看起来最棘手的功能；数据透视表。虽然听起来复杂，但实际上只需几次点击就能完成。我们将在几分钟内创建第一个数据透视表，并同时添加一个图表。在短短几分钟内，您将比不知道数据透视表的人更具优势。 第二部分 - 获取和转换数据（也称为准备数据） 我们将学习如何转换数据，从而节省分析时间，包括排序和筛选、拆分列等操作。我们还将合并、追加和组合查询，进行Pivot和Unpivot操作，以及使用M语言创建自定义列。 第三部分 - 精炼模型（也称为建模数据） 此部分将介绍如何通过多个表建立关系，并使用DAX语言精炼数据，创建自定义列和度量值。 整个课程预计需要16小时完成，学习后能创建可视化、仪表板和故事，并掌握解决常见问题的方法。课程的难度逐渐增加，从创建表格或基本柱状图开始，逐步深入到堆叠柱状图及其属性的探索。课程相对轻松，会有一些“错误转弯”，让您了解可能出现的问题，但每节课都朝着一个最终目标前进，您可以轻松在自己的电脑上跟随学习。 完成课程后，您可以下载结业证书，向大家展示您新掌握的技能，并可以开始自己进行数据分析。 请注意：微软将在2021年1月31日停止70-779考试，尚未给出替代方案。
This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!)Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.ReviewsNora: "I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable"Dilbag: "Phillip's presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course."Amy: "I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job."Khalid: "Great great teacher. knowledgable in the tech and its usages, Speed, info delivery, and his voice is friendly. I'm lucky to choose this course over another one ;). Thank you all"Do you already use the PC version of Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data? In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification.Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt.This course comes in three parts:Part 1 - Creating Pivot Tables and Pivot ChartsThis part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.Part 2 - Get and Transform Data (also known as Prepare the Data)We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language.Part 3 - Refining the model (also known as Model the Data)We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems.The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on.At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves.Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft.
