Skip to Content

Learn how to transform data into compelling graphics and dashboards using Excel and Tableau. During this course, you’ll become fluent in the necessary tools to create elements of dashboard design, analyze social networks and generate basic statistics. You will also learn why analytics are essential to successful organizations and explore contemporary issues in data ethics.

who should take this course?

Data Visualization Using Excel and Tableau is an introductory course that is ideal for individuals who use data to make or influence decisions. Whether you work with data occasionally or every day, this course will give you the skills and strategies to turn flat data into a compelling story.

Course pricing and details:

  • 3-Credit Tuition: $897
  • Non-Credit Tuition: $705
  • Fees: $40 Registration Fee (required for both credit and noncredit options)
  • Duration: 8 Weeks

Course Outline

Week One

  • What is Data Visualization?
  • Designing Effective Visualizations
  • Using Excel and Tableau for Data Visualization
  • Tableau Fundamentals
  • Excel Pivot Tables

Week Two

  • Your First Tableau Visualizations
  • Customizing Data in Tableau
  • Basic Tableau Visualizations
  • Basic Excel Visualizations
  • Data Dashboards
  • Creating a Dashboard in Tableau and Excel

Week Three

  • Advanced Tableau Visualizations
  • Additional Advanced Tableau Visualizations
  • Advanced Visualizations with Excel

Week Four

  • Time Series Data
  • Creating Time Series Visualizations in Tableau and Excel
  • Data Maps and Geopolitical Data
  • Creating Data Maps in Tableau and Excel

Week Five

  • Interactive Dashboards
  • Dashboard Actions in Tableau and Excel
  • Dashboard Alerts in Tableau

Week Six

  • Business Intelligence and Analytics
  • Types of Analytics
  • Descriptive, Diagnostic and Predictive Analytics
  • A Prescriptive Analytic: The What-If Analysis

Week Seven

  • Network Data
  • What is a Data Bubble?
  • Creative Network Data Visualizations

Week Eight

  • Data Visualization and Storytelling
  • Understand the Context
  • Choose an Appropriate Display
  • Design Elements
  • Ethics of Storytelling with Data

Course Author

Course Author

Candice Bradley Photo

Candice Bradley

Candice Bradley is a quantitative anthropologist, teaching courses in the data sciences. She received a Ph.D. in social science from UC Irvine, which has produced the most quantitative anthropologists in the US. She studied women’s empowerment and fertility in Africa and has done research in Kenya and Zimbabwe. Bradley’s underlying interest is in research methods and data analysis, which has led her to the study of data visualization.

Course: Data Visualization Using Excel and Tableau