Modeling data for analysis
Modeling is where you structure your Power BI semantic model to represent the business processes from an analytical standpoint. In essence, modeling actually starts before development. It is part of designing your Power BI solution.
We shall dive deeper into the details of modeling in Chapter 5. Here, let us look at what you, as a developer, would do. But remember, at every point of modeling data, you are, or should be, following a design that has been thought out. Even the data that you cleanse, transform, and combine are driven by what your model design dictates.
To model data effectively, you will need to use the right modeling technique. Let us look at the star schema, a popular analytics modeling technique.
Star schema
The recommended design technique for Power BI models is the star schema modeling approach. Regardless of your requirements, building your model according to this technique gives users a versatile, performant, and intuitive...