Interactive Excel HR Dashboard - FREE Download

In this video you will learn how to create an interactive HR dashboard from scratch using Excel's Power Query and Power Pivot tools. Applies to Excel 2010 onward for Windows only.

🎓 LEARN MORE

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
0:00 Introduction
1:02 Get Data with Power Query
6:09 Active Employess Column Chart
13:59 Ethnic Group Column Chart
20:51 Separations & Termination Column Charts
25:01 Headline Visuals
39:20 Slicers
44:23 Color Formatting
46:07 Dashboard Tabs
49:08 Automatica Updating
50:27 Icons
52:15 Outro

[zbeesapiary]

It is quite refreshing to find someone on the Internet who is so organized in their presentations and loves what they do. Your videos are informative, well presented, and meaningful to anyone who wants to know more about excel. DZ, North Carolina, USA.

[drisshaffad]

That's the best tutorial for dashboard design in Excel I've seen so far.

[quiro]

Did not think i could watch a 50+ min video but this went by so fast .. glad i watched this
i am ready to show off

[gracepaddington]

You probably are the best excel tutor on youtube (sorry didn't mean to offend the others). I was so proud that I managed to build my first interactive dashboard after watching your tutorial. Thank you!

[jimfitch]

Another fantastic training, Mynda - thanks!!! I built my first Excel dashboard about 4 months ago after viewing an earlier webinar by you. It works, but taught me to dive deeper into Power Query, M, Power Pivot, & DAX (all new to me at the time). So, I’ve learned & am learning PQ & PP from you, Mike Girvin, Leila Gharani, Jon Acompora, & others. This webinar came at just the right time to push me back into dashboard development ... probably beginning with replacing that first dashboard. (I configured it to load data tables which makes the file huge & slows the daily update. Now, I know to load data to the PP data model in background & make only pivoted data visible. My DAX chops aren’t quite ready for that, but I learned to swim at the deep end of the pool, so why not jump in?) I love the fast-paced, content-rich method of your webinars. Thanks again!

[divyeshkatariya]

For a guy who learnt PowerBI first, this seems like a revision of measures and calculated columns but this video showed me where the PowerBI began!!

[thecodfather]

Been looking for something like this! Especially working in HRIS. Thank you so much, you're amazing! X

[chrisg]

Just brilliant. At a moment, it was like watching a movie and saying the dialogue you want to hear just ahead of hearing it; “Plenty of room to grow”. Yes! Side note, going back to rewatch the 15 things I missed while penning this most amazing commentary.

[marcellokassa]

Absolutely incredible... Thanks for this webinar.... So proud of you!

[JosQiNgMT]

To be honest. Your video is the best. Can see u r a very good teacher. Everything is so detail and never miss a step.

[Excel-power-users]

Loved watching the video and I never realized how the time passed while learning. Beautifully presented and easily explained. Would like see more from you on measures section.👍

[tarunkumarjami]

Firstly I have to say thank you on behalf of all the members who are learning from your videos. your efforts to educate us on deep excel usage were remarkable ... Thankyou so much for that.

[jamesperry]

*This is a super great online tutorial* _for free!_ *Will i be able to master it? Wish me luck. THANK YOU!!*

[shivenappalsamy]

Great example you have shed a new light on the capabilities of Excel as a BI tool and changed my perspective !!!!

[findthetruth]

Your videos are awesome 😍😍😍. Thanks a lot. Please create a special video for pivot calculator.

[excelworx]

You have done everything with PQ and PP, with a few measures. Fantastic Mynda. I would add a small rejoinder in the end that this is the same way you make this in PowerBI

[purpleduck]

Excellent tutorial! I still have 13 minutes more to go in the video but I am literally excited to finish and go into Excel to play around with this.

[republikadugave]

Your style is so calming...im so chill when watching your videos

[hyw]

It is an art rather than a so-called-skill!!!

[sweydert]

This was easily the best tutorial I've ever seen on building dashboards in enhanced Excel -- and I've been using Power Query and Power Pivot for several years.

The problem is, sometimes I still struggle to describe or explain what I see happening on my Power Pivot dashboards as I "trial-and-error" my way through various DAX calculations. The two biggest areas of "nebulousness" are:

1) Given that (in addition to allowing us to add basic conditional filters) CALCULATE adds the current row to the existing filter context, is there an easy way to know in advance when you will want to add CALCULATE to your expressions rather than simply waiting to see if things "look right" with or without it on your pivot table?

2) Similarly, I know what ALL and ALLEXCEPT do and I use them frequently to remove or keep selected filters/columns. However, for example, in this tutorial you sometimes use ALL to augment your FILTER statements but not others. Is there an easy way to know in advance that we should be thinking of modifying our FILTER statement with ALL?