Data Visualization Fundamentals

Course Description:

This Data Visualization Fundamentals course, taught at Bridgerland Technical College, introduces students to the core principles of data visualization essential for data analysis. With a focus on practical application using industry-standard tools, participants learn to translate complex datasets into compelling visual stories. The course covers visualization design fundamentals, data cleansing, and  exploration of interactive dashboards. Through consideration of ethical principles throughout the course, learners cultivate aptitude essential for creating impactful visualizations. Through hands-on projects, individuals refine their skills, gaining the ability to extract insights effectively and drive informed decision-making across diverse industries.

Course Contents:

Course materials include a syllabus and an .imscc file. The syllabus includes an introduction, course description, course objectives, course activities, and more. The .imscc file includes numerous folders and files from the Canvas course. Below is a list of modules and a sample of topics:

• Module 1 - Introduction to Data Visualization
  • Introduction to Data Visualization Course Overview
    • Introduction to Data Visualization
    • Microsoft Power BI-2
  • Importing Data & Connecting Sources
  • Navigating Power BI
    • Report View
    • Power Query Editor-2
• Module 2 - Data Preparation in Power BI
  • Data Cleaning Overview
    • Data Cleaning-2
      • Missing Values
      • Duplicate Data-2
      • Anonymizing Data-2
      • Erroneous Data
      • Cleaning Methods
  • Data Structure & Design
  • Power Query Editor
  • DAX
  • Data Modeling
    • Relationships in Model View-2
  • Flight Analysis - Data Preparation Assignment
• Module 3 - Introduction to Statistical Charts
  • Common Statistical Charts Overrview
    • Bar Charts
    • Line Charts
    • Pie Charts-2
    • Scatterplots-2
    • Box & Whisker Plots
    • Histograms-2
    • Other Report Graphics
  • Flights Analysis - Create Charts Assignment
• Module 4 - Chart Creation in Power BI
  • Filters, Slicers, and Drill Down Overview
  • Filters, slicers, and Drill Down
    • Filters-2
    • Slicers-2
    • Drill Down
    • More Visualization & Charts-2
  • Chart Design Guidelines
  • Flight Analysis - Drill Down Assignment
• Module 5 - Dashboard & Report Design
  • Branding & Style Guidelines Overview
  • Branding & Style Guides
  • Dashboard Design
    • Dashboard Background-2
    • Dashboard Details
    • Interactive Elements
  • Publishing & Sharing
  • Flight Analysis - Dashboard Design Assignment
• Module 6 - Presentation and Written Report
  • Presentation Overview
  • Presentation
  • Written Report
    • Flights Analysis - Written Report Assignment
    • Flights Analysis - Presentation Assignment