Data Analytics Last-Minute Revision
Quickly revise the questions you picked. Add questions from the interview-questions lists with Save to → Last-Minute Revision.
30 quick revision notes for Data Analytics
- WHERE filters rows before grouping, HAVING filters groups after aggregation, so aggregate conditions like SUM(sales) > 1000 go in HAVING.
- ROW_NUMBER gives unique numbers, RANK leaves gaps after ties, and DENSE_RANK gives ties the same rank without gaps.
- SQL runs logically as FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT, which is why SELECT aliases are not allowed in WHERE.
- COUNT(*) counts all rows, COUNT(column) skips NULLs, and COUNT(DISTINCT column) counts unique non-null values.
- NOT IN returns no rows if the subquery contains a NULL; use NOT EXISTS or a LEFT JOIN with IS NULL for anti-joins.
- A join fan-out happens when the key is not unique on one side, duplicating rows and inflating sums; aggregate before joining.
- XLOOKUP defaults to exact match, can look left, and returns a custom value when nothing is found.
- Absolute references like $A$1 stay fixed when copied; relative references like A1 shift with the formula.
- SUMIFS adds values meeting multiple conditions; its first argument is the sum range, unlike SUMIF.
- Excel Tables expand automatically and use structured references, making formulas and PivotTables safer as data grows.
- A measure is calculated at query time in filter context; a calculated column is computed per row at refresh and stored.
- CALCULATE changes the filter context of an expression and is the most important function in DAX.
- A star schema has one central fact table linked to dimension tables with one-to-many, single-direction relationships.
- Time intelligence functions like SAMEPERIODLASTYEAR need a continuous date table marked as a date table.
- Import mode is fastest and stores data in memory; DirectQuery queries the source live and is slower but always current.
- In pandas, loc selects by labels and includes the slice end, while iloc selects by position and excludes it.
- Vectorised pandas operations are much faster than apply or loops because they run in optimised compiled code.
- Always check row counts before and after a merge to catch duplicate keys or unmatched rows.
- Use the median instead of the mean for skewed data such as salaries, house prices or order values.
- A p-value is the probability of results at least this extreme if there were no real effect, not the probability the hypothesis is true.
- A Type I error is a false positive (alpha); a Type II error is a false negative (beta); power equals 1 minus beta.
- Correlation shows two variables move together; causation needs an experiment or careful control of confounding variables.
- In an A/B test, fix the sample size and duration in advance and avoid stopping early when results first look significant.
- Tableau FIXED LOD expressions are computed before dimension filters unless those filters are added to context.
- Tableau extracts are fast snapshots refreshed on a schedule; live connections query the database on every interaction.
- Blue pills in Tableau are discrete and create headers; green pills are continuous and create axes.
- Missing data can be MCAR, MAR or MNAR, and the type decides whether dropping or imputing rows will bias results.
- A KPI is a metric tied to a business goal with a target and owner; leading KPIs predict lagging outcome KPIs.
- Give every chart an action title that states the insight, such as South drove 70 percent of the decline.
- Bar charts should start at zero; truncated axes exaggerate small differences and mislead the audience.
Night-before checklist
- Revise your saved questions on this page once, aloud.
- Read the quick notes and mark any you cannot explain in one line.
- Rehearse a two-minute self-introduction and two project stories.
- Keep CV, ID, laptop charger and interview link ready; sleep on time.
Frequently asked questions
How does Last-Minute Revision work?
On any question page, open Save to → Last-Minute Revision. Saved questions appear here with their answers, so the night before an interview you revise only what you found hard.
Is my list saved?
Yes, in this browser. Guests can save 5 questions; free accounts can save 20 for revision and 100 for the 7-day plan.
What should I revise last before a Data Analytics interview?
Your saved misses first, then the quick notes on this page, then one or two project stories. Avoid learning brand-new topics the night before.
Find questions to save
Company-wise Data Analytics questionsPackage-wise Data Analytics questionsExperience-wise Data Analytics questionsRole-wise Data Analytics questionsCity-wise Data Analytics questionsMost asked Data Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsData Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsData Analytics topic sheets