R Programming for Excel Training Course

This instructor-led, live training in Malaysia (online or onsite) is aimed at intermediate-level advanced R users who wish to use R to build faster workflows, improve code quality, and handle more complex analysis tasks.

By the end of this training, participants will be able to: create reusable functions, improve data workflows, debug and optimize code, and produce reproducible reports.

This instructor-led, live training in Malaysia (online or onsite) is aimed at business analysts who wish to automate trade with algorithmic trading, Python, and R.

By the end of this training, participants will be able to:

• Employ algorithms to buy and sell securities at specialized increments rapidly.
• Reduce costs associated with trade using algorithmic trading.
• Automatically monitor stock prices and place trades.

Big Data refers to frameworks designed for storing and processing large volumes of data. Initially developed by Google, these Big Data solutions have evolved and inspired numerous similar projects, many of which are now available as open-source software. R is a widely adopted programming language within the financial sector.

This instructor-led, live training in Malaysia (online or onsite) targets beginner-level data analysts who wish to use R programming to manipulate data, perform basic data analysis, and create compelling visualizations for insights.

By the end of this training, participants will be able to:

• Understand the basics of R Programming.
• Apply fundamental data science processes.
• Create visual representations of data.

R is an open-source, free programming language designed for statistical computing, data analysis, and graphics. Its user base is expanding among corporate managers and data analysts, as well as statisticians, engineers, and scientists who lack formal programming skills but appreciate its ease of use. The language's popularity stems from the growing application of data mining in diverse areas, such as optimizing pricing strategies, accelerating drug discovery, and refining financial models. R supports this versatility through a wide array of packages tailored for data mining.

This instructor-led, live training in Malaysia (online or onsite) is aimed at data analysts who wish to program with R in SAS for cluster analysis.

By the end of this training, participants will be able to:

• Use cluster analysis for data mining
• Master R syntax for clustering solutions.
• Implement hierarchical and non-hierarchical clustering.
• Make data-driven decisions to help to improve business operations.

Data analytics plays an essential role in modern business operations. Throughout this course, we will concentrate on building practical, hands-on skills for effective data analysis. The primary objective is to empower participants to provide evidence-based answers to key questions:

What has happened?

• processing and analyzing data
• producing informative data visualizations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimizing processes

This instructor-led live training in Malaysia (online or on-site) is designed for beginner-level professionals who wish to clean and analyze data, make statistical projections, and create insightful visualizations using these tools.

By the end of this training, participants will be able to:

• Understand the basics of Python, R, Power Query, and Power BI for data analysis.
• Clean and organize datasets using Python and Power Query.
• Perform statistical analysis and projections with R.
• Create professional dashboards and reports with Power BI.
• Integrate and analyze data from multiple sources effectively.

R is a widely utilized, open-source environment designed for statistical computing, data analytics, and graphical representation. This course provides students with an introduction to the R programming language, encompassing its core fundamentals, library usage, and advanced concepts. Participants will explore advanced data analytics and graphing techniques utilizing real-world datasets.

Target Audience

Developers and data analysts

Duration

3 days

Format

Instructional lectures combined with practical, hands-on exercises

This instructor-led, live training in Malaysia (online or onsite) is aimed at beginner-level professionals who wish to gain a mastery of the fundamentals of R and how to work with data.

By the end of this training, participants will be able to:

• Understand the R programming environment and RStudio interface.
• Import, manipulate, and explore datasets using R commands and packages.
• Perform basic statistical analysis and data summarization.
• Generate visualizations using both base R and ggplot2.
• Manage workspaces, scripts, and packages effectively.

This instructor-led, live training in Malaysia (online or onsite) is aimed at intermediate-level data analysts and business professionals who wish to perform time series forecasting and automate data analysis workflows using R.

By the end of this training, participants will be able to:

• Understand the fundamentals of forecasting techniques in R.
• Apply exponential smoothing and ARIMA models for time series analysis.
• Utilize the ‘forecast’ package to generate accurate forecasting models.
• Automate forecasting workflows for business and research applications.

R is a free, open-source programming language designed for statistical computing, data analysis, and graphical visualization. Its adoption is expanding rapidly among corporate managers, data analysts, and academic researchers. R boasts an extensive ecosystem of packages tailored for data mining and analytical tasks.

This instructor-led live training in Malaysia (online or onsite) is aimed at data scientists who wish to programme in Python and R for KNIME.

By the end of this training, participants will be able to:

• Plan, build, and deploy machine learning models in KNIME.
• Make data-driven decisions for operations.
• Implement end-to-end data science projects.

Unstructured data is estimated to make up over 90 percent of all data generated, with a significant portion in text format. Content such as blog posts, tweets, social media interactions, and other digital publications continuously expand this vast pool of information.

This instructor-led, live course focuses on extracting valuable insights and meaning from this data. By leveraging the R programming language alongside Natural Language Processing (NLP) libraries, we integrate principles from computer science, artificial intelligence, and computational linguistics to algorithmically interpret the semantics of text data. Data samples provided during the training are available in various languages, tailored to specific customer needs.

Upon completion of this training, participants will be capable of preparing datasets of varying sizes from diverse sources and applying appropriate algorithms to analyze and report on their significance.

Course Format

• A combination of lectures, discussions, and extensive hands-on practice, with occasional assessments to evaluate understanding.

Audience

Format of the course

By the end of this training, participants will be able to:

In this instructor-led, live training, participants will learn how to manipulate and visualize data using the tools included in the Tidyverse.

The Tidyverse is a collection of versatile R packages for cleaning, processing, modeling, and visualizing data. Some of the packages included are: ggplot2, dplyr, tidyr, readr, purrr, and tibble.

• Beginners to the R language
• Beginners to data analysis and data visualization

• Part lecture, part discussion, exercises and heavy hands-on practice

• Perform data analysis and create appealing visualizations
• Draw useful conclusions from various datasets of sample data
• Filter, sort and summarize data to answer exploratory questions
• Turn processed data into informative line plots, bar plots, histograms
• Import and filter data from diverse data sources, including Excel, CSV, and SPSS files