Pyramid Consulting Data Analyst Interview Questions

The questions to prepare for a Pyramid Consulting Data Analyst interview. Questions from real interview reports rank first. Updated daily.

7questions

~2htotal time

Track your progressSign up free to work through all 7 questions and resume where you left off.

SQL & Data ManipulationStart here. 5 questions · ~74 min

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Difference Between WHERE and HAVING ClausesEasy

Explain the differences between WHERE and HAVING clauses in SQL and when to use each.

JoinsData WranglingAggregations

Pyramid Consulting

Consecutive Purchase CustomersMedium

Practice

Identify customers with purchases in at least three consecutive calendar months using date normalization, CTEs, and window functions.

Window FunctionsLag/LeadDate Functions

Pyramid Consulting

7-Day Rolling DAU on FacebookMedium

Practice

Compute daily distinct active users and a 7-day rolling average using a CTE and window function.

Pyramid Consulting

Compare Weekly User Activity TrendsMedium

Practice

Aggregate user activity by week, then use LAG to compare sessions and watch time versus the prior active week.

Window FunctionsLag/LeadDate Functions

Pyramid Consulting

Create a free account to unlock this list and practice real interview questions.

The finish line: interview-readyComplete all 7 questions to finish this plan.