Relevant Technical Experience and Projects Questions

Describe the hands on technical work and projects that directly relate to the role. Cover specific tools and platforms you used, such as forensic analysis tools, operating systems, networking and mobile analysis utilities, analytics and database tools, and embedded systems or microcontroller development work. For each item explain your role, the scope and scale of the work, key technical decisions, measurable outcomes or improvements, and what you learned. Include relevant certifications and training when they reinforced your technical skills. Also discuss any process improvements you drove, cross functional collaboration required, and how the project experience demonstrates readiness for the role.

HardTechnical

0 practiced

Explain how you'd implement version control and code review workflows for BI artifacts (LookML, Tableau workbooks, Power BI PBIX, SQL scripts). Address diffing of binary files, promoting changes across dev/staging/prod, automated validation (lint/tests), and governance controls to prevent accidental production breaks.

MediumTechnical

0 practiced

Discuss the trade-offs between using live connections and using extracts (data extracts) for Power BI/Tableau dashboards. Cover data freshness, concurrency and load on source systems, cost, complexity, governance, and performance. Provide concrete decision criteria to choose one approach over the other.

HardTechnical

0 practiced

In Power BI DAX, write a measure that computes the rolling 12-month average of Sales[Amount], excluding the current incomplete month. Assume you have a Date table 'DimDate[Date]' marked as Date in the model and related to Sales[Date]. Provide the DAX and explain how context transition and performance considerations affect your implementation.

EasyTechnical

0 practiced

Explain query folding in Power Query (M): what it means, why it improves performance for data extracts and refreshes, how to detect when query folding is broken, and give one example transformation that preserves folding and one that breaks it.

MediumTechnical

0 practiced

Given the events table below in PostgreSQL:

| event_id | user_id | device_id | event_type | event_time ||----------|---------|-----------|------------|------------|

Write an efficient PostgreSQL query to compute weekly active users (WAU) per week where each user is counted at most once per week regardless of device. Explain indexing or pre-aggregation strategies you'd use for a table with hundreds of millions of rows.

Unlock Full Question Bank

Get access to hundreds of Relevant Technical Experience and Projects interview questions and detailed answers.

Join thousands of developers preparing for their dream job.