From the course: AI in Business Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Taking data analytics to the next level: AI

Taking data analytics to the next level: AI - Microsoft Excel Tutorial

From the course: AI in Business Essential Training

Start my 1-month free trial

Taking data analytics to the next level: AI

- [Instructor] Traditional data analytics requires that the business analyst come up with the relationship between different variables that he or she is interested in. For instance, the business analyst might look at the relationship between, say the overall economy and the likelihood that a borrower can repay their loan. AI helps us to automate some of this process. I'm in the 02_04_Begin Excel file. Now what we have here is data on 500 different people that have taken out loans for different purposes. Everything from as an example, a small business investment, to home improvement to debt consolidation, credit cards, things like that. We've got a lot of different data here, that might be useful. Things on interest rates, the term of the loan as an example, the purpose, their debt to income ratio, etc. So those will all be independent variables. There's a few dependent variables we might be interested in exploring. One obvious dependent variable would be, what's the status of the loan…

Contents