Data Analytics Certificate Online
A 156-hour certificate focused on the working analyst's toolkit. It starts with data analysis in Excel and SQL, covering pivot tables, lookup functions, and macros alongside SQL for retrieving, filtering, and sorting data, then moves into Python for...
What's included
- Software access during the course
- 156 hours of project-based instruction
- 413 training videos
- One additional elective course
- Instructor support for questions during the course
- Additional one-on-one mentoring outside class
- Verified digital certificate of completion
- Instruction at an ACCET-accredited school
Overview
A 156-hour certificate focused on the working analyst's toolkit. It starts with data analysis in Excel and SQL, covering pivot tables, lookup functions, and macros alongside SQL for retrieving, filtering, and sorting data, then moves into Python for automation work such as web scraping and reporting.
Later coursework turns results into interactive dashboards using Python visualization libraries and Tableau, and introduces machine learning with Pandas and scikit-learn, including data cleaning, balancing, and model building. The program ends with a data science capstone.
Who this course is for
People starting out as data or business analysts, and anyone wanting a working foundation in data visualization, Python, statistics, and database querying.
Tuition & enrollment
Enroll with Virtual Design and Construction Institute, the course provider.
Loading enrollment options…
Prefer to enroll directly? Open the course website.
Preview the course
Watch free previews and explore the lessons included with enrollment at VDCI.
Data Analytics Foundations Course Online
-
Central Tendency
Lesson 1: Basic Data Analysis
10:00
Explain measures of central tendency, including mean, median, mode, and mid-range, using examples and Excel functions to analyze data distribution.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Mixed Reference
Lesson 1: Basic Data Analysis
5:50
Use mixed cell referencing to efficiently apply formulas across multiple cells by locking either columns or rows, enabling quick calculations in spreadsheets.
View enrollment options at VDCI -
Enrollment required
Position
Lesson 1: Basic Data Analysis
15:05
Compare data using percentiles to rank positions and quartiles to divide data into four equal parts, visualizing results with box-and-whisker charts for risk assessment.
View enrollment options at VDCI -
Enrollment required
Dispersion
Lesson 1: Basic Data Analysis
15:26
Explain measures of dispersion by using standard deviation and variance to describe how far data points fall from the mean.
View enrollment options at VDCI -
Enrollment required
Normal Curve
Lesson 1: Basic Data Analysis
17:38
Create a bell curve using the normal distribution function by calculating the mean and standard deviation, and use z-scores to determine standard deviations from the mean.
View enrollment options at VDCI -
Enrollment required
Descriptive Statistics
Lesson 1: Basic Data Analysis
13:46
Summarize descriptive statistics concepts such as skewness, kurtosis, and standard error, and demonstrate how to use Excel's analysis tool pack to generate relevant statistical calculations.
View enrollment options at VDCI -
T Test
Lesson 2: Predictive Analytics I
10:00
Run a paired T-Test using the Data Analysis Toolpak in Excel to determine the significance of performance changes by comparing t-stat and p-values before and after an intervention.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Correlation
Lesson 2: Predictive Analytics I
16:28
Examine linear relationships between variables by calculating correlation coefficients, recognizing that correlation does not imply causation.
View enrollment options at VDCI -
Enrollment required
Series Forecast
Lesson 2: Predictive Analytics I
6:09
Forecast future values using Excel's fill series tool for linear or exponential growth patterns.
View enrollment options at VDCI -
Enrollment required
Forecasting
Lesson 2: Predictive Analytics I
17:23
Explore forecasting in Excel using methods like least sum of squares, exponential smoothing, and confidence intervals to predict future data based on historical trends.
View enrollment options at VDCI -
Enrollment required
Regression
Lesson 2: Predictive Analytics I
8:41
Explain how to use linear regression and Excel tools to model and predict relationships between dependent and independent variables.
View enrollment options at VDCI -
Enrollment required
Regression Analysis
Lesson 2: Predictive Analytics I
9:24
Calculate regression analysis using linear regression, predict future outcomes, and evaluate correlation strength with R-squared.
View enrollment options at VDCI -
Enrollment required
Simple Linear Regression
Lesson 2: Predictive Analytics I
9:17
Estimate the relationship between variables using Excel's analysis tool pack to determine the least sum of squares regression equation, assess its predictive accuracy, and calculate the independent variable's contribution.
View enrollment options at VDCI -
Enrollment required
Multiple Regression
Lesson 2: Predictive Analytics I
6:36
Perform a multiple regression analysis using the data analysis tool pack to identify the impact of employees, products, and advertising expenses on company revenue.
View enrollment options at VDCI -
Histogram
Lesson 3: Data Visualization I
10:00
Create histograms by using the analysis tool pack to group data into intervals and visualize frequency distributions for categories and seniority levels.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Moving Averages
Lesson 3: Data Visualization I
7:40
Calculate different types of moving averages to smooth data and assess recent trends, including simple, weighted, and exponential methods.
View enrollment options at VDCI -
Enrollment required
Charts
Lesson 3: Data Visualization I
7:53
Transform data into visual insights using stacked column, area, tree map, funnel, and pie charts for clear representation of values and relationships.
View enrollment options at VDCI -
Probability 1
Lesson 4: Probability
10:00
Summarize the key points about probability, including concepts like zero to one range, law of large numbers, calculating probabilities using Excel's RAND function, and applications in games like card drawing and craps.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Probability 2
Lesson 4: Probability
13:34
Calculate probabilities and analyze independent versus dependent events, expected values, fair prices, and conditional probability.
View enrollment options at VDCI -
Enrollment required
Binominal
Lesson 4: Probability
14:18
Calculate the probability of a specific number of successes in a fixed number of independent binary (success/failure) trials using binomial distribution.
View enrollment options at VDCI -
Enrollment required
Poisson Distribution
Lesson 4: Probability
11:11
Calculate the probability of a specific number of events occurring within a fixed interval using the Poisson distribution.
View enrollment options at VDCI -
Enrollment required
Monte Carlo
Lesson 4: Probability
12:25
Use Monte Carlo simulation to assess the likelihood of achieving a profit over $10,000 by modeling revenue and costs with variable distributions and calculating outcomes over 300 scenarios.
View enrollment options at VDCI -
Enrollment required
Resampling
Lesson 4: Probability
12:15
Resample data by using techniques like RANDBETWEEN and VLOOKUP to fill in missing information and make statistical inferences, allowing for comparison and analysis despite incomplete data.
View enrollment options at VDCI -
Enrollment required
Statistics
Lesson 4: Probability
9:30
Calculate weighted averages and total salaries with conditions using the SUMPRODUCT function alongside SUMIF as needed.
View enrollment options at VDCI -
Scenario Manager
Lesson 5: Prescriptive Analytics I
10:00
Use Excel's Scenario Manager to create, edit, and summarize different financial scenarios, such as base, best-case, and worst-case scenarios, for revenue growth, profit margin, and price per earnings, and generate a summary report to compare their impacts on projected revenues and values.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Scenario Manager 2
Lesson 5: Prescriptive Analytics I
10:20
Use the Scenario Manager in Excel to create and analyze multiple hiring scenarios, summarizing the financial impact of hiring up to five new employees on company benefits.
View enrollment options at VDCI -
Enrollment required
Solver 1
Lesson 5: Prescriptive Analytics I
11:46
Install Solver through Excel's add-ins, set objective and constraints, and use it to determine optimal production quantities for maximum profit.
View enrollment options at VDCI -
Enrollment required
Solver 2
Lesson 5: Prescriptive Analytics I
4:29
Use Solver to abandon Project B to maximize net present value while keeping capital usage within available limits.
View enrollment options at VDCI -
Enrollment required
Solver 3
Lesson 5: Prescriptive Analytics I
9:07
Attempt to use Excel Solver to optimize the route between cities for minimal travel distance, potentially reducing total miles from 18,275 to a lower value using GRG nonlinear or evolutionary techniques.
View enrollment options at VDCI -
Pivot Tables
Lesson 6: Data Visualization II
10:00
Create and analyze pivot tables to summarize data, perform calculations, and visualize information using pivot charts and slicers for efficient data manipulation and interpretation.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Sparklines
Lesson 6: Data Visualization II
7:55
Visualize data trends using sparklines by inserting miniature, single-cell charts like lines, columns, or win/loss indicators to represent changes and highlight high or low points.
View enrollment options at VDCI -
Enrollment required
Color Scales
Lesson 6: Data Visualization II
8:28
Apply color scales and icon sets to format cells based on their values, sort data in ascending or descending order, and use the percentile function to determine threshold values for conditional formatting.
View enrollment options at VDCI
Python for Data Science Course Online
-
Introduction to Python for Data Science
Lesson 1: Python for Data Science Fundamentals
9:06
Download, unzip, and upload course files to Google Drive, then open and edit copies in Google Colab with AI assistance turned off and line numbers enabled to support hands-on coding practice.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Variables
Lesson 1: Python for Data Science Fundamentals
21:19
Explain how variables, data types, and string operations function in Python programming.
View enrollment options at VDCI -
Enrollment required
Integer and Decimal
Lesson 1: Python for Data Science Fundamentals
20:07
Differentiate integers and decimals, apply math operators, convert between strings and numeric types, and manage string concatenation in Python.
View enrollment options at VDCI -
Enrollment required
Input Function
Lesson 1: Python for Data Science Fundamentals
8:30
Capture user input with the input function, convert values to integers or floats, apply the correct order of operations, and use modulus to convert total minutes into hours and minutes.
View enrollment options at VDCI -
Enrollment required
Input Function Part 2
Lesson 1: Python for Data Science Fundamentals
4:39
Apply the modulus operator to format movie duration by separating hours from remaining minutes.
View enrollment options at VDCI -
Enrollment required
Round Function
Lesson 1: Python for Data Science Fundamentals
6:00
Process numerical input by converting strings to floats, rounding values, and calculating percentages in practical scenarios such as billing.
View enrollment options at VDCI -
Enrollment required
Cafe Bill Challenge Solution
Lesson 1: Python for Data Science Fundamentals
14:12
Calculate a café bill by collecting food, beverage, and tip inputs, computing subtotals, tax, and tip amounts separately, formatting currency values, and presenting a final total.
View enrollment options at VDCI -
Enrollment required
Boolean
Lesson 1: Python for Data Science Fundamentals
5:32
Explain Boolean values and comparison operators, and how they evaluate conditions as true or false.
View enrollment options at VDCI -
Enrollment required
List Data Type
Lesson 1: Python for Data Science Fundamentals
15:52
Describe how lists work in Python, including creation, indexing, slicing, and accessing nested lists.
View enrollment options at VDCI -
Enrollment required
Methods Functions
Lesson 1: Python for Data Science Fundamentals
18:45
Explain object methods with a focus on list methods such as append, pop, sort, and extend, and distinguish methods from standalone functions.
View enrollment options at VDCI -
Enrollment required
Set & Vector Operation
Lesson 1: Python for Data Science Fundamentals
14:37
Use sets to manage unique values, remove duplicates from lists, and perform basic set and list operations.
View enrollment options at VDCI -
If Else Logic
Lesson 2: Boolean Conditions
9:25
Apply if, elif, and else statements with Boolean logic to control program flow based on conditions.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
If Else Logic Challenge Solution
Lesson 2: Boolean Conditions
16:35
Write Python code that uses conditional logic to evaluate prices and manipulate lists using logical operators such as and and or.
View enrollment options at VDCI -
Datetime Part 1
Lesson 3: Datetime & Random
10:00
Summarize Python modules and demonstrate importing libraries to extend functionality, including random number generation and timezone handling with datetime and pytz.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Datetime Part 2
Lesson 3: Datetime & Random
11:35
Convert and format time values into military and AM/PM formats and generate conditional greetings based on the current hour.
View enrollment options at VDCI -
Enrollment required
Random Module
Lesson 3: Datetime & Random
20:22
Use the random module to generate numbers, sample unique values, shuffle lists, and complete exercises involving scores, dates, and lottery selections.
View enrollment options at VDCI -
Loops
Lesson 4: Loops & Strings
8:57
Explore loops by iterating over lists and ranges with for loops while avoiding infinite loops.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Loop the Nums List Challenge
Lesson 4: Loops & Strings
9:17
Loop through numbers one through ten, square even numbers, cube odd numbers, and print the results.
View enrollment options at VDCI -
Enrollment required
List Methods Review Part 1
Lesson 4: Loops & Strings
13:11
Practice list manipulation by extending lists, inserting and removing elements, popping by index, removing duplicates, and rearranging items without sorting.
View enrollment options at VDCI -
Enrollment required
List Methods Review Part 2
Lesson 4: Loops & Strings
9:03
Insert specific elements into a list, remove items at given indices, deduplicate values using sets, sort lists, and maintain alphabetical order through targeted insertion.
View enrollment options at VDCI -
Enrollment required
Loop Method Exercise
Lesson 4: Loops & Strings
10:23
Loop through a list to create transformed values, store results in a new list, and selectively print items while skipping defined positions.
View enrollment options at VDCI -
Enrollment required
Loop Challenges
Lesson 4: Loops & Strings
9:37
Apply conditional logic to generate different outputs based on string length or other criteria, such as creating jelly beans, popsicles, jams, or lollipops.
View enrollment options at VDCI -
Enrollment required
In and Not In Operators
Lesson 4: Loops & Strings
16:23
Use in and not in operators to test membership in strings and lists, and apply conditional logic to categorize items based on starting or ending characters.
View enrollment options at VDCI -
Enrollment required
String Methods
Lesson 4: Loops & Strings
34:06
Manipulate strings using methods such as lower, upper, capitalize, replace, and split, while creating modified copies since strings are immutable.
View enrollment options at VDCI -
Enrollment required
Nested Loop
Lesson 4: Loops & Strings
11:01
Create and shuffle a standard 52-card deck using nested loops and simulate dealing hands in a blackjack-style game.
View enrollment options at VDCI -
Dictionaries Part 1
Lesson 5: Dictionaries
10:00
Explore Python dictionaries by working with key-value pairs, nested structures, and list data within dictionaries.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dictionaries Part 2
Lesson 5: Dictionaries
10:39
Add, update, rename, and delete dictionary keys and values, and iterate through dictionary contents.
View enrollment options at VDCI -
Enrollment required
Dictionaries Scrabble Exercise
Lesson 5: Dictionaries
13:11
Build a Scrabble score calculator that converts user input to uppercase, looks up letter values in a dictionary, accumulates points, and outputs a final score.
View enrollment options at VDCI -
Numpy
Lesson 6: Numpy
9:05
Introduce NumPy by importing it as np and using it to convert lists into multi-dimensional arrays for advanced data manipulation.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Numpy Array
Lesson 6: Numpy
18:34
Transform lists into NumPy arrays to enable reshaping, transposing, and other array-based operations.
View enrollment options at VDCI -
Enrollment required
2D Selections with Numpy Array
Lesson 6: Numpy
18:27
Perform two-dimensional selection and slicing in NumPy arrays, including creating matrices and extracting subarrays.
View enrollment options at VDCI -
Pandas Dataframes Part 1
Lesson 7: Pandas Dataframes
10:00
Create and analyze pandas DataFrames by converting lists and dictionaries into tabular structures for data analysis.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pandas Dataframes Part 2
Lesson 7: Pandas Dataframes
10:18
Load external images and display structured data such as a chessboard using pandas DataFrames with customized rows and columns.
View enrollment options at VDCI -
Enrollment required
Pandas Dataframes Part 3
Lesson 7: Pandas Dataframes
14:01
Select specific rows and columns from a DataFrame using the iloc method.
View enrollment options at VDCI -
Enrollment required
Pandas Dataframes Part 4
Lesson 7: Pandas Dataframes
12:21
Manipulate DataFrame sections to model chessboard layouts by slicing rows and columns and assigning pieces through indexing.
View enrollment options at VDCI -
Enrollment required
Pandas Dataframes Part 5
Lesson 7: Pandas Dataframes
6:51
Arrange structured data, such as chess pieces or food items, into DataFrames with associated attributes.
View enrollment options at VDCI -
Enrollment required
Pandas Dataframes Part 6
Lesson 7: Pandas Dataframes
12:17
Create DataFrames by defining column names and value lists of equal length to ensure proper row alignment.
View enrollment options at VDCI -
Enrollment required
Dataframes Location
Lesson 7: Pandas Dataframes
16:20
Access and modify DataFrame data using loc for labels and iloc for integer-based indexing.
View enrollment options at VDCI -
Enrollment required
Select Rows by Condition
Lesson 7: Pandas Dataframes
24:16
Filter DataFrames with Boolean conditions, update or remove rows and columns, and use describe to generate statistical summaries.
View enrollment options at VDCI -
Enrollment required
AT & IAT
Lesson 7: Pandas Dataframes
13:29
Use at and iat for efficient scalar value assignment, apply string filtering with str.contains, and clean text data with str.replace.
View enrollment options at VDCI -
Enrollment required
Dataframes from Dictionary
Lesson 7: Pandas Dataframes
25:15
Create DataFrames from dictionaries, concatenate multiple DataFrames, clean mismatched columns, and manage indices appropriately.
View enrollment options at VDCI -
Enrollment required
Dataframes Challenges
Lesson 7: Pandas Dataframes
6:28
Add new rows to a DataFrame, then create filtered DataFrames based on calorie limits or multi-word names.
View enrollment options at VDCI -
Enrollment required
String Split
Lesson 7: Pandas Dataframes
12:39
Split strings into lists using delimiters, remove file extensions, and manipulate string components with list operations.
View enrollment options at VDCI -
Enrollment required
Select and Filter by Condition
Lesson 7: Pandas Dataframes
21:09
Filter and update DataFrames using multiple logical conditions and create new columns based on calculated values.
View enrollment options at VDCI -
Enrollment required
Vector Operations
Lesson 7: Pandas Dataframes
9:16
Perform vectorized operations on DataFrame columns, sort and rename columns, and rearrange column order using pop and insert.
View enrollment options at VDCI -
Introduction to Matplotlib
Lesson 8: Bar Charts with Matplotlib
10:00
Use Matplotlib to create charts and visualizations, load CSV data into pandas, connect to Google Drive, and calculate summary statistics.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Python Data Selection
Lesson 8: Bar Charts with Matplotlib
18:01
Review slicing techniques with loc and iloc, shuffle and split datasets, and group and sort data by defined criteria.
View enrollment options at VDCI -
Enrollment required
Data Visualization with Matplotlib
Lesson 8: Bar Charts with Matplotlib
21:21
Create bar charts with Matplotlib, label bars clearly, sort data by multiple criteria, and adjust visual presentation.
View enrollment options at VDCI -
Line and Scatter Charts with Matplotlib
Lesson 9: Line & Scatter Charts with Matplotlib
10:00
Plot scatter and line charts with Matplotlib, add regression lines, and highlight minimum and maximum values.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Linear Regression with Matplotlib
Lesson 9: Line & Scatter Charts with Matplotlib
26:39
Apply NumPy and Matplotlib together to perform linear regression, visualize scatter data, and calculate best-fit lines for analysis.
View enrollment options at VDCI -
Pivot, Plot, Animate
Lesson 10: Pivot Population Data & Charts
10:00
Pivot datasets, generate pie charts and bar chart races, and manage missing data in data science workflows.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Data Cleaning
Lesson 10: Pivot Population Data & Charts
27:01
Handle missing data by dropping, filling with averages, removing sparse columns, and exporting clean DataFrames to CSV files.
View enrollment options at VDCI -
Enrollment required
Two Different Ways to Make a Bar Chart
Lesson 10: Pivot Population Data & Charts
18:52
Create bar charts by extracting and indexing country population data for accurate labeling.
View enrollment options at VDCI -
Enrollment required
Pivoting the Data
Lesson 10: Pivot Population Data & Charts
16:20
Pivot population data to restructure years and countries, then visualize trends with line and bar charts.
View enrollment options at VDCI -
Enrollment required
There is Always Time for Pie (Charts)
Lesson 10: Pivot Population Data & Charts
10:54
Generate a pie chart illustrating population shares of selected countries and save the visualization as an image file.
View enrollment options at VDCI -
Enrollment required
Animated Bar Chart Race
Lesson 10: Pivot Population Data & Charts
13:10
Install and configure the bar chart race library and generate an animated visualization showing population changes over time.
View enrollment options at VDCI
SQL Course Online
-
Benefits of Learning SQL
Lesson 1: Setting Up the Work Environment
10:00
Download the PDF workbook and class files, and install the free dBeaver Community Edition to practice SQL querying without modifying databases.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Connecting to Our Database
Lesson 1: Setting Up the Work Environment
14:06
Set up a database connection in dBeaver using the provided credentials, test connectivity, and review available tables.
View enrollment options at VDCI -
Getting Started & Your First Query
Lesson 2: Let's Start Learning SQL Code
10:00
Navigate databases in dBeaver by adjusting preferences, exploring schemas, and running practice queries to build familiarity.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Learning the SQL Language
Lesson 2: Let's Start Learning SQL Code
14:10
Review SQL syntax through slides, live demos, and exercises focused on SELECT, FROM, ORDER BY, DISTINCT, execution order, and result limits.
View enrollment options at VDCI -
Enrollment required
Coding Exercise PostgreSQL
Lesson 2: Let's Start Learning SQL Code
18:29
Connect to the correct database environment and complete Exercise 1C by writing and executing SQL queries.
View enrollment options at VDCI -
Enrollment required
Solution PostgreSQL Challenge
Lesson 2: Let's Start Learning SQL Code
15:11
Query users and orders tables to view, filter, sort, and remove duplicate records.
View enrollment options at VDCI -
Data Types and Filtering Results
Lesson 3: Working with Characters & Numbers
9:28
Differentiate database data types to query text and numeric values correctly, applying quotes and comparison logic appropriately.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Coding Exercise Filtering with WHERE
Lesson 3: Working with Characters & Numbers
5:34
Define the active data source to enable code hints when querying product data based on price conditions.
View enrollment options at VDCI -
Enrollment required
Solution Filtering with WHERE
Lesson 3: Working with Characters & Numbers
22:42
Refine queries to filter specific records, sort results, perform calculations, handle data types accurately, and eliminate duplicates.
View enrollment options at VDCI -
Pattern Matching
Lesson 4: Using SQL Wildcards
4:46
Apply wildcard characters such as percent signs and underscores with LIKE and ILIKE to identify data patterns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Combining Filters and Aliases
Lesson 4: Using SQL Wildcards
4:32
Combine conditions using AND, OR, and NOT, perform calculations, and assign column aliases for clearer result sets.
View enrollment options at VDCI -
Enrollment required
Coding Exercise Like and Wildcards
Lesson 4: Using SQL Wildcards
12:31
Practice filtering records using LIKE, ILIKE, and NOT to control query results precisely.
View enrollment options at VDCI -
Enrollment required
Solution Like and Wildcards
Lesson 4: Using SQL Wildcards
23:49
Explore table structures and ER diagrams to understand relationships and safely query data such as email domains or state-based orders.
View enrollment options at VDCI -
Database Terminology and Primary & Foreign Keys
Lesson 5: Identifying Rows & Connecting Tables
10:00
Connect related tables by identifying primary and foreign keys to manage relationships and avoid duplication.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Joins Combining Data from Multiple Tables
Lesson 5: Identifying Rows & Connecting Tables
12:28
Perform inner joins by matching common columns and using table aliases to simplify query syntax.
View enrollment options at VDCI -
Enrollment required
Exercise Inner Join
Lesson 5: Identifying Rows & Connecting Tables
18:40
Reinforce inner join logic by combining tables, filtering shared data, and presenting unified results.
View enrollment options at VDCI -
Enrollment required
Solution Inner Join
Lesson 5: Identifying Rows & Connecting Tables
10:36
Join users, orders, and line items to identify high-value purchases and return distinct customer details.
View enrollment options at VDCI -
Inner vs. Outer Joins
Lesson 6: Inner vs. Outer Joins
10:00
Compare inner joins with left, right, and full outer joins to understand how non-matching rows are handled.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Exercise Outer Join and NULL
Lesson 6: Inner vs. Outer Joins
23:37
Open the designated file, review warm-up exercises, and complete challenge problems to reinforce learning.
View enrollment options at VDCI -
Enrollment required
Solution Outer Join and NULL
Lesson 6: Inner vs. Outer Joins
34:12
Analyze database relationships to uncover insights such as unsold products or specific purchasing behaviors, then export results as CSV files.
View enrollment options at VDCI -
Cast
Lesson 7: Changing Data Types
10:00
Convert data types within queries using CAST without altering the underlying database structure.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Aggregate Functions
Lesson 7: Changing Data Types
6:33
Apply aggregate functions to calculate totals, counts, minimums, maximums, and averages for analysis.
View enrollment options at VDCI -
Enrollment required
Exercise Aggregate Function and ROUND
Lesson 7: Changing Data Types
27:56
Manipulate aggregated results using rounding functions and column aliases for readable output.
View enrollment options at VDCI -
Enrollment required
Solution Aggregate Function and ROUND
Lesson 7: Changing Data Types
19:00
Build aggregate queries incrementally, validating intermediate results before final execution.
View enrollment options at VDCI -
Date Functions
Lesson 8: Working with Dates
4:39
Work with date and time functions to retrieve current timestamps, extract components, and convert data types.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Exercise 2.0 Date Functions
Lesson 8: Working with Dates
19:52
Extract, format, filter, and convert date values using date_part, to_char, CAST, and range-based conditions.
View enrollment options at VDCI -
Enrollment required
Solution 2.0 Date Functions
Lesson 8: Working with Dates
17:40
Analyze account creation data to determine user age, creation year, weekend sign-ups, and date-range activity.
View enrollment options at VDCI -
Grouping Data
Lesson 9: Organizing Statistical Results Into Categories
10:00
Group records using GROUP BY to apply aggregate functions across defined categories.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Subqueries
Lesson 10: Subqueries
27:41
Nest subqueries within main queries to process intermediate results before final selection.
View enrollment options at VDCI -
Enrollment required
Solution Subqueries
Lesson 10: Subqueries
24:51
Prefer joins over subqueries when appropriate to improve clarity and performance.
View enrollment options at VDCI -
Enrollment required
Aggregate Window Functions
Lesson 11: Aggregate Window Functions
23:01
Use window functions to add aggregate insights while preserving row-level detail.
View enrollment options at VDCI -
Enrollment required
Solution Window Functions
Lesson 11: Aggregate Window Functions
9:34
Apply PARTITION BY within window functions to analyze grouped metrics without collapsing results.
View enrollment options at VDCI -
Enrollment required
Conditionals
Lesson 12: Conditionals
18:26
Create conditional logic with CASE statements to classify, transform, or correct query output.
View enrollment options at VDCI -
Enrollment required
CASE Exercise
Lesson 12: Conditionals
14:36
Categorize data into regions or groups, calculate order counts, and manage joins for broader analysis.
View enrollment options at VDCI -
Enrollment required
Views
Lesson 13: Views
18:50
Save reusable queries as views to simplify access, enhance security, and streamline workflows.
View enrollment options at VDCI -
Enrollment required
Views Solution
Lesson 13: Views
0:46
Summarize and filter user spending patterns using flexible query criteria.
View enrollment options at VDCI -
String Functions
Lesson 14: String Functions
9:09
Manipulate text data with string functions to change case, extract substrings, split values, and evaluate length.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Learning Resources
Lesson 15: Additional Resources
3:24
Reinforce skills through external SQL resources, practice platforms, cheat sheets, and coding challenges.
View enrollment options at VDCI -
Enrollment required
Finding Datasets
Lesson 15: Additional Resources
2:04
Source datasets from Kaggle and convert them into usable databases with guided setup support.
View enrollment options at VDCI -
AI and SQL
Lesson 16: AI and SQL
10:00
Use AI tools such as ChatGPT to explain, refine, and generate SQL queries while validating results independently.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Challenge AI and SQL
Lesson 16: AI and SQL
5:13
Generate SQL queries from database visuals using tools like Chat2BT, specifying structure and dialect requirements.
View enrollment options at VDCI -
Enrollment required
Solution AI and SQL
Lesson 16: AI and SQL
14:13
Apply best practices for using AI-generated SQL by providing clear requirements, verifying accuracy, and learning from explanations.
View enrollment options at VDCI
Python for Automation Course Online
-
APIs Intro
Lesson 1: APIs
5:05
Access data from an API using Python by sending an HTTP request to a specific URL and receiving the expected data response.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
API Keys
Lesson 1: APIs
8:13
Explore the setup and use of the AlphaVantage stock market data API, including obtaining an API key and configuring a Python program to request stock data.
View enrollment options at VDCI -
Enrollment required
HTTP Status Codes
Lesson 1: APIs
5:03
Access an API using Python's requests library to send a GET request to a URL, check the response's status code for errors, and handle data retrieval upon receiving a 200 OK status.
View enrollment options at VDCI -
Enrollment required
JSON
Lesson 1: APIs
3:58
Convert a JSON string response from a web request into a Python dictionary or list using the .json() method from the requests library.
View enrollment options at VDCI -
Enrollment required
Challenge 1 Navigating API Data
Lesson 1: APIs
0:47
Navigate the data variable to find and print the stock information for Apple on the specified date.
View enrollment options at VDCI -
Enrollment required
Challenge 1 Navigating API Data Solution
Lesson 1: APIs
4:29
Access the desired date's data within the time series daily key in the API response dictionary, then retrieve the closing value for Apple on that date.
View enrollment options at VDCI -
Making a Dataframe From Api Data
Lesson 1: APIs
4:22
Transpose the data frame, convert strings to numeric values, and format the index as date times for easier data manipulation.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Challenge 2 Finding Highest Value
Lesson 1: APIs
0:53
Find the highest and lowest stock prices and their respective dates from the data frame.
View enrollment options at VDCI -
Enrollment required
Challenge 2 Finding Highest Value Solution
Lesson 1: APIs
3:07
Find the highest apple price using the numeric value in the dataset and identify the date of that price.
View enrollment options at VDCI -
Plotting Our Api Data and a Plotting Challenge
Lesson 1: APIs
3:29
Plot the low and high apple prices using pyplot's scatterplot method by identifying the lowest and highest prices with their corresponding dates and adding these points to the existing graph.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Plotting Our Data With Bmh and Scatter
Lesson 1: APIs
1:47
Add scatter plots for the highest and lowest apple prices using green and red markers respectively.
View enrollment options at VDCI -
Enrollment required
APIs Conclusion
Lesson 1: APIs
3:13
Access data using APIs by researching, understanding their structure, and extracting information with minimal code.
View enrollment options at VDCI -
Data Scraping Intro
Lesson 2: Data Scraping
4:37
Access data by programmatically scraping it from third-party websites while considering ethical and legal implications.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Data Scraping and HTML
Lesson 2: Data Scraping
7:04
Learn to understand and utilize HTML structure for web scraping by identifying and inspecting elements like headings (H3) to extract specific data efficiently.
View enrollment options at VDCI -
Enrollment required
Our First Data Scraping
Lesson 2: Data Scraping
8:54
Parse an HTML page using BeautifulSoup to extract and print specific text elements like act and scene names from H3 tags.
View enrollment options at VDCI -
Enrollment required
Accessing One Part of a Page
Lesson 2: Data Scraping
4:19
Use BeautifulSoup to extract the desired text from the HTML.
View enrollment options at VDCI -
Challenge 3: Scraping on Your Own
Lesson 2: Data Scraping
0:51
Scrape and print specified text from the page, then find and print the text of the first 10 tags.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Challenge 4: Scraping on Your Own
Lesson 2: Data Scraping
3:04
Identify and extract text from specific HTML elements using BeautifulSoup for web scraping.
View enrollment options at VDCI -
Enrollment required
More Complex Data Scraping Queries
Lesson 2: Data Scraping
8:37
Extract attribute values from HTML elements and find nested elements within specified parent elements.
View enrollment options at VDCI -
Enrollment required
Challenge: Scraping a New Page
Lesson 2: Data Scraping
3:14
Scrape book titles and prices from books2scrape.com using the requests and Beautiful Soup libraries.
View enrollment options at VDCI -
Enrollment required
Challenge: Scraping a New Page Solution
Lesson 2: Data Scraping
12:49
Extract book titles and prices from a webpage using BeautifulSoup by identifying specific HTML tags, handling issues with truncated titles and currency symbols, and converting prices to numerical values.
View enrollment options at VDCI -
Enrollment required
Saving our Scraped Data in a Dataframe
Lesson 2: Data Scraping
1:33
Convert data into a Pandas DataFrame and prepare to scrape all pages for complete results.
View enrollment options at VDCI -
Enrollment required
Challenge: Scraping the Page Number Max
Lesson 2: Data Scraping
1:36
Extract the text from the page element indicating "page 1 of 50" and retrieve the last word to determine the total number of pages.
View enrollment options at VDCI -
Enrollment required
Challenge: Scraping the Page Number Max Solution
Lesson 2: Data Scraping
3:36
Extract the maximum page number by finding the LI element with the class "current," splitting its text into words, and converting the last word to an integer.
View enrollment options at VDCI -
Enrollment required
Scraping an Entire Website
Lesson 2: Data Scraping
8:41
Loop through pages, scrape book titles and prices, and compile into a data frame with 1,000 entries.
View enrollment options at VDCI -
Comparing APIs and Data Scraping
Lesson 3: Comparing APIs and Data Scraping
3:35
Compare using APIs and web scraping in Python to access structured and unstructured data, respectively.
This preview is temporarily unavailable. Please try again later.
Python Data Visualization & Interactive Dashboards Course Online
-
Course Intro
Lesson 1: Environment Setup & Foundations
0:59
Learn to build interactive data visualization apps using Dash by Plotly from setup to advanced interactivity.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Getting Our Class Files
Lesson 1: Environment Setup & Foundations
3:13
Download the class files from GitHub as a ZIP, unzip them directly into your Downloads folder (avoiding nested folders), and prepare for Anaconda installation.
View enrollment options at VDCI -
Installing Anaconda
Lesson 1: Environment Setup & Foundations
2:31
Download and install Anaconda from anaconda.com, selecting the correct version for your operating system and following the installation instructions.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Our First Terminal Command
Lesson 1: Environment Setup & Foundations
4:23
Learn to open and use a terminal emulator to run basic text-based commands like echo in a command-response cycle.
View enrollment options at VDCI -
Enrollment required
Understanding the Prompt
Lesson 1: Environment Setup & Foundations
5:34
Understand the terminal prompt as an indicator of your current Python environment, user, computer, and directory, signaling when it’s ready to accept commands.
View enrollment options at VDCI -
Creating Our Python Environment
Lesson 1: Environment Setup & Foundations
7:22
Create and activate a Python virtual environment using conda to isolate project-specific dependencies.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Configuring Our Python Environment
Lesson 1: Environment Setup & Foundations
4:42
Configure the DVENV Python environment to use CondaForge as the exclusive package source and install the latest versions of pandas, dash, and dash-bootstrap-components.
View enrollment options at VDCI -
Enrollment required
Opening Our Class Files
Lesson 1: Environment Setup & Foundations
3:37
Open your curriculum folder in Visual Studio Code, navigate to app.py in Notebook 1, and prepare to write and run code.
View enrollment options at VDCI -
Enrollment required
Running Our Dash App
Lesson 2: Building Core Dash Visuals
5:49
Navigate to your project directory in the terminal, activate the dvenv environment, run your app.py file using the python command, and open the provided local URL in your browser to view your Dash app.
View enrollment options at VDCI -
Enrollment required
Intro to Dash
Lesson 2: Building Core Dash Visuals
5:48
Understand how Dash, a Python library, builds interactive web dashboards by converting Python code into HTML, CSS, and JavaScript, and learn how to run, modify, and refresh a basic Dash app using app layout definitions and live server updates.
View enrollment options at VDCI -
Enrollment required
an Html Primer
Lesson 2: Building Core Dash Visuals
7:55
Understand basic HTML structure and tags like H1-H6 for headings, P for paragraphs, and DIV/SPAN for layout and inline text, focusing on how elements nest as parent and child.
View enrollment options at VDCI -
Enrollment required
Formatting Our Data
Lesson 2: Building Core Dash Visuals
11:45
Import stock data from a CSV file using Pandas, filter the top five stocks by trading volume, convert volume figures to millions, round them to one decimal place, and prepare the data for visualization.
View enrollment options at VDCI -
Creating a Pie Chart
Lesson 2: Building Core Dash Visuals
6:32
Create a pie chart using Plotly Express to visualize the top five stocks by volume and embed it into the dashboard using Dash core components.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Why Data Viz and Why Dash
Lesson 2: Building Core Dash Visuals
4:03
Explain how simple data visualizations like pie charts, built with Dash, help reveal insights—such as Apple’s dominance in trading volume—and offer advantages over tools like Jupyter Notebooks for creating interactive, shareable web applications.
View enrollment options at VDCI -
Enrollment required
Composing Elements
Lesson 2: Building Core Dash Visuals
4:55
Add a heading, author name, and pie chart as a list of children to an HTML.Div to structure the dashboard layout.
View enrollment options at VDCI -
Enrollment required
Creating a Bar Chart
Lesson 2: Building Core Dash Visuals
4:47
Compare company stock volumes using a bar chart to highlight relative differences versus overall proportions shown in a pie chart.
View enrollment options at VDCI -
Enrollment required
Adding Further Visualizations
Lesson 2: Building Core Dash Visuals
7:45
Explore different data visualizations—horizontal bar and scatter plots—to assess data relationships and determine the most effective format for analysis.
View enrollment options at VDCI -
a Quick Demo of Dash Interactivity
Lesson 2: Building Core Dash Visuals
2:51
Explore interactive Dash features that allow users to zoom, filter, and analyze specific data segments directly within visualizations.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Summing Up Section 1
Lesson 2: Building Core Dash Visuals
1:44
Build a functional dashboard using Dash with interactive layouts and data visualizations.
View enrollment options at VDCI -
Enrollment required
VS Code Jupyter Setup
Lesson 3: Pandas & Function Essentials
5:09
Review basic Python and pandas skills in Jupyter Notebooks using VS Code with the correct extensions and environment setup to prepare for advanced data visualization with Dash.
View enrollment options at VDCI -
Reading in Our Data to a Notebook
Lesson 3: Pandas & Function Essentials
4:18
Import pandas, read a CSV of company stock and market data into a DataFrame, and interact with it in a Jupyter notebook using VS Code.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pandas Practice
Lesson 3: Pandas & Function Essentials
15:00
Practice pandas by transforming market cap values, dropping unnecessary columns and zero-priced rows, filtering for specific companies, calculating statistics like max and average prices, counting entries under a threshold, and retrieving targeted data points.
View enrollment options at VDCI -
Enrollment required
Creating a Pandas and Pyplot Pie Chart
Lesson 3: Pandas & Function Essentials
7:34
Group companies by country, sum their market caps, sort to find the top five, and plot them in a pie chart using matplotlib.
View enrollment options at VDCI -
Enrollment required
Viewing Our Pie Chart
Lesson 3: Pandas & Function Essentials
1:51
Install missing packages as needed during development, then proceed with data formatting and plotting in the notebook.
View enrollment options at VDCI -
Enrollment required
Reintroducing Functions
Lesson 3: Pandas & Function Essentials
5:54
Learn how to define and use functions, including lambdas and apply, for advanced data manipulation in a data frame.
View enrollment options at VDCI -
Enrollment required
Challenge Writing Your Own Function
Lesson 3: Pandas & Function Essentials
4:46
Define a function addCents that returns a given dollar amount plus a random number of cents rounded to two decimal places using random.random.
View enrollment options at VDCI -
Named Lambdas
Lesson 3: Pandas & Function Essentials
3:58
Use lambda functions to create concise, one-line operations that take inputs and return computed values without requiring formal function definitions.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Apply
Lesson 3: Pandas & Function Essentials
4:28
Create a DataFrame with numbers from 10,000 to 10,010 and use apply to transform the column with function calls, including chaining and anonymous lambdas.
View enrollment options at VDCI -
Enrollment required
Anonymous Lambdas With Apply
Lesson 3: Pandas & Function Essentials
6:01
Use both a named function and an anonymous lambda with apply to convert numeric values into formatted dollar strings, optionally adding commas for readability.
View enrollment options at VDCI -
Enrollment required
Apply Challenge Solution
Lesson 3: Pandas & Function Essentials
4:08
Format dollar amounts with commas using a custom function or lambda and apply it to a DataFrame column.
View enrollment options at VDCI -
Enrollment required
Using Apply With Real Data
Lesson 3: Pandas & Function Essentials
8:31
Convert string-based percentage and volume columns from a stock CSV file into usable numeric formats using pandas, apply, lambda functions, and string manipulation.
View enrollment options at VDCI -
Enrollment required
Lambdas With Ternaries
Lesson 4: Data Analysis & Multi-Graph Dashboards
9:27
Create a column called advice using apply with a lambda that returns "buy" if last_price < 200, else "sell".
View enrollment options at VDCI -
Enrollment required
Exploring The Chipotle Data
Lesson 4: Data Analysis & Multi-Graph Dashboards
7:21
Analyze Chipotle order data to extract item prices, identify the most expensive item, and prepare for revenue calculations.
View enrollment options at VDCI -
Enrollment required
Grouping To Get Total Revenue
Lesson 4: Data Analysis & Multi-Graph Dashboards
4:00
Group Chipotle order data by item name to calculate total quantities and total revenue for each item, then extract specific values (like for "chicken bowl") using .loc for further analysis and visualization.
View enrollment options at VDCI -
Graphing Our Revenue
Lesson 4: Data Analysis & Multi-Graph Dashboards
4:55
Identify the top-selling items by revenue using n-largest, then plot the top 5 as a bar chart with proper labels and styling.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dash App Setup Redux
Lesson 4: Data Analysis & Multi-Graph Dashboards
5:27
Set up your Dash app by activating the correct Python environment and navigating to the proper project directory.
View enrollment options at VDCI -
Enrollment required
Manipulating The Data In A Python File
Lesson 4: Data Analysis & Multi-Graph Dashboards
5:31
Run the Dash app from the Notebook2 directory, load and clean the Chipotle CSV data, compute revenue by item, extract the top five items, and prepare figures for dashboard display.
View enrollment options at VDCI -
Adding A Pie Graph
Lesson 4: Data Analysis & Multi-Graph Dashboards
4:54
Replace the header with a div containing a dcc.Graph that displays a Plotly Express pie chart based on the top five item prices.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adding A Second Graph
Lesson 4: Data Analysis & Multi-Graph Dashboards
3:26
Add a bar chart alongside the pie chart using a list of multiple dcc.Graph components to display both figures with built-in interactivity.
View enrollment options at VDCI -
Enrollment required
Adding All Graphs
Lesson 4: Data Analysis & Multi-Graph Dashboards
2:55
Add additional bar and scatter plots, adjust their orientation and visual properties, then address layout issues by organizing the graphs using Bootstrap for better presentation.
View enrollment options at VDCI -
Enrollment required
Bootstrap
Lesson 4: Data Analysis & Multi-Graph Dashboards
10:35
Use Bootstrap’s responsive layout system with containers, rows, and columns to arrange Dash components cleanly and control their sizing across screen sizes.
View enrollment options at VDCI -
Enrollment required
Final Dashboard Intro
Lesson 5: Interactive Dashboards & Final Project
1:46
Create an interactive Dash dashboard that updates visualizations based on user input using car sales data from carsales.csv.
View enrollment options at VDCI -
Enrollment required
A Basic Scatterplot
Lesson 5: Interactive Dashboards & Final Project
5:36
Create a Dash app in app.py that reads car-sales.csv, builds a Plotly Express scatter plot of horsepower vs fuel efficiency with color indicating price, and displays it in a web layout using Dash components.
View enrollment options at VDCI -
Enrollment required
Running Our Dash App
Lesson 5: Interactive Dashboards & Final Project
4:13
Run the app in the DVEnv environment, view the interactive graph in a browser, and prepare to add company filtering, engine size slider, and detailed tooltips in the next step.
View enrollment options at VDCI -
Creating A Dropdown
Lesson 5: Interactive Dashboards & Final Project
5:14
Create a dropdown using Dash to list unique car manufacturers from a dataset and prepare it to filter the graph based on selection.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Using Dash Callbacks
Lesson 5: Interactive Dashboards & Final Project
13:54
Use a Dash callback decorator to update a graph dynamically based on a user's dropdown selection, replacing the initial figure on page load.
View enrollment options at VDCI -
Enrollment required
Outputting From Our Callback
Lesson 5: Interactive Dashboards & Final Project
3:34
Implement interactive filtering of a car dataset by manufacturer using a dropdown, and update the graph accordingly with an option to display all manufacturers.
View enrollment options at VDCI -
Enrollment required
Adding An All Option
Lesson 5: Interactive Dashboards & Final Project
7:05
Insert an "All Manufacturers" option at the top of the drop-down list, set it as the default selection, and adjust the data filtering logic to display all cars when it's selected.
View enrollment options at VDCI -
Enrollment required
Adding A Range Slider
Lesson 5: Interactive Dashboards & Final Project
4:31
Create a range slider using Pandas min and max engine size values to filter engine sizes from minimum to maximum in step increments of one.
View enrollment options at VDCI -
Making The Slider Interactive
Lesson 5: Interactive Dashboards & Final Project
7:21
Connect the engine size slider to the graph update function by adding it as an input, filter the data based on the selected range, and update the graph accordingly.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Hover Data Intro
Lesson 5: Interactive Dashboards & Final Project
2:25
Enable interactive Dash dashboards by using user actions like hovering to dynamically display additional data in designated output sections.
View enrollment options at VDCI -
Enrollment required
The Final Interactive Element
Lesson 5: Interactive Dashboards & Final Project
22:43
Create a new Dash callback that updates an info panel with detailed car data based on hover events from a graph.
View enrollment options at VDCI -
Course Outro
Lesson 5: Interactive Dashboards & Final Project
0:40
Explore data that interests you and apply your Dash skills to create interactive visualizations.
This preview is temporarily unavailable. Please try again later.
Python Machine Learning Course Online
-
Python for Machine Learning Introduction
Lesson 1: Basic Regression Analysis
2:08
Cover regression analysis, supervised learning essentials, k-nearest neighbors algorithm, random forest classifiers, and neural networks in a structured course.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Colab Setup
Lesson 1: Basic Regression Analysis
3:23
Download the class files zip archive, extract it, and use Google Colab to upload and connect the first Jupyter Notebook to Google Drive.
View enrollment options at VDCI -
Enrollment required
Drive Setup
Lesson 1: Basic Regression Analysis
3:38
Upload the Python Machine Learning Bootcamp folder directly to My Drive in Google Drive to ensure all file paths work correctly in Google Colab.
View enrollment options at VDCI -
Enrollment required
Jupyter Setup
Lesson 1: Basic Regression Analysis
10:14
Learn how to use Jupyter Notebooks for running and explaining Python code blocks in data science and machine learning courses.
View enrollment options at VDCI -
Enrollment required
Loading The Cars Data
Lesson 1: Basic Regression Analysis
7:50
Summarize the process of setting up and troubleshooting Python imports, URLs, and dataframes in Jupyter Notebooks using statistical libraries and CSV files.
View enrollment options at VDCI -
Enrollment required
Pandas Dataframe Slices
Lesson 1: Basic Regression Analysis
8:06
Explore subsets of car data using `iloc` for index-based slicing and `loc` for label-based, more human-readable slicing.
View enrollment options at VDCI -
Challenge 1 Slices
Lesson 1: Basic Regression Analysis
1:01
Retrieve the last three rows and last three columns of the data frame using both ILOC and LOC methods.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Challenge 1 Slices Solution
Lesson 1: Basic Regression Analysis
7:48
Use iloc or loc to select the last three rows and columns of a DataFrame, ensuring correct index handling and semantic representation for dynamic updates.
View enrollment options at VDCI -
Enrollment required
Initial Data Analysis Tools
Lesson 1: Basic Regression Analysis
11:33
Analyze statistical data using Python to find minimum, maximum, and mean values from lists and data frames, employing functions like `min()`, `max()`, and NumPy's `.mean()`, while using methods to handle specific data structures like pandas series.
View enrollment options at VDCI -
Enrollment required
Median
Lesson 1: Basic Regression Analysis
6:48
Explain how the median provides a more accurate representation of typical data than the mean when outliers are present.
View enrollment options at VDCI -
Enrollment required
Mode
Lesson 1: Basic Regression Analysis
2:49
Explain how to calculate the mode using the `stats.mode` function from SciPy, which returns a tuple with the most frequent value and its count.
View enrollment options at VDCI -
Enrollment required
Tuples
Lesson 1: Basic Regression Analysis
5:43
Understand and utilize tuple unpacking in Python to efficiently work with multiple returned values from functions, ensuring immutability and correct assignment order.
View enrollment options at VDCI -
Enrollment required
Averages In Real Data
Lesson 1: Basic Regression Analysis
6:35
Analyze a dataset's central tendencies using pandas methods to calculate the mean, median, and mode, considering the context of outliers and data repetition.
View enrollment options at VDCI -
Enrollment required
Standard Deviation And The Bell Curve
Lesson 1: Basic Regression Analysis
4:42
Explain standard deviation as a measure of how much values deviate from the mean in a normal distribution, where one standard deviation includes about 68.2% of values, two standard deviations cover 95.4%, and three standard deviations encompass nearly all values.
View enrollment options at VDCI -
Enrollment required
Calculating Standard Deviation
Lesson 1: Basic Regression Analysis
2:17
Calculate standard deviation using NumPy, adjusting for degrees of freedom if analyzing a sample.
View enrollment options at VDCI -
Enrollment required
Variance
Lesson 1: Basic Regression Analysis
3:04
Calculate variance as the square of standard deviation, useful for mathematical statistical work.
View enrollment options at VDCI -
Enrollment required
Percentile
Lesson 1: Basic Regression Analysis
2:02
Calculate percentiles using NumPy's percentile method to understand dataset distribution.
View enrollment options at VDCI -
Challenge 2 Percentile From User Input
Lesson 1: Basic Regression Analysis
1:28
Prompt the user for a percentile and print the corresponding age at which that percent of people are younger using the input function and np.percentile.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Challenge 2 Percentile From User Input Solution
Lesson 1: Basic Regression Analysis
3:18
Create an input box to enter a percentile and calculate the corresponding age using NumPy's percentile function.
View enrollment options at VDCI -
Enrollment required
Uniform Distribution Histograms
Lesson 1: Basic Regression Analysis
7:13
Comment out the code to avoid repeated prompts, and create histograms using NumPy and PyPlot to visualize the frequency distribution of uniformly distributed random numbers, showing smoother distributions with larger sample sizes.
View enrollment options at VDCI -
Enrollment required
Normal Distribution Histograms
Lesson 1: Basic Regression Analysis
4:11
Illustrate a normal distribution using NumPy to generate 250,000 random scores centered around a mean of 100 with a standard deviation of 15, and visualize the data with a histogram to show the bell curve.
View enrollment options at VDCI -
Enrollment required
Linear Regression
Lesson 1: Basic Regression Analysis
2:43
Predict the relationship between x and y variables using linear regression by minimizing the variance, or the sum of squared differences, between the line and data points.
View enrollment options at VDCI -
Plotting Attendance Against Concessions
Lesson 1: Basic Regression Analysis
5:56
Perform a linear regression to predict concessions revenue based on baseball game attendance data using NumPy's polyfit function and visualize it with a line plot.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Using Pandas For Vector Operations
Lesson 1: Basic Regression Analysis
2:02
Create a data frame using pandas to perform vector operations on attendance and concessions data for predictive analysis.
View enrollment options at VDCI -
Enrollment required
A Prediction Concessions Function
Lesson 1: Basic Regression Analysis
4:50
Create a Python function called `predict_concessions` to calculate expected concession revenue based on attendance, using a linear regression formula, and ensure the result is rounded to the nearest dollar for readability and ease of updates in one place.
View enrollment options at VDCI -
Enrollment required
Predicting Concessions From User Input
Lesson 1: Basic Regression Analysis
3:32
Create a program that allows ballpark employees to input attendance numbers to predict concessions revenue using a predefined formula.
View enrollment options at VDCI -
Enrollment required
Adding Predictions To Our Data
Lesson 1: Basic Regression Analysis
2:50
Add predicted concessions values to the data frame by mapping the `predict_concessions` function over the attendance column.
View enrollment options at VDCI -
Enrollment required
Polynomial Regressions
Lesson 1: Basic Regression Analysis
8:45
Implement polynomial regression to fit a curve to the data, but avoid overfitting by not using too many polynomial degrees.
View enrollment options at VDCI -
Supervised Learning Intro
Lesson 2: Supervised Learning Essentials
7:45
Set up your notebook for machine learning by importing necessary libraries and preparing data for supervised learning, including splitting it into training and testing sets.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Car Data Overview
Lesson 2: Supervised Learning Essentials
4:37
Predict car sales using a linear regression model, analyze and clean data using Scikit-learn and Pandas, and determine important features through visualization and correlation matrices.
View enrollment options at VDCI -
Enrollment required
Picking Features From Domain Knowledge
Lesson 2: Supervised Learning Essentials
4:10
Determine which data is important for training the model by analyzing both domain knowledge and data analysis.
View enrollment options at VDCI -
Enrollment required
Correlation Matrixes
Lesson 2: Supervised Learning Essentials
5:29
Analyze the correlation matrix to determine that "sales in thousands" is not significantly correlated with other variables and may not be essential for model training.
View enrollment options at VDCI -
Enrollment required
Pair Plots Intro
Lesson 2: Supervised Learning Essentials
1:41
Visualize data relationships using a Seaborn pair plot to display scatter plots for correlations and histograms for individual variables.
View enrollment options at VDCI -
Enrollment required
Pair Plot Analysis
Lesson 2: Supervised Learning Essentials
4:02
Create a Seaborn pair plot to visually explore relationships and distributions between variables in a dataset.
View enrollment options at VDCI -
Enrollment required
Cleaning Data
Lesson 2: Supervised Learning Essentials
7:29
Clean data, select features (fuel efficiency, engine size, horsepower), split into training/testing sets, and prepare for linear regression model training to predict car prices.
View enrollment options at VDCI -
Enrollment required
Splitting Training Data From Test Data
Lesson 2: Supervised Learning Essentials
6:11
Split data into training and testing sets using `train-test-split` to ensure 80% for training and 20% for testing.
View enrollment options at VDCI -
Scaling the Data
Lesson 2: Supervised Learning Essentials
6:23
Scale the X train and X test data using scikit-learn's StandardScaler to ensure all features have a mean of zero and are measured in standard deviations, preventing the model from detecting false patterns based on varying scales.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Linear Regression Model Intro
Lesson 2: Supervised Learning Essentials
2:50
Use a linear regression model to perform continuous classification by predicting numeric values from data.
View enrollment options at VDCI -
Enrollment required
Training the Linear Regression Model
Lesson 2: Supervised Learning Essentials
1:24
Train the model using model.fit with X train and Y train data for linear regression.
View enrollment options at VDCI -
Enrollment required
Comparing Predictions to Test Data
Lesson 2: Supervised Learning Essentials
2:55
Evaluate the model's predictions against test data by comparing predicted values to actual values.
View enrollment options at VDCI -
Enrollment required
Accuracy Score
Lesson 2: Supervised Learning Essentials
3:39
Evaluate the accuracy of the linear regression model by comparing its predictions to the mean prediction, resulting in a 69% improvement.
View enrollment options at VDCI -
Enrollment required
Removing Outliers
Lesson 2: Supervised Learning Essentials
5:17
Improve accuracy by removing outliers from the dataset before splitting it into training and testing sets.
View enrollment options at VDCI -
Enrollment required
Filtering Outliers Out
Lesson 2: Supervised Learning Essentials
1:59
Filter car sales data to exclude rows with a price over 80,000 and an engine size over 7, reducing the dataset to 150 rows for model retraining.
View enrollment options at VDCI -
Enrollment required
Training and Testing a Second Model
Lesson 2: Supervised Learning Essentials
8:15
Try removing outliers and using larger datasets to improve model accuracy.
View enrollment options at VDCI -
Enrollment required
Logistic Regression Intro
Lesson 2: Supervised Learning Essentials
3:53
Use logistic regression to predict whether employees will stay or leave based on HR data.
View enrollment options at VDCI -
Enrollment required
Hr Data Overview
Lesson 2: Supervised Learning Essentials
2:35
Check for null values and visualize how many people left or stayed using HR data, revealing that 11,428 stayed and 3,571 left.
View enrollment options at VDCI -
Data Analysis Crosstabs
Lesson 2: Supervised Learning Essentials
2:16
Crosstabulate the "left" and "salary" columns in the HR data using Pandas to analyze the impact of salary on employee retention.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Making Our Crosstab More Readable
Lesson 2: Supervised Learning Essentials
4:11
Rename indices to "stayed" and "left," move "high" column to the left, and convert categorical values to numerical data for computer processing.
View enrollment options at VDCI -
Enrollment required
One Hot Encoding
Lesson 2: Supervised Learning Essentials
3:57
Convert categorical salary data into numerical format using one-hot encoding with Pandas get_dummies, creating separate columns for low, medium, and high values.
View enrollment options at VDCI -
Enrollment required
Concatenating Ohe Data
Lesson 2: Supervised Learning Essentials
1:45
Concatenate the high, low, and medium columns to the right side of the data frame before splitting it into testing and training data.
View enrollment options at VDCI -
Enrollment required
Training a Logistic Regression Model
Lesson 2: Supervised Learning Essentials
4:26
Create and evaluate a logistic regression model using the specified columns for predicting whether employees left or stayed, scaling the data as needed.
View enrollment options at VDCI -
Enrollment required
Measuring Accuracy
Lesson 2: Supervised Learning Essentials
5:42
Evaluate the model's predictions to identify true positives, true negatives, false positives, and false negatives, achieving a 77% overall accuracy.
View enrollment options at VDCI -
Enrollment required
Confusion Matrix
Lesson 2: Supervised Learning Essentials
4:35
Analyze the confusion matrix to identify where the model misclassified predictions, particularly noting that it accurately predicted only 25% of those who actually left.
View enrollment options at VDCI -
Enrollment required
Precision and Recall
Lesson 2: Supervised Learning Essentials
5:22
Evaluate model performance using precision and recall, noting high accuracy in predicting who stayed but poor recall for those who left, highlighting the importance of directionality in errors depending on use case.
View enrollment options at VDCI -
Knn Intro
Lesson 3: K-Nearest Neighbors
2:13
Explore the k-nearest neighbors (KNN) algorithm to classify data points based on the values of their nearest existing points.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Visualizing Knn
Lesson 3: K-Nearest Neighbors
2:04
Classify new data points by identifying the class of the majority among their k-nearest neighbors.
View enrollment options at VDCI -
Enrollment required
Plotting Training Data
Lesson 3: K-Nearest Neighbors
3:02
Visualize k-nearest neighbors by plotting categorized x and y coordinates using pyplot's scatter plot function.
View enrollment options at VDCI -
Creating and Training Our Knn Model
Lesson 3: K-Nearest Neighbors
3:13
Train a k-neighbors classifier using a k-value of three on saved data points and classes, then test its prediction on a new data point.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Visualizing Our New Point
Lesson 3: K-Nearest Neighbors
4:41
Visualize the new data point with a unique class and predict its class using the KNN model.
View enrollment options at VDCI -
Enrollment required
Visualizing the Prediction
Lesson 3: K-Nearest Neighbors
2:06
Append the integer prediction to the classes list and visualize the newly classified point using k-nearest neighbors.
View enrollment options at VDCI -
Enrollment required
Iris Knn Intro
Lesson 3: K-Nearest Neighbors
2:29
Apply K-Nearest Neighbors to the iris dataset using sepal and petal measurements to classify flowers with high accuracy.
View enrollment options at VDCI -
Enrollment required
Visualizing Multi Dimensional Datasets
Lesson 3: K-Nearest Neighbors
2:43
Visualize and analyze iris species data using K-Nearest Neighbors across multiple dimensions to classify new samples.
View enrollment options at VDCI -
Enrollment required
Loading and Reviewing Iris Data
Lesson 3: K-Nearest Neighbors
2:40
Load and explore the Iris dataset using sklearn to understand its structure, including data arrays, target classifications, and target names.
View enrollment options at VDCI -
Enrollment required
Creating Iris Dataframe
Lesson 3: K-Nearest Neighbors
8:29
Convert the iris dataset into a pandas DataFrame, add a target column with numerical values (0, 1, 2), and then apply a function or lambda to map these target values to their corresponding species names, creating a new 'species' column for human readability.
View enrollment options at VDCI -
Enrollment required
Prepping Our Data for Knn
Lesson 3: K-Nearest Neighbors
2:58
Prepare the dataset by splitting it into training and testing sets for features (X) and targets (Y) using 20% of the data for testing.
View enrollment options at VDCI -
Enrollment required
Training and Testing Our Knn Model
Lesson 3: K-Nearest Neighbors
1:58
Train the k-neighbors classifier with 3 neighbors on the training data and compare predictions against actual test data.
View enrollment options at VDCI -
Enrollment required
Creating a Classification Report
Lesson 3: K-Nearest Neighbors
3:08
Score the model by calculating accuracy and generating a classification report to identify prediction errors.
View enrollment options at VDCI -
Enrollment required
Analyzing and Summing Up Knn Results
Lesson 3: K-Nearest Neighbors
3:07
Identify a virginica misclassified as a versicolor due to its closeness to the versicolor group.
View enrollment options at VDCI -
Titanic Dataset Intro
Lesson 4: Titanic Survival Prediction
2:13
Predict Titanic survival using a random forest classifier with the Kaggle dataset.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Titanic Dataset Closer Look
Lesson 4: Titanic Survival Prediction
2:23
Analyze and clean the Titanic dataset by addressing missing values in age and embarked columns while ignoring the cabin data.
View enrollment options at VDCI -
Enrollment required
Filling in Na Values
Lesson 4: Titanic Survival Prediction
8:43
Fill missing ages in the Titanic dataset with gender-specific mean values and replace missing 'embarked' entries with the mode 'S'.
View enrollment options at VDCI -
Enrollment required
Plotting Survived vs Perished
Lesson 4: Titanic Survival Prediction
2:00
Analyze the survival rates and passenger class distribution of Titanic data using Seaborn count plots.
View enrollment options at VDCI -
Enrollment required
Plotting by 2 Columns
Lesson 4: Titanic Survival Prediction
3:37
Graph passenger class distribution and survival rates by class using Seaborn to identify potential predictive features for analysis.
View enrollment options at VDCI -
Enrollment required
Plotting More Data
Lesson 4: Titanic Survival Prediction
2:10
Analyze Titanic survival rates by gender and port of embarkation to identify potential influential factors.
View enrollment options at VDCI -
Enrollment required
Graphing a Combined Column
Lesson 4: Titanic Survival Prediction
5:37
Combine passenger class and gender into a new categorical column "p-class sex" in the Titanic dataset to analyze survival patterns based on these combined factors.
View enrollment options at VDCI -
Enrollment required
Label Encoding
Lesson 4: Titanic Survival Prediction
3:31
Use LabelEncoder to transform categorical variables into numerical values for easier processing.
View enrollment options at VDCI -
Enrollment required
Splitting and Scaling Our Data
Lesson 4: Titanic Survival Prediction
4:40
Split and scale the Titanic dataset using standard scaler before applying random forest classifiers.
View enrollment options at VDCI -
Random Forest Classifiers
Lesson 4: Titanic Survival Prediction
4:42
Explain how random forest classifiers use multiple decision trees to make predictions by averaging diverse subsets of data.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Creating and Training Our Model
Lesson 4: Titanic Survival Prediction
0:53
Create and train a random forest classifier model with the training data, then proceed to test it.
View enrollment options at VDCI -
Enrollment required
Cleaning Up the Test Data
Lesson 4: Titanic Survival Prediction
8:01
Prepare and clean the X test data by filling missing ages with mean values by gender and filling the missing fare with the mean fare before labeling, encoding, scaling, and submitting the predictions to Kaggle.
View enrollment options at VDCI -
Enrollment required
Label Encoding and Scaling Our Test Data
Lesson 4: Titanic Survival Prediction
4:50
Label, encode, and scale the specified columns in the dataset to prepare for model submission.
View enrollment options at VDCI -
Enrollment required
Fixing Column Order Error
Lesson 4: Titanic Survival Prediction
1:09
Correct the column order by moving age to the fourth position and rerun the code to ensure accuracy.
View enrollment options at VDCI -
Enrollment required
Submitting to Kaggle
Lesson 4: Titanic Survival Prediction
7:49
Create a predictions array from the model, form a data frame with passenger IDs and predictions, save it as a CSV without an index, and submit it to Kaggle for scoring.
View enrollment options at VDCI -
Neural Networks Intro
Lesson 5: Neural Networks
4:30
Explore neural networks, focusing on translating handwritten digits using TensorFlow and Keras, while learning data visualization, normalization, and model training techniques.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Notebook Setup
Lesson 5: Neural Networks
1:15
Import libraries and set up Google Drive and TensorFlow for the neural network.
View enrollment options at VDCI -
Enrollment required
Task Intro
Lesson 5: Neural Networks
2:16
Analyze the MNIST dataset of handwritten digits to train a machine learning model for accurate digit recognition.
View enrollment options at VDCI -
Enrollment required
Analyzing the Shape of Our Data
Lesson 5: Neural Networks
6:09
Analyze the MNIST dataset from TensorFlow to understand its structure as immutable tuples containing training and testing data divided into images and labels.
View enrollment options at VDCI -
Enrollment required
Unpacking All Our Data
Lesson 5: Neural Networks
2:41
Unpack the data into training and testing images and labels to confirm their shapes and types.
View enrollment options at VDCI -
Looking at a Digit Array Part 1
Lesson 5: Neural Networks
5:28
Explore how to train a neural network model using 60,000 grayscale 28x28 pixel images of handwritten digits represented as NumPy arrays.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Looking at a Digit Array Part 2
Lesson 5: Neural Networks
1:59
Visualize the array as a stretched-out image to see it resembles a 5.
View enrollment options at VDCI -
Enrollment required
Training and Testing Review
Lesson 5: Neural Networks
3:51
Train the model using 60,000 handwritten digit images to recognize patterns and improve accuracy before testing with 10,000 new images.
View enrollment options at VDCI -
Enrollment required
Normalizing Our Data
Lesson 5: Neural Networks
5:18
Normalize data by dividing each pixel value by 255 to scale them between zero and one for both training and testing images.
View enrollment options at VDCI -
Enrollment required
Building a Neural Network
Lesson 5: Neural Networks
12:06
Build a three-layer neural network using a sequential Keras model with an input layer that flattens a 28x28 input, a dense hidden layer with 128 neurons using the ReLU activation function, and an output layer with 10 neurons using the softmax activation.
View enrollment options at VDCI -
Enrollment required
Training Our Model
Lesson 5: Neural Networks
4:37
Compile the neural network model, train it over multiple epochs, and observe accuracy improvements and loss reductions.
View enrollment options at VDCI -
Enrollment required
Analyzing Predictions
Lesson 5: Neural Networks
11:22
Analyze the predictions' accuracy by comparing predicted digits to correct labels and preparing for further evaluation and tuning in the next lesson.
View enrollment options at VDCI
Tableau Course Online
-
Requirements & Getting Started
Lesson 1: Getting Started With Tableau
9:58
Download and extract the class zip folder, install Tableau Public, and access the provided datasets, images, and presentations to follow along with day one of the Tableau training.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Introduction to Tableau
Lesson 1: Getting Started With Tableau
8:26
Demonstrate how to access, sign into, and use both the Tableau Desktop and Tableau Public online versions to create and manage visualizations.
View enrollment options at VDCI -
Enrollment required
Understanding Data
Lesson 1: Getting Started With Tableau
14:47
Learn key data concepts, explore chart types and visualization principles, understand Tableau features and dashboards, distinguish data types, evaluate data sources, and practice using vetted datasets for effective visual analysis.
View enrollment options at VDCI -
Enrollment required
Foundations for Building Data Visualizations
Lesson 1: Getting Started With Tableau
6:13
Understand key skills for effective Tableau visualizations—statistics, storytelling, graphic design—and align data, questions, and visuals while using appropriate Tableau tools based on privacy and functionality needs.
View enrollment options at VDCI -
Enrollment required
Tableau Versions
Lesson 1: Getting Started With Tableau
7:06
Understand Tableau’s user roles—Creators build content, Explorers analyze it, Viewers interact with it—while noting pricing, feature differences between Tableau Desktop and Public, and comparisons to Power BI in workflow and accessibility.
View enrollment options at VDCI -
Enrollment required
Workflow & Chart Types
Lesson 1: Getting Started With Tableau
4:57
Follow the Tableau workflow by connecting data sources, formatting data, creating and editing visualizations in worksheets, building dashboards, and publishing results, while understanding chart types, and distinguishing dimensions (qualitative) from measures (quantitative).
View enrollment options at VDCI -
Working with your Data
Lesson 1: Getting Started With Tableau
7:52
Connect and structure clean, well-formatted data (like Superstore Sales) in Tableau Public, avoiding unstructured or mislabeled datasets that require correction with limited tools like Data Interpreter.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Creating your First Visualization
Lesson 1: Getting Started With Tableau
6:14
Connect to your data by dragging and dropping the file into Tableau to quickly establish a connection without modifying the original data.
View enrollment options at VDCI -
Enrollment required
Previewing your Data in the Source Menu
Lesson 1: Getting Started With Tableau
9:25
Connect and preview your data in Tableau by importing the main Orders table first, then add People and Returns to build relationships based on matching fields, verify data types, hide unnecessary fields, and ensure dimensions and measures are correctly identified by color.
View enrollment options at VDCI -
Enrollment required
Quickly Creating a Visualization
Lesson 2: Creating Visualizations
8:44
Create a quick category-region report in Tableau using drag-and-drop fields, apply color scales for sales, quantity, and profit, adjust view to entire sheet, and add text labels with one click.
View enrollment options at VDCI -
Enrollment required
Data Visualization Basics
Lesson 2: Creating Visualizations
10:29
Learn how to simplify complex data using visual tools like charts, colors, and sorting to make insights easy to understand at a glance.
View enrollment options at VDCI -
Enrollment required
The Tableau Interface
Lesson 2: Creating Visualizations
16:35
Explore the Tableau interface by navigating the data source area, data sidebar, marks card, shelves, view pane, and menu options to build, format, and manage visualizations.
View enrollment options at VDCI -
Enrollment required
Creating a Pie Chart
Lesson 2: Creating Visualizations
13:33
Create a pie chart using the Show Me panel by selecting one dimension (e.g., Person) and one measure (e.g., Sales), then customize it using the Marks card to add labels, percentages, adjust size and layout, and format text and colors as needed.
View enrollment options at VDCI -
Enrollment required
Creating a Bar or Column Chart
Lesson 2: Creating Visualizations
10:32
Create bar or column charts by dragging dimensions (e.g., Subcategory) to Rows and measures (e.g., Sales) to Columns, adjust formatting using right-click or dropdown options, apply labels with the T button, set default currency formatting via Default Properties, and customize chart appearance through Format options including shading, borders, and axis scaling.
View enrollment options at VDCI -
Swap Rows and Columns
Lesson 2: Creating Visualizations
3:59
Swap rows and columns using the swap button, drag fields to rearrange positions, sort data alphabetically or by field values, reset to original data source order, and adjust view using the fit menu options.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adding a Sub Category
Lesson 2: Creating Visualizations
5:54
Add dimensions like subcategory and product to your chart to display hierarchical data and explore levels of detail, using the "Describe" option to assess member counts for practicality.
View enrollment options at VDCI -
Enrollment required
Sorting and Saving
Lesson 2: Creating Visualizations
3:07
Summarize sorting options, explain saving methods including Save and Save As with TWB and TWX formats, clarify that Ctrl-S publishes to Tableau Public, and outline how to rename or hide sheet titles.
View enrollment options at VDCI -
Organizing the Data Sidebar
Lesson 3: Organizing Data
6:53
Create hierarchies in Tableau by grouping related fields (like country, state, city, zip) to organize the sidebar and simplify visualizations.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Sets
Lesson 3: Organizing Data
15:39
Create a set to filter subcategories where total sales are greater than or equal to 100,000, enable "Show Members in Set," and optionally filter by year using a single value list for dynamic reporting across worksheets.
View enrollment options at VDCI -
Enrollment required
Groups
Lesson 3: Organizing Data
14:14
Create manual groupings within a dimension to categorize data (e.g., electrical vs. non-electrical) by selecting and assigning values, similar to organizing breakout rooms.
View enrollment options at VDCI -
Enrollment required
Labels
Lesson 3: Organizing Data
5:50
Adjust labels, tooltips, alignment, and formatting settings to customize data visualization display.
View enrollment options at VDCI -
Enrollment required
Tool Tips
Lesson 3: Organizing Data
12:22
Edit axes to customize scale, tick marks, and labels; modify and reset tooltips to control displayed data and insert other worksheets for detailed hover views.
View enrollment options at VDCI -
Enrollment required
Measures
Lesson 3: Organizing Data
7:29
Change measure aggregations (e.g., sum to average) and chart types (e.g., bar to line) by adjusting settings and using available controls in Tableau.
View enrollment options at VDCI -
Enrollment required
Marks Card
Lesson 3: Organizing Data
5:49
Format sheets, rows, columns, fonts, alignment, shading, borders, and colors using the formatting sidebar or right-click options.
View enrollment options at VDCI -
Tableau Calculations
Lesson 4: Calculations and Dashboards
8:37
Create a calculated field for profit margin by dividing SUM(Profit) by SUM(Sales), then format it as a percentage and add it to the view using label or tooltip as needed.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pages
Lesson 4: Calculations and Dashboards
8:21
Use the Pages feature in Tableau with "Show History" enabled to overlay and animate year-by-year data changes in a single worksheet.
View enrollment options at VDCI -
Enrollment required
Dashboards Part 1
Lesson 4: Calculations and Dashboards
14:05
Create a responsive Tableau dashboard by selecting "New Dashboard," setting the size to "Automatic," dragging in sheets and objects like text boxes, containers, and images, arranging them using floating or tiled layouts, customizing layout and appearance, and adding navigation buttons to link multiple dashboards for interactive navigation.
View enrollment options at VDCI -
Enrollment required
Dashboards Part 2
Lesson 4: Calculations and Dashboards
8:25
Demonstrate how to create interactive Tableau dashboards with filters, navigation buttons, and publish them to Tableau Public for user interaction.
View enrollment options at VDCI -
Enrollment required
Creating Stories
Lesson 4: Calculations and Dashboards
2:54
Create a story by dragging dashboards or charts onto blank pages, customizing layout with captions or numbers, adjusting size settings, and navigating in presentation mode.
View enrollment options at VDCI -
Data Interpreter
Lesson 5: Data Interpreter
10:00
Use Tableau's Data Interpreter to automatically detect and clean common spreadsheet issues like extra headers, footers, and multiple tables before importing the data.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Life Expectancy Exercise
Lesson 5: Data Interpreter
8:42
Recreate the initial poor visualization in Tableau using the cleaned data, then improve it by applying best practices demonstrated through Excel's Power Query and pivot table features.
View enrollment options at VDCI -
Enrollment required
Life Expectancy Exercise Solution
Lesson 5: Data Interpreter
7:34
Create a filtered area chart in Tableau showing the top 10 countries by life expectancy using summed values to handle missing data and improve visual clarity.
View enrollment options at VDCI -
Creating Multi Chart Worksheets
Lesson 6: Multi-Chart Worksheets
10:00
Create a multi-chart worksheet by dragging multiple measures into the rows or columns shelf, customizing each chart independently using individual marks cards.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dual Axis & Combo Chart
Lesson 6: Multi-Chart Worksheets
8:50
Create a dual-axis combo chart by placing two measures on Rows, assigning distinct chart types (e.g., bar for Sales, line for Profit), setting each to a non-automatic type, then selecting Dual Axis from the right-side measure’s dropdown, aligning scales with Synchronize Axis, and customizing colors as needed.
View enrollment options at VDCI -
Enrollment required
Creating a Better Line Chart
Lesson 6: Multi-Chart Worksheets
17:50
Create a better line chart by overlaying two synchronized charts—one as a line and one as customizable circles or shapes—using dual axis in Tableau.
View enrollment options at VDCI -
Enrollment required
Creating a Butterfly Chart Part 1
Lesson 6: Multi-Chart Worksheets
8:48
Create a basic butterfly chart by reversing the axis on one bar chart in a side-by-side layout to visualize opposing data categories.
View enrollment options at VDCI -
Enrollment required
Creating a Butterfly Chart Part 2
Lesson 6: Multi-Chart Worksheets
10:58
Duplicate the basic butterfly chart, insert a zero-value calculated field between the two measures to place category labels in the center, change its mark type to text, clean up axes and gridlines, and adjust label formatting for a cleaner intermediate butterfly chart layout.
View enrollment options at VDCI -
Enrollment required
Formatting the Butterfly Chart
Lesson 6: Multi-Chart Worksheets
13:57
Create an advanced butterfly chart with centered subcategory text by duplicating axes, synchronizing scales, layering dual-axis text fields, and adjusting formatting and colors for clarity.
View enrollment options at VDCI -
Creating State Selector
Lesson 7: Parameters and Filtering
10:00
Create a parameter called "state selector" from the State field, set its default value to New York, then connect it to a calculation, filter, or set to enable interactive map navigation.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Creating a Calculated Field
Lesson 7: Parameters and Filtering
15:26
Create a calculated field called "State Focus" that filters data to a selected state or all states using a parameter.
View enrollment options at VDCI -
Enrollment required
Creating a Parameter to Control a Filter
Lesson 7: Parameters and Filtering
11:06
Demonstrate how to create a parameter to dynamically control a top N filter for subcategories in a bar chart, enabling user input to adjust the number of displayed items (e.g., top 5, top 10), which is not possible using basic filters alone.
View enrollment options at VDCI -
Enrollment required
Creating an International Map Part 1
Lesson 7: Parameters and Filtering
12:12
Troubleshoot and clean data in Tableau by fixing date formats, correcting city name misspellings with aliases, and resolving unrecognized international locations to create accurate visualizations.
View enrollment options at VDCI -
Enrollment required
Creating an International Map Part 2
Lesson 7: Parameters and Filtering
8:18
Exclude "MLS" from city filter, create a calculated field for "country" using an IF statement to assign Canadian cities to "Canada" and others to "US", change its data type to geographic role "country", drag it to the detail mark, and verify all locations appear on the map.
View enrollment options at VDCI -
Enrollment required
More Chart Types
Lesson 7: Parameters and Filtering
12:13
Explore various Tableau chart types—including heat maps, density maps, highlight tables, pie and donut charts, stacked bars, scatter plots, histograms, box plots, Gantt charts, bullet graphs, and flow maps—with brief creation steps and usage tips.
View enrollment options at VDCI
Python for AI Course Online
-
Getting Started
Lesson 1: Using VSCode & Flask
10:00
Build web applications using Python’s Flask framework and the OpenAI API, starting from core concepts and assuming foundational Python programming knowledge, while setting up VS Code and an OpenAI account.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Set Up VS Code for Flask
Lesson 1: Using VSCode & Flask
37:40
Create a new VS Code project, set up a virtual environment, install Flask, and run a basic Hello World app in the browser.
View enrollment options at VDCI -
Enrollment required
Add an 'About' Route
Lesson 1: Using VSCode & Flask
11:41
Add a new Flask route, update the homepage to link to it, and test changes by restarting the development server.
View enrollment options at VDCI -
Flask for Rendering
Lesson 2: Rendering HTML with Flask
10:00
Render full HTML pages with Flask by using render_template, creating an index.html file inside a templates folder, and updating routes to return HTML instead of plain text.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Render an About Page
Lesson 2: Rendering HTML with Flask
7:47
Build an About page by defining a new route, rendering an HTML template, and linking to the route path rather than the file name.
View enrollment options at VDCI -
Enrollment required
Connecting to OpenAI
Lesson 3: Connecting with OpenAI
36:38
Connect a Flask app to the OpenAI API by installing the OpenAI module, configuring an API key, sending a request to a GPT model, parsing the JSON response, and displaying the AI output in the browser.
View enrollment options at VDCI -
Enrollment required
Prompting AI to Respond in JSON
Lesson 3: Connecting with OpenAI
27:00
Prompt the AI to return structured JSON responses, parse them into Python dictionaries, and extract specific data fields for use in the app.
View enrollment options at VDCI -
Jinja Templating Engine for HTML
Lesson 4: Jinja and Prompt Engineering
10:00
Use Jinja templating to dynamically display AI-generated content inside HTML pages rendered by Flask.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Prompt Engineering With JSON and Jinja Part 1
Lesson 4: Jinja and Prompt Engineering
42:21
Identify and resolve JSON prompt errors caused by curly quotes or invalid characters in Python code.
View enrollment options at VDCI -
Enrollment required
Prompt Engineering With JSON and Jinja Part 2
Lesson 4: Jinja and Prompt Engineering
22:14
Fix malformed JSON by correcting quotation marks, adding missing commas, and validating syntax before parsing.
View enrollment options at VDCI -
Having an Ongoing Chat with AI
Lesson 5: Building the Chat
10:00
Implement a terminal-based AI chat function that maintains conversation context using a list, processes user input in a loop, and appends AI responses sequentially.
This preview is temporarily unavailable. Please try again later.
-
Coding with HTML and CSS Part 1
Lesson 6: Coding HTML & CSS
10:00
Design a browser-based chat interface with HTML and CSS by structuring content with semantic elements, organizing assets in static folders, styling user and AI messages, and adding a hero image.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Coding with HTML and CSS Part 2
Lesson 6: Coding HTML & CSS
21:59
Add interactive input fields and buttons to the chat interface and prevent page reloads through JavaScript event handling.
View enrollment options at VDCI -
Enrollment required
JavaScript for Send Button
Lesson 7: Using JavaScript
15:49
Implement JavaScript logic to capture user input, create chat message elements, and append them dynamically to the chat window.
View enrollment options at VDCI -
Enrollment required
JavaScript fetch() for Server Requests
Lesson 7: Using JavaScript
17:33
Introduce JavaScript fetch by retrieving data from a public API and displaying results on the page in response to user interaction.
View enrollment options at VDCI -
Enrollment required
JavaScript fetch() Request for Flask
Lesson 7: Using JavaScript
17:10
Fetch JSON data from custom Flask routes, process responses in JavaScript, and update page content dynamically.
View enrollment options at VDCI -
Fetch & Python Flask Chat Round Trip
Lesson 8: Improving the Chat
10:00
Send chat messages from the browser to a Flask server using fetch, process them server-side, and return simulated AI responses to the UI.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Completing the AI Chat Assistant Part 1
Lesson 8: Improving the Chat
18:39
Integrate full chat workflows by sending conversation history as JSON to Flask, forwarding it to the OpenAI API, storing responses, and updating the chat interface in real time.
View enrollment options at VDCI -
Enrollment required
Completing the AI Chat Assistant Part 2
Lesson 8: Improving the Chat
26:13
Debug JSON handling issues in an AI chat system and improve response quality by incorporating structured FAQ context.
View enrollment options at VDCI -
Enrollment required
AI Prompt Engineering with Product FAQ
Lesson 8: Improving the Chat
27:17
Load and manage FAQ content within a Flask application to enhance an AI assistant’s ability to answer product- or service-specific questions accurately.
View enrollment options at VDCI -
Making a File Chooser in HTML & JS
Lesson 9: Starting the Meal Analyzer
10:00
Create an image upload feature by configuring a virtual environment, building HTML and JavaScript upload forms, and displaying uploaded images using Flask.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Sending Image Data to Flask and Returning Temp URL
Lesson 9: Starting the Meal Analyzer
34:34
Send uploaded image data to Flask, generate a temporary file path, and render the image back in the browser.
View enrollment options at VDCI -
Enrollment required
Sending Image Data to Flask and Returning Temp URL Part 2
Lesson 9: Starting the Meal Analyzer
24:58
Encode uploaded images in Base64, send them to the OpenAI API, and process JSON responses for display in the application.
View enrollment options at VDCI -
Enrollment required
Sending Image Data to Flask and Returning Temp URL Part 3
Lesson 9: Starting the Meal Analyzer
26:35
Apply prompt engineering techniques to request structured AI analysis of images, such as extracting meal details from uploaded photos.
View enrollment options at VDCI -
Enrollment required
Securing API Key as Environment Variable
Lesson 10: Finalizing the Meal Analyzer
16:18
Secure OpenAI API credentials by storing them as environment variables in a .env file and loading them with python-dotenv to prevent accidental exposure in version control.
View enrollment options at VDCI
Power BI Course Online
-
Course Overview & Setup
Lesson 1: Getting Started with Power BI
0:55
Introduces the structure of the Power BI course and explains how to use class files, PDFs, and step-by-step guides to build skills progressively.
This preview is temporarily unavailable. Please try again later.
-
Overview of Power BI
Lesson 1: Getting Started with Power BI
10:00
Explains what Power BI is, how it’s used for business intelligence, and how it compares to Excel, including an overview of Desktop, Service, and mobile access.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Installing the Power BI Desktop app
Lesson 1: Getting Started with Power BI
1:14
Walks through installing Power BI Desktop via the Microsoft Store, explaining update cycles and how to launch the application.
View enrollment options at VDCI -
Enrollment required
Create our First Visualization
Lesson 1: Getting Started with Power BI
16:02
Demonstrates importing data and creating basic visuals like tables and column charts while explaining data types and automatic visual suggestions.
View enrollment options at VDCI -
Enrollment required
Publishing and Sharing Reports
Lesson 1: Getting Started with Power BI
10:35
Covers publishing reports to the Power BI Service, including workspaces, sharing options, licensing, and browser-based access.
View enrollment options at VDCI -
Enrollment required
Managing Links to Data Source Files & Refreshing Data
Lesson 1: Getting Started with Power BI
2:15
Explains how Power BI connects to external data sources rather than embedding files and how to manage paths and refresh data.
View enrollment options at VDCI -
Transforming Data
Lesson 2: Transforming Data Using Power Query
10:00
Introduces Power Query for data transformation, including cleaning data, handling missing values, and improving performance through upstream changes.
This preview is temporarily unavailable. Please try again later.
-
Merge Queries
Lesson 2: Transforming Data Using Power Query
10:00
Explains merging tables in Power Query to combine related data and introduces normalized data concepts and lookup tables.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Append Queries
Lesson 2: Transforming Data Using Power Query
8:13
Demonstrates appending queries to combine multiple tables with the same structure into a single dataset.
View enrollment options at VDCI -
Enrollment required
Fill and Transpose
Lesson 2: Transforming Data Using Power Query
5:16
Covers advanced transformations such as fill down and transpose to correct poorly structured data.
View enrollment options at VDCI -
Enrollment required
Unpivot & Merge Columns
Lesson 2: Transforming Data Using Power Query
10:26
Demonstrates unpivoting data, combining date fields, assigning correct data types, and preparing datasets for time-based analysis.
View enrollment options at VDCI -
Enrollment required
Query Dependencies
Lesson 2: Transforming Data Using Power Query
1:43
Explores Query Dependencies to visualize how data sources and transformations connect and to troubleshoot complex models.
View enrollment options at VDCI -
Enrollment required
Getting Data from Multiple Files in a Folder (Appending from Folder)
Lesson 2: Transforming Data Using Power Query
4:59
Demonstrates importing and automatically appending files from a folder to support scalable data updates.
View enrollment options at VDCI -
Relationships
Lesson 3: Building the Adventure Works Report
10:00
Explains creating relationships between fact and dimension tables and introduces star schema modeling.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Importing Data and Building Relationships
Lesson 3: Building the Adventure Works Report
10:00
Walks through building a relational model using AdventureWorks data and validating automatically detected relationships.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Designing and Building the Report
Lesson 3: Building the Adventure Works Report
7:20
Focuses on report design using text boxes, images, alignment tools, and layout best practices for professional presentations.
View enrollment options at VDCI -
Enrollment required
Adventure Works Intro to DAX Adding the Current Date
Lesson 3: Building the Adventure Works Report
7:22
Introduces DAX by creating a simple date measure and explains the difference between measures and calculated columns.
View enrollment options at VDCI -
Enrollment required
Adventure Works DAX Calculated Columns Profit or Loss
Lesson 3: Building the Adventure Works Report
14:04
Demonstrates creating calculated columns with DAX and using relationships and the RELATED function across tables.
View enrollment options at VDCI -
Adventure Works Removing the Default White Background from Visuals by editing the Theme
Lesson 4: Visuals, Slicers, and More
2:00
Shows how to customize Power BI themes to remove default styling and apply consistent global design changes.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Adding more visuals
Lesson 4: Visuals, Slicers, and More
3:17
Builds additional visuals to analyze sales by customer attributes while demonstrating interactive filtering.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Slicers
Lesson 4: Visuals, Slicers, and More
20:24
Introduces slicers as interactive filters and demonstrates layout improvements and user-friendly labeling.
View enrollment options at VDCI -
Enrollment required
Adventure Works SUM vs SUMX
Lesson 4: Visuals, Slicers, and More
12:01
Explains the difference between SUM and SUMX in DAX and why iterator functions are needed for row-level calculations.
View enrollment options at VDCI -
Enrollment required
Adjusting a Desktop Report for Mobile Devices
Lesson 4: Visuals, Slicers, and More
2:58
Demonstrates optimizing reports for mobile using the mobile layout view and adjusting visuals for smaller screens.
View enrollment options at VDCI -
Global Superstore Import Data, Define Relationships, and Create Visuals
Lesson 5: Building the Global Superstore Report
10:00
Walks through importing and modeling Global Superstore data to reinforce ETL and star schema concepts.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore Intro to Filters
Lesson 5: Building the Global Superstore Report
10:00
Introduces visual-, page-, and report-level filters and explains when filters are preferable to slicers.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Top N Filter and Filter Across All Pages
Lesson 5: Building the Global Superstore Report
7:00
Demonstrates Top N filters to highlight best- and worst-performing items and explains how ties affect results.
View enrollment options at VDCI -
Enrollment required
Global Superstore Sales by Country Page
Lesson 5: Building the Global Superstore Report
9:27
Builds a multi-page report analyzing sales by country using slicers and geographic comparisons.
View enrollment options at VDCI -
Enrollment required
Global Superstore Edit Interactions
Lesson 5: Building the Global Superstore Report
4:16
Explains how to control visual interactions to compare filtered values against unfiltered totals.
View enrollment options at VDCI -
Global Superstore Controlling Filtering with SUM and SUMX
Lesson 6: Diving Deeper into DAX
8:46
Demonstrates using SUM and SUMX to control whether calculations respect or ignore filters.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore CONCATENATEX, COUNT, and COUNTX
Lesson 6: Diving Deeper into DAX
7:42
Introduces CONCATENATEX, COUNT, and COUNTX for advanced aggregations and dynamic titles.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore CALCULATE
Lesson 6: Diving Deeper into DAX
5:03
Explains how CALCULATE applies filters within DAX expressions to create reusable measures.
View enrollment options at VDCI -
Enrollment required
Global Superstore Matrix Visual with Conditional Formatting Icons and Data Bars
Lesson 6: Diving Deeper into DAX
4:10
Builds a matrix visual with conditional formatting to highlight performance trends at a glance.
View enrollment options at VDCI -
Enrollment required
Global Superstore Quick Measures
Lesson 6: Diving Deeper into DAX
7:21
Uses Quick Measures to generate common DAX calculations like YTD and YoY while keeping measures organized.
View enrollment options at VDCI -
Global Superstore Maps
Lesson 7: Maps, Drill Down, and Drill Through
6:14
Creates map visuals with Azure Maps and explains data categorization and geographic field requirements.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Drill Down
Lesson 7: Maps, Drill Down, and Drill Through
10:41
Demonstrates drill-down using hierarchies to move between summary and detailed views.
View enrollment options at VDCI -
Enrollment required
Global Superstore Drill Through
Lesson 7: Maps, Drill Down, and Drill Through
6:21
Builds drill-through navigation between report pages while preserving filter context.
View enrollment options at VDCI -
Global Superstore Scheduling Data Refreshes and Getting Data
Lesson 8: Refreshing Data, Dashboards & Databases
10:00
Explains local refresh versus scheduled refresh in the Power BI Service using OneDrive and shared models.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dashboards
Lesson 8: Refreshing Data, Dashboards & Databases
4:02
Explains how Power BI dashboards aggregate pinned visuals while linking back to underlying reports.
View enrollment options at VDCI -
Enrollment required
Connecting to a Database
Lesson 8: Refreshing Data, Dashboards & Databases
4:00
Demonstrates connecting Power BI to databases like SQL Server and compares Import and DirectQuery modes.
View enrollment options at VDCI -
Enrollment required
Course Outro
Lesson 8: Refreshing Data, Dashboards & Databases
0:13
Encourages continued practice to improve efficiency, confidence, and the ability to build original Power BI reports.
View enrollment options at VDCI
Curriculum
Course outline
-
Excel for Data Analytics Course Online 18 hours
Improve your data analysis skills with this class. Learn essential functions, formulas, and advanced techniques like Pivot Tables and VLOOKUP. Gain hands-on experience and optimize your workflow for efficient data analysis.
-
Data Analytics Foundations Course Online 12 hours
Master the basics of data analytics, including descriptive and inferential statistics, and understand how various industries and organizations leverage data for forecasting and decision-making. Dive into statistical analysis and modeling, exploring key algorithms, theorems, and models used in the field.
-
Python for Data Science Course Online 30 hours
Discover the potential of Python for data-driven decision-making by mastering the fundamentals of Python programming and exploring data analysis. Gain crucial skills to clean and manipulate data, generate meaningful visualizations, and conduct statistical analysis, all through practical projects using real-world datasets.
-
SQL Course Online 18 hours
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.
-
Python for Automation Course Online 6 hours
Learn how to use Python to extract data from websites and write loops to process multiple pages. This course covers essential topics like HTML/CSS, Python fundamentals, web scraping techniques, data storage, scheduling, and includes real-world examples of scraping valuable data.
- Understand how websites are structured using HTML and CSS to locate and extract specific data
- Build a foundation in Python fundamentals, including variables, data types, conditionals, loops, and working with lists
- Use the Requests and Beautiful Soup libraries to scrape web content and target relevant information
- Write loops to automate data collection across multiple web pages and reduce repetitive manual work
- Save scraped data in common formats such as text files and CSVs for analysis and reporting
- Schedule Python scripts to run automatically, supporting ongoing data collection and automated workflows
-
Python Data Visualization & Interactive Dashboards Course Online 24 hours
Learn how to collect, manipulate, and analyze real-world data in this course, gaining hands-on experience with Python's NumPy and pandas libraries. Enhance your data visualization skills with tools like Matplotlib, Seaborn, Plotly, and Dash Enterprise, and work on real-life projects that you can deploy online.
-
Python Machine Learning Course Online 30 hours
Master the basics of machine learning, including regression analysis and classification algorithms, in this hands-on course. Develop the skills required to tackle real-world challenges using machine learning, with an emphasis on Python programming and key data science libraries.
-
Tableau Course Online 12 hours
Master Tableau, a powerful data visualization tool, to create interactive and visually stunning charts, graphs, and maps. In this course, you'll learn how to connect to datasets, analyze and organize data, customize your visualizations, and publish your work for professional use.
-
Python for AI Course Online 30 hours
Build, design, and enhance web apps with AI features in this advanced Python course. You’ll create a robust sentiment analysis web application using Flask and integrate the OpenAI API, all while learning how to elevate your coding projects with AI-powered functionality.
-
Power BI Course Online 12 hours
Develop skills in Power BI, an advanced data visualization platform, to design interactive and visually engaging charts, graphs, and maps. Bring in data from multiple sources, shape and examine information, tailor visual elements, and publish polished reports for sharing and presentation.
- Import and prepare data from sources such as Excel, CSV files, and online databases using Power Query
- Build interactive visuals, including charts, maps, cards, and slicers, to uncover trends and patterns
- Apply DAX (Data Analysis Expressions) to create measures, calculated columns, and custom summaries
- Create polished reports by adding titles, logos, and formatting for a professional presentation
- Manage relationships between tables to enable dynamic and responsive reporting
- Share and collaborate on reports through the Power BI Service with options for exporting, commenting, and app connections
- Create dashboards and understand how dashboards differ from reports when presenting to stakeholders
- Schedule data refreshes and manage reusable datasets to keep reports current and scalable