Use-Case End-to-End Data Flow

The user currently works with the data in a spreadsheet and would like to visualize this data in a meaningful way with defined KPI.

Scenario - Spreadsheet Import E2E case

Requirement:

The initial requirement is about data center resource capacity planning. As a Data Center Configuration Manager, the user needs to provide the following daily primitive metrics regarding the data center sever capacity.

• RESERVED: The total amount of capacity that has been reserved for use, within a room.???what is a room???
• IN USE: The total amount of capacity that is in use, within a room.
• MOVE IN: The total amount of capacity which is to be received from another location.
• MOVE OUT: The total amount of capacity that is to be decommissioned.

The data for these metrics are presented in one spreadsheet, where Region Name, Country Name, City Name, Data Centre Name, Room Name, Room ID (unique) are present within every data row, in addition to the metrics.

Design:

• A Scorecard will be designed for the Data Center Configuration Manager.
• Each region will be designed as a Perspective.
• Each country will be designed as an Objective.
• KPIs for each type of capacity will be designed beneath each Objective.
• Breakdowns (City Name, Data Centre Name, Room Name Hierarchy structure) will be designed for each KPI .

Implementation:

1. Log on ITBA application by account: Administrator/Admin111.

   

2. Launch the context designer layer by: Admin -> SemanticLayer -> SemanticLayer -> Launch Context Designer.

   

   

3. Select Import Content.

   

4. Select the custom xlsx file, such as data center server capacity.xlsx.

   

5. Click the Next button and select the spreadsheets.

   

6. Click the Next button.

   

7. Click the Next button and check Schedule import later.

   

8. Click Upload > Finish .

9. Create and save one context as below.

   

10. Update the context as below, enable breakdowns and click Save.

    

11. Open Studio and build a Scorecard tree as follows：

    

    • 

    • 

    • 

    • 

    • 

    • 

    • 

12. Create 4 KPIs foreach Objective asfollows：

    

    • Total capacity used for USA:

      KPI configuration details

      

      KPI Calculation details

      

    • Total capacity moved in for USA:

      KPI configuration details:

      

      KPI calculation details:

      

    • Total  capacity moved out for USA:

      KPI configuration details

      

      KPI calculation details:

      

    • Total capacity reserved for USA

      KPI configuration details：

      

      KPI calculation details:

      

13. Create breakdowns (City, Data Center, Room Hierarchy structure) for each KPI

    1. : Createthefirstlevelbreakdown City  forTotal  capacity moved out for USA：

       

       Modify the breakdown name to City and click save button:

       

    2. Create the second level breakdown Data Center for Total  capacity moved out for USA:

       

       Modify the breakdown name to Data Center and click save button:

       

    3. Create the third level breakdown Room for Total amount of capacity that Used for:

       

       Modify the breakdown name to Room and click save button:

       

    4. The breakdown Hierarchy structure:

       

14. Do the KPI calculation:

    

    

15. Check the result in explorer

    

16. Create breakdown overwrite for the breakdown:

    • Click Add Breakdown Override button:

      

    • Add one override for this breakdown as following:

      

      

17. Save this breakdown

    

18. Do the KPI calculation:

    

19. Check the result in explorer:

    

20. Present data in dashboard page: