What is a dashboard? •
A dashboard is a visual representation of data.
•
Dashboards are prepared to communicate the insights from the data through charts and graphs to help the users make better and informed decisions.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Qualities of a good dashboard
Easy to understand
Select the Relevant Metrics
Logical Layout
Email: Support@skillfinlearning.com
Choose Right Visuals
Simple and consistent
Mobile: 9650010925
Easy to understand Crisp and Simple
Make complex information simple
Follow 10 Second rule
Audience should be able to grasp the information quickly
Avoid over- information
Over information may lead to confusion.
Understand the audience
Keep the target audience in mind while structuring your dashboard
Email: Support@skillfinlearning.com
Mobile: 9650010925
Select the relevant metric “A Dashboard should display the metrics or Key Performance Indicators (KPIs) which are most relevant to the business and audience needs.”
Retailer Example by Industry
Email: Support@skillfinlearning.com
HR
Bank
Same store sales growth %
Loan book growth ($)
Digital revenues %
Net Interest margins (%)
Example by Function
Number of FTEs (#)
Invoice processing cost ($)
Average FTE Cost ($)
Collection time (Days) Day’s sales outstanding (Days) Year end books closure time (Days)
Store growth %
CASA ratio (%)
Average Age (#)
Average Revenues per square feet ($)
NoPerforming Assets (%)
Training completion rate (%)
Mobile: 9650010925
Finance
Choose the right visuals “It is important to choose the right charts and visuals along with the right analysis. If the visuals are not correct it is difficult to communicate the correct story.”
Email: Support@skillfinlearning.com
Bar Chart can be used to compare data across time frames.
Scatter Plot is used to show correlation between two variables.
Line Chart can be used to show evolution of one or more variable over time.
Waterfall chart to show variance from one point to the other.
Pie Chart is generally used to show breakup of data by proportion.
Histogram to show the frequency distribution of data.
Mobile: 9650010925
Logical layout • Document should have a logical Flow. Place the charts in a logical order Start with the ANSWER Group your SUPPORTING Statements BACK UP of the supporting statements
Email: Support@skillfinlearning.com
• Follow Top-Down Approach (PYRAMID PRINCIPLE) The most important message at the top, Followed by supporting analysis in the middle, and More granular details at the end.
Mobile: 9650010925
Keep things simple and consistent • Use contrasting colors for background and texts. • Restrict yourself to few colors.
Use contrasting colors
Consistent Labels and data formats
White Space
Round off numbers
• Avoid unnecessary text/graphics to fill the “white space”. • Do not consider “white space” as blank space.
Email: Support@skillfinlearning.com
• The font size should be at least 12. • Keep the color selection consistent across all charts.
• Rounding off the numbers helps audience retain the information.
Mobile: 9650010925
Conclusion • Your dashboard Should be Simple With the right visuals Have a logical flow, and Follow Top-down approach
Email: Support@skillfinlearning.com
Logical Flow
Mobile: 9650010925
Top-Down Approach
Tell a compelling Story
Want to learn more? Explore our Data Analysts Skills Training (DAST) in Excel Go from beginner to an Expert in Data analytics Skills in Excel. Join this program to build your Excel analytical skill quickly through hands on project Includes: ✔ Annual (1 year) access ✔ Take the program anytime anywhere ✔ Direct access to the instructor ✔ Weekly mentorship assistance ✔ 6.5 hours on-demand HD videos ✔ 20+ real life case illustrations ✔ 5 Practice assignment ✔ Access on Mobile and Tablet ✔ Certificate of Completion ✔ 30-day money back guarantee
Email: Support@skillfinlearning.com
You get a Personalized Training Experience: ✔ Unlimited access to video content ✔ 1 on 1 coaching from expert instructor ✔ Individual mentorship assistance ✔ Dedicated doubts resolution sessions ✔ Practice on real world projects from industry experts ✔ Evaluation and feedback on assignments
For more details please visit; Data Analyst Skills Training in Excel (DAST)
Mobile: 9650010925
Want to learn more? Explore our Business Presentation Skills Training (BPST) in PowerPoint Become a PowerPoint specialist to create client-ready business presentations from scratch through a real-life case illustration Includes: ✔ Annual (1 year) access ✔ 100+ Live interactions ✔ Unlimited access to vide content ✔ Weekly mentorship assistance ✔ Individual assignments evaluation ✔ Access on Mobile and Tablet ✔ Certificate of Completion
Skills you will Master ✔ Create meeting presentations in PowerPoint ✔ Present insights and data logically ✔ Synthesizing key messages on slides ✔ Story-telling using PowerPoint presentations ✔ Presentation design techniques ✔ Client facing communication skills ✔ Develop powerful executive summary ✔ Build a real-world presentation from scratch
For more details please visit Email: Support@skillfinlearning.com
Business Presentation Skills Training (BPST)
Mobile: 9650010925
Our Training approach ensures You Learn Effectively and in Less Time
Email: Support@skillfinlearning.com
Mobile: 9650010925
THANK YOU Visit Skillfinlearning.com
Email: Support@skillfinlearning.com
Mobile: 9650010925