All articles in 'Interview Questions' Category
Top 10 Power BI Interview Questions & Answers
![Top 10 Power BI Interview Questions & Answers](https://chandoo.org/wp/wp-content/uploads/2023/10/SNAG-3027.png)
I recently interviewed people for Power BI analyst roles and here are my top 10 favorite questions to assess the skills (with answer cues).
Continue »![How can you analyze 1mn+ rows data – Excel Interview Question – 02](https://chandoo.org/wp/wp-content/uploads/2019/09/how-to-handle-more-than-one-million-rows-in-excel.png)
As part of our Excel Interview Questions series, today let’s look at another interesting challenge. How can you analyze more than 1 million rows data in Excel?
You may know that Excel has a physical limit of 1 million rows (well, its 1,048,576 rows). But that doesn’t mean you can’t analyze more than a million rows in Excel.
The trick is to use Data Model.
Continue »VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01
![VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01](https://chandoo.org/wp/wp-content/uploads/2019/08/vlookup-or-index-match.png)
This is part of our Excel Interview Questions series.
VLOOKUP or INDEX+MATCH? When you should use each function and why?
This is such a great question to ask in interviews. So in my first installment of Excel interview questions, let me answer it.
Continue »