After downloading, unzip the file and run the program. It starts installing. Open the installed ‘Microstrategy Desktop’. SELECT SAMPLE DATA After installing and opening up Microstrategy Desktop, select “New Dossier” Go to in the menu ‘Add Data’ bar. Select ‘New Data’. Select the ‘Sample files’ These are the list of Sample files Select from the set of Sample Files and then ‘Retail Sample Data’ click ‘Finish’. DATA ANALYSIS and to rows and to columns. The cities and months are in rows and Drag ‘City’ ‘Month’ ‘Item category’ item categories are in columns. Drag and to Metrics. Note also, that by selecting the edit icon (see system ‘Revenue’, ‘Units sold’ ‘Cost’ screenshot below), you can change your selections. After dragging, click on the totals are shown. ‘Show Totals’ icon. Now Observe the data and answer the following questions: Questions on the Data See if you can take advantage of the native tools to answer the following questions. Answer the questions below by filtering for the city ‘Annapolis’. For the city Annapolis, which item category (or categories) has ( have) the highest revenue? How much? (1 pt). Note that you have to clear the visualization after each display by clicking the ‘drop in top right corner and select Clip the relevant portion of your answer and down’ button ‘Delete’.
After downloading, unzip the file and run the program. It starts installing. Open the installed ‘Microstrategy Desktop’. SELECT SAMPLE DATA After installing and opening up Microstrategy Desktop, select “New Dossier” Go to ‘Add Data’ in the menu bar. Select ‘New Data’. Select the ‘Sample files’ These are the list of Sample files Select ‘Retail Sample Data’ from the set of Sample Files and then click ‘Finish’. DATA ANALYSIS Drag ‘City’ and ‘Month’ to rows and ‘Item category’ to columns. The cities and months are in rows and item categories are in columns. Drag ‘Revenue’, ‘Units sold’ and ‘Cost’ to Metrics. Note also, that by selecting the edit icon (see system screenshot below), you can change your selections. After dragging, click on ‘Show Totals’ icon. Now the totals are shown. Observe the data and answer the following questions: Questions on the Data See if you can take advantage of the native tools to answer the following questions. Answer the questions below by filtering for the city ‘Annapolis’. For the city Annapolis, which item category (or categories) has ( have) the highest revenue? How much? (1 pt). Note that you have to clear the visualization after each display by clicking the ‘drop down’ button in top right corner and select ‘Delete’. Clip the relevant portion of your answer and