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
π₯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









![How many days overlap between two projects [Excel Formula Magic]
Find out quickly how many days both projects overlap using this elegant and simple Excel formula How many days overlap between two projects [Excel Formula Magic]](https://i.ytimg.com/vi/EqALWpxps0I/mqdefault.jpg)
