Question

1. Use the Help function of Excel to learn more about the Excel Scenario Manager and the Excel Solver Add-in.

2. Do research on the Web to find business analytics applications that can run on a smartphone. Prepare a brief paragraph summarizing the features and potential applications of three applications of most interest to you.

Answer 1

Question 1

Excel Scenario Manager

Scenario Manager is a tool which is used in the scenario when there are multiple variables and we want to see the effect on the final result based on the values changed on these variables. Main point is to check how the final result changes when these variables values are changed.

Excel Solver Add-in.

Solver Add-in is mainly used for the what-if analysis. It is used to calculate the maximum or minimum value for a particular formula in a particular cell. This particular cell is referred as the objective cell. Solver Add-in works with the values in the decision variables cell so that it satisfies all the limit constraints and to conclude the result for the objective cell.

Question 2

Business analytics applications that can run on a smartphone are as follows

1. RoamBI

RoamBi is application which has all the features for analyzing a spreadsheet. It has the potential to read data from multiple sources like SAP BO, Google Docs, Salesforce etc.

2. QlikView

Qlikview is one of the best application for having Business analytics. The main advantage is that it helps in creating and presenting the information in a dynamic way. Also it has a inbuilt dynamic calculation engine for performing real time analysis. It provides an interactive layout by the help of the HTML5.

3. SalesClic

SalesClic is a type of application which helps to give a wider analysis of sales management. It can be used with any other apps very easily. The main advantage of it is it helps in adjusting sales process by checking the historical data which are stored in various databases. As a result it helps in making statement about the improvement of sales forecast.