Array
(
    [0] => 
    [1] => 
)

Excel Analytics Ninja US (Feb 2020)

1-Day course - US

A fundamental analytics skill that is mostly needed by most data analysts and managers.

February 21-22, 2020
Hotel Grand Pacific

Course Overview

Well told data stories are change drivers within the modern organisation.
Influence decision makers by designing data stories that are engaging and clearly communicate insights and actions.

Course outline

Day 1
I. What is the end goal of this course?
9:00am - 9:05am

II. Keys to Effective Analytics: Exploratory Data Analysis (EDA)
9:05am - 9:15am

What is EDA?

Context: understanding the data and its source

Variables: knowing and classifying data into various data types

Wrangling: performing basic data munging to address missing values, outliers, input errors

Analysis: discovering univariate and bivariate relationships in the data

III. Context and Variables: Understanding the Data
9:15am - 9:45am

Questions to ask of your dataset

What are the different types of data?

Fancy statistics terms vs. their common business meanings

Classifying the variables of the course dataset

Numeric variables: continuous and discrete

Categorical variables

Dummified data: what they look like and why they exist

Formatting data according to their variable types

IV. Wrangling: Using Formulae, Filtering, and Sorting to Manipulate Data
9:45am - 10:15am

Querying your data

Sorting data according to various dimensions and multiple levels

Identifying and extracting metrics needed to generate or prove certain insights

Manipulating text or string data

Working with dates

Wrangling data through arrays

Optional wrangling:

V. Q&A / Break
10:15am - 10:30am
VI. Univariate Analysis and Multivirate: Leveraging Excel Features for Analyzing Data
10:30am - 12:00nn

Querying your data to make relevant analysis

Choosing the right metrics, according to the insight to be supported

Calculating percentages and understanding their meanings

Summarizing your data into logical groupings

Other ways to summarize your data

VII. Lunch
12:00nn - 1:00pm
VIII. Workshop
1:00pm - 4:00pm
IX. Group Work Submission Deadline
4:00pm - 4:15pm
X. Group Presentations, Feedback and Wrap
4:15pm – 5:00pm
Day 2
I. Day 1 Recap
9:00am - 10:15am
II. Q&A / Break
10:15am - 10:30am
III. Using Elegant Data Visualization for Reporting
10:30am - 12:00nn

When to use and how to create non-standard data visualizations

Reference lines to support your insight

Funnel Charts to show sequential steps and subsets

Tornado / Divergent Bar / Bi-Directional Bar Charts to show comparisons

Funnel Charts to show sequential steps and subsets

Optional charts for advanced audiences

IV. Lunch
12:00nn - 1:00pm
V. Workshop
1:00pm - 4:00pm
VI. Group Work Submission Deadline
4:00pm - 4:15pm
VII. Group Presentations, Feedback and Wrap
4:15pm - 5:00pm

Learn from one of our Lead Trainers

Isaac Reyes Lead Data Storytelling Trainer

A former university lecturer in statistics at the Australian National University, Isaac is also a TEDx speaker and a regular keynote at big data conferences. Isaac holds a Master’s Degree in Statistics from the Australian National University and a Bachelors Degree in Actuarial Science from Macquarie University.

Martin Ng Lead Data Storytelling Trainer

With more than a decade of teaching and training experience, Martin has trained both corporates and students in the field of business IT, data analytics and data storytelling. He specializes in offering practical steps to guide data projects by applying the Design Thinking methodology to data analytics.

Diedre Downing Lead Data Storytelling Trainer

Our Lead Analytics Translator, Diedre is a former Wall St trader, college lecturer and NYC Department of Education program leader. Prior to DataSeer, she oversaw the operation, curation and data driven strategy of WeTeachNYC.org-the NYC

Pricing

Course
Date
Location
Price
Feb 21-22, 2020
Hotel Grand Pacific
Early Bird Price!
990.00 USD
890.00 USD
To be announced

For 20+ students, Contact us for private/custom training solutions.

Prices are VAT exclusive. / Training fee is inclusive of lunch, coffee and snacks.

Testimonials