Business intelligence architecture

A BI architecture has the following components: A source system—typically an online transaction processing (OLTP) system, but other

systems or files that capture or hold data of interest are also possible

An extraction, transformation, and loading (ETL) process

A data warehouse—typically an online analytical processing (OLAP) system

A business intelligence platform such as MicroStrategy

S No Terms in DWH Terms in MSTR1 Dimension Attribute2 Fact Fact3 Dimension Table Look Up Table4 Fact Table Fact Table

Backend Process:The backend process will be designed by architect

Sql Engine: Generates the query [Bring the data from metadata database and then generate the query]

Query Engine: It interacts with data ware house & brings the data for the query generated by sql engine

Analytical Engine: All the calculations required for the report are performed by analytical engine For ex: total, sub-total, Grand total…etc

Differences between MSTR 9.2 and 9.3

1) Configurable formatting for table of contents   Customization of Report service Document's table of contents by formatting such as font properties, title alignment, indentation and borders, the report look and feel can be improved.

2) Dashboards enhancements Drilling across templates: Drilling on one Grid/graph to simultaneous drilling can be done on another  Grid/graph.Export a single report in a dashboard: The user can choose to export the grid/graph on the dashboard instead of exporting the entire dashboard as a PDF/Microsoft excel.Filter Panel: This type of panel stack contains only selectors, which users interact with to filter the data displayed in a dashboard.

3) Widget support Network Visualization widget: This widget displays on web. It displays different colors/line between Map markers depending on Metric values.Micro charts widget: Consists of compact representations of data that allow analysts to quickly visualize trends in data.

4) Visual Insight Enhanced mapping options,  Network Visualization, Graph Matrix Visualization, Image Layout Visualization, etc.,

5) MicroStrategy Intelligence Server Intelligent Total calculations: The Total subtotal for all metrics is calculated based on the metric’s function, rather than always defaulting to a simple summation. In addition, totals for derived metrics can also be calculated from the base level data available in a report. This is particularly useful for derived metrics such as distinct counts and averages.Communication encryption: Communications between MicroStrategy Desktop and MicroStrategy Intelligence Server are encrypted to provide enhanced security.

A Report is a request for Specific, Formatted data from the Data Warehouse.There are 5 types of Views

1) Design View2) Grid View3) Graph View4) Grid Graph View5) Sql View

Report Data Manipulations:

Report Style Manipulations

ThresholdIt is conditional formatting of Metric valuesBy defining Thresholds for a metric Report developers can format metric values according to their criteria.Go to data Tab and select Thresholds