MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 47 lectures (5h 8m) | Size: 2.44 GB
This course will give you a complete overview of a set of tools and packages that can help you to automate any office and business task.
Programming, Automation, Read and Write Data of every Format, Reporting, Cloud Data, Cloud Scheduling
Automate Tasks with R
Manipulate Data from Local, Web and Cloud Sources
Read and Write CSV, TXT, XLSX
Create Formatted Excel Spreadsheets
Create Dynamic Reports (Powerpoint, Word, PDF, HTML)
Parse Web and PDF Files
Parse Email Content and Attachments
Schedule Automation - Cloud or Local
Send Automated Emails
Cloud Solutions - Dropbox and S3
Github Repository Management
Linux Server and AWS EC2
Basic Programming (R, Python, SQL) is preferred but not mandatory
Some knowledge of Microsoft Office (Excel, Word, Powerpoint)
Recent version of R and Rstudio: how to install is covered
Windows OS is preferred but all code runs on Mac OS as well and the minor differences between Mac and PC will be explained
Lean how to Automate every Office and Business task with R
The learning material does not contain any analytics or data science lessons.
We will not study statistics or machine learning.
We will not write complex algorithms and solve coding puzzles.
Instead we focus on how to make your life easier, save for yourself and money for your company.
This course is the most complete automation course you will find online
After completing this course you will be able to schedule any repetitive task
read and write files dynamically from various sources (local drive, web, google sheets, dropbox, )
store results without complex SQL databases
parse emails and attachments for further manipulations
produce custom Excel, Powerpoint and Word documents
send results by email and files as attachments
export your scripts to cloud, schedule automatic runs or on demand
create a cloud dashboard to control automated tasks
Automation is a very dynamic skill and I am learning new skills every day.
This course will be updated about twice per month with new skills, packages and features.
During my banking career I had to program hundreds of automatic mailing reports to track stock market information and portfolio performance on daily basis. By automating these tasks I became very efficient with my .
Currently as a consultant I help dozens of companies to automate their recurring tasks. Often hundreds of hours of manual work per month are saved once a complex recurring task is automated.
I teach R, C# and Excel/VBA on daily basis and after 600 mentoring sessions I know precisely which tools are necessary for most of people who learn programming.
As a consultant, you can very quickly acquire new clients who desperately need to improve their business.
R has been chosen since it is one of the simplest languages to learn and is very friendly with data manipulation. After all, every office task is about manipulating and transfog data on daily basis.
R is open source and is part of a large community of developers that create and maintain packages we will explore during this course.
RStudio is probably the best IDE there is for programmers (also supports C++, Python, SQL and other languages).
Which Packages will be covered
Base R functions will be covered as much as possible however they are very limited.
Therefore we will learn a set of packages necessary for the automation tasks.
dplyr: data manipulation with very user-friendly syntax
tidyr: data clean-up, remove duplicates, NA's etc.
stringr: string and regex manipulation
lubridate: work with Date class objects
pdftools: parse content from PDF files
htmltab: parse html tables from web
gsheet: files from Google Sheets
mRpostman: connect to email box and read data from Emails
emayili: connect to email box and send emails
tableHTML: create custom format HTML tables
openxlsxl: read and write Excel files
officer: read and write Word and PowerPoint documents
flextable: create formated tables as content for officer
rdrop2: connect to dropbox as cloud source
Office Workers | Business Managers | Accountants | Financial Administators | Students and Researchers
Financial Analysts and Traders who need to Automate their Data Flows
Business Consultants who work with large amount of Data
Bners who want to learn R without starting immediately with Statistics, Algorithms and Data Science
Data Scientists and R Developers who need to Automate their tasks
Excel users who want to switch to Programming
R programmers who want to discover what else R can offer