Dashboard creation process

We can start creating our dashboard once we complete the initiation phase. The dashboard creation process is very simple, as we can see in the following diagram:

Now, let's discuss each step in more detail as follows:

• Import data: The first logical step in the dashboard creation process is to import data to your dashboard, which can be done by linking our dashboard MS Excel model with a dynamic data source, such as Live Office, Web service or Direct Universes query. This option will help us dynamically refresh the data in our dashboard after we publish it. On the other hand, we can also import the Excel raw data into our dashboard. In this case, our dashboard will depend on the data imported, and somehow it will be static.
• Build the model: We can start building the model after importing the data by adding dashboard components, and by linking them with the data we imported in the preceding section. We may link our dashboard objects directly to the source data...