Q&A
The second part of developing a Power BI solution is to explore and visualize data, after which you will share and deploy your data. Hence, it is good to look at some questions that you may potentially be asked during your interview.
Question 1: How is data consumed once you build a semantic model in Power BI?
Answer: Data can be consumed in many ways. The natural and most intuitive step would be to explore it using Power BI itself, though if users are not too familiar with it, they can analyze data with Excel using pivots. One method I usually use is to look at measures at a high level, such as for the current year and for the region I operate in. I use the Power BI canvas and use the appropriate visuals to draw the picture. I look for whether the measures have met their targets or are on their way to meeting them. If I notice that this is not the case, I dive deeper to see where things may have gone wrong by adding further dimensions, or attribute levels of dimensions...
