The Business Intelligence Analyst Course 2024

About Course

Hi! Welcome to The Business Intelligence Analyst Course, the only course you need to become a BI Analyst.

We are proud to present you this one-of-a-kind opportunity. There are several online courses teaching some of the skills related to the BI Analyst profession. The truth of the matter is that none of them completely prepare you.

Our program is different than the rest of the materials available online.

It is truly comprehensive. The Business Intelligence Analyst Course comprises of several modules:

Introduction to Data and Data Science
Statistics and Excel
Database theory
SQL
Tableau
SQL + Tableau

These are the precise technical skills recruiters are looking for when hiring BI Analysts. And today, you have the chance of acquiring an invaluable advantage to get ahead of other candidates. This course will be the secret to your success. And your success is our success, so let’s make it happen!

Here are some more details of what you get with The Business Intelligence Analyst Course:

Introduction to Data and Data Science – Make sense of terms like business intelligence, traditional and big data, traditional statistical methods, machine learning, predictive analytics, supervised learning, unsupervised learning, reinforcement learning, and many more;
Statistics and Excel – Understand statistical testing and build a solid foundation. Modern software packages and programming languages are automating most of these activities, but this part of the course gives you something more valuable – critical thinking abilities;
Database theory – Before you start using SQL, it is highly beneficial to learn about the underlying database theory and acquire an understanding of why databases are created and how they can help us manage data
SQL – when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business
Tableau – one of the most powerful and intuitive data visualization tools available out there. Almost all large companies use such tools to enhance their BI capabilities. Tableau is the #1 best-in-class solution that helps you create powerful charts and dashboards
Learning a programming language is meaningless without putting it to use. That’s why we integrate SQL and Tableau, and perform several real-life Business Intelligence tasks

Sounds amazing, right?

Our courses are unique because our team works hard to:

Pre-script the entire content
Work with real-life examples
Provide easy to understand and complete explanations
Create beautiful and engaging animations
Prepare exercises, course notes, quizzes, and other materials that will enhance your course taking experience
Be there for you and provide support whenever necessary

We love teaching and we are really excited about this journey. It will get your foot in the door of an exciting and rising profession. Don’t hesitate and subscribe today. The only regret you will have is that you didn’t find this course sooner!

Become an expert in Statistics, SQL, Tableau, and problem solving
Boost your resume with in-demand skills
Gather, organize, analyze and visualize data
Use data for improved business decision-making
Present information in the form of metrics, KPIs, reports, and dashboards
Perform quantitative and qualitative business analysis
Analyze current and historical data
Discover how to find trends, market conditions, and research competitor positioning
Understand the fundamentals of database theory
Use SQL to create, design, and manipulate SQL databases
Extract data from a database writing your own queries
Create powerful professional visualizations in Tableau
Combine SQL and Tableau to visualize data from the source
Solve real-world business analysis tasks in SQL and Tableau

Course Content

01. Part 1 Introduction

002. Download All Resources.html

00:00

02. Intro to Data and Data Science – The Different Data Science Fields

001. Why Are There So Many Business and Data Science Buzzwords.mp4

00:00
002. Analysis vs Analytics.mp4

00:00
003. Intro to Business Analytics, Data Analytics, and Data Science.mp4

00:00
004. Intro to Business Analytics, Data Analytics, and Data Science.html

00:00
005. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.mp4

00:00
006. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.html

00:00
007. An Overview of our Data Science Infographic.mp4

00:00
008. An Overview of our Data Science Infographic.html

00:00

03. Intro to Data and Data Science – The Relationship between Different Fields

04. Intro to Data and Data Science – What is the Purpose of each Data Science Field

05. Intro to Data and Data Science – Common Data Science Techniques

001. Traditional Data Techniques.mp4

00:00
002. Traditional Data Techniques.html

00:00
003. Traditional Data Real-life Examples.mp4

00:00
004. Big Data Techniques.mp4

00:00
005. Big Data Techniques.html

00:00
006. Big Data Real-life Examples.mp4

00:00
007. Business Intelligence (BI) Techniques.mp4

00:00
008. Business Intelligence (BI) Techniques.html

00:00
009. Business Intelligence (BI) Real-life Examples.mp4

00:00
010. Traditional Methods Techniques.mp4

00:00
011. Traditional Methods Techniques.html

00:00
012. Traditional Methods Real-life Examples.mp4

00:00
013. Machine Learning (ML) Techniques.mp4

00:00
014. Machine Learning (ML) Techniques.html

00:00
015. Machine Learning (ML) Types of Machine Learning.mp4

00:00
016. Machine Learning (ML) Types of Machine Learning.html

00:00
017. Machine Learning (ML) Real-life Examples.mp4

00:00
018. Machine Learning (ML) Real-life Examples.html

00:00

06. Intro to Data and Data Science – Common Data Science Tools

07. Intro to Data and Data Science – Data Science Career Paths

08. Intro to Data and Data Science – Dispelling Common Misconceptions

09. Part 2 Statistics – Population and Sample

10. Statistics – Descriptive Statistics

001. Types of Data.mp4

00:00
002. Types of data.html

00:00
003. Levels of Measurement.mp4

00:00
004. Levels of measurement.html

00:00
005. Categorical Variables – Visualization Techniques.mp4

00:00
006. Categorical variables. Visualization Techniques.html

00:00
007. Categorical Variables Exercise.html

00:00
008. Numerical Variables – Frequency Distribution Table.mp4

00:00
009. Numerical variables. Using a frequency distribution table.html

00:00
010. Numerical Variables Exercise.html

00:00
011. The Histogram.mp4

00:00
012. The Histogram.html

00:00
013. Histogram Exercise.html

00:00
014. Cross Table and Scatter Plot.mp4

00:00
015. Cross Tables and Scatter Plots.html

00:00
016. Cross Tables and Scatter Plots Exercise.html

00:00
017. Mean, median and mode.mp4

00:00
018. Mean, Median and Mode Exercise.html

00:00
019. Skewness.mp4

00:00
020. Skewness.html

00:00
021. Skewness Exercise.html

00:00
022. Variance.mp4

00:00
023. Variance Exercise.html

00:00
024. Standard Deviation and Coefficient of Variation.mp4

00:00
025. Standard deviation.html

00:00
026. Standard Deviation and Coefficient of Variation Exercise.html

00:00
027. Covariance.mp4

00:00
028. Covariance.html

00:00
029. Covariance Exercise.html

00:00
030. Correlation Coefficient.mp4

00:00
031. Correlation Coefficient.html

00:00
032. Correlation Coefficient Exercise.html

00:00

11. Statistics – Practical Example Descriptive Statistics

12. Statistics – Inferential Statistics Fundamentals

001. Introduction.mp4

00:00
002. What is a Distribution.mp4

00:00
003. What is a Distribution.html

00:00
004. The Normal Distribution.mp4

00:00
005. The Normal Distribution.html

00:00
006. The Standard Normal Distribution.mp4

00:00
007. The Standard Normal Distribution.html

00:00
008. The Standard Normal Distribution Exercise.html

00:00
009. Central Limit Theorem.mp4

00:00
010. Central Limit Theorem.html

00:00
011. Standard error.mp4

00:00
012. Standard error.html

00:00
013. Estimators and Estimates.mp4

00:00
014. Estimators and Estimates.html

00:00

13. Statistics – Inferential Statistics Confidence Intervals

001. What are Confidence Intervals.mp4

00:00
002. What are Confidence Intervals.html

00:00
003. Confidence Intervals; Population Variance Known; z-score.mp4

00:00
004. Confidence Intervals; Population Variance Known; z-score Exercise.html

00:00
005. Confidence interval clarifications.mp4

00:00
006. Student’s T Distribution.mp4

00:00
007. Student’s T Distribution.html

00:00
008. Confidence Intervals; Population Variance Unknown; t-score.mp4

00:00
009. Confidence Intervals; Population Variance Unknown; t-score Exercise.html

00:00
010. Margin of Error.mp4

00:00
011. Margin of Error.html

00:00
012. Confidence intervals. Two means. Dependent samples.mp4

00:00
013. Confidence intervals. Two means. Dependent samples Exercise.html

00:00
014. Confidence intervals. Two means. Independent samples (Part 1).mp4

00:00
015. Confidence intervals. Two means. Independent samples (Part 1) Exercise.html

00:00
016. Confidence intervals. Two means. Independent samples (Part 2).mp4

00:00
017. Confidence intervals. Two means. Independent samples (Part 2) Exercise.html

00:00
018. Confidence intervals. Two means. Independent samples (Part 3).mp4

00:00

14. Statistics – Practical Example Inferential Statistics

15. Statistics – Hypothesis Testing

001. The Null vs Alternative Hypothesis.mp4

00:00
002. Further Reading on Null and Alternative Hypothesis.html

00:00
003. The Null vs Alternative Hypothesis.html

00:00
004. Rejection Region and Significance Level.mp4

00:00
005. Rejection Region and Significance Level.html

00:00
006. Type I Error and Type II Error.mp4

00:00
007. Type I Error and Type II Error.html

00:00
008. Test for the Mean. Population Variance Known.mp4

00:00
009. Test for the Mean. Population Variance Known Exercise.html

00:00
010. p-value.mp4

00:00
011. p-value.html

00:00
012. Test for the Mean. Population Variance Unknown.mp4

00:00
013. Test for the Mean. Population Variance Unknown Exercise.html

00:00
014. Test for the Mean. Dependent Samples.mp4

00:00
015. Test for the Mean. Dependent Samples Exercise.html

00:00
016. Test for the mean. Independent samples (Part 1).mp4

00:00
017. Test for the mean. Independent samples (Part 1). Exercise.html

00:00
018. Test for the mean. Independent samples (Part 2).mp4

00:00
019. Test for the mean. Independent samples (Part 2).html

00:00
020. Test for the mean. Independent samples (Part 2).html

00:00

16. Statistics – Practical Example Hypothesis Testing

17. Part 3 Relational Database Theory & Introduction to SQL

001. Why use SQL.mp4

00:00
002. Why use SQL.html

00:00
003. Why use MySQL.mp4

00:00
004. Why use MySQL.html

00:00
005. Introducing Databases.mp4

00:00
006. Introducing Databases.html

00:00
007. Relational Database Fundamentals.mp4

00:00
008. Relational Database Fundamentals.html

00:00
009. Comparing Databases and Spreadsheets.mp4

00:00
010. Comparing Databases and Spreadsheets.html

00:00
011. Important Database Terminology.mp4

00:00
012. Important Database Terminology.html

00:00
013. The Concept of Relational Schemas Primary Key.mp4

00:00
014. The Concept of Relational Schemas Primary Key.html

00:00
015. The Concept of Relational Schemas Foreign Key.mp4

00:00
016. The Concept of Relational Schemas Foreign Key.html

00:00
017. The Concept of Relational Schemas Unique Key and Null Values.mp4

00:00
018. The Concept of Relational Schemas Unique Key.html

00:00
019. The Concept of Relational Schemas Relationships Between Tables.mp4

00:00
020. The Concept of Relational Schemas Relationships Between Tables.html

00:00

18. SQL – Install and get to know MySQL

19. SQL – Best SQL Practices

20. SQL – Loading the ’employees’ Database

21. SQL – Practical Application of the SQL SELECT Statement

001. Using SELECT – FROM.mp4

00:00
002. Using SELECT – FROM – Exercise.html

00:00
003. Using SELECT – FROM – Solution.html

00:00
004. Using WHERE.mp4

00:00
005. Using WHERE – Exercise.html

00:00
006. Using WHERE – Solution.html

00:00
007. Using AND.mp4

00:00
008. Using AND – Exercise.html

00:00
009. Using AND – Solution.html

00:00
010. Using OR.mp4

00:00
011. Using OR – Exercise.html

00:00
012. Using OR – Solution.html

00:00
013. Operator Precedence and Logical Order.mp4

00:00
014. Operator Precedence and Logical Order – Exercise.html

00:00
015. Operator Precedence and Logical Order – Solution.html

00:00
016. Using IN – NOT IN.mp4

00:00
017. Using IN – NOT IN – Exercise 1.html

00:00
018. Using IN – NOT IN – Solution 1.html

00:00
019. Using IN – NOT IN – Exercise 2.html

00:00
020. Using IN – NOT IN – Solution 2.html

00:00
021. Using LIKE – NOT LIKE.mp4

00:00
022. Using LIKE – NOT LIKE – Exercise.html

00:00
023. Using LIKE – NOT LIKE – Solution.html

00:00
024. Using Wildcard Characters.mp4

00:00
025. Using Wildcard characters – Exercise.html

00:00
026. Using Wildcard characters – Solution.html

00:00
027. Using BETWEEN – AND.mp4

00:00
028. Using BETWEEN – AND – Exercise.html

00:00
029. Using BETWEEN – AND – Solution.html

00:00
030. Using IS NOT NULL – IS NULL.mp4

00:00
031. Using IS NOT NULL – IS NULL – Exercise.html

00:00
032. Using IS NOT NULL – IS NULL – Solution.html

00:00
033. Using Other Comparison Operators.mp4

00:00
034. Using Other Comparison Operators – Exercise.html

00:00
035. Using Other Comparison Operators – Solution.html

00:00
036. Using SELECT DISTINCT.mp4

00:00
037. Using SELECT DISTINCT – Exercise.html

00:00
038. Using SELECT DISTINCT – Solution.html

00:00
039. Getting to Know Aggregate Functions.mp4

00:00
040. Getting to Know Aggregate Functions – Exercise.html

00:00
041. Getting to Know Aggregate Functions – Solution.html

00:00
042. Using ORDER BY.mp4

00:00
043. Using ORDER BY – Exercise.html

00:00
044. Using ORDER BY – Solution.html

00:00
045. Using GROUP BY.mp4

00:00
046. Using Aliases (AS).mp4

00:00
047. Using Aliases (AS) – Exercise.html

00:00
048. Using Aliases (AS) – Solution.html

00:00
049. Using HAVING.mp4

00:00
050. Using HAVING – Exercise.html

00:00
051. Using HAVING – Solution.html

00:00
052. Using WHERE vs HAVING – Part I.mp4

00:00
053. Using WHERE vs HAVING – Part II.mp4

00:00
054. Using WHERE vs HAVING – Part II – Exercise.html

00:00
055. Using WHERE vs HAVING – Part II – Solution.html

00:00
056. Using LIMIT.mp4

00:00
057. Using LIMIT – Exercise.html

00:00
058. Using LIMIT – Solution.html

00:00

22. SQL – Expanding on MySQL Aggregate Functions

001. Applying COUNT().mp4

00:00
002. Applying COUNT() – Exercise.html

00:00
003. Applying COUNT() – Solution.html

00:00
004. Applying SUM().mp4

00:00
005. Applying SUM() – Exercise.html

00:00
006. Applying SUM() – Solution.html

00:00
007. MIN() and MAX().mp4

00:00
008. MIN() and MAX() – Exercise.html

00:00
009. MIN() and MAX() – Solution.html

00:00
010. Applying AVG().mp4

00:00
011. Applying AVG() – Exercise.html

00:00
012. Applying AVG() – Solution.html

00:00
013. Rounding Numbers with ROUND().mp4

00:00
014. Rounding Numbers with ROUND() – Exercise.html

00:00
015. Rounding Numbers with ROUND() – Solution.html

00:00

23. SQL – SQL JOINs

001. What are JOINs.mp4

00:00
002. What are JOINs – Exercise 1.html

00:00
003. What are JOINs – Exercise 2.html

00:00
004. The Functionality of INNER JOIN – Part I.mp4

00:00
005. The Functionality of INNER JOIN – Part II.mp4

00:00
006. The Functionality of INNER JOIN – PART II – Exercise.html

00:00
007. The Functionality of INNER JOIN – PART II – Solution.html

00:00
008. Extra Info on Using Joins.mp4

00:00
009. Duplicate Rows.mp4

00:00
010. The Functionality of LEFT JOIN – Part I.mp4

00:00
Draft Lesson

00:00
012. The Functionality of LEFT JOIN – Part II – Exercise.html

00:00
013. The Functionality of LEFT JOIN – Part II – Solution.html

00:00
014. The Functionality of RIGHT JOIN.mp4

00:00
015. Differences between the New and the Old Join Syntax.mp4

00:00
016. Differences between the New and the Old Join Syntax – Exercise.html

00:00
017. Differences between the New and the Old Join Syntax – Solution.html

00:00
018. Using JOIN and WHERE Together.mp4

00:00
019. Important – Prevent Error Code 1055!.html

00:00
020. Using JOIN and WHERE Together – Exercise.html

00:00
021. Using JOIN and WHERE Together – Solution.html

00:00
022. The Functionality of CROSS JOIN.mp4

00:00
023. The Functionality of CROSS JOIN – Exercise 1.html

00:00
024. The Functionality of CROSS JOIN – Solution 1.html

00:00
025. The Functionality of CROSS JOIN – Exercise 2.html

00:00
026. The Functionality of CROSS JOIN – Solution 2.html

00:00
027. Combining Aggregate Functions with Joins.mp4

00:00
028. JOIN More than Two Tables.mp4

00:00
029. JOIN More than Two Tables – Exercise.html

00:00
030. JOIN More than Two Tables – Solution.html

00:00
031. Top Tips for Joins.mp4

00:00
032. Top Tips for Joins – Exercise.html

00:00
033. Top Tips for Joins – Solution.html

00:00
034. The Differences Between UNION and UNION ALL.mp4

00:00
035. The Differences Between UNION and UNION ALL – Exercise.html

00:00
036. The Differences Between UNION and UNION ALL – Solution.html

00:00

24. SQL – SQL Subqueries

001. SQL Subqueries with IN Embedded Inside WHERE.mp4

00:00
002. SQL Subqueries with IN Embedded Inside WHERE – Exercise.html

00:00
003. SQL Subqueries with IN Embedded Inside WHERE – Solution.html

00:00
004. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE.mp4

00:00
005. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE – Exercise.html

00:00
006. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE – Solution.html

00:00
007. SQL Subqueries Nested in SELECT and FROM.mp4

00:00
008. SQL Subqueries Embedded in SELECT and FROM – Exercise 1.html

00:00
009. SQL Subqueries Embedded in SELECT and FROM – Exercise 2.html

00:00
010. SQL Subqueries Nested in SELECT and FROM – Solution 2.html

00:00

25. SQL – Stored Routines

001. Defining Stored Routines.mp4

00:00
002. Defining Stored Routines.html

00:00
003. Create Stored Procedures with MySQL Syntax.mp4

00:00
004. An Example of Stored Procedures Part I.mp4

00:00
005. An Example of Stored Procedures Part II.mp4

00:00
006. An Example of Stored Procedures Part II – Exercise.html

00:00
007. An Example of Stored Procedures Part II – Solution.html

00:00
008. Creating a Procedure in MySQL Another Way.mp4

00:00
009. Create Stored Procedures with an Input Parameter.mp4

00:00
010. Create Stored Procedures with an Output Parameter.mp4

00:00
011. Create Stored Procedures with an Output Parameter – Exercise.html

00:00
012. Stored Procedures with an Output Parameter – Solution.html

00:00
013. SQL Variables.mp4

00:00
014. SQL Variables – Exercise.html

00:00
015. SQL Variables – Solution.html

00:00
016. The Benefit of User-Defined Functions in MySQL.mp4

00:00
017. Error Code 1418..html

00:00
018. The Benefit of User-Defined Functions in MySQL – Exercise.html

00:00
019. The Benefit of User-Defined Functions in MySQL – Solution.html

00:00
020. Concluding Stored Routines.mp4

00:00
021. Concluding Stored Routines.html

00:00

26. SQL – The CASE Statement

27. Part 4 Introduction to Tableau

28. Tableau – Tableau functionalities

29. Tableau – The Tableau Exercise

001. Introduction to the Exercise.mp4

00:00
002. Let’s Create a Dashboard – Visualizing the Three Charts We Want to Create.mp4

00:00
003. Using Joins in Tableau.mp4

00:00
004. Performing a Numbers Check – Attempt #1.mp4

00:00
005. Blending Data in Tableau.mp4

00:00
006. Performing a Numbers Check – Attempt #2.mp4

00:00
007. First Chart.mp4

00:00
008. Second Chart.mp4

00:00
009. Third Chart.mp4

00:00
010. Creating and Formatting a Dashboard.mp4

00:00
011. Adding Interactive Filters for Improved Analysis.mp4

00:00
012. Interactive Filters – fix.mp4

00:00

30. Part 5 Combining SQL and Tableau – Introduction

31. Combining SQL and Tableau – Problem 1

32. Combining SQL and Tableau – Problem 2

33. Combining SQL and Tableau – Problem 3

34. Combining SQL and Tableau – Problem 4

35. Combining SQL and Tableau – Problem 5

36. Part 6 Introduction to Programming with Python

002. A 5-minute explanation of Programming.html

00:00
003. Why use Python.mp4

00:00
004. Why Use Python.html

00:00
005. Why use Jupyter.mp4

00:00
006. Why Use Jupyter.html

00:00
007. How to Install Python and Jupyter.mp4

00:00
008. Understanding Jupyter’s Interface – Dashboard.mp4

00:00
009. Understanding Jupyter’s Interface – Prerequisites for Coding.mp4

00:00
010. Understanding Jupyter’s Interface.html

00:00
011. Python 2 vs Python 3.mp4

00:00

37. Python – Python Variables and Data Types

38. Python – Python Syntax Fundamentals

001. The Arithmetic Operators of Python.mp4

00:00
002. Using Arithmetic Operators in Python.html

00:00
003. What is the Double Equality Sign.mp4

00:00
004. What is the Double Equality Sign.html

00:00
005. How to Reassign Values.mp4

00:00
006. How to Reassign Values.html

00:00
007. How to Add Comments.mp4

00:00
008. How to Add Comments.html

00:00
009. Understanding Line Continuation.mp4

00:00
010. How to Index Elements.mp4

00:00
011. How to Index Elements.html

00:00
012. How to Structure Your Code with Indentation.mp4

00:00
013. How to Structure Your Code with Indentation.html

00:00

39. Python – Other Python Operators

40. Python – Conditional Statements

41. Python – Functions

42. Python – Python Sequences

43. Python – Using Iterations

44. Python – Advanced Python tools

45. Part 7 Integration – Software Integration

001. Getting Started with Data, Servers, Clients, Requests, and Responses.mp4

00:00
002. Getting Started with Data, Servers, Clients, Requests, and Responses.html

00:00
003. Getting Started with Data Connectivity, APIs, and Endpoints.mp4

00:00
004. Getting Started with Data Connectivity, APIs, and Endpoints.html

00:00
005. Become Better Acquainted with APIs.mp4

00:00
006. Become Better Acquainted with APIs.html

00:00
007. Communication through Text Files.mp4

00:00
008. Communication through Text Files.html

00:00
009. What is Software Integration and How is it Applied.mp4

00:00
010. What is Software Integration and How is it Applied.html

00:00

46. Integration – What is contained in this Course

47. Integration – Data Preprocessing Step by Step

001. How is the Content in the Next Sections Organized.html

00:00
002. How to Import the Data Set in Python.mp4

00:00
003. Exploring the Data Set.mp4

00:00
004. Programming vs the Rest of the World.mp4

00:00
005. A Brief Summary of Regression Analysis.html

00:00
006. The Approach we will Take to Solve this Exercise.mp4

00:00
007. Dropping Variables We Don’t Need.mp4

00:00
008. EXERCISE – Dropping Variables We Don’t Need.html

00:00
009. SOLUTION – Dropping Variables We Don’t Need.html

00:00
010. A Deeper Look at the ‘Reasons for Absence’ Column.mp4

00:00
011. Splitting a Variable into Multiple Dummy Variables.mp4

00:00
012. EXERCISE – Splitting a Variable into Multiple Dummy Variables.html

00:00
013. SOLUTION – Splitting a Variable into Multiple Dummy Variables.html

00:00
014. How to Drop a Dummy Variable from the Data Set.html

00:00
015. A Statistical Perspective on Dummy Variables.mp4

00:00
016. Categorizing the Various Reasons for Absence.mp4

00:00
017. Concatenation in Python.mp4

00:00
018. EXERCISE – Concatenation in Python.html

00:00
019. SOLUTION – Concatenation in Python.html

00:00
020. How to Reorder Columns in a DataFrame in Python.mp4

00:00
021. EXERCISE – How to Reorder Columns in a DataFrame in Python.html

00:00
022. SOLUTION – How to Reorder Columns in a DataFrame in Python.html

00:00
023. Using Checkpoints to Ease Your Work in Jupyter.mp4

00:00
024. EXERCISE – Using Checkpoints to Ease Your Work in Jupyter.html

00:00
025. SOLUTION – Using Checkpoints to Ease Your Work in Jupyter.html

00:00
026. Analyzing the Date Column.mp4

00:00
027. Retrieving the Month Value From the Date Column.mp4

00:00
028. Adding the Day of the Week Column.mp4

00:00
029. EXERCISE – Dropping Columns.html

00:00
030. Analysis of the Next 5 Columns in DF.mp4

00:00
031. Dealing with More Numerical Features which may Behave like Categorical Ones.mp4

00:00
032. A Final Note on this Section.mp4

00:00

48. Integration – Integrating Python and SQL

001. How to Use the ‘absenteeism_module’ in Python – Part I.mp4

00:00
002. How to Use the ‘absenteeism_module’ in Python – Part II.mp4

00:00
003. Creating the ‘predicted_outputs’ Database in MySQL.mp4

00:00
004. Importing ‘pymysql’ in Python.mp4

00:00
005. Creating a Connection and Cursor.mp4

00:00
006. EXERCISE – Creating ‘df_new_obs’.html

00:00
007. Creating the ‘predicted_outputs’ Table in MySQL.mp4

00:00
008. Executing and SQL SELECT Statement from Python.mp4

00:00
009. Sending Data from Jupyter to Workbench – Part I.mp4

00:00
010. Sending Data from Jupyter to Workbench – Part II.mp4

00:00
011. Sending Data from Jupyter to Workbench – Part III.mp4

00:00

49. Integration – Using Tableau to Analyze the Predicted Outputs

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

01. Part 1 Introduction

002. Download All Resources.html

02. Intro to Data and Data Science – The Different Data Science Fields

001. Why Are There So Many Business and Data Science Buzzwords.mp4

002. Analysis vs Analytics.mp4

003. Intro to Business Analytics, Data Analytics, and Data Science.mp4

004. Intro to Business Analytics, Data Analytics, and Data Science.html

005. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.mp4

006. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.html

007. An Overview of our Data Science Infographic.mp4

008. An Overview of our Data Science Infographic.html

03. Intro to Data and Data Science – The Relationship between Different Fields

001. When are Traditional data, Big Data, BI, Traditional Data Science and ML applied.mp4

002. When are Traditional data, Big Data, BI, Traditional Data Science and ML applied.html

04. Intro to Data and Data Science – What is the Purpose of each Data Science Field

001. Why do we Need each of these Disciplines.mp4

002. Why do we Need each of these Disciplines.html

05. Intro to Data and Data Science – Common Data Science Techniques

001. Traditional Data Techniques.mp4

002. Traditional Data Techniques.html

003. Traditional Data Real-life Examples.mp4

004. Big Data Techniques.mp4

005. Big Data Techniques.html

006. Big Data Real-life Examples.mp4

007. Business Intelligence (BI) Techniques.mp4

008. Business Intelligence (BI) Techniques.html

009. Business Intelligence (BI) Real-life Examples.mp4

010. Traditional Methods Techniques.mp4

011. Traditional Methods Techniques.html

012. Traditional Methods Real-life Examples.mp4

013. Machine Learning (ML) Techniques.mp4

014. Machine Learning (ML) Techniques.html

015. Machine Learning (ML) Types of Machine Learning.mp4

016. Machine Learning (ML) Types of Machine Learning.html

017. Machine Learning (ML) Real-life Examples.mp4

018. Machine Learning (ML) Real-life Examples.html

06. Intro to Data and Data Science – Common Data Science Tools

001. Programming Languages & Software Employed in Data Science – All the Tools Needed.mp4

002. Programming Languages & Software Employed in Data Science – All the Tools Needed.html

07. Intro to Data and Data Science – Data Science Career Paths

001. Data Science Job Positions What do they Involve and What to Look out for.mp4

002. Data Science Job Positions What do they Involve and What to Look out for.html

08. Intro to Data and Data Science – Dispelling Common Misconceptions

001. Dispelling common Misconceptions.mp4

002. Dispelling common Misconceptions.html

09. Part 2 Statistics – Population and Sample

001. Population vs sample.mp4

002. Population and Sample.html

10. Statistics – Descriptive Statistics

001. Types of Data.mp4

002. Types of data.html

003. Levels of Measurement.mp4

004. Levels of measurement.html

005. Categorical Variables – Visualization Techniques.mp4

006. Categorical variables. Visualization Techniques.html

007. Categorical Variables Exercise.html

008. Numerical Variables – Frequency Distribution Table.mp4

009. Numerical variables. Using a frequency distribution table.html

010. Numerical Variables Exercise.html

011. The Histogram.mp4

012. The Histogram.html

013. Histogram Exercise.html

014. Cross Table and Scatter Plot.mp4

015. Cross Tables and Scatter Plots.html

016. Cross Tables and Scatter Plots Exercise.html

017. Mean, median and mode.mp4

018. Mean, Median and Mode Exercise.html

019. Skewness.mp4

020. Skewness.html

021. Skewness Exercise.html

022. Variance.mp4

023. Variance Exercise.html

024. Standard Deviation and Coefficient of Variation.mp4

025. Standard deviation.html

026. Standard Deviation and Coefficient of Variation Exercise.html

027. Covariance.mp4

028. Covariance.html