Top 10 Power BI Interview Questions & Answers
I recently interviewed people for Power BI analyst roles and here are my top 10 favorite questions to assess the skills (with answer cues).
How can you analyze 1mn+ rows data – Excel Interview Question – 02
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.
VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01
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.