Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Picking the Right Chart for Your Data

Picking the Right Chart for Your Data

1h 19mBeginner2018-03-17

Authors

Bill Shander

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.

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

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal