If you are going for a Microstrategy Interview then it is not sure that you will be asked only questions which are related to microstrategy.There is no fix pattern for the interview questions.We can differentiate the question in different sections like:
1. Business Knowledge
2.Analytical skills
3.SQL knowledge
4.Microstrategy Concepts
5.Some general question related to your job change or candidature
There is no particular order for these questions.These questions and answers are my point of views,but everybody can have different answers.I want to just tell the kind of question for the interview.
1.Some general question related to your job change or candidature
a) Tell Me About Yourself :
First and For sure question in every interview for any level. And Ball is in your court.
You can tell :
Your Personal Details (Name,Hometown etc)
Your Academics (Start From Highest)
Your Extra curricular Activities (give a brief description)
Your Current Job and Role
Your Hobbies.
All depends on the time given by the interviewer.
Sometimes you don't have more than 2 mins.
In those situations you can tell about your personal details,academics and your competency for the job.
And also be prepare for interruption by the interviewer , but answer with smile.
And remember 2 things always : "Don't Bluff and Short is Sweet"
b)How you got the information about this job?
Show your interest in the job while answering like I was visiting your website and I was very impressed by the services or products and work culture etc ,
or you can say this was my dream company while college days...
don't tell while surfing or some of your friend applied etc.
Show them that you are serious for the job. And before going for any interview always collect some information for the organization no matter it is a technical interview.
c)Why should we hire you?
Now again ball is in your court.Tell them you have all the required skills for the job and not only this show your passion and attachment and honesty about the job by giving example of your previous job.
d)What was your role in the last company ?
Tell about your role like coding ,testing etc.
e) How you helped your organization in making money?
You can tell about your dedication and deadlines adherence,quick learning and team work
2.Microstrategy Concepts:
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?
18)
Try to give scenario based answer like you can take attribute,metric,filters etc .It will be more clear and easy to explain also.
3.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.
4.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
5.Analytical Skills:
a)You can be given a practical problem like to calculate the revenue of a region.And you need to define your approach and write SQL.
b)Interviewer can ask you to find number of post offices in a state.
These are the question to check you presence of mind and analytical skills.Interviewer is interested in your approach rather than your correct answers.
Your suggestions are most welcome.
http://www.thinkvidya.com/bangalore/microstrategy-t/1551795
1. Business Knowledge
2.Analytical skills
3.SQL knowledge
4.Microstrategy Concepts
5.Some general question related to your job change or candidature
There is no particular order for these questions.These questions and answers are my point of views,but everybody can have different answers.I want to just tell the kind of question for the interview.
1.Some general question related to your job change or candidature
a) Tell Me About Yourself :
First and For sure question in every interview for any level. And Ball is in your court.
You can tell :
Your Personal Details (Name,Hometown etc)
Your Academics (Start From Highest)
Your Extra curricular Activities (give a brief description)
Your Current Job and Role
Your Hobbies.
All depends on the time given by the interviewer.
Sometimes you don't have more than 2 mins.
In those situations you can tell about your personal details,academics and your competency for the job.
And also be prepare for interruption by the interviewer , but answer with smile.
And remember 2 things always : "Don't Bluff and Short is Sweet"
b)How you got the information about this job?
Show your interest in the job while answering like I was visiting your website and I was very impressed by the services or products and work culture etc ,
or you can say this was my dream company while college days...
don't tell while surfing or some of your friend applied etc.
Show them that you are serious for the job. And before going for any interview always collect some information for the organization no matter it is a technical interview.
c)Why should we hire you?
Now again ball is in your court.Tell them you have all the required skills for the job and not only this show your passion and attachment and honesty about the job by giving example of your previous job.
d)What was your role in the last company ?
Tell about your role like coding ,testing etc.
e) How you helped your organization in making money?
You can tell about your dedication and deadlines adherence,quick learning and team work
2.Microstrategy Concepts:
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?
18)
Try to give scenario based answer like you can take attribute,metric,filters etc .It will be more clear and easy to explain also.
3.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.
4.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
5.Analytical Skills:
a)You can be given a practical problem like to calculate the revenue of a region.And you need to define your approach and write SQL.
b)Interviewer can ask you to find number of post offices in a state.
These are the question to check you presence of mind and analytical skills.Interviewer is interested in your approach rather than your correct answers.
Your suggestions are most welcome.
http://www.thinkvidya.com/bangalore/microstrategy-t/1551795
No comments:
Post a Comment