Picking the Right Chart for Your Data
1h 19mBeginner2018-03-17
Authors

Bill Shander
CEO and Founder of Beehive Media
Course details
When selecting charts to showcase data, many people simply pick from the few choices available in Excel or other such software. This can be highly limiting, and can result in the selection of charts that fail to effectively convey whatever you're trying to communicate. This course can help you think more strategically about your data, and provide you with the tools you need to pick the best visual display for the type of data you're working with—and your ultimate communication goals. Main topics include getting to the key idea you're trying to communicate; finding the right standard chart for your data type; and brainstorming and experimenting to come up with alternatives to the standards.
Learning objectives
Identify the three KWYs.
Recall the seven types of chart categories.
Explain how to determine whether or not to use an alternative to a standard bar chart.
Analyze the advantages and disadvantages of using a donut chart to display data.
Identify the most effective charts to use when showing the correlation between variables.
Summarize instances when it is most effective to use a cumulative chart.
Learning objectives
Identify the three KWYs.
Recall the seven types of chart categories.
Explain how to determine whether or not to use an alternative to a standard bar chart.
Analyze the advantages and disadvantages of using a donut chart to display data.
Identify the most effective charts to use when showing the correlation between variables.
Summarize instances when it is most effective to use a cumulative chart.
Skills covered
Data VisualizationBusiness IntelligenceMicrosoft ExcelData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Welcome
- 02 - What you should know
1. Getting to KWYRWTS
- 03 - What is KWY
- 04 - Get to KWY
2. The Standards
- 05 - Chart categories
- 06 - Comparisons - Bars and columns
- 07 - Comparisons - Beyond bars
- 08 - Trends - Line charts
- 09 - Trends - Beyond the line
- 10 - Proportions - Pie charts and more
- 11 - Proportions - Beyond the circle
- 12 - Relationships - Correlation
- 13 - Relationships - Hierarchical and network
- 14 - Relationships - Flow
- 15 - Distribution - Histograms
- 16 - Distribution - Beyond histograms
- 17 - Deviation
- 18 - Geographic
3. Beyond the Standards
- 19 - To cumulative or not cumulative
- 20 - Outside the box
Conclusion
- 21 - Next steps
Related courses
Related learn paths
- Develop Your Data Analysis Skills
- Become a Data Visualization Specialist: Tools
- Advance Your Business Analytics Skills
- Become a Business Intelligence Specialist
- Build Your WordPress Ecommerce Skills
- Develop Your Skills as a Program Manager
- Prepare for the PMI-ACP Certification
- Develop Your Skills in Agile Software Development