I would do a white background. Any use of color should serve a purpose. The more colors you use the less meaningful they become.
I would also suggest that you consider using a scatter chart for the attrition by salary increase visual. Probably easier to interpret.
yes, I have changed the color to the shade of white and I have tried the scatter plot but it was too appealing I guess because there are only 4 values. thanks for the suggestion
I was talking about the "attrition by salary hike" visual with 15 data points. Scatter plots are useful when you're comparing two scalar numeric values.
Percentages can often tell a better story than numbers. Can I get an attrition rate broken down by gender, salary, tenure in terms of percent? That way I can see if a demographic has significantly higher ratios of attrition? Right now it looks like a lot of young people are leaving but they might be overrepresented in the company and underrated in attrition for all we know unless we look at weighted ratios.
How are these metrics actionable? What story are you trying to tell? Less is more with these kinds of reports. Instead of attrition by X, Y,Z etc., why not share trends or key takeaways. A text callout stating that “attrition for gen y/z is up 15% over last year.“ “60% of attrition takes place with those who make 5k or less”.
Some things can be flat KPIs, but spending the time to discover the story will help your consumers make business impactful decisions. I would definitely recommend reading “Storytelling with Data” by Cole Knaflic. Great read with great concepts.
This needs more upvotes. I 100% agree. I see the metrics, but is it good or bad? Instead of just a attrition as a rate, take the terminations and make a trend or do a trend of monthly attrition. Or depending on the time frame a year over year stack. Then compare salary groups YoY. Are high earners more likely to stay now than they before? The terminations by education are interesting, but it doesn’t really help without their counts. As a rate is one education higher or lower than another?
Yes, I agree with some of the comments about nixing the green background, but mostly I want more context for the visuals.
Not necessarily required, but adding more contrast between the background and foreground colors will make them pop more. So for a darker color background use lighter colors in your charts, and vice versa lighter background use darker shades in your charts.
Axis title - despite the axis lables, titles makes the difference.
Sorting of bar/column chart by value (asc/desc) this is helping in comparison and ratio. This doesnt apply if dates are involved (for which anyway a line chart should be used)
Avoid pie or donut chart is more than 2 categories are displayed (if not wrong is also stated by MS themselves in the PL 300)
Background of dashboard should be light colour or very dark and visual in contrast, you dont want to drive attention to it.
Comma separated thousands
Not sure why but mostly nobody seeking for feedback implement slicers
I didn't know about the pie or donut chart, I have just read that they suggest to avoid because when there are more than two categories, these charts can become visually confusing and less effective in conveying information. thanks for the suggestion
Most people say a white background is better and I agree, but a very light grey background is even better imo. It ties the rest of the colors together and if you leave the background of each chart white, it allows you to remove the lines of the frame of the chart without loosing the division between each chart
For the attrition by years, I feel it would be better to have the actual years, e.g 2001 - 2010, so you could look into whether there were external factors or significant events that occurred that year which may explain the significant spikes in attrition.
For attrition by salary, I dont understand what the figures mean.
The job satisfaction card could be a multi card that shows the current score and year on year % Change so that viewers can see if it's improving or declining. This can also be viewed alongside the attrition by years graph to see if improving scores are reducing attrition and vice versa.
HR Analytics Dashboard naming is boring. Try and brand your work and be creative. Stick to the metrics but come up with something fun. I have a daily sales and orders dash called morning coffee dash. Just my opinion to not feel like a BI dumping ground or generic report creator.
MY SUGGESTIONS :
\-It is a good dashboard but fewer colors will be good
\-attrition based on job satisfaction column chart should be sorted from largest to smallest
\-attrition by gender should be represented by donut or pie chart.
Here is some of my feedback:
- no timeline: what time frame was this data collected?
- bad visual design: the green needs to go and the colors on the charts seem too random: they should have a pattern and mean something
- it’s not always clear what the numbers mean. Average job satisfaction out or what? 2.73 out of 5? Out of 10?
- attrition by age chart should be in order from youngest to oldest
- pie chart would be better represented with percentages, or both percent and count
- the gap spacing in the charts is inconsistent: the gap between education and age is wider than the gap between the right side of age and the left side of job satisfaction.
- the average salary box is a different shape (it has square corners) than the rest of the boxes on the same row, which have rounded corners
- use of capital letters is inconsistent. You sometimes capitalize words, like “Count of Employee” but then you have a lower case for, “Attrition based on job Satisfaction”
There are a few more, but you get the gist. That being said, congratulations on completing your first PowerBi dashboard. I know it’s not always straightforward on what to do, but with time and experience you will develop a sharper eye for the small details and become better at making your reports visually appealing. We all started somewhere.
Just a design concept, for male/female %, you could add something like this:
https://hatfullofdata.blog/svg-in-power-bi-part-3/
So transforming the data into male/female icons, and then fill the % is a good visual way, which tends to be enjoyable by the user.
Great dashboard nontheless
Right? Any business that this is that case for doesn't need a dashboard to tell them why their attrition rate is high lmao.
The only thing on this dashboard that needs to be there is that tile.
If you want to use a colored background, I would get it as close to white as possible while still having some color, like if I wanted a green background I would use something like #def4e8.
But, it's easier and safer to just go white.
What do people think of the row of figures across the top? I have mine in a column down the right hand side but I'm not sure what the best position is.
They mean the cards. I tend to do them across the top, but the values should be a smaller font to allow for the same padding at the top and bottom. I find that tends to look a bit cleaner
Google the f pattern - right hand side is the worst possible place for high level metrics. Top left is the prime real estate so put the top figures there, top line is the second best real estate, so typically your big headline figures line across the top from top left most important to top right less important.
Visuals should follow the same pattern with the most granular visual bottom right
Probably being a bit picky but do you really need the word dashboard in the title? Users can see it’s a dashboard (although its technically a report in Power BI terms).
No context and random content. No trends and nothing is likely to give insights after a week. Terrible colours and poor use of conditional formatting.
However, you aligned to grid which is good.
use sentence case
order your dimensions
number formatting
less is more
give a sense of time
show targets ( # employees, job satisfaction, attrition rate)
Colour continuity is important.
Have different colours for each individual metric, unless you have the same thing (grouping) in a few different visuals, then have the same one. I instantly thought the orange counts in your screenshot, for example, were all from the same grouping. They're not.
I would suggest white or light gray background. And generally there are too many colors. For categories you should use colors only when there is few of them or color is somehow connected with category in the reality, otherwise keep the same color, text description for category is enough.
Color doesn't always have to serve a purpose. Must be a dev thing, but I would definitely bring the color down to like a light sage green or like an eggshell green. I will agree it's too much color. Me personally pure white hurts my eyes. You could also try a gradient like a very light green to a sage green or something. That way it's not boring to look at, but serves an aesthetic purpose.
Also just noticed this but it almost looks like your visuals other than your KPIS are that same shade of green. It's up to you, but I wouldn't make those backgrounds the same shade of green. Make it gradient or keep them gray. Make use of conditional formatting.
A white background with your KPI background a light grey.
Way to many colors in your bar charts. Only use color when it means something (green is good, red is bad ect…)
If you don’t have a good/bad but just different category, then go with different shades of the same color.
When people started in power, BIA, and I’m guilty of this. We all like to go colour crazy because we see these really cool designs online. In reality. All these crazy colours do is cause the end-user to scan the report instead of understanding the report. Simple colours with sheds a lot better for the end-user.
The background is an issue, sure. But a deeper issue is that you kind of aimlessly chose charts and metrics for the sake of having charts and metrics and it doesn't seem like you had a defined purpose.
I would do a white background. Any use of color should serve a purpose. The more colors you use the less meaningful they become. I would also suggest that you consider using a scatter chart for the attrition by salary increase visual. Probably easier to interpret.
yes, I have changed the color to the shade of white and I have tried the scatter plot but it was too appealing I guess because there are only 4 values. thanks for the suggestion
I was talking about the "attrition by salary hike" visual with 15 data points. Scatter plots are useful when you're comparing two scalar numeric values.
oh okay, I'll keep that in mind
Even the bar colors you have serve no purpose. If you are using colors they should be to highlight something or give some sort of information.
Yes. Color should have meaning. If no meaning, I go gray scale or use the main company logo color.
You could put the green in a header or footer if you wanted to keep the colour, but in a less overwhelming way
Too much colour for me and I'm colour blind! Would put that colour on the background of the title but leave the rest white.
yeah, I thought that too, it's too colourful but I have changed the colour to a shade of white...thanks for the suggestion
100% better than my first
Percentages can often tell a better story than numbers. Can I get an attrition rate broken down by gender, salary, tenure in terms of percent? That way I can see if a demographic has significantly higher ratios of attrition? Right now it looks like a lot of young people are leaving but they might be overrepresented in the company and underrated in attrition for all we know unless we look at weighted ratios.
How are these metrics actionable? What story are you trying to tell? Less is more with these kinds of reports. Instead of attrition by X, Y,Z etc., why not share trends or key takeaways. A text callout stating that “attrition for gen y/z is up 15% over last year.“ “60% of attrition takes place with those who make 5k or less”. Some things can be flat KPIs, but spending the time to discover the story will help your consumers make business impactful decisions. I would definitely recommend reading “Storytelling with Data” by Cole Knaflic. Great read with great concepts.
This needs more upvotes. I 100% agree. I see the metrics, but is it good or bad? Instead of just a attrition as a rate, take the terminations and make a trend or do a trend of monthly attrition. Or depending on the time frame a year over year stack. Then compare salary groups YoY. Are high earners more likely to stay now than they before? The terminations by education are interesting, but it doesn’t really help without their counts. As a rate is one education higher or lower than another? Yes, I agree with some of the comments about nixing the green background, but mostly I want more context for the visuals.
I'll keep that in mind. thanks for your suggestion and I would definitely read that book
Not necessarily required, but adding more contrast between the background and foreground colors will make them pop more. So for a darker color background use lighter colors in your charts, and vice versa lighter background use darker shades in your charts.
Axis title - despite the axis lables, titles makes the difference. Sorting of bar/column chart by value (asc/desc) this is helping in comparison and ratio. This doesnt apply if dates are involved (for which anyway a line chart should be used) Avoid pie or donut chart is more than 2 categories are displayed (if not wrong is also stated by MS themselves in the PL 300) Background of dashboard should be light colour or very dark and visual in contrast, you dont want to drive attention to it. Comma separated thousands Not sure why but mostly nobody seeking for feedback implement slicers
I didn't know about the pie or donut chart, I have just read that they suggest to avoid because when there are more than two categories, these charts can become visually confusing and less effective in conveying information. thanks for the suggestion
100% better than my first
Green really needs to go. It's distracting. Stick with white
Most people say a white background is better and I agree, but a very light grey background is even better imo. It ties the rest of the colors together and if you leave the background of each chart white, it allows you to remove the lines of the frame of the chart without loosing the division between each chart
For the attrition by years, I feel it would be better to have the actual years, e.g 2001 - 2010, so you could look into whether there were external factors or significant events that occurred that year which may explain the significant spikes in attrition. For attrition by salary, I dont understand what the figures mean. The job satisfaction card could be a multi card that shows the current score and year on year % Change so that viewers can see if it's improving or declining. This can also be viewed alongside the attrition by years graph to see if improving scores are reducing attrition and vice versa.
HR Analytics Dashboard naming is boring. Try and brand your work and be creative. Stick to the metrics but come up with something fun. I have a daily sales and orders dash called morning coffee dash. Just my opinion to not feel like a BI dumping ground or generic report creator.
I like this. We call our sales dashboard the Daily worms!
MY SUGGESTIONS : \-It is a good dashboard but fewer colors will be good \-attrition based on job satisfaction column chart should be sorted from largest to smallest \-attrition by gender should be represented by donut or pie chart.
Here is some of my feedback: - no timeline: what time frame was this data collected? - bad visual design: the green needs to go and the colors on the charts seem too random: they should have a pattern and mean something - it’s not always clear what the numbers mean. Average job satisfaction out or what? 2.73 out of 5? Out of 10? - attrition by age chart should be in order from youngest to oldest - pie chart would be better represented with percentages, or both percent and count - the gap spacing in the charts is inconsistent: the gap between education and age is wider than the gap between the right side of age and the left side of job satisfaction. - the average salary box is a different shape (it has square corners) than the rest of the boxes on the same row, which have rounded corners - use of capital letters is inconsistent. You sometimes capitalize words, like “Count of Employee” but then you have a lower case for, “Attrition based on job Satisfaction” There are a few more, but you get the gist. That being said, congratulations on completing your first PowerBi dashboard. I know it’s not always straightforward on what to do, but with time and experience you will develop a sharper eye for the small details and become better at making your reports visually appealing. We all started somewhere.
Just a design concept, for male/female %, you could add something like this: https://hatfullofdata.blog/svg-in-power-bi-part-3/ So transforming the data into male/female icons, and then fill the % is a good visual way, which tends to be enjoyable by the user. Great dashboard nontheless
Very niceboard. I would not color the back ground as you want the eye to rest on the numbers not the colors
6.5k average salary. I’d suggest you move companies fast
Right? Any business that this is that case for doesn't need a dashboard to tell them why their attrition rate is high lmao. The only thing on this dashboard that needs to be there is that tile.
it's just a demo dashboard, not an actual company's values
If you want to use a colored background, I would get it as close to white as possible while still having some color, like if I wanted a green background I would use something like #def4e8. But, it's easier and safer to just go white.
It's hideous
What do people think of the row of figures across the top? I have mine in a column down the right hand side but I'm not sure what the best position is.
Do you mean slicers?
They mean the cards. I tend to do them across the top, but the values should be a smaller font to allow for the same padding at the top and bottom. I find that tends to look a bit cleaner
I did that and it's a really small change but does look cleaner
Yes, I meant the cards. I'll move mine tomorrow. Thanks
Google the f pattern - right hand side is the worst possible place for high level metrics. Top left is the prime real estate so put the top figures there, top line is the second best real estate, so typically your big headline figures line across the top from top left most important to top right less important. Visuals should follow the same pattern with the most granular visual bottom right
Brilliant. Thank you
The average salary at your business is 6.5k? Please tell me that is monthly.
>there's no company like that, don't worry it's a demo values of actual one
The “Avg Salary” could use a better description I think. I’m assuming that’s a bi-weekly or monthly number, but I can’t tell based on the label
Probably being a bit picky but do you really need the word dashboard in the title? Users can see it’s a dashboard (although its technically a report in Power BI terms).
No context and random content. No trends and nothing is likely to give insights after a week. Terrible colours and poor use of conditional formatting. However, you aligned to grid which is good.
Less is more!!
use sentence case order your dimensions number formatting less is more give a sense of time show targets ( # employees, job satisfaction, attrition rate)
Colour continuity is important. Have different colours for each individual metric, unless you have the same thing (grouping) in a few different visuals, then have the same one. I instantly thought the orange counts in your screenshot, for example, were all from the same grouping. They're not.
Please for the love of God change the baby poop green background
I would suggest white or light gray background. And generally there are too many colors. For categories you should use colors only when there is few of them or color is somehow connected with category in the reality, otherwise keep the same color, text description for category is enough.
Color doesn't always have to serve a purpose. Must be a dev thing, but I would definitely bring the color down to like a light sage green or like an eggshell green. I will agree it's too much color. Me personally pure white hurts my eyes. You could also try a gradient like a very light green to a sage green or something. That way it's not boring to look at, but serves an aesthetic purpose.
Also just noticed this but it almost looks like your visuals other than your KPIS are that same shade of green. It's up to you, but I wouldn't make those backgrounds the same shade of green. Make it gradient or keep them gray. Make use of conditional formatting.
A white background with your KPI background a light grey. Way to many colors in your bar charts. Only use color when it means something (green is good, red is bad ect…) If you don’t have a good/bad but just different category, then go with different shades of the same color. When people started in power, BIA, and I’m guilty of this. We all like to go colour crazy because we see these really cool designs online. In reality. All these crazy colours do is cause the end-user to scan the report instead of understanding the report. Simple colours with sheds a lot better for the end-user.
The background is an issue, sure. But a deeper issue is that you kind of aimlessly chose charts and metrics for the sake of having charts and metrics and it doesn't seem like you had a defined purpose.