The interview is totally task based. No theoretical questions were asked. I have explained the process in interview questions section, please refer. However, the interviewer was very helpful and gave hints whenever required. But it was tough task to perform.
Interview questions [1]
Question 1
They gave me unstructured data and asked me to clean it using Power BI with the help of DAX. The data was very messy and it took me 20 mins to understand. The columns were in shape of rows. There were dates mentioned. They also provided the clean dataset file for reference.