AUTOMATE:
Business Reporting with R
8-9 April 2020
14.00 – 17.00 (WIB)
LIVE STREAMING
Online Learning
IDR 330.000
Workshop Lecturer’s Notes
Including 2x Course Books (PDF), HTML files, course transcripts (if any).
Course Summary
This 2-day online workshop is a beginner-friendly introduction to automating business reporting with R. By learning how to automate various business reports, you will have more time to focus on what matters the most.
Throughout the online course, we will provide participants with rich interactive experience. One Instructor and two Teaching Assistants will help participants to troubleshoot or help with any difficulties encountered by participants.
NOTE: The workshop will be delivered in Bahasa Indonesia
COURSE OBJECTIVE
Upon completion of this workshop, you will be able to:
- Working with data in a statistical environment, including the cleansing, transformation and exploratory process.
- Convert simple statistical models into textual reports suitable for publication.
- Optimizing repetitive and long-term reports using a parameterized scheme in Rmarkdown.
- Using and developing automated reporting script for business needs.
Syllabus
RMARKDOWN
- Introduction to Rmarkdown
- Write R command in the markdown file
- Markdown text
- Setting global option that apply to every command in Rmarkdown
- YAML options (title, subtitle, author, table of content, etc)
- Generate report from rmarkdown file
- Pdf document
- Word document
- Html document
- Interactive PowerPoint presentation
- Parameterized Reports
- Declaring parameters
- Using parameter in code chunks
- Using parameter inline code
BASIC DATA ANALYSIS IN R
- Data science workflow
- Basic programming in R
- Object and environment
- Data structures in R
- Data type in R
- How to overcome messy excel sheets in R
- Importing dataset
- Data cleansing
- Data transformation
- Descriptive statistics
- Automated reporting of object in R with
easystats
TEMPLATE AND AUTOMATED REPORTING
- Create awesome table with
kableandkableExtra - Reproducible function (R script)
- [Demo Only] Generating downloadables report using shiny
Your Instructor
Ahmad Husain Abdullah majored in statistics from Islamic University of Indonesia and passionate about teaching. Husain is one of 5 holders of RStudio Trainer Certification in Indonesia.
He was involved in a lot of Data Science Training, such as BCA, KAI, PT Indo Tambangraya Megah, Indosat, OCBC NISP, and Tokopedia, to name a few. He enjoys the time making data more meaningful and loves to help companies make data-driven decisions.
Automate Series
Workshop in this series is particularly suited for people looking to pick up programming as a supplementary skill to their day to day work. Workshops in the Automate series are beginner-friendly and focus on productivity enhancements to the modern-day office executive.
Upon completion of any course in this series, participants would have the required skills to:
- Speed up day to day work with programming.
- Automate mundane tasks in Excel, Word, PowerPoint.
- A report production pipeline that is tidy, programmatic, and integrates directly with the tool you already use and love.
- Best-of-breed tools that tie your data collection, analysis, and presentation together.
Frequently Asked Questions
If I don’t have any IT or programming skills, can I still attend this workshop?
Yes, you can still attend the workshop as it is a beginner-friendly workshop.
How to join the interactive-online learning class after I’ve done the payment & registration?
Our system will send you an email containing a link and details to join the classroom. You can only enter the class at the scheduled time & date, 8 & 9 April 2020.
What platform will be utilized for this online-interactive learning workshop?
We are going to use Zoom.us.
How will the participants receive the learning materials?
We will send the workshop materials via email before 8 April 2020.
Would I receive a certificate after participating in the Workshop?
You will receive a Letter of Participation via email.
What are the learning support would I get during the workshop?
This workshop is an online-interactive learning workshop led by one Instructor and two Teaching Assistants. If you encounter any issue/difficulties with any topics throughout the workshop, our Teaching Assistants will gladly help to answer your question.