Practical 4: Apply the what – if Analysis for data visualization. Design and generate
necessary reports based on the data warehouse data.
1. Create the Excel workbook.
2. Add formula in formula bar of D10
=60*50+40*20
3. On the Data tab, in the Forecast group, click What-If Analysis.
4. Click Scenario Manager.
5. The Scenario Manager dialog box appears.
6. Add a scenario by clicking on Add.
7. Type a scenario name as 60% highest and changing place to $C$4
8. Enter the corresponding value 0.6 and click on OK again.
9. Next, add 4 other scenarios (70%, 80%, 90% and 100%).
Comments
Post a Comment