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
| Term | Meaning |
|---|---|
| Descriptive analytics | What happened |
| Business question | Problem the analysis answers |
| Pivot table | Interactive summary table |
| SELECT | Chooses columns |
| EDA | Exploratory Data Analysis |
| KPI | Key Performance Indicator |
| Power Query | Data preparation tool |
pandas | Data 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.