All classes Power BI Syllabus · Episode 6 of 7

Checking access...

Want to go deeper?

Join one of our courses or ask us directly on WhatsApp.

View the full 7-episode syllabus View Power BI Courses Ask on WhatsApp

Need more than a video?

Other ways we can help with Power BI Desktop.

Learn with a mentor

Scheduled Data & Analytics courses with live guidance and a certificate.

Course

Course/Training Deep Learning — From Machine Learning to Deep Learning

★ 5.0 (11)

Course

Course/Training Python — Machine Learning Data Science Using Python & R

★ 5.0 (11)

Course

Course/Training Skripsi/TA/Tesis/Disertasi Mahasiswa S1/S2/S3 Visual Studio

★ 5.0 (10)

See all in Data & Analytics →

Have it built for you

No time to learn Power BI Desktop? Our team can do the project for you.

Service

Python Training Development Service

★ 5.0 (73)

Service

Development Service: Python — Complete Python Developer Zero to Mastery (2020)

★ 5.0 (14)

Service

Development Service: Django — Build Web Apps with Python, Django, Flask, Heroku, Git

★ 5.0 (12)

See all in Data & Analytics →

Get notified about new Power BI Desktop classes

At most one email a week. Unfollow anytime with one click.

Transcript

The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.

Show transcript

Introduction

This is the final result of part 6, the HR Work4C dashboard. We'll look at the trend of employee recruitment per year, number of employees per department, gender composition in each department, and employee grade distribution. Let's start. Hello, this is part 6 of the Power BI Wave Facts dashboard series. This time, we'll switch to employee data in the HR table and create the HR Work4C dashboard. Right-click the HR tab, select duplicate, then rename it to HR Work4C.

Step 1: Duplicate the HR page into HR Workforce

Change the page title to HR Work4C.

Step 2: Recruitment trend per year

We change the age area chart per department into a recruitment trend chart. Clear the X-axis, then drag the date of joining. Power BI automatically creates a hierarchy of year, quarter, month, and day. We only need the year, so delete day, month, and quarter. Then replace the axis with total employees. The highest recruitment occurred in the year 2014. The title becomes Hearing Trend By Year.

Step 3: Bar chart of employees per department

We change the gender pie chart into the number of employees per department. Clear the legend and details, then drag the department to the legend. Since the color of this pie is locked to one color, we change the type to clustered bar chart for better readability. The manufacturing department is the largest with 53 employees.

Step 4: Stacked column for department and gender

We change the education waterfall chart into a stacked column chart. Fill the X-axis with department and legend with gender. Each column is now divided into male and female employees. The title becomes Employees By Department and Gender.

Step 5: Funnel of employees per grade

We change the promotion status funnel chart into employee grade distribution. Clear the category, then drag employee grade. Most employees are in grade 4 and 5. The title becomes Employees By Grade.

Done! HR Workforce Dashboard

Done. The Higher Workforce Dashboard is now complete. Save with Ctrl S. See you in the final part about drill through product details. Want to have a Power BI dashboard like this? Cerdas Inovasi Digital offers Power BI courses, dashboard creation and report automation services, as well as selling Power BI project files from this tutorial series. Contact us via WhatsApp, or visit cerdasinovasidigital.com.

Ask the class material

Type a question or keyword; we find the part of this episode that explains it and jump the video there.

My notes

Notes are saved with the current video time and are only visible to you.

Questions & answers

Stuck on a step? Ask here; the instructor and other learners can answer.

No questions yet.

Your instructor

Cerdas Inovasi Digital Team

Software developers, BIM & 3D engineers, and AI practitioners

52 video classes1,276 episodes

We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.

See our clients →

Memuat

Transcript

The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.

Show transcript

Introduction

Step 1: Duplicate the HR page into HR Workforce

Change the page title to HR Work4C.

Step 2: Recruitment trend per year

Step 3: Bar chart of employees per department

Step 4: Stacked column for department and gender

Step 5: Funnel of employees per grade

We change the promotion status funnel chart into employee grade distribution. Clear the category, then drag employee grade. Most employees are in grade 4 and 5. The title becomes Employees By Grade.

Done! HR Workforce Dashboard

Your instructor

Cerdas Inovasi Digital Team

Software developers, BIM & 3D engineers, and AI practitioners

52 video classes1,276 episodes

See our clients →

Need more than a video?

Transcript

0:03Introduction

0:38Step 1: Duplicate the HR page into HR Workforce

0:56Step 2: Recruitment trend per year

1:59Step 3: Bar chart of employees per department

2:43Step 4: Stacked column for department and gender

3:38Step 5: Funnel of employees per grade

4:15Done! HR Workforce Dashboard

Ask the class material

My notes

Questions & answers

Your instructor

Need more than a video?

Transcript

0:03Introduction

0:38Step 1: Duplicate the HR page into HR Workforce

0:56Step 2: Recruitment trend per year

1:59Step 3: Bar chart of employees per department

2:43Step 4: Stacked column for department and gender

3:38Step 5: Funnel of employees per grade

4:15Done! HR Workforce Dashboard

Ask the class material

My notes

Questions & answers

Your instructor

Introduction

Step 1: Duplicate the HR page into HR Workforce

Step 2: Recruitment trend per year

Step 3: Bar chart of employees per department

Step 4: Stacked column for department and gender

Step 5: Funnel of employees per grade

Done! HR Workforce Dashboard

Introduction

Step 1: Duplicate the HR page into HR Workforce

Step 2: Recruitment trend per year

Step 3: Bar chart of employees per department

Step 4: Stacked column for department and gender

Step 5: Funnel of employees per grade

Done! HR Workforce Dashboard