Q&A
Bringing your data into Power BI and developing the perfect semantic model is what we have worked toward since Chapter 3. Hence, it makes sense that we look at a few probable questions that you can be asked in an interview. You need to understand that these questions can be potentially asked in different ways, so you must prepare for them accordingly.
Question 1: Why is it important to design a semantic model before you build one?
Answer: The design provides a way for you to envision what the result of the model will look like. It also ensures that all the business requirements are considered and mapped to the output of the model. The model author now has a guideline against which they can develop the model without any unnecessary deviations.
Question 2: What methodology have you used to design a semantic model?
For your answer: Refer to the Designing a model section in this chapter and prepare a summary of dimensional modeling that you can talk about with your...