Overview of Microstrategy

MicroStrategy develops and sells business intelligence, mobile software, and cloud-based services. The company’s software performs analytics on a variety of data, such as sales figures,payroll data,and inventory in order to inform users' business decisions.

What is Microstrategy?
MicroStrategy  is the latest release of the MicroStrategy Business Intelligence (BI) Platform. With the addition of over 2,000 enhancements across the entire platform as well as several exciting new sets of functionality, MicroStrategy  sets the gold standard for ease-of-use, comprehensive functionality, 
scalability, security and lowest total cost of ownership in the business intelligence software industry.

Microstrategy Interview Questions

Concepts of Microstrategy:

1) Difference between View Filter,Report Filter and Report Limit.

2).Difference between consolidation and custom groups.

3)What are the level metrics and conditional metrics and their use?

4)What are the VLDB properties ? What properties you have used?

5)Parent Child Relationship of attributes and its use?

6)Report execution flow?

7)Task of the analytical engine.

8)Prompts types and uses.

9)Pass Through functions.

10)Security Role And Security Filter.

11)Questions Related to document formatting like grouping ,sorting,linking,thresholds etc.

12)Questions related to Microstrategy Admin like database instance,scheduling,users etc.

13)What is compound key attribute?

14)Intelligent cube ?

15)What is the logical size of a table and how it is calculated?

16)why we use heterogeneous mapping in MSTR?

17) What is a fact less fact table? And Why we use?

SQL And Data warehouse: 

a)joins in SQL like outer join ,inner join etc

b)Normalization

c)Difference between Snowflake and Star Schema

d)Indexing and its importance

e)Different functions of SQL like coalesce

f)How to find the second highest row.

Business Knowledge: 

a) What is Business Intelligence?

b) Characteristics of a project ?

c) Best Technology to use for the project.

d) What improvement you want in Microstrategy tool.

These questions are asked to check one's interest and in-depth knowledge of the subject and platform on which he/she is working