InternshipKey terms and common mistakes
The words you will hear in Business Intelligence work and the mistakes that most often cost interns approvals.
Key terms
| Term | Meaning |
|---|---|
| Cell reference | Address like B2 |
| IF | Returns values based on a condition |
| PivotTable | Interactive summary table |
| Power Query | Data transformation tool |
| Power BI Desktop | Report authoring app |
| Fact table | Table of events and measures |
| DAX | Data Analysis Expressions |
| KPI | Key Performance Indicator |
Common mistakes to avoid
- Dashboards with too many charts and no clear question.
- Different numbers for the same KPI in different reports.
- Not documenting where each metric comes from.
- Refreshing data manually instead of scheduling it.
Want to go deeper? The free Power BI & Excel learning path has short modules, games and a certificate for each module.