|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/professional-dashboards-in-excel-and-tableau/
课程评论:没有评论
课程名称:Excel 和 Tableau 中的专业仪表盘 课程概述:本课程将教授您如何使用 Excel 和 Tableau 创建引人注目的报告!无论您更喜欢使用 Excel 还是 Tableau,本课程都能让您从零开始制作精美的报告。动态且富有意义的可视化报告已成为大多数商业互动的重点。通过仪表盘,您可以从公司数据中获取重要见解,并向投资者或客户展示信息。因此,建立一个引人注目的仪表盘是一项高度受欢迎的技能,它可能会影响您在公司战略团队中的职位。如果您希望提升数据可视化能力并改善职业前景,那么这个课程将是您的不二选择! 在《Excel 和 Tableau 中的专业仪表盘》课程中,您不仅将学习如何创建报告,还将学习如何将其美化至完美,并轻松解读。课程还提供优雅的配色模板,使您可以在未来的报告中应用,从而获得专业和统一的外观。此外,我们将指导您如何利用最佳的在线平台创建您自己的个性化模板。 本课程的内容包括: - 数据可视化的主要原则介绍:讨论色彩理论、如何根据数据选择合适的可视化方式,并展示一些可以帮助您进行数据可视化的在线平台。 - 在 Excel 中创建仪表盘的整个过程:从基础开始,展示可成功应用于每个 Excel 报告的技术。我们将使用来自快速消费品行业的真实数据创建报告。 - 在 Tableau 中创建仪表盘:同样,我们使用快速消费品行业的现实数据。在制作组件的过程中,将熟悉多种构建图表和其他元素的技术。 课程内容还包括如何在 Excel 和 Tableau 中添加自定义时间过滤器。虽然在 Excel 中创建时间过滤器是一项技术性任务,但通过周密的构思和精心规划的执行,一切皆有可能。这种类型的过滤器可以应用于任何包含时间序列数据的报告,您可以将此知识转移到未来负责的所有报告中。在 Tableau 中,我们将探讨多种自定义和样式设计过滤器的软件选项。设计和样式化过滤器有很多可能性,轻松直观地将其整合到仪表盘中。即使您之前从未使用过该软件,也可以迅速掌握制作引人注目的图表和报告的技巧。 适合人群: - 希望通过数据可视化技能提升职业水平的人士 - 希望提升 Excel 和 Tableau 技能的人士 - 对动态可视化技术感兴趣的人员 - 希望在商业智能或分析领域建立职业的人士
What you'll learn in this course?Professional Dashboards in Excel and Tableau will teach you how to create visually compelling reports with both Excel and Tableau!Whether you prefer working with Excel or Tableau, this course will enable you to create beautiful reports from scratch!Dynamic and meaningful visual reports have now become the focus of most business interactions. With dashboards, you can gain crucial insights from the company's data and present information to investors or clients. That makes building a compelling dashboard a highly demanded skill which can make or break your chances of securing a place in the strategic team of your company. So, if you are looking for ways to improve your data visualization proficiency and boost your career prospects, look no further!Professional Dashboards in Excel and Tableau will show you not only how to create reports, but also how to style them to perfection and interpret them with ease. You'll also have access to the elegant color template we work with during the lessons, so you can apply it to your future reports for a professional and cohesive look. In addition, we'll help you with advice on how to create your own dashing templates using the best free online platforms out there.Here's what you will find in this unique course:· Introduction into the main principles of data visualizationWe discuss topics such as color theory, how to choose the right visualization based on your data, and showcase a few online platforms that can aid you on your data visualization journey.· The entire process of making a dashboard in ExcelStarting from the very beginning, we'll show you techniques that you can successfully apply to every Excel report. We work on real-world data and create a report based on data from a real firm, operating in the fast-moving consumer goods sector.· Creating a dashboard in TableauAgain, our data comes from the real-world FMCG industry. In the process of crafting the components, we'll get familiar with a wide range of techniques for building charts and other elements available in Tableau.But it doesn't end there!You'll also learn how to add custom time filters on both Excel and Tableau. Creating a time filter in Excel is a technical task, but with a well thought through idea and a neatly planned execution, everything is possible. This type of filter can then be applied to any report featuring time series data. So, you can transfer this knowledge to all future reports you're in charge of.In Tableau, we'll see various software options for customizing and styling filters. There are numerous possibilities to design and style filters in Tableau, and integrating it into a dashboard is easy and intuitive. Even if you've never worked with the software before, you'll quickly become the master of creating dazzling charts and reports.Who is this course for:People who want to level up their career with data visualization skillsAnyone who wants to improve their Excel and Tableau skillsAnyone interested in dynamic visualization techniquesPeople who are looking for a career in business intelligence or analytics