Data Analytics & AI Certificate

Self-paced lessons

Watch free previews and explore the lessons included with enrollment at Noble Desktop.

• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop

• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop

• ▶ Play preview

  Benefits of Learning SQL

  Lesson 1: Setting Up the Work Environment

  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 Noble Desktop
• ▶ Play preview

  Getting Started & Your First Query

  Lesson 2: Let's Start Learning SQL Code

  7:29

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Data Types and Filtering Results

  Lesson 3: Working with Characters & Numbers

  4:44

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Database Terminology and Primary & Foreign Keys

  Lesson 5: Indentifying Rows & Connecting Tables

  6:44

  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: Indentifying Rows & Connecting Tables

  12:28

  Perform inner joins by matching common columns and using table aliases to simplify query syntax.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Exercise Inner Join

  Lesson 5: Indentifying Rows & Connecting Tables

  18:40

  Reinforce inner join logic by combining tables, filtering shared data, and presenting unified results.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Solution Inner Join

  Lesson 5: Indentifying 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 Noble Desktop
• ▶ Play preview

  Inner vs. Outer Joins

  Lesson 6: Inner vs. Outer Joins

  9:45

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Cast

  Lesson 7: Changing Data Types

  7:07

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Date Functions

  Lesson 8: Working with Dates

  2:20

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Grouping Data

  Lesson 9: Organizing Statistical Results Into Categories

  8:18

  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 Noble Desktop
• 

  Enrollment required

  Solution Subqueries

  Lesson 10: Subqueries

  24:51

  Prefer joins over subqueries when appropriate to improve clarity and performance.

  View enrollment options at Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  Enrollment required

  Views Solution

  Lesson 13: Views

  0:46

  Summarize and filter user spending patterns using flexible query criteria.

  View enrollment options at Noble Desktop
• ▶ Play preview

  String Functions

  Lesson 14: String Functions

  4:34

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  AI and SQL

  Lesson 16: AI and SQL

  11:06

  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 Noble Desktop
• 

  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 Noble Desktop

• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  If Else Logic

  Lesson 2: Boolean Conditions

  4:43

  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 Noble Desktop
• ▶ Play preview

  Datetime Part 1

  Lesson 3: Datetime & Random

  10:28

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Loops

  Lesson 4: Loops & Strings

  4:29

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Dictionaries Part 1

  Lesson 5: Dictionaries

  10:16

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Numpy

  Lesson 6: Numpy

  4:33

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Pandas Dataframes Part 1

  Lesson 7: Pandas Dataframes

  5:21

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Introduction to Matplotlib

  Lesson 8: Bar Charts with Matplotlib

  14:46

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Line and Scatter Charts with MatPlotlib

  Lesson 9: Line & Scatter Charts with Matplotlib

  13:56

  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 Noble Desktop
• ▶ Play preview

  Pivot, Plot, Animate

  Lesson 10: Pivot Population Data & Charts

  9:59

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop

• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  Enrollment required

  Panda 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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop

• ▶ Play preview

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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.

• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  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.

• ▶ Play preview

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Flask for Rendering

  Lesson 2: Rendering HTML with Flask

  6:21

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Jinja Templating Engine for HTML

  Lesson 4: Jinja and Prompt Engineering

  15: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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Having an Ongoing Chat with AI

  Lesson 5: Building the Chat

  15: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.

• ▶ Play preview

  Coding with HTML and CSS Part 1

  Lesson 6: Coding HTML & CSS

  13:37

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Fetch & Python Flask Chat Round Trip

  Lesson 8: Improving the Chat

  15: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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• ▶ Play preview

  Making a File Chooser in HTML & JS

  Lesson 9: Starting the Meal Analyzer

  12:34

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop
• 

  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 Noble Desktop

• ▶ Play preview

  Course Introduction

  Lesson 1: Introduction to AI in Data Analytics

  1:16

  Understand how AI enhances traditional analytics and supports descriptive, predictive, and prescriptive decision making.

  This preview is temporarily unavailable. Please try again later.

• ▶ Play preview

  Reframing Analytics Through AI Augmentation

  Lesson 1: Introduction to AI in Data Analytics

  5:15

  Define the four types of analytics and position AI as a tool that augments rather than replaces analysts.

  This preview is temporarily unavailable. Please try again later.

• 

  Enrollment required

  Understanding the AI Pipeline and Managing Bias

  Lesson 1: Introduction to AI in Data Analytics

  5:56

  Explain the AI pipeline from data collection through deployment & examine how bias in data, algorithms, or deployment can lead to unfair outcomes.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Unlocking the Strategic Benefits of AI in Analytics

  Lesson 1: Introduction to AI in Data Analytics

  7:22

  Identify the benefits of AI including speed, accuracy, scalability, and discovery.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Navigating Enterprise AI Platforms and Smart Use Cases

  Lesson 1: Introduction to AI in Data Analytics

  5:18

  Compare enterprise AI platforms and BI tools that integrate AI capabilities.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Accelerating Descriptive Statistics with AI

  Lesson 1: Introduction to AI in Data Analytics

  6:12

  Review core descriptive statistics including mean, median, variance, distribution shape, and outliers.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Discovering Relationships Through Correlation

  Lesson 1: Introduction to AI in Data Analytics

  5:18

  Explain the correlation coefficient and reinforce that correlation does not imply causation.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Predicting Outcomes with Regression and Forecasting

  Lesson 1: Introduction to AI in Data Analytics

  7:41

  Use AI to generate and interpret predictive models in accessible language.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Applying Probability and Distributions in Analysis

  Lesson 1: Introduction to AI in Data Analytics

  5:33

  Define theoretical, experimental, conditional, and compound probability.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Modeling Risk with Monte Carlo Simulation

  Lesson 1: Introduction to AI in Data Analytics

  6:06

  Explain Monte Carlo simulation and expected value under uncertainty.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Integrating End to End AI Analysis

  Lesson 1: Introduction to AI in Data Analytics

  5:27

  Combine descriptive, predictive, and probabilistic techniques into a unified AI prompt.

  View enrollment options at Noble Desktop
• ▶ Play preview

  Sourcing and Classifying Data for AI

  Lesson 2: Data Collection & Preparation

  6:24

  Identify internal and external data sources and understand how AI accelerates data collection through APIs, scraping, and file merging.

  This preview is temporarily unavailable. Please try again later.

• 

  Enrollment required

  Cleaning Dirty Data with AI Assistance

  Lesson 2: Data Collection & Preparation

  4:41

  Learn to recognize common data quality issues such as missing values, duplicates, inconsistent formats, and outliers.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Automating Exploratory Data Review and Cleanup

  Lesson 2: Data Collection & Preparation

  6:51

  Evaluate a real dataset to identify structural issues, missing values, formatting errors, and outliers.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Applying the DIG Framework for AI Assisted EDA

  Lesson 3: Exploratory Data Analysis (EDA)

  7:24

  Understand EDA as the process of reviewing, visualizing, and filtering data to uncover structure, trends, and anomalies.

  View enrollment options at Noble Desktop
• ▶ Play preview

  Designing Insightful Pivot Tables with AI Guidance

  Lesson 4: Data Visualization

  6:18

  Build meaningful summaries using pivot tables to compare categories, calculate metrics, and surface unusual patterns.

  This preview is temporarily unavailable. Please try again later.

• 

  Enrollment required

  Creating Interactive Dashboards and Data Stories

  Lesson 4: Data Visualization

  7:46

  Select effective chart types such as bar, line, and scatter plots to communicate trends and relationships.

  View enrollment options at Noble Desktop
• ▶ Play preview

  Building and Evaluating Predictive Models with AI

  Lesson 5: Predictive Analytics & Modeling

  4:19

  Differentiate between regression, classification, and clustering models and connect each to real business use cases.

  This preview is temporarily unavailable. Please try again later.

• 

  Enrollment required

  Demonstrating AI Powered Classification and Model Validation

  Lesson 5: Predictive Analytics & Modeling

  5:09

  Build a predictive model that classifies satisfaction scores using an uploaded dataset and structured prompts.

  View enrollment options at Noble Desktop
• ▶ Play preview

  Applying Predictive Models

  Lesson 6: Application of AI in Various Domains

  5:17

  Connect regression, classification, and clustering models to real use cases such as churn prediction, demand forecasting, workforce planning, and employee retention.

  This preview is temporarily unavailable. Please try again later.

• 

  Enrollment required

  Leveraging AI Modeling in Finance and Healthcare

  Lesson 6: Application of AI in Various Domains

  2:03

  Apply predictive modeling to fraud detection, credit scoring, financial forecasting, and real time risk monitoring.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Building Scenario Models and Executive Recommendations with AI

  Lesson 6: Application of AI in Various Domains

  4:05

  Generate revenue, cost, and profit scenarios using AI driven modeling and compare financial outcomes across strategic options.

  View enrollment options at Noble Desktop
• ▶ Play preview

  Analyzing Unstructured Text with Natural Language Processing

  Lesson 7: Advanced AI Techniques

  5:55

  Apply NLP techniques such as sentiment analysis, keyword extraction, topic clustering, summarization, and text classification to transform unstructured reviews and comments into structured insights.

  This preview is temporarily unavailable. Please try again later.

• 

  Enrollment required

  Forecasting Trends with Time Series Analysis

  Lesson 7: Advanced AI Techniques

  4:08

  Identify trends, seasonality, cycles, and anomalies in time based data such as sales or website traffic.

  View enrollment options at Noble Desktop
• 

  Enrollment required

  Conclusion

  Lesson 7: Advanced AI Techniques

  1:27

  Reflect on the core AI frameworks, hands on projects, and real world applications explored throughout the course.

  View enrollment options at Noble Desktop