Make an AWESOME Employee Dashboard with Power BI (Adv. DAX) @chandoo_
Make an AWESOME Employee Dashboard with Power BI (Adv. DAX)  @chandoo_
Uploaded June 2025 | Updated November 2026, 2 days ago
πŸ’₯Master Power BI for data analysis with my course πŸ‘‰ chandoo.org/wp/power-bi-course

~

Power BI is great for generating HR reports, employee reports and dashboards. In this video, learn how to use Power BI, Power Query, Power Pivot, DAX, SVG Measures and visual design to create an impressive employee attendance dashboard.

πŸ“Get the files:

Sample data: github.com/chandoo-org/Power-BI/blob/main/SVG/emp_attendance_data.xlsx
Demo report: github.com/chandoo-org/Power-BI/blob/main/SVG/attendance%20dashboard%20-%20explained.pbix
Watch Part1 video - youtu.be/djUyi4oOAEM

πŸ•‘ Video Topics & Timestamps:
0:00 - Demo of our Employee Power BI Dashboard
1:29 - A closer look at the data
2:54 - Dashboard Design - Inspiration
3:43 - Designing the Dashboard in OneNote
7:48 - Loading and transforming data (with Power Query)
16:00 - Data Modelling
17:28 - Background Design (in PPT)
20:50 - Page Design in Power BI
21:40 - What visuals we need?
22:23 - Setting up a dedicated measures table in Power BI
23:02 - DAX Measures for our analysis
31:03 - Designing the Calendar View (with just matrix)
33:00 - Using SVG to create a better calendar view
41:35 - Adjusting the SVG Calendar Colors and Matrix Format
45:55 - Designing Employee Card Visual with SVG + DAX
49:00 - But images are not loading with SVG - fixing the issue with Power Query
56:00 - Formatting the dashboard
1:01:00 - Adding dynamic dashboard title to tell a story
1:03:00 - In conclusion

πŸ“š Additional Resources:

Watch Part1 video - youtu.be/djUyi4oOAEM
Dashboard inspiration by Seun Adeyemo public.tableau.com/app/profile/bigxpt/viz/SALARYWORKHOURS/SALARY
Extracting large image bytes with PQ - blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets
SVB DAX Basics - chandoo.org/wp/how-to-svg-dax-measures-power-bi
Kerry Kolosko's website for SVG inspiration - kerrykolosko.com/portfolio
Boxy SVG Editor - boxy-svg.com/app

πŸ“Ί More Power BI Dashboards & Reports:

HR Dashboard with Power BI - youtu.be/5KaIU-9EF-0
Sales Dashboard with Power BI (basic) - youtube.com/live/mXD0Peot4hY
Sales Dashboard with Power BI (adv) - youtu.be/ooJO7NW4uJU
Finance Dashboard with Power BI - youtu.be/i3AR0gt9SHA
Insurance Dashboard with Power BI - youtube.com/live/TazNFzgWtgA?feature=share
Hotel Dashboard with Power BI - youtube.com/live/qjzjYurmb5s?feature=share


πŸ’₯Master Power BI for data analysis with my course πŸ‘‰ chandoo.org/wp/power-bi-course

~

#powerbi #hrdashboard #dax
Make an AWESOME Employee Dashboard with Power BI (Adv. DAX)Second Week Sales Only with SUMIFS (Excel formula)Filled Column Charts in Excel - Amazing Dataviz TrickGet ALL Option in Excel Data Validation with this Crazy Trick πŸ’‘This Excel Fuzzy Match Formula is CRAZY GOOD 🀩5 HR KPIs Every Analyst Needs to Master #HRAnalytics #KPIsThis Excel Trick shows the New Customers Quickly!Excel Formula to Show Top Sellers InstantlyPower Query - Advanced Tips + Q&A - REPLAYAdvanced SQL for Data Analysis - 10 Powerful Examples in 40 minutes πŸ•—How many days overlap between two projects [Excel Formula Magic]Excel + ChatGPT - 7 Ways to Work Faster & Smarter 😎
Chandoo |

Make an AWESOME Employee Dashboard with Power BI (Adv. DAX)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER