Data Visualization with Excel

Description

Data visualization helps data analysts uncover the story behind the data. It also helps analysts explain their findings to decision makers and non-technical audiences. Data visualization tells the data story in a convincing way and highlights the most important aspects and necessities in the decision-making process.

In this 2-day course, participants will have hands-on experience on how to apply data visualization techniques to data sets and uncover the stories behind the data. Participants will use the Microsoft Excel platform to create advanced graphs and charts. The course contains many hands-on examples that can be modified later and applied to other projects.

The course also covers the design of interactive dashboards.

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

Subjects to be covered:

a. Column or Bar charts

b. Pie Charts

c. Histograms

d. Line Charts

e. Box and Whiskers

f. Radial charts

g. Combo charts

h. Scatter plots

i. Sparklines

j. Hybrid charts

a. Radio buttons

b. Checkboxes

c. Combo Box

d. Maps

e. Dynamic series

a. Pareto charts

b. Cause and effect diagrams

c. Scatter diagrams

d. Histograms

e. Control Charts

a. Dashboard wireframe

b. Reports design

c. Interactive dashboards

d. Best practices

Course requirements:

1- Basic knowledge of Microsoft Excel

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

Instructor:

TBD

Course fee:

$370.00