|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-dashboard-from-scratch/
课程评论：没有评论
**课程名称：** HR数据分析 - 从零打造动态Excel仪表盘 **课程概述：** 本课程将教您如何在Microsoft Excel中从零开始构建一个交互式的动态仪表盘。许多人可能认为制作动态仪表盘需要Tableau或Power BI等专业工具，但本课程将证明Excel同样强大且易于上手。之所以选择Excel，是因为它普及率高，大多数人都有使用经验。 最令人兴奋的是，您将在不到两小时内完成一个完整的仪表盘！这将大大提升您在工作中的竞争力，尤其是在需要快速响应经理要求，提供分析性报告时。 **为何需要仪表盘？** * **运营型仪表盘：** 提供绩效概览，需要在不依赖过多层层下钻的情况下包含大量细节。 * **分析型仪表盘：** 利用历史数据识别趋势，为未来决策提供支持。 **课程内容亮点：** 本课程以“招聘所需时间”（Time to Hire）这一常用KPI为例，构建了一个交互式仪表盘。您将学会： * 计算和可视化招聘流程不同阶段的耗时。 * 按周、招聘来源渠道、技能等筛选数据。 * 分析招聘人员的效率。 * 识别招聘流程耗时过长的业务单元。 此外，课程还将讲解“仪表盘解剖学”，帮助您将复杂的仪表盘构建问题分解为更小的部分，从而能够快速、系统地为任何业务问题构建交互式仪表盘。这是一种实用的、循序渐进的仪表盘构建方法。
Well, we're going to build an interactive dynamic dashboard in excel. Yes you heard it right. We gonna create it in MS Excel. No, we are not kidding…. Let me show you the end result, then you might believe me. You may have seen dashboards in tableau, power BI. but it's time you learn how to do that in excel. Why excel?My reason for building it in MS excel is because excel is easily available to everyone, and almost everyone have hands-on experience in working in Excel.Additionally let me tell you one very amazing part. You gonna learn to create the dashboard in less than two hours. Yes you heard it right, in less than 2 hours Amazing isn't it. Just imagine, your manager asked you to submit the report, and comeback with and interactive, dynamic, analytical dashboard. Definitely, It is going to add some extra points in your performance score. Start expecting a good bonus already.Now your question would be Why do we create a dashboard? What is the purpose?The main purpose of an operational Dashboard is to provide a comprehensive snapshot of performance, which means that you should incorporate a large amount of detail without using too many drill downs. Analytical Dashboards - Use data from the past to identify trends that can influence future decision-making.In this course we used one of the very popular KPI "Time to Hire" and built an interactive dashboard around it. Which calculates and visualize the ageing of different stages, then we can also check or you can say filter the data week wise, by sourcing channel, skill wise. Also we can go ahead and check the recruiters efficiency, which business unit is takes too much time to get the candidate hired.We have also went ahead and created an anatomy of dashboard which will help you drill down the problem into smaller parts so that it becomes easy for you to build any interactive dashboard in very less time. That is a step by step approach to build a dashboard for any type of business problems.
