Course Outline

Basic Excel

  • Navigation
  • Manipulating data
  • Working with formulas and addresses
  • Charts

Advanced Excel 

  • Logical functions
  • Scenario analysis
  • Solver
  • Macros
  • First glimpse of code: VBA

VBA

  • Data types
  • Writing a function
  • Controlling a program: conditional evaluation and loops
  • Debugging techniques

Data Analytics with R

  • Introducing R
  • Variables and types
  • Data manipulation in R
  • Writing functions
  • Data visualization using ggplot
  • Data wrangling with Dplyr

Introduction to Machine Learning with R

  • Linear Regression
  • Classification and regression trees
  • Classification using Support Vector Machines and Random Forests
  • Clustering techniques

Requirements

There are no specific requirements needed to attend this course.
  42 Hours
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Tamil was held up helping other people, I could crack on with the next parts.

Luke Pontin

Learning how to use excel properly.

Torin Mitchell

The way the trainer made complex subjects easy to understand.

Adam Drewry

Detailed and comprehensive instruction given by experienced and clearly knowledgeable expert on the subject.

Justin Roche

Tamil is very knowledgeable and nice person, I have learned from him a lot.

Aleksandra Szubert

I liked the first session. Very intensive and quick.

Digital Jersey

I mostly liked the patience of Tamil.

Laszlo Maros

I really was benefit from the real life practical examples.

Wioleta (Vicky) Celinska-Drozd

Related Courses

Automated Monitoring with Zabbix

  14 hours
This course focuses on practical implementation and tooling. This course covers the installation, planning and configuration of Zabbix
Read More...

Databricks

  14 hours
Azure Databricks is a unified data analytics platform that allows users to store and visualize vast amounts of data from different sources. It provides a collaborative environment to build, deploy, and manage data analytics workloads easily. This
Read More...

Data Cleaning

  7 hours
Data Cleaning or Data Cleansing refers to the process of detecting and fixing issues in a data set before analyzing it. This instructor-led, live training (online or onsite) is aimed at data scientists, data analysts, and business analysts who
Read More...

Datadog Monitoring

  7 hours
Datadog is a monitoring platform for cloud-based applications that provides tools for monitoring servers and databases. It helps determine performance metrics and perform event monitoring for infrastructure and cloud-based services. This
Read More...

Netdata

  7 hours
Netdata is an open-source infrastructure performance monitoring and troubleshooting solution that simplifies real-time data collection of system, hardware, and application metrics. Netdata helps users visualize and store data, set performance issue
Read More...

Zenoss Monitoring for Administrators

  21 hours
Zenoss Community Edition is an application, server, and network management platform for monitoring availability, inventory/configuration, performance, and events. It is based on the Zope application server. This instructor-led, live training
Read More...

Fluentd for Log Data Unification

  14 hours
This instructor-led, live training (online or onsite) is aimed at engineers who wish to set up an architecture where everything is logged. By the end of this training, participants will be able to: Install and configure Fluentd. Collect
Read More...

KNIME Analytics Platform for BI

  21 hours
KNIME Analytics Platform is a leading open source option for data-driven innovation, helping you discover the potential hidden in your data, mine for fresh insights, or predict new futures. With more than 1000 modules, hundreds of ready-to-run
Read More...

Microsoft Power Platform Fundamentals

  14 hours
Microsoft Power Platform is a platform made up of three Microsoft products: Power BI, PowerApps, and Power Automate. These products use low-code programming to help users build simple apps, create automated workflows, and generate business
Read More...

Monitoring Your Resources with Munin

  7 hours
Munin is an open-source monitoring tool that helps system administrators monitor resources such as servers, workstations, networks, SANs, applications, network devices, etc. It shows resource trends and provides insights into questions such as
Read More...

Nagios

  35 hours
The 5-day course demonstrates through hands-on practice the fundamentals of Nagios.
Read More...

Nagios Core

  21 hours
This course covers the installation, planning and configuration of Nagios Core The level of this course is Intermediate
Read More...

Nagios XI Administration

  21 hours
Nagios XI is enterprise server and network monitoring software. In this instructor-led, live training, participants will learn how to set up and operate Nagios XI as they step through process of managing Linux and Windows servers in a series
Read More...

Sensu: Beginner to Advanced

  14 hours
Sensu is a telemetry and monitoring service for multi-cloud infrastructures at scale. Sensu is aimed at dynamic infrastructures that require a change in approach to monitoring systems that traditional monitoring systems cannot provide. This
Read More...

SPSS Modeler

  14 hours
IBM SPSS Modeler is a software used for data mining and text analytics. It provides a set of data mining tools that can build predictive models and perform data analytic tasks. This instructor-led, live training (online or onsite) is aimed at
Read More...