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:
1. Essential data analysis skills
(Data Cleaning, Data Analysis, Data Visualization)
4. Acquiring data and datasets
a. Datasets
b. Excel tables
c. Power Query
d. Pivot tables
5. Descriptive Analytics
a. Descriptive statistics
b. Basic data visualization in Excel
c. Process control charts
6. Predictive Analytics
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
7. Prescriptive Analytics and Optimization
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