Scribd
Upload
22 views15 pages

Session 3 - Data Wrangling, Data Manipulation With Excel

The document outlines a syllabus for a business analytics course focused on marketing, detailing steps for problem-solving using data, including data wrangling, analysis, visualization, and communication. It emphasizes the five steps of data wrangling: discovery, structuring, cleaning, enriching, and verifying, along with the necessary Excel skills for each step. The course includes practical demonstrations and exercises for students to apply their learning on provided datasets.

Uploaded by

nghingo.31231021119
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views15 pages

Session 3 - Data Wrangling, Data Manipulation With Excel

The document outlines a syllabus for a business analytics course focused on marketing, detailing steps for problem-solving using data, including data wrangling, analysis, visualization, and communication. It emphasizes the five steps of data wrangling: discovery, structuring, cleaning, enriching, and verifying, along with the necessary Excel skills for each step. The course includes practical demonstrations and exercises for students to apply their learning on provided datasets.

Uploaded by

nghingo.31231021119
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 15

BUSINESS ANALYTICS

IN
MARKETING
SYLLABUS

problem-solving DATA wrangling VISUALIZATION EXPERT


using data & ANALYSIS & STORYTELLING SHARING
• Problem statement & goal • Data wrangling • Graphs, charts &
setting • Data analysis dashboards
• Data analytics roadmap • RFM analysis • Story-telling
• Analytics tools exercise • Common pitfalls
HOW TO SOLVE PROBLEMS USING DATA?

STEP 1 Step 2 Step 3


Problem statement Data wrangling Data analysis

Step 4 Step 5
Data visualization Communication
data
WRANGLING
HOW TO SOLVE PROBLEMS USING DATA?
5 steps of data wrangling
5 steps of data wrangling
Step Goal Excel Skills Practiced
1. Discovery Understand the dataset Filter, Sort, COUNT, AVERAGE,
COUNTBLANK
2. Structuring Reorganize into usable Excel Tables, data types, helper columns
format
3. Cleaning Fix errors and Conditional formatting, ISBLANK,
inconsistencies Remove Duplicates
4. Enriching Add value through context XLOOKUP, derived columns, IF logic
and calculations
5. Verifying Confirm accuracy and Cross-check formulas, validation logic
consistency
HOW TO SOLVE PROBLEMS USING DATA?

Step 2 DATA WRANGLING


DATA
DISCOVERY

Understand your data


HOW TO SOLVE PROBLEMS USING DATA?

Step 2 DATA WRANGLING


DATA
STRUCTURING

Remove duplicates.
HOW TO SOLVE PROBLEMS USING DATA?

Step 2 DATA WRANGLING


DATA
STRUCTURING

Create unique ids for


the observations.
HOW TO SOLVE PROBLEMS USING DATA?

Step 2 DATA WRANGLING


DATA Missing values:
CLEANING ● Drop the observation
DATA
altogether.
ENRICHING
● Impute the values using the
mean, median or max value
(for continuous values) or
most frequent value (for
categorical values) depending
on the situation.
● Ignore the values of those
variables only.
HOW TO SOLVE PROBLEMS USING DATA?

Step 2 DATA WRANGLING


DATA Invalid value:
CLEANING ● Drop the observation
DATA
altogether.
ENRICHING
● Correct the value using most
reasonable methods.
HOW TO SOLVE PROBLEMS USING DATA?

Step 2 DATA WRANGLING


DATA
CLEANING
DATA
ENRICHING

Remove, impute or
correct missing values
and invalid values.
HOW TO SOLVE PROBLEMS USING DATA?

Step 2 DATA WRANGLING


Value inconsistency: lengths

Data type inconsistency: text (“20”)


vs. number (19)
DATA
VERIFYING

Validate and ensure the correct data


types, data homogeneity and
constraints.
HOW TO SOLVE PROBLEMS USING DATA?

Step 2 DATA WRANGLING

DATA
publishing

Store & manage data in suitable


format and system to deliver &
distribute the data to end-users
through platform and tools.
Demo &
practice
Lecturer explains, demonstrate and students to practice with the dataset provided in class

You might also like