The Business Intelligence Analyst Course 2024

• What Does the Course Cover

• Download All Resources

• Why Are There So Many Business and Data Science Buzzwords?

• Analysis vs Analytics

• Intro to Business Analytics, Data Analytics, and Data Science

• Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture

• An Overview of our Data Science Infographic

• When are Traditional data, Big Data, BI, Traditional Data Science and ML applied

• Why do we Need each of these Disciplines?

• Traditional Data: Techniques

• Traditional Data: Real-life Examples

• Big Data: Techniques

• Big Data: Real-life Examples

• Business Intelligence (BI): Techniques

• Business Intelligence (BI): Real-life Examples

• Traditional Methods: Techniques

• Traditional Methods: Real-life Examples

• Machine Learning (ML): Techniques

• Machine Learning (ML): Types of Machine Learning

• Machine Learning (ML): Real-life Examples

• Programming Languages & Software Employed in Data Science - All the Tools Needed

• Data Science Job Positions: What do they Involve and What to Look out for?

• Dispelling common Misconceptions

• Population vs sample

• Population and Sample

• Types of Data

• Levels of Measurement

• Categorical Variables - Visualization Techniques

• Categorical variables. Visualization Techniques

• Categorical Variables Exercise

• Numerical Variables - Frequency Distribution Table

• Numerical variables. Using a frequency distribution table

• Numerical Variables Exercise

• The Histogram

• Histogram Exercise

• Cross Table and Scatter Plot

• Cross Tables and Scatter Plots

• Cross Tables and Scatter Plots Exercise

• Mean, median and mode

• Mean, Median and Mode Exercise

• Skewness

• Skewness Exercise

• Variance

• Variance Exercise

• Standard Deviation and Coefficient of Variation

• Standard deviation

• Standard Deviation and Coefficient of Variation Exercise

• Covariance

• Covariance Exercise

• Correlation Coefficient

• Correlation Coefficient Exercise

• Practical Example

• Practical Example Exercise

• Introduction

• What is a Distribution

• The Normal Distribution

• The Standard Normal Distribution

• The Standard Normal Distribution Exercise

• Central Limit Theorem

• Standard error

• Estimators and Estimates

• What are Confidence Intervals?

• Confidence Intervals; Population Variance Known; z-score

• Confidence Intervals; Population Variance Known; z-score Exercise

• Confidence interval clarifications

• Student's T Distribution

• Confidence Intervals; Population Variance Unknown; t-score

• Confidence Intervals; Population Variance Unknown; t-score Exercise

• Margin of Error

• Confidence intervals. Two means. Dependent samples

• Confidence intervals. Two means. Dependent samples Exercise

• Confidence intervals. Two means. Independent samples (Part 1)

• Confidence intervals. Two means. Independent samples (Part 1) Exercise

• Confidence intervals. Two means. Independent samples (Part 2)

• Confidence intervals. Two means. Independent samples (Part 2) Exercise

• Confidence intervals. Two means. Independent samples (Part 3)

• Practical Example: Inferential Statistics

• Practical Example: Inferential Statistics Exercise

• The Null vs Alternative Hypothesis

• Further Reading on Null and Alternative Hypothesis

• Rejection Region and Significance Level

• Type I Error and Type II Error

• Test for the Mean. Population Variance Known

• Test for the Mean. Population Variance Known Exercise

• p-value

• Test for the Mean. Population Variance Unknown

• Test for the Mean. Population Variance Unknown Exercise

• Test for the Mean. Dependent Samples

• Test for the Mean. Dependent Samples Exercise

• Test for the mean. Independent samples (Part 1)

• Test for the mean. Independent samples (Part 1). Exercise

• Test for the mean. Independent samples (Part 2)

• Practical Example: Hypothesis Testing

• Practical Example: Hypothesis Testing Exercise

• Why use SQL?

• Why use MySQL?

• Introducing Databases

• Relational Database Fundamentals

• Comparing Databases and Spreadsheets

• Important Database Terminology

• The Concept of Relational Schemas: Primary Key

• The Concept of Relational Schemas: Foreign Key

• The Concept of Relational Schemas: Unique Key and Null Values

• The Concept of Relational Schemas: Unique Key

• The Concept of Relational Schemas: Relationships Between Tables

• Installing MySQL Workbench and Server

• Installing Visual C

• Installing MySQL on macOS and Unix systems

• The Client-Server Model

• Linking GUI with the MySQL Server

• Read me!!!

• Creating a New User and a New Connection to it

• Familiarize Yourself with the MySQL Interface

• SQL Fundamentals - MySQL Session and Databases

• SQL Fundamentals - DROP, CREATE, SELECT, INSERT, DELETE

• Coding Tips and Best Practices - I

• Coding Tips and Best Practices - II

• Loading the 'employees' Database

• Using SELECT - FROM

• Using SELECT - FROM - Exercise

• Using SELECT - FROM - Solution

• CODING EXERCISES - the 'employees_10' Database

• SELECT - FROM - Exercise #1

• SELECT - FROM - Exercise #2

• SELECT - FROM - Exercise #3

• SELECT - FROM - Exercise #4

• Using WHERE

• Using WHERE - Exercise

• Using WHERE - Solution

• SELECT - Using WHERE - Exercise #1

• Using AND

• Using AND - Exercise

• Using AND - Solution

• SELECT - Using AND - Exercise #1

• Using OR

• Using OR - Exercise

• Using OR - Solution

• SELECT - Using OR - Exercise #1

• Operator Precedence and Logical Order

• Operator Precedence and Logical Order - Exercise

• Operator Precedence and Logical Order - Solution

• Operator Precedence and Logical Order - Exercise #1

• Using IN - NOT IN

• Using IN - NOT IN - Exercise 1

• Using IN - NOT IN - Solution 1

• Using IN - NOT IN - Exercise 2

• Using IN - NOT IN - Solution 2

• SELECT - Using IN - NOT IN - Exercise #1

• SELECT - Using IN - NOT IN - Exercise #2

• Using LIKE - NOT LIKE

• Using LIKE - NOT LIKE - Exercise

• Using LIKE - NOT LIKE - Solution

• SELECT - Using LIKE - NOT LIKE - Exercise #1

• SELECT - Using LIKE - NOT LIKE - Exercise #2

• SELECT - Using LIKE - NOT LIKE - Exercise #3

• Using Wildcard Characters

• Using Wildcard characters - Exercise

• Using Wildcard characters - Solution

• Using Wildcard characters - Exercise #1

• Using Wildcard characters - Exercise #2

• Using BETWEEN - AND

• Using BETWEEN - AND - Exercise

• Using BETWEEN - AND - Solution

• SELECT - Using BETWEEN - AND - Exercise #1

• SELECT - Using BETWEEN - AND - Exercise #2

• SELECT - Using BETWEEN - AND - Exercise #3

• Using IS NOT NULL - IS NULL

• Using IS NOT NULL - IS NULL - Exercise

• Using IS NOT NULL - IS NULL - Solution

• SELECT - Using IS NOT NULL - IS NULL - Exercise #1

• Using Other Comparison Operators

• Using Other Comparison Operators - Exercise

• Using Other Comparison Operators - Solution

• SELECT - Using Other Comparison Operators - Exercise #1

• SELECT - Using Other Comparison Operators - Exercise #2

• Using SELECT DISTINCT

• Using SELECT DISTINCT - Exercise

• Using SELECT DISTINCT - Solution

• SELECT DISTINCT - Exercise #2

• Getting to Know Aggregate Functions

• Getting to Know Aggregate Functions - Exercise

• Getting to Know Aggregate Functions - Solution

• Getting to Know Aggregate Functions - Exercise #1

• Getting to Know Aggregate Functions - Exercise #2

• Using ORDER BY

• Using ORDER BY - Exercise

• Using ORDER BY - Solution

• SELECT - Using ORDER BY - Exercise #1

• Using GROUP BY

• Using Aliases (AS)

• Using Aliases (AS) - Exercise

• Using Aliases (AS) - Solution

• SELECT - Using Aliases (AS) - Exercise #1

• Using HAVING

• Using HAVING - Exercise

• Using HAVING - Solution

• SELECT - Using HAVING - Exercise #1

• Using WHERE vs HAVING - Part I

• Using WHERE vs HAVING - Part II

• Using WHERE vs HAVING - Part II - Exercise

• Using WHERE vs HAVING - Part II - Solution

• SELECT - Using WHERE vs HAVING - Exercise #1

• Using LIMIT

• Using LIMIT - Exercise

• Using LIMIT - Solution

• SELECT - Using LIMIT - Exercise #1

• Applying COUNT()

• Applying COUNT() - Exercise

• Applying COUNT() - Solution

• Applying COUNT() - Exercise #1

• Applying SUM()

• Applying SUM() - Exercise

• Applying SUM() - Solution

• Applying SUM() - Exercise #1

• MIN() and MAX()

• MIN() and MAX() - Exercise

• MIN() and MAX() - Solution

• MIN() and MAX() - Exercise #1

• MIN() and MAX() - Exercise #2

• Applying AVG()

• Applying AVG() - Exercise

• Applying AVG() - Solution

• Applying AVG() - Exercise #1

• Rounding Numbers with ROUND()

• Rounding Numbers with ROUND() - Exercise

• Rounding Numbers with ROUND() - Solution

• Applying ROUND() - Exercise #1

• What are JOINs?

• What are JOINs? - Exercise 1

• What are JOINs? - Exercise 2

• The Functionality of INNER JOIN - Part I

• The Functionality of INNER JOIN - Part II

• The Functionality of INNER JOIN - PART II - Exercise

• The Functionality of INNER JOIN - PART II - Solution

• INNER JOIN - Exercise #1

• Extra Info on Using Joins

• Duplicate Rows

• The Functionality of LEFT JOIN - Part I

• The Functionality of LEFT JOIN - Part II

• The Functionality of LEFT JOIN - Part II - Exercise

• The Functionality of LEFT JOIN - Part II - Solution

• LEFT JOIN - Exercise #1

• The Functionality of RIGHT JOIN

• RIGHT JOIN - Exercise #1

• Differences between the New and the Old Join Syntax

• Differences between the New and the Old Join Syntax - Exercise

• Differences between the New and the Old Join Syntax - Solution

• Differences between the New and the Old Join Syntax - Exercise #1

• Using JOIN and WHERE Together

• Important – Prevent Error Code: 1055!

• Using JOIN and WHERE Together - Exercise

• Using JOIN and WHERE Together - Solution

• Using JOIN and WHERE Together - Exercise #1

• The Functionality of CROSS JOIN

• The Functionality of CROSS JOIN - Exercise 1

• The Functionality of CROSS JOIN - Solution 1

• The Functionality of CROSS JOIN - Exercise 2

• The Functionality of CROSS JOIN - Solution 2

• The Functionality of CROSS JOIN - Exercise #1

• The Functionality of CROSS JOIN - Exercise #2

• Combining Aggregate Functions with Joins

• JOIN More than Two Tables

• JOIN More than Two Tables - Exercise

• JOIN More than Two Tables - Solution

• JOIN More than Two Tables - Exercise #1

• Top Tips for Joins

• Top Tips for Joins - Exercise

• Top Tips for Joins - Solution

• Top Tips for Joins - Exercise #1

• The Differences Between UNION and UNION ALL

• The Differences Between UNION and UNION ALL - Exercise

• The Differences Between UNION and UNION ALL - Solution

• The Differences Between UNION and UNION ALL - Exercise #1

• SQL Subqueries with IN Embedded Inside WHERE

• SQL Subqueries with IN Embedded Inside WHERE - Exercise

• SQL Subqueries with IN Embedded Inside WHERE - Solution

• SQL Subqueries with IN Embedded Inside WHERE - Exercise #1

• SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE

• SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Exercise

• SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Solution

• SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Exercise #1

• SQL Subqueries Nested in SELECT and FROM

• SQL Subqueries Embedded in SELECT and FROM - Exercise 1

• SQL Subqueries Embedded in SELECT and FROM - Exercise 2

• SQL Subqueries Nested in SELECT and FROM - Solution 2

• SQL Subqueries Nested in SELECT and FROM - Exercise #1

• Defining Stored Routines

• Create Stored Procedures with MySQL Syntax

• An Example of Stored Procedures Part I

• An Example of Stored Procedures Part II

• An Example of Stored Procedures Part II - Exercise

• An Example of Stored Procedures Part II - Solution

• Creating a Procedure in MySQL Another Way

• Create Stored Procedures with an Input Parameter

• Create Stored Procedures with an Output Parameter

• Create Stored Procedures with an Output Parameter - Exercise

• Stored Procedures with an Output Parameter - Solution

• SQL Variables

• SQL Variables - Exercise

• SQL Variables - Solution

• The Benefit of User-Defined Functions in MySQL

• Error Code: 1418.

• The Benefit of User-Defined Functions in MySQL - Exercise

• The Benefit of User-Defined Functions in MySQL - Solution

• Concluding Stored Routines

• The SQL CASE Statement

• The SQL CASE Statement - Exercise 1

• THE SQL CASE Statement - Solution 1

• THE SQL CASE Statement - Exercise 2

• THE SQL CASE Statement - Solution 2

• THE SQL CASE Statement - Exercise 3

• THE SQL CASE Statement - Solution 3

• The SQL CASE Statement - Exercise #1

• The SQL CASE Statement - Exercise #2

• The SQL CASE Statement - Exercise #3

• Introduction to MySQL Window Functions

• The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax

• The ROW_NUMBER Ranking Window Function - Exercise

• The ROW_NUMBER Ranking Window Function - Solution

• The ROW_NUMBER() Ranking Window Function - Exercise #1

• The ROW_NUMBER() Ranking Window Function - Exercise #2

• A Note on Using Several Window Functions in a Query

• A Note on Using Several Window Functions in a Query - Exercise

• A Note on Using Several Window Functions in a Query - Solution

• A Note on Using Several Window Functions - Exercise #1

• A Note on Using Several Window Functions - Exercise #2

• MySQL Window Functions Syntax

• MySQL Window Functions Syntax - Exercise

• MySQL Window Functions Syntax - Solution

• MySQL Window Functions Syntax - Exercise #1

• The PARTITION BY Clause vs the GROUP BY Clause

• The PARTITION BY Clause vs the GROUP BY Clause - Exercise

• The PARTITION BY Clause vs the GROUP BY Clause - Solution

• The PARTITION BY Clause vs the GROUP BY Clause - Exercise #1

• The PARTITION BY Clause vs the GROUP BY Clause - Exercise #2

• The PARTITION BY Clause vs the GROUP BY Clause - Exercise #3

• The MySQL RANK() and DENSE_RANK() Window Functions

• The MySQL RANK() and DENSE_RANK() Window Functions - Exercise

• The MySQL RANK() and DENSE_RANK() Window Functions - Solution

• The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #1

• The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #2

• The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #3

• Working with MySQL Ranking Window Functions and Joins Together

• Working with MySQL Ranking Window Functions and Joins Together - Exercise

• Working with MySQL Ranking Window Functions and Joins Together - Solution

• MySQL Ranking Window Functions and JOINs - Exercise #1

• MySQL Ranking Window Functions and JOINs - Exercise #2

• The LAG() and LEAD() Value Window Functions

• The LAG() and LEAD() Value Window Functions - Exercise

• The LAG() and LEAD() Value Window Functions - Solution

• The LAG() and LEAD() Value Window Functions - Exercise #1

• The LAG() and LEAD() Value Window Functions - Exercise #2

• MySQL Aggregate Functions in the Context of Window Functions - Part I

• MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise

• MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution

• MySQL Aggregate Functions in the Context of Window Functions - Part II

• MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise

• MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution

• MySQL Aggregate Functions in the Context of Window Functions - Exercise #1

• MySQL Aggregate Functions in the Context of Window Functions - Exercise #2

• MySQL Common Table Expressions - Introduction

• An Alternative Solution to the Same Task

• An Alternative Solution to the Same Task-Exercise

• An Alternative Solution to the Same Task-Solution

• An Alternative Solution to the Same Task - Exercise #1

• An Alternative Solution to the Same Task - Exercise #2

• Using Multiple Subclauses in a WITH Clause - Part I

• Using Multiple Subclauses in a WITH Clause - Part II

• Using Multiple Subclauses in a WITH Clause-Exercise

• Using Multiple Subclauses in a WITH Clause-Solution

• Referring to Common Table Expressions in a WITH Clause

• Using Multiple Subclauses in a WITH Clause - Exercise #1

• Using Multiple Subclauses in a WITH Clause - Exercise #2

• Using Multiple Subclauses in a WITH Clause - Exercise #3

• MySQL Temporary Tables - Introduction

• MySQL Temporary Tables in Action

• MySQL Temporary Tables in Action-Exercise

• MySQL Temporary Tables in Action-Solution

• MySQL Temporary Tables - Exercise #1

• MySQL Temporary Tables - Exercise #2

• Other Features of MySQL Temporary Tables

• Other Features of MySQL Temporary Tables-Exercise

• Other Features of MySQL Temporary Tables-Solution

• MySQL Temporary Tables - Other Features - Exercise #1

• MySQL Temporary Tables - Other Features - Exercise #2

• MySQL Temporary Tables - Other Features - Exercise #3

• MySQL Temporary Tables - Other Features - Exercise #4

• Why Use Tableau: Make Your Data Make an Impact

• Let's Download Tableau Public

• Connecting Data in Tableau

• Exploring Tableau's Interface

• Let's Create our first Chart in Tableau!

• Duplicating a Sheet

• Creating a Table

• Creating Custom Fields

• Creating a Custom Field and Adding Calculations to a Table

• Adding Totals and Subtotals

• Adding a Custom Calculation

• Inserting a Filter

• Working with Joins in Tableau

• Introduction to the Exercise

• Let's Create a Dashboard - Visualizing the Three Charts We Want to Create

• Using Joins in Tableau

• Performing a Numbers Check - Attempt #1

• Blending Data in Tableau

• Performing a Numbers Check - Attempt #2

• First Chart

• Second Chart

• Third Chart

• Creating and Formatting a Dashboard

• Adding Interactive Filters for Improved Analysis

• Interactive Filters - fix

• Introduction to Software Integration

• Combining SQL and Tableau

• Loading the Database

• Problem 1: Task

• Problem 1: Task - Text

• Important clarification!

• Problem 1: Solution in SQL

• Problem 1: Solution in SQL - Code

• Exporting Your Output from SQL and Loading it in Tableau

• Chart 1: Visualizing the Solution in Tableau - Part I

• Chart 1: Visualizing the Solution in Tableau - Part II

• MySQL and Tableau - Task/Exercise #1

• Problem 2: Task

• Problem 2: Task - Text

• Problem 2: Solution in SQL

• Problem 2: Solution in SQL - Code

• Chart 2: Visualizing the Solution in Tableau

• MySQL and Tableau - Task/Exercise #2

• Problem 3: Task

• Problem 3: Task - Text

• Problem 3: Solution in SQL

• Problem 3: Solution in SQL - Code

• Chart 3: Visualizing the Solution in Tableau

• MySQL and Tableau - Task/Exercise #3

• Problem 4: Task

• Problem 4: Task - Text

• Problem 4: Solution in SQL

• Problem 4: Solution in SQL - Code

• Chart 4: Visualizing the Solution in Tableau

• Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard

• A 5-minute explanation of Programming

• Why use Python?

• Why use Jupyter?

• How to Install Python and Jupyter

• Understanding Jupyter’s Interface – Dashboard

• Understanding Jupyter’s Interface – Prerequisites for Coding

• Understanding Jupyter's Interface

• Python 2 vs Python 3

• Python Variables

• Python Variables - Exercise #1

• Python Variables - Exercise #2

• Python Variables - Exercise #3

• Python Variables - Exercise #4

• Understanding Numbers and Boolean Values

• Numbers and Boolean Values - Exercise #1

• Numbers and Boolean Values - Exercise #2

• Numbers and Boolean Values - Exercise #3

• Numbers and Boolean Values - Exercise #4

• Numbers and Boolean Values - Exercise #5

• Strings

• Strings - Exercise #1

• Strings - Exercise #2

• Strings - Exercise #3

• Strings - Exercise #4

• Strings - Exercise #5

• The Arithmetic Operators of Python

• The Arithmetic Operators in Python - Exercise #1

• The Arithmetic Operators in Python - Exercise #2

• The Arithmetic Operators in Python - Exercise #3

• The Arithmetic Operators in Python - Exercise #4

• The Arithmetic Operators in Python - Exercise #5

• The Arithmetic Operators in Python - Exercise #6

• The Arithmetic Operators in Python - Exercise #7

• The Arithmetic Operators in Python - Exercise #8

• Using Arithmetic Operators in Python

• What is the Double Equality Sign?

• What is the Double Equality Sign? - Exercise #1

• How to Reassign Values

• How to Reassign Values - Exercise #1

• How to Reassign Values - Exercise #2

• How to Reassign Values - Exercise #3

• How to Reassign Values - Exercise #4

• How to Add Comments

• Understanding Line Continuation

• Understanding Line Continuation - Exercise #1

• How to Index Elements

• How to Index Elements - Exercise #1

• How to Index Elements - Exercise #2

• How to Structure Your Code with Indentation

• How to Structure Your Code with Indentation - Exercise #1

• Python's Comparison Operators

• Python's Comparison Operators - Exercise #1

• Python's Comparison Operators - Exercise #2

• Python's Comparison Operators - Exercise #3

• Python's Comparison Operators - Exercise #4

• Python's Logical and Identity Operators

• Python's Logical and Identity Operators - Exercise #1

• Python's Logical and Identity Operators - Exercise #2

• Python's Logical and Identity Operators - Exercise #3

• Python's Logical and Identity Operators - Exercise #4

• Python's Logical and Identity Operators - Exercise #5

• Python's Logical and Identity Operators - Exercise #6

• Getting to know the IF Statement

• The IF Statement - Exercise #1

• The IF Statement - Exercise #2

• Adding an ELSE statement

• The ELSE Statement - Exercise #1

• Else if, for Brief – ELIF

• The ELIF Statement - Exercise #1

• The ELIF Statement - Exercise #2

• An Additional Explanation of Boolean Values

• How to Define a Function in Python

• How to Create a Function with a Parameter

• How to Create a Function with a Parameter - Exercise #1

• How to Create a Function with a Parameter - Exercise #2

• Define a Function in Another Way

• Define a Function in Another Way - Exercise #1

• How to Use a Function within a Function

• How to Use a Function within a Function - Exercise #1

• Use Conditional Statements and Functions Together

• Conditional Statements and Functions - Exercise #1

• How to Create Functions Which Contain a Few Arguments

• Built-In Functions in Python Worth Knowing

• Built-In Function in Python Worth Knowing - Exercise #1

• Built-In Function in Python Worth Knowing - Exercise #2

• Built-In Function in Python Worth Knowing - Exercise #3

• Built-In Function in Python Worth Knowing - Exercise #4

• Built-In Function in Python Worth Knowing - Exercise #5

• Built-In Function in Python Worth Knowing - Exercise #6

• Built-In Function in Python Worth Knowing - Exercise #7

• Built-In Function in Python Worth Knowing - Exercise #8

• Built-In Function in Python Worth Knowing - Exercise #9

• Python - Functions

• Introduction to Lists

• Introduction to Lists - Exercise #1

• Introduction to Lists - Exercise #2

• Introduction to Lists - Exercise #3

• Introduction to Lists - Exercise #4

• Introduction to Lists - Exercise #5

• Using Methods in Python

• Using Methods in Python - Exercise #1

• Using Methods in Python - Exercise #2

• Using Methods in Python - Exercise #3

• Using Methods in Python - Exercise #4

• What is List Slicing?

• What is List Slicing? - Exercise #1

• What is List Slicing? - Exercise #2

• What is List Slicing? - Exercise #3

• What is List Slicing? - Exercise #4

• What is List Slicing? - Exercise #5

• What is List Slicing? - Exercise #6

• What is List Slicing? - Exercise #7

• Working with Tuples

• Working with Tuples - Exercise #1

• Working with Tuples - Exercise #2

• Working with Tuples - Exercise #3

• Working with Tuples - Exercise #4

• Python Dictionaries

• Python Dictionaries - Exercise #1

• Python Dictionaries - Exercise #2

• Python Dictionaries - Exercise #3

• Python Dictionaries - Exercise #4

• Python Dictionaries - Exercise #5

• Python Dictionaries - Exercise #6

• Using For Loops

• Using For Loops - Exercise #1

• Using For Loops - Exercise #2

• Using While Loops and Incrementing

• Using While Loops and Incrementing - Exercise #1

• Use the range() Function to Create Lists

• Use the range() Function to Create Lists - Exercise - #1

• Use the range() Function to Create Lists - Exercise - #2

• Use the range() Function to Create Lists - Exercise - #3

• Combine Conditional Statements and Loops

• Conditional Statements and Loops - Exercise #1

• Conditional Statements and Loops - Exercise #2

• Conditional Statements and Loops - Exercise #3

• All In – Conditional Statements, Functions, and Loops

• All In - Conditional Statements, Functions, and Loops - Exercise #1

• How to Iterate over Dictionaries

• How to Iterate over Dictionaries - Exercise #1

• How to Iterate over Dictionaries - Exercise #2

• Introduction to Object Oriented Programming (OOP)

• Using Modules and Packages

• What is the Standard Library?

• How to Import Modules in Python

• Getting Started with Data, Servers, Clients, Requests, and Responses

• Getting Started with Data Connectivity, APIs, and Endpoints

• Become Better Acquainted with APIs

• Communication through Text Files

• What is Software Integration and How is it Applied?

• Solving a Business Exercise with Python, SQL, and Tableau

• Presenting the Task: Absenteeism at Work

• Presenting the Data Set

• How is the Content in the Next Sections Organized?

• How to Import the Data Set in Python

• Exploring the Data Set

• Programming vs the Rest of the World

• A Brief Summary of Regression Analysis

• The Approach we will Take to Solve this Exercise

• Dropping Variables We Don't Need

• EXERCISE - Dropping Variables We Don't Need

• SOLUTION - Dropping Variables We Don't Need

• A Deeper Look at the 'Reasons for Absence' Column

• Splitting a Variable into Multiple Dummy Variables

• EXERCISE - Splitting a Variable into Multiple Dummy Variables

• SOLUTION - Splitting a Variable into Multiple Dummy Variables

• How to Drop a Dummy Variable from the Data Set

• A Statistical Perspective on Dummy Variables

• Categorizing the Various Reasons for Absence

• Concatenation in Python

• EXERCISE - Concatenation in Python

• SOLUTION - Concatenation in Python

• How to Reorder Columns in a DataFrame in Python

• EXERCISE - How to Reorder Columns in a DataFrame in Python

• SOLUTION - How to Reorder Columns in a DataFrame in Python

• Using Checkpoints to Ease Your Work in Jupyter

• EXERCISE - Using Checkpoints to Ease Your Work in Jupyter

• SOLUTION - Using Checkpoints to Ease Your Work in Jupyter

• Analyzing the "Date" Column

• Retrieving the Month Value From the "Date" Column

• Adding the "Day of the Week" Column

• EXERCISE - Dropping Columns

• Analysis of the Next 5 Columns in DF

• Dealing with More Numerical Features which may Behave like Categorical Ones

• A Final Note on this Section

• How to Use the 'absenteeism_module' in Python - Part I

• How to Use the 'absenteeism_module' in Python - Part II

• Creating the 'predicted_outputs' Database in MySQL

• Importing 'pymysql' in Python

• Creating a Connection and Cursor

• EXERCISE - Creating 'df_new_obs'

• Creating the 'predicted_outputs' Table in MySQL

• Executing and SQL SELECT Statement from Python

• Sending Data from Jupyter to Workbench - Part I

• Sending Data from Jupyter to Workbench - Part II

• Sending Data from Jupyter to Workbench - Part III

• EXERCISE - Age vs Probability

• Using Tableau to Analyze Age vs Probability

• EXERCISE - Reasons vs Probability

• Using Tableau to Analyze Reasons vs Probability

• EXERCISE - Transportation Expense vs Probability

• Using Tableau to Analyze Transportation Expense vs Probability

• Completing 100%