Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
R Programming, RStudio, R Automation, R Reporting, Cloud Scheduling, Linux Automation, RStudio Cloud, R Coding
Learn how to Automate every Office and Business task with R programming language and RStudio!
This course will give you a complete overview of a set of tools and packages that can help you automate any office and business task with the R programming language.
With Udemy's 30-day money-back guarantee in place, there's no need to worry if the class doesn't meet your expectations.
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 and save time 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 with R and RStudio
read and write files dynamically from various sources (local drive, web, Google Sheets, dropbox, amazon)
store results without complex SQL databases using various R packages
parse emails and attachments for further manipulations with R programming
produce custom Excel, PowerPoint, and Word documents from R scripts
send results by email and files as attachments
export your scripts to the cloud, schedule automatic runs or on-demand
create a cloud dashboard to control R automated tasks
Automation is a very dynamic skill and I am learning new skills every day.
This course will be updated with new programming skills, packages and features.
My experience
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 time.
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 a daily basis and after 1,200 mentoring sessions, I know precisely which tools are necessary for most of the people who learn programming.
As a consultant, you can very quickly acquire new clients who desperately need to improve their business.
Why R, RStudio, and Posit?
R is one of the simplest programming languages to learn and is very friendly with data manipulation.
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 for programmers (also supports C++, Python, SQL, and other languages).
As of the end of 2023, R is rocking it with these cool numbers:
RStudio has an active user base of 3.5 million.
Posit cloud has a 65,000 userbase.
Over the year, an impressive 2 billion R packages were downloaded.
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 programming automation tasks.
dplyr: R 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: download 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 using R and RStudio
Course Content
- 17 section(s)
- 50 lecture(s)
- Section 1 Introduction
- Section 2 Setup R and Rstudio
- Section 3 Github
- Section 4 Read and Transform Files using R and RStudio Programming
- Section 5 Read Files of Different Formats
- Section 6 Data from Web
- Section 7 Parse Emails
- Section 8 Write Emails
- Section 9 Recap
- Section 10 Formatted MS Excel Report
- Section 11 Introduction to MS Powerpoint Reporting
- Section 12 Introduction to MS Word Reporting
- Section 13 Dropbox as Cloud Data Source
- Section 14 Complex Reporting Tool and Automation
- Section 15 Automate and Schedule Job Locally
- Section 16 Schedule Automation Job on Cloud - Advanced
- Section 17 More Learning
What You’ll Learn
- Automate Tasks with R Programming Language
- Manipulate Data from Local, Web and Cloud Sources using R and RStudio
- Schedule Automation - Cloud or Local
- Read and Write CSV, TXT, XLSX with R
- Create Formatted Excel Spreadsheets with R Code
- Create Dynamic Reports (Powerpoint, Word, PDF, HTML)
- Parse Web and PDF Files with R packages
- Parse Email Content and Attachments
- Send Automated Emails with R and RStudio
- Cloud Solutions - Dropbox and Amazon S3
- Github Repository Management
- Linux Server and AWS EC2 - Install R and Setup CronJobs
Skills covered in this course
Reviews
-
JJA Ephambuka
This has been an eye-opener to some functions in R that I was not aware of despite using R for ages. It's technical, however, each section the presenter uses the help functions ?? to explain what the function does, and that ends up making the course user-friendly. I highly recommend it. These are skills one MUST have.
-
BBryan Butler
This is a good course on working with Office and some other tools such as dropbox and a preview of AWS. It is not really a full automation course, but there is lots of good information here for the tasks with office (email, Excel and Powerpoint). On the PowerPoint/Officer part, it would have been great to go into working with themes, etc. One a minor technical note, the screen fonts are small and need a bit of zooming in to see the code.
-
CChaitanya Popuri
very different content ..great job
-
RRonald Hernández
He aprendido mucho y es muy intersante todo lo que se detalla, pero me gustaria que actualizara el curso, aun tiene partes sin finalizar.