Data Visualization Essentials for High-Impact Presentations

The Data Visualization course teaching you the ins and outs of business data presentation utilizing Microsoft Excel
4.3 (6 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
143 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 31
  • Length 5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2014 English

Course Description

This A-Z course features detailed lectures on data essentials, pie charts, bar charts, color schemes, textual display, and more -- all within the mindset of an individual presenting business data for a group of users.

In addition to detailed lectures, there are number of Excel walk-through examples that replicate the graphs and charts, along with explanations and further insight along the way.

This course was designed using Microsoft Excel 2007 and virtually every aspect covered in the videos remains relevant to newer versions.

After finishing this course you will have a greater understanding of the visualization techniques used by the best in the industry. Data Visualization is not hard, and after completing this course you will have a working knowledge to help you format and prepare professional business presentations that is sure to be noticed and appreciated by your peers and superiors. Clean out your desk, because after this course you'll be well on your way to your next promotion!

What are the requirements?

  • Microsoft Excel 2007 or newer

What am I going to get from this course?

  • Expand the scope of data visualization skills and theory that can be applied in any and all business settings
  • By the end of this course you will be able to work with your own existing data in Microsoft Excel to create beautiful and meaningful visualizations

What is the target audience?

  • Beginner, Intermediate, and Advanced Microsoft Excel users
  • Business professionals who are responsible for high-profile presentations

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Article

Attached is a detailed goal-oriented statement that provides clarity and context for the scope of the class and what I hope we each gain from the material provided.

Section 2: General Tips and Tricks
2 pages
Attached is a brief textual lesson to help provide the necessary groundwork for a successful, "high impact" presentation. It is important to keep these two key tenets in mind throughout the course -- that is why I've included the downloadable PDF document first!
04:27

In this lecture we learn about the true purpose of data visualization: carrying the message. We discuss the fact that the goal of data visualization is to enable an audience to better comprehend your message. In other words, data visualization helps facilitate audience learning and comprehension.

09:13

This lecture introduces the generic "data cycle" to viewers. Data is circular in the sense that it begins at a point of contact (a sale, for example), is fed into systems, stored, extracted, analyzed and acted upon. This action, whether positive or negative, impacts future sales; thus, the circle continues in this manner and businesses store and analyze an ever-growing amount of information. Understanding this simple concept puts any employee in a better position to understand the data they work with.

03:08

In this lecture we briefly touch on the different types of data patterns and which of their subcategories will be expanded upon further throughout the course.

05:35

Edward Tufte is a pioneer in the data visualization industry and in this lecture we discussion key concepts such as the data-ink ratio.

12:22

Color schemes are instrumental in any data visualization discussion. In this lecture we discuss best practices and walk through several different examples and possible color schemes for users to use in their own presentations.

Section 3: Line Charts
18:27

Our Line Charts section starts off by discussing the concept of line charts, specifically with respect to single-lined charts. We discuss color schemes and several best practice concepts.

Article

In this document we provide the URL necessary for the user to follow along in the same Excel document used in the walk-through examples. The document is downloaded via Dropbox.

15:06

This single-lined Excel walk-through lesson walks through several examples of building and modifying the standard line chart in order to maximize audience impact.

12:57

This single-lined Excel walk-through lesson walks through several examples of building and modifying the standard line chart in order to maximize audience impact.

11:09

In this lecture we add to our discussion on line charts by introducing best practice techniques and theory related to working with multiple-lined data. Specifically, we discuss two scenarios: data that follows a relatively similar pattern, and unorganized data patterns. These two different scenarios call for different implementation techniques and considerations which we discuss.

14:37

In this walk-through lecture we create several multiple-lined charts in Excel and expand our discussion on implementation techniques.

14:43

In this walk-through lecture we create several multiple-lined charts in Excel and expand our discussion on implementation techniques.

05:42

Working with dual axes is a power technique to display multiple data within the same chart. In this lecture we introduce the concept and discuss a vital best practice that will either make or break the dual axes display. We further highlight a few key considerations unique to working with dual axes.

10:10

In this walk-through we go through an example that discussion the best practice techniques in greater detail, along with touching on color schemes and other best practices needed for a successful dual axes chart.

Section 4: Bar Charts
16:29

Bar charts are a key ingredient to any successful presentation. In this lecture we discuss the basic and go over several key best practice requirements to make the most of the power of bar charts.

14:04

In this walk-through we create several examples of vertical and horizontal bar charts while going in-depth with regard to common best practice considerations.

15:54

In this walk-through we create several examples of vertical and horizontal bar charts while going in-depth with regard to common best practice considerations.

14:10

100% stacked bars are a unique and power display option that can provide a unique angle to any data set. This powerful visualization/charting technique is discussed with several examples.

15:47

In this walk-through we go through several 100% stacked bar examples that show the steps and techniques used to create an ideal chart.

Section 5: Pie Charts
05:04

This introductory pie chart lecture introduces the student to common pie chart techniques and, specifically, addresses the common error of less-than-optimal angle rotation display. After this video, the student will be able to create a pie chart with optimal angle rotation, from a data display and visualization perspective.

05:22

This lecture adds to our pie chart discussion by defining the need to limit the number of pie slices in any pie chart. This conclusion is backed up by common-sense evidence that draws attention to the true purpose of the pie chart display in regard to business presentations.

05:15

This pie chart lecture discusses optimal "explosion" techniques and drill-down techniques. After the lecture, the student will be able to analyze explosion options and determine what, if any, explosion technique is best for his/her presentation.

19:10

This pie chart walk-through creates several pie chart examples and holds in-depth discussions on color, angle rotation, explosion, and the number of pie slices. After watching this lecture, the student will be able to build a complete pie chart under several different scenarios using the techniques described.

06:02

This lecture discusses a common pie chart alternative: Pareto Charts. The student will learn to interpret the meaning of this alternative presentation technique.

15:14

In this walk-through the student will learn to create an ideal Pareto chart as a pie chart alternative. More in-depth discussions around this concept are also introduced and explored.

02:05

A brief note, drawing attention to an update on the original Pareto Chart walkthrough video.

Section 6: Chart Details
07:40

The important, yet often overlooked, idea of working visually with text is discussed in this lecture and several "easy win" solutions are offered to the student as options for presenting text within a business presentation.

08:45

Often overlooked details such as text alignment and axes labeling are discussed here. The student will learn more about these details which, if skipped, can jeopardize the integrity of any presentation.

19:22

In this walk-through example we recreate several of the techniques shown in the Text and Boring Stuff lectures. The student will be able to recreate these as needed, or, modify based on several best practice techniques.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Erik Baker, Senior Data Management and Quality Business Analyst

I work as a Senior Business Analyst in the Business Intelligence arm of a Fortune 500 investment services company. My role is focused solely on developing Business Intelligence products (Product Development), specifically operational and executive dashboard solutions for the highest-level executives of leading global financial firms.

I have a Master of Science degree in Business Intelligence and have extensive experience with data visualization, data mining, statistics, predictive analytics and process modeling.

Ready to start learning?
Take This Course