Data Analytics in R
About the Author
1
Introduction
2
R basics
2.1
Setup
2.2
Help
2.3
Variable
2.4
Data structure
2.5
Control flow
2.6
Function
2.7
OOP
2.8
IO
2.9
System
3
Import
3.1
Dataset
3.1.1
Data to database
3.1.2
Data model
3.1.3
Join tables
3.2
SQLite
3.2.1
Connection
3.2.2
R code chunk
3.2.3
SQL code chunk
4
FP&A
4.1
Validation
4.2
EDA
4.2.1
Categorical
4.2.2
Numeric
4.3
Business ananlysis
4.3.1
Product profit margin
4.3.2
Product category
4.3.3
Manufactuer
4.3.4
Store
4.4
Info graphic
4.5
Report
4.6
Dashboard
5
External Auditors
5.1
Cleaning
5.2
Validation
5.3
EDA
5.3.1
Missing value
5.3.2
Categorical
5.3.3
Numberic
5.4
Audit planning
5.4.1
Test of controls
5.4.2
Digits tests
5.4.3
Benford’s law
5.4.4
Outlier
5.4.5
Ratios
5.4.6
Cutomers
5.5
Substantive test
5.5.1
Reconcilation
5.5.2
Aging report
5.5.3
Confirmation letter
5.6
Reporting
6
Utilities
6.1
Command line tool
6.2
PDF data
6.3
Learnr
References
Published with bookdown
Data Analytics in R
References