NOTE: Note that the National CTC was funded by an NSF ATE grant. As such, curriculum is intended for use solely by educators of North American secondary and post-secondary institutions. To access the content, visit the CTC's public "Curriculum" legacy drive.
Description: This course what is called the data collection process - a process to develop, acquire, and prepare data albeit briefly. These data processes can include any kind of application system data, log data, a web site or survey data (or even big data). We will overview database principles and data preparation. Keep in mind that once we have data for storage (loaded), we need to use the data to create visualizations, help make decisions, and tell the data story. That is where this course comes in. But whether you're a web designer, programmer, network manager, user support technician, network engineer, or security expert (and others), we all need to be able to present data in an honest and convincing manner. That's why this “Data Visualization” class develops important skills for ALL information workers as data literacy. We have aimed to help even more than just data analytics related roles.
Course Outcomes: By the end of this course, students will be able to…
• Clean and manipulate raw data and prepare the data for analysis.
• Describe the different ways to visualize data and data visualization tools.
• Use data visualization tools to analyze data and produce reports.
• Complete the steps to design and implement a dashboard.
Introduction to Power BI
Data Preparation and Analysis using BI
Cleansing and Transforming Using Power BI and Recognizing BPM
Visualization Intro and Intro to Tableau
Fundamentals of Modeling, Visualization, and DQ
Best Practices, Privacy, and Ethics with Data
Using Color in Visualization and Dashboard Design
Typography and Data Visualization
Incorporating Interactive Data Visualization
Including Mapping Data
Please remember this curriculum is copyrighted material and is intended for public education use only.