What is the Business Builder and why should you use it?
The Business Builder deals with the question of how business users can understand, associate, and combine the data to get flexible and insightful results. Business consumers can further answer multiple business questions in an easy self-service way.
In this Blog I want to introduce you to Maddison Modeler. Maddison is a Business Analyst at the BikesForYou company, and she is responsible for helping her manager to take smart business decisions based e.g., sales data. Luckily, Madison recently got access to the Business Builder, which helps her to prepare the data for such decisions.
For a brief introduction to the Business Builder watch this video:
Why are Dimensions important and what is a Dimension?
Dimensions typically represent master data, such as products, customers, or time. For a simple understanding, imagine a cube, where each cube side is a dimension.
It is necessary for Maddison to create dimensions with attributes that she wants to use for her analysis. The better she prepares the dimensions and selects the suitable attributes, the more variable her data foundation becomes for further questions. One fact not mentioned in the video is that dimensions and hierarchies often belong together.
If you want to have a closer look on how to create dimensions watch the linked video.
What is an Analytical Dataset?
Now, that Maddison knows what a dimension is and how she creates one, it is time for her to look at the fact data. The fact data is used as an Analytical Dataset, and it is the core of the data model. It should at least contain the measures and should provide the foreign keys to the dimensions which Maddison wants to analyze later in her report. The fact data could, for example, include accounting data from finance, sales data, supply chain or salary payments.
If you want to learn more on how to create an Analytical Dataset watch the linked video.
How to create a Consumption Model and Perspective?
In the last step, Maddison needs to create a consumption model and a perspective. Both are necessary to first prepare and then expose the data to SAP Analytics Cloud. By using Preview Maddison can quickly choose the data as she wants, by selecting the measures and attributes for her analysis. She can further assign authorizations, and if necessary, she can always create additional measures in the consumption model, which is especially important for so called Multifact-Models. Multifact Models are an advanced method to bridge data with different granularities over various dimensions.
How to create a consumption and a perspective in the fastest viable way have a look at this video:
Finally, Maddison could easily create an SAP Analytics Cloud Story like the following:
This Blog covers, what the Business Builder is and how to create Dimensions, Analytical Datasets, Consumption Models and Perspectives.
If you have any questions, feedback or thoughts please let me know in the comment section.