Preparing the dashboard workspace
We will use the raw data that has been exported to the Excel file and has been extracted from the eFashion database. The eFashion database is provided by SAP BO for training and practice purposes. We will learn how to connect directly with the eFashion Universe to dynamically refresh our data in Chapter 9, Retrieving External Data Sources. For now, we will just learn how to import and use the raw Excel data extracted from the eFashion database.
Before we start, we need to download the example code files from the Packt site. Then, we need to extract the downloaded file. The file contains the folders that we can see in the following screenshot:
Let's take a moment to describe each folder as follows:
- Dashboards (Ready): This folder contains the
.XLF
file for each chapter. You can use this folder to open the final version of the dashboard that you should have if you followed all the steps mentioned in the chapter. You can use it to compare the dashboard file...