workers-collab

How to Turn Data Into Compelling Visual Presentations

Visually and clearly present data and the message it represents.

Communicating data and the story of what that data means has become increasingly important in recent years. As attention spans decrease and the amounts of quantitative information increase, it is crucial to be able to visualize your data for your audiences in the most clear and effective ways possible. A chart that takes 10 seconds to understand, compared to one that takes only 2 seconds, could mean the difference between a sale and no sale. Your data is only as powerful as your visual presentation of it. In this course, you will learn the fundamentals and best practices of data visualization techniques, as well as hands-on approaches to using Microsoft Excel and PowerPoint to present your data in a variety of formats. You will complete multiple exercises and create various types of visualizations and charts throughout the course. You will also work individually and in groups to analyze, redesign, and improve poorly designed charts that are provided.

Seminar Number: 02012

  • In a Classroom
  • Your Company Location

Course Scheduling & Pricing

Who Should Attend

Those with a foundational understanding of Microsoft Excel® and PowerPoint®, who work regularly with data and wish to design basic and more advanced charts, graphs, and tables

  •   Classroom2 Day(s)
    1.2 CEU, 14 CPE, 12 CPU
 
Communicating data and the story of what that data means has become increasingly important in recent years. As attention spans decrease and the amounts of quantitative information increase, it is crucial to be able to visualize your data for your audiences in the most clear and effective ways possible. A chart that takes 10 seconds to understand, compared to one that takes only 2 seconds, could mean the difference between a sale and no sale.

Your data is only as powerful as your visual presentation of it.

In this course, you will learn the fundamentals and best practices of data visualization techniques, as well as hands-on approaches to using Microsoft Excel and PowerPoint to present your data in a variety of formats.

You will complete multiple exercises and create various types of visualizations and charts throughout the course. You will also work individually and in groups to analyze, redesign, and improve poorly designed charts that are provided.

  • Understand basic graphic design principles and how audiences process information visually
  • Learn how to make use of emphasis, color, layout, and typography to maximize the clarity of your messages
  • Become familiar with available tools/techniques for data visualization
  • Understand the differences between “Glanceable” and “Referenceable” visualizations and how to harness the power of each
  • Increase the impact and strength of your messages by choosing the most effective chart for a given data set and story in various circumstances
  • Learn the one color that you should make use of in every visualization, the one default element that should be removed from every chart, how legends can confuse your audience, why a bar is nearly always better than a pie, and common design mistakes that distort your data and damage your credibility  
  • The history and current landscape of information and data design 
  • Basic principles of graphic, information, and layout design 
  • “Chart Junk” and how to remove it to improve clarity
  • Basic charts such as pies, columns, bars, lines, and variations of these 
  • Advanced charts such as scatters, bubbles, histograms, bullet graphs, combos, and Paretos
  • Specialty charts including units, tree maps, and proportional shapes
  • How to make use of trend lines, reference bands, annotations, and direct labeling
  • When to use Excel® and PowerPoint® to create tables, how to properly design them, and how to apply conditional formatting to create heat maps and table lenses
  • Tricks, tips, and techniques for overcoming Excel and PowerPoint limitations and creating proper workflows

Special Feature

Note: Participants must bring a PC laptop equipped with Microsoft Office 2010 or later. Those with Mac computers may attend and will be able to follow and perform all exercises, but may not receive as detailed technical attention from the instructor.

Learning Objective

  • Apply Best Practices for Optimizing Data Visualization and information Design to Determine the Most Effective Way to Present the Story of Your Quantitative Information and Data

The World of Data Visualization

  • Discuss the Importance of Information Design and Data Visualization
  • Identify General Options for Telling the Story of Your Data
  • Apply Best Practices for Graphic Design When Presenting Your Data

Chart Types

  • Identify and Eliminate Chart Junk
  • Apply Best Practices for Labeling and Titling When Presenting Your Data
  • Compare and Contrast Three Different Groups of Chart Types
  • Select a Chart Type That Best Communicates and Presents the Data Story You Wish to Tell

This course qualifies for 12 CPUs toward your recertification as a CAP (Certified Analytics Professionals).

American Management Association is accredited by the International Association for Continuing Education and Training (IACET) and is accredited to issue the IACET CEU.

AMA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org. For additional information or for more information regarding administrative policies such as complaints and refunds, please contact Martha Leon at 212-903-8173.

Recommended CPE Credit: 14 hours/Intermediate
Prerequisites: Basic understanding of PowerPoint and Excel
Advance Preparation: None
Delivery Method: Group Live
Field of Study: Non-technical –Communication, Computer Science

Classroom Schedule

8 Sessions Available

  • $2,195.00 Non Members
  • $1,995.00 AMA Members
  • $1,889.00 GSA
Date Duration State City Zip
  2019-09-05 2019-09-06 Sep 5, 2019 - Sep 6, 2019 2 Days IL Chicago 60601 Chicago Register Now

  2019-10-21 2019-10-22 Oct 21, 2019 - Oct 22, 2019 2 Days NY New York 10019 New York Register Now

  2019-11-14 2019-11-15 Nov 14, 2019 - Nov 15, 2019 2 Days MA Boston 02110-1817 Boston Register Now

  2019-12-16 2019-12-17 Dec 16, 2019 - Dec 17, 2019 2 Days DC Arlington/Washington 22202-4807 Arlington/Washington Register Now

  2020-02-20 2020-02-21 Feb 20, 2020 - Feb 21, 2020 2 Days NY New York 10019 New York Register Now

  2020-03-09 2020-03-10 Mar 9, 2020 - Mar 10, 2020 2 Days IL Chicago 60601 Chicago Register Now

  2020-04-23 2020-04-24 Apr 23, 2020 - Apr 24, 2020 2 Days DC Arlington/Washington 22202-4807 Arlington/Washington Register Now

  2020-05-14 2020-05-15 May 14, 2020 - May 15, 2020 2 Days GA Atlanta 30309-7705 Atlanta Register Now

2195.00 $
Close