HR Analytics – Build Dynamic Excel Dashboard from Scratch
HR Analytics – Build Dynamic Excel Dashboard from Scratch, available at $49.99, has an average rating of 3.75, with 26 lectures, based on 113 reviews, and has 607 subscribers.
You will learn about Learn how to create a professional KPI dashboard from scratch Build Interactive Dashboard Reports with Buttons and Drop Down Menus Streamline and Analyze Data with Excel PivotTables and Linked Charts The Art of creating Visually Stunning Excel Dashboards You can write some macros and design KPI Dashboard. Use effective design principles when creating and presenting data Effectively summarize and present data clearly How to approach an Excel dashboard project from idea to delivery Impress management with reports that make the decision-making process faster This course is ideal for individuals who are Anyone who would like to take his Excel Skills to the next level or Those who are dealing with reporting and want to take it to the next level or Those who want to influence the manager and raise or get promoted It is particularly useful for Anyone who would like to take his Excel Skills to the next level or Those who are dealing with reporting and want to take it to the next level or Those who want to influence the manager and raise or get promoted.
Enroll now: HR Analytics – Build Dynamic Excel Dashboard from Scratch
Summary
Title: HR Analytics – Build Dynamic Excel Dashboard from Scratch
Price: $49.99
Average Rating: 3.75
Number of Lectures: 26
Number of Published Lectures: 26
Number of Curriculum Items: 26
Number of Published Curriculum Objects: 26
Original Price: ₹7,900
Quality Status: approved
Status: Live
What You Will Learn
- Learn how to create a professional KPI dashboard from scratch
- Build Interactive Dashboard Reports with Buttons and Drop Down Menus
- Streamline and Analyze Data with Excel PivotTables and Linked Charts
- The Art of creating Visually Stunning Excel Dashboards
- You can write some macros and design KPI Dashboard.
- Use effective design principles when creating and presenting data
- Effectively summarize and present data clearly
- How to approach an Excel dashboard project from idea to delivery
- Impress management with reports that make the decision-making process faster
Who Should Attend
- Anyone who would like to take his Excel Skills to the next level
- Those who are dealing with reporting and want to take it to the next level
- Those who want to influence the manager and raise or get promoted
Target Audiences
- Anyone who would like to take his Excel Skills to the next level
- Those who are dealing with reporting and want to take it to the next level
- Those who want to influence the manager and raise or get promoted
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.
Course Curriculum
Chapter 1: Introduction
Lecture 1: The Business Problem
Lecture 2: Important Note
Chapter 2: Data Collection
Lecture 1: Data Collection and Architecture
Chapter 3: Dashboard Wireframe
Lecture 1: Wireframing
Chapter 4: Data Validation
Lecture 1: Data Validation
Chapter 5: Data Preparation
Lecture 1: Variable Creation and Ageing Calculation
Chapter 6: Calculation
Lecture 1: Pivot Tables
Chapter 7: Linked Tables
Lecture 1: Inter connected Tables
Chapter 8: Charts and Graphs
Lecture 1: Building the Charts
Chapter 9: Dashboard Layout
Lecture 1: Dashboard Designing and Layout
Chapter 10: VBA – Visual Basic
Lecture 1: Filters using VBA
Chapter 11: Slicers
Lecture 1: Pivot connections
Chapter 12: Macro
Lecture 1: Hide and Seek using Macro
Chapter 13: Final Touch
Lecture 1: Final Touch to DashBoard
Chapter 14: Presenting the Dashboard
Lecture 1: Dashboard Presentation
Chapter 15: (Bonus) Why Dashboard?
Lecture 1: Why dashboard and not a report?
Chapter 16: (Bonus) Analytics Maturity Model
Lecture 1: Analytics Maturity Model
Chapter 17: (Bonus) Recruitment Metrics and KPI's
Lecture 1: Recruitment Metrics and KPI's
Chapter 18: Bonus – Top Excel Formulas you should know
Lecture 1: Count and Frequency
Lecture 2: Largest and Smallest Values
Lecture 3: Averages
Lecture 4: Confidence Intervals
Lecture 5: Percentile, Quartiles and Rank
Lecture 6: Deviation and Variance
Lecture 7: Covariance
Lecture 8: Trend Line Functions
Instructors
-
Unlock HR
HR Analytics / People Analytics / Talent Analytics
Rating Distribution
- 1 stars: 6 votes
- 2 stars: 13 votes
- 3 stars: 22 votes
- 4 stars: 39 votes
- 5 stars: 33 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024