Course
Data Analytics
54 hours 56 minutes
Credits: 3 Credits
Description
In this course, learners will build a strong foundation in data analytics – from understanding data types, quality, and statistical thinking to creating meaningful visualizations and communicating insights effectively. Learners will develop hands-on skills in Excel for data exploration, analysis, and pivot tables, and will use SQL to query, manipulate, and aggregate data across relational databases. They will master data visualization and storytelling in Tableau, building interactive dashboards and compelling visual narratives. Learners will also apply classification algorithms including K-Nearest Neighbors, Decision Trees, and Support Vector Machines, and explore unsupervised learning techniques such as clustering and Principal Component Analysis (PCA) alongside feature engineering methods.
What Students Will Learn
- Case Studies in Data Literacy
- Data Types and Quality
- Statistical Thinking
- Movie Statistics Lab
- Data Visualization Basics
- Misleading and Confusing Graphs
- Data Viz Basics Lab
- Analyzing Data
- Exploring Data In Excel
- Formatting Cells and Ranges in Excel 365
- Explore Data In Excel Lab: GDP
- Visualizing Data In Excel
- Visualizing Data In Excel Lab: Hotel Cancellation Rates
- Handling Data In Excel
- Handling Data In Excel Lab: Hotel Bookings
- Pivot Tables In Excel
- Data Analysis and Visualization In Excel Capstone Lab: Bitcoin Prices
- SQL Overview
- SQL Manipulation
- SQL Lab: Create A Table with SQL
- Queries
- SQL Lab: New York Restaurants
- Aggregate Functions
- SQL Lab: Trends in Startups
- SQL Lab: Analyze Hacker News Trends
- Query Multiple Tables with SQL
- SQL Lab: Lyft Trip Data
- SQL Window Functions
- SQL Math and Date Functions
- SQL Window Functions: Climate Change Lab
- Opening & Connecting Data Sources in Tableau Desktop
- Preparing & Cleaning Data in Tableau Desktop
- Blending & Managing Data Files in Tableau Desktop
- Working with Data & Fields in Tableau Desktop
- Creating Data Visualizations in Tableau Desktop
- Analyzing Data in Tableau Desktop
- Performing Calculations in Tableau Desktop
- Going Deeper with Maps in Tableau Desktop
- Enhancing Data Visualizations in Tableau Desktop
- Presenting & Delivering Vizzes in Tableau Desktop
- Tableau: Storytelling Tools
- Tableau Desktop: Real Time Dashboards
- K-Nearest Neighbors
- K-Nearest Neighbors Regression
- K-Nearest Neighbors: Classification Lab
- Decision Trees
- Decision Trees Lab: Flag Predictions
- Support Vector Machines
- Support Vector Machines Lab: Baseball
- K Means Clustering
- K Means Clustering Lab: Handwriting Recognition using K-Means
- Clustering Techniques
- Principal Component Analysis (PCA)
- Principal Component Analysis (PCA) Lab: Telescope Data
- What is Feature Engineering?
- Numerical Transformations
- Data Transformations Lab
- Evaluation Metrics for Classification Tasks
- Manipulation Cheatsheet
- Query Multiple Tables with SQL Cheatsheet
- Visualizing Data In Excel Cheatsheet
- Handling Data In Excel Cheatsheet
- Pivot Tables In Excel Cheatsheet
- Exploring Data In Excel Cheatsheet
Overall Learning Outcomes
- Apply data literacy principles to evaluate data quality, types, and real-world case studies
- Use statistical thinking to analyze and interpret data accurately and responsibly
- Create and critically assess data visualizations, identifying misleading or confusing representations
- Explore, format, handle, and visualize data in Excel using pivot tables and analytical functions
- Write SQL queries to manipulate, aggregate, and join data across relational databases using window and math functions
- Connect, prepare, and blend data sources in Tableau Desktop to build interactive dashboards and data stories
- Apply classification algorithms including K-Nearest Neighbors, Decision Trees, and Support Vector Machines to real-world datasets
- Implement unsupervised learning techniques including K-Means Clustering and Principal Component Analysis (PCA)
- Engineer and transform features to improve model performance and evaluate classification results using appropriate metrics

