Decision Making with Analytics

Description

In this 2-day course, participants will utilize Microsoft Excel to have a deep understanding of the decision-making process using data analytics.

Through hands-on examples participants will learn using Microsoft Excel how to handle large datasets and extract useful information that will help organizations make sound decisions backed up by data.

With the amount of data collected by organization or dedicated services, the decision-making process is not an art anymore neither it will depend entirely on the experience and the ‘gut feeling’ of the decision maker. Although experience is still important, decision makers must hire the people who are equipped with the tools to process the data and be able to understand the story behind the data. Those people must build the communication skills to deliver the story and support it by the evidence that their tools produced for them.

Reading data trends whether for business, investment, or even for sports is becoming an essential skill for every employee or business owner. Industry is looking for people who understand data and know how to deal with it. In this course participants will learn how to read data and be able to uncover the story behind the data.

By taking this course, you will have a lifetime commitment from Wafaa Analytics data scientists and Engineers to help you accomplish your data analytics projects. It’s all free of charge after the completion of this course.

Subjects to be covered:

(Data Cleaning, Data Analysis, Data Visualization)

a. Datasets

b. Excel tables

c. Power Query

d. Pivot tables

a. Descriptive statistics

b. Basic data visualization in Excel

c. Process control charts

a. Modeling

   i. Physical modeling

   ii. Mathematical modeling

   iii. Statistical modeling

b. Linear programming

c. Regression

d. Excel Solver

e. Hypothesis testing

f. Machine Learning Algorithms

   i. Cluster Analysis

   ii. K-Mean

   iii. Decision Trees

a. Forecasting

b. Monte Carlo simulations

   i. Yasai Simulator

c. Scenario Analysis

d. Analytical Hierarchy Process (AHP)

   i. Neural networks

   ii. Other algorithms and future of Machine Learning

Course requirements:

1- Basic knowledge of Microsoft Excel

2- Current version of Microsoft Excel (Microsoft Office 365 version 2308 or later)

Instructor:

TBD

Course fee:

$499.00