Preparing & Transforming Data

Reshape, join, and derive fields so a dataset is ready to analyze.

Inside this lesson

Reshape data between wide and long (tidy) formats.
Join tables using keys and explain inner versus left join behavior.
Derive new fields such as ratios, flags, and bins.
Apply grouping, aggregation, and basic normalization concepts.

Unlock the full Business & Data Analysis course

Every paid lesson — deeper discovery and value-selling, objection handling, negotiation and closing, account management, and the pipeline metrics that run a healthy sales team.
Buy this course on its own and keep access — or get it as part of an all-access subscription.

Get this course →

One-time purchase or subscription — see options on the next page.

or unlock everything with all-access

Not ready yet? Keep learning for free — start with the analytics value chain or data types and measurement.

⚖️

Educational training content only - not professional, financial, legal, or data-governance advice, and not a promise of any business or analytical result. Examples are illustrative and use hypothetical data with stated assumptions and units. Third-party names are descriptive and imply no affiliation.