Notes

2). Foundation for creating reports
* Pivoting data
- Interchanging rows with columns to look on the data from different perspectives
* Drilling
- Changing granularity of data ( for example Country -> Region -> City -> Neighbourhood)
* Attributes and metrics
- Attribute forms
- Additional descriptive information of any attribute (Mapped to columns in SQL [for example: Attribute Country would have ID, Name, Population etc.)
* Attribute elements
- Unique elements of attributes (for example: Attribute Country would have elements such as USA, Poland, UK)
* Metrics
- Numerical values obtained by performing calculations on the data

Basic description and functionality of Microstrategy Platform
Exercise 2.1 (Report basics) goals:
- Open a pre-designed report
- Modify the report by adding additional attributes and metrics
- View the report in Grid, Graph and Grid/Graph modes
- Drill into different levels of data

Exercise 2.2 (Report data manipulation) goals:
- Pivot the report data
- Page the report
- Drill into different levels of data
- Change the background fill of grid cells
- Save report with different names


3). Creating reports
Creating new reports from scratch or already existing ones.

Exercise 3.1 (Create a report using the Employee Analysis template) goals:
- Create a report based on a template
- Adding objects (Attributes, metrics, filters)
- Customising report ( Choosing which attribute forms to display, merging rows or columns)
- Building reports from scratch

Exercise 3.2: (Create a simple report from scratch) goals:
- Creating template from scratch
- Adding objects
- Customising report, simple filtering


4). Filtering reports
4.1). Filters
* Report filters
- Set filters before data it is retrieved from the database
* View filters
- Set filters after data was retrieved (control what is displayed)
4.2). Prompts
- Instead of hard-coding values on a filter, allow users to set threshold values, select attributes to be displayed
4.3). Reports
- That I don't understand that well

Exercise 4.1 (Create a view filter) goals:
- Controlling what data is displayed on already generated report

Exercise 4.2 (Create a report filter) goals:
- Controlling what data is available in the report (before report was generated)

Exercise 4.3 (Create stand-alone filters) goals:
- Combining multiple filters into one object

Exercise 4.4 (Create prompts to use in a filter) goals:
- Allowing user to filter the data by specifying threshold values for attributes and metrics

Exercise 4.5 (Create object prompts to select objects displayed on report) goals:
- Allowing user to filter the data by specifying what objects should be included in the report

5). Creating own metrics (Need more revision)
Exercise 5.1 and 5.2 (Create simple metrics) goals:
- Use simple, singular functions to define new metrics
- Format the metric

Exercise 5.3 (Create compound metrics) goals:
- Use multiple metrics in their formula
- Format the metric
- Use smart metric feature

5.3). Derived metrics
* Based on data that is already in the report