15 Connecting R to an SQL Database
Note
10 PART IV: Data Wrangling 16 Anonymous Data Notes 17 Data Wrangling in the tidyverse 17.1 Importing the Data 17.2 Tidy Data 17.3 Tidying Up Data with tidyr 17.4 SQL-like Functionality via dplyr 17.5 String Manipulation in the tidyverse 17.6 Dates with lubridate 17.7 Factors with Forcats Notes 18 Dealing with Missing Data 18.1 Reasons for Data to be Missing 18.2 Methods to Handle Missing Data 18.3 R Packages to Deal with Missing Data Notes 19 Data Binning 19.1 What is Binning and Why Use It 19.2 Tuning the Binning Procedure 19.3 More Complex Cases: Matrix Binning 19.4 Weight of Evidence and Information Value Notes 20 Factoring Analysis and Principle Components 20.1 Principle Components Analysis (PCA) 20.2 Factor Analysis Note
11 PART V: Modelling 21 Regression Models 21.1 Linear Regression 21.2 Multiple Linear Regression 21.3 Performance of Regression Models 22 Classification Models 22.1 Logistic Regression 22.2 Performance of Binary Classification Models Notes 23 Learning Machines 23.1 Decision Tree 23.2 Random Forest 23.3 Artificial Neural Networks (ANNs) 23.4 Support Vector Machine 23.5 Unsupervised Learning and Clustering Notes 24 Towards a Tidy Modelling Cycle with modelr 24.1 Adding Predictions 24.2 Adding Residuals 24.3 Bootstrapping Data 24.4 Other Functions of modelr 25 Model Validation 25.1 Model Quality Measures 25.2 Predictions and Residuals 25.3 Bootstrapping 25.4 Cross-Validation 25.5 Validation in a Broader Perspective Notes 26 Labs 26.1 Financial Analysis with quantmod Notes 27 Multi Criteria Decision Analysis (MCDA) 27.1 What and Why 27.2 General Work‐flow 27.3 Identify the Issue at Hand: Steps 1 and 2 27.4 Step 3: the Decision Matrix 27.5 Step 4: Delete Inefficient and Unacceptable Alternatives 27.6 Plotting Preference Relationships 27.7 Step 5: MCDA Methods 27.8 Summary MCDA Notes
12 PART VI: Introduction to Companies 28 Financial Accounting (FA) 28.1 The Statements of Accounts 28.2 The Value Chain 28.3 Further, Terminology 28.4 Selected Financial Ratios Notes 29 Management Accounting 29.1 Introduction 29.2 Selected Methods in MA 29.3 Selected Use Cases of MA Notes
