Key terms and common mistakes

The words you will hear in Data Analytics work and the mistakes that most often cost interns approvals.

Key terms

TermMeaning
Descriptive analyticsWhat happened
Business questionProblem the analysis answers
Pivot tableInteractive summary table
SELECTChooses columns
EDAExploratory Data Analysis
KPIKey Performance Indicator
Power QueryData preparation tool
pandasData analysis library

Common mistakes to avoid

  • Starting charts before cleaning and checking the data.
  • Picking chart types that hide the comparison, like 3D pies.
  • Reporting numbers without context such as last month or target.
  • Mixing up totals and averages in summaries.

Want to go deeper? The free Data Analytics learning path has short modules, games and a certificate for each module.

โ† Submitting tasks and earning your certificateApply for the Data Analytics internship โ†’