|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-data-visualization-for-business-analysts/
课程评论：没有评论
Coursera 课程《Excel 数据可视化 for Business Analysts》摘要 本课程专为需要大量处理数据并经常使用 Microsoft Excel 的业务分析师设计，旨在帮助学员掌握使用 Excel 进行高级数据可视化的技巧。 课程内容涵盖： * **数据可视化原理**：深入理解各种图表类型背后的研究，了解哪些图表最能有效地传达信息，并学习如何为你的图表选择最佳的可视化方法，甚至可以为图表效果提供学术上的依据（例如，解释为何不推荐使用饼图）。 * **高级图表创建**：学习创建 Excel 原生图表库中不包含的高级图表，例如子弹图（Bullet Charts）、多级分组图表和带有渐变色带的图表。 * **数据分析与叙事**：区分用于数据探索（data graphics）和用于信息传达（infographics）的图表，学习如何根据不同目的创建图表。 * **图表布局与呈现**：掌握如何排版图表和信息图，以便清晰地向高层管理者呈现。课程将介绍 Excel 的“照相机工具”（Camera Tool），该工具能像 Power BI 一样方便地拖放图表。 * **实践练习**：课程包含实验和测验，帮助学员巩固知识并立即将所学应用于实际工作中。 * **排除 VBA/宏**：课程将重点展示如何无需编写大量 VBA 或宏代码，就能快速创建高级图表。 课程还将讲解数据可视化的重要性，3D 图表存在的问题，以及如何创建进度指示图（Progress Meter Charts）和华夫饼图（Waffle Charts）。 学员将学习数据可视化的关键原则，如闭合性、邻近性、共同分组和预注意属性。 本课程适合想要在众多同事中脱颖而出，并希望将 Excel 和数据技能提升到全新水平的业务分析师。
Master Data Visualization Using Microsoft ExcelWhether you've just started working in Excel or you've been using it forever, chances are you've heard about data visualization and understand how important is. More than that, you've probably made a few charts you were proud of. I was there, too. I could make any basic Excel chart my boss asked for. But I knew my charts - and many of those that I saw presented - did a poor job communicating data. Looking back, I think I was being asked to make charts just so we would have more to present. Sound familiar? I've been where you are. So I wanted to create a data visualization course for the business analysts who work with a lot of data and use Microsoft Excel regularly within their workflows. Chances are - you can already create a bar chart, a pie chart, and more. If that's you, read on. Because I think a course for people like us has been missing. So I decided to distill everything I knew into a course that shows:The important research behind which charts show the best information. That way you're always communicating the best results. And when your boss challenges you, you can point to the research. (Just point him or her to the module on why Pie Charts are the worst!)How to create advanced charts not included in Excel. Most business problems can't be captured in Excel's native chart library. Do you know how to create Bullet Charts? Charts with multiple banding? This course will show you how. How to create charts for analysis and how to create charts to tell a story.In this course, we'll talk about the difference between data graphics and info graphics. The former is for investigation, the latter for narration. You won't find this content elsewhere - I know, because I came up with it organically while working as a management consultant. How to layout your charts and info graphics when you deliver them to executives. I'll introduce you to the camera tool, one of Excel's most powerful features. You'll see how it will allow you to drag-and-drop a chart, much like in Power BI. Labs and QuizzesIt's not enough to learn this information. You need to apply. I have created labs and quizzes based on the content. Take the quizzes to reinforce your knowledge. Complete the labs and then use them immediately in your own work.No VBA or MacrosI love VBA and Macros too but they're way over deployed. In many cases, the advanced chart you're thinking of making doesn't need lines and lines of code. I'll show you how quickly. Here's what you can look forward to in this course: Data visualization principles including closure, proximity, common group and preattentive attributesTheory and practice for why data visualization is so importantWhy 3d charts cause issues when communicating dataProblems pie charts present to the audienceHow to create charts with graded banding in ExcelHow to create Bullet Charts in Excel How to create Progress Meter Charts in ExcelHow to create Waffle Charts in ExcelMicrosoft Excel's camera toolResources to help you continue your learningLike you, I work in the trenches, hustling to solve every new data challenge that comes my way. I wanted to create a course for people like me to learn from. If you want to stand out in the crowd and take your Excel and data skills to a whole new level, then you're the person I created this course for. See you there,Jordan
