DOSSMEGT PHARMACEUTICALS Power BI Developer Interview Questions and Answers

Q1. Sql and os related questions,Java based
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. What is your family background?
Ans. 
I come from a close-knit family that values education, support, and togetherness, which has shaped my personal and professional life.
• Supportive Parents: My parents have always encouraged my education and career aspirations, providing guidance and resources.

• Siblings: I have two siblings who inspire me with their achievements; we often collaborate on projects and share ideas.

• Family Traditions: We have regular family gath...read more
Answered by AI
Add your answer
Q3. Where do you see yourself in 5 years?
Ans. 
In five years, I envision myself as a senior Power BI Developer, leading projects and mentoring others in data visualization.
• I aim to deepen my expertise in Power BI, mastering advanced features like DAX and Power Query.

• I see myself leading a team, guiding junior developers in best practices and innovative solutions.

• I plan to contribute to strategic decision-making by providing actionable insights through data storytel...read more
Answered by AI
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. What is your expectations from this company
Ans. 
I expect a supportive and collaborative work environment that values professional growth and provides opportunities for learning and development.
• Supportive and collaborative work environment

• Valuing professional growth

• Opportunities for learning and development
Answered by AI
Add your answer
Q2. I want to get into good data analytics project and learn latest tech
Add your answer

Q1. Can you please explain previous experience?
Add your answer
Q2. Can you explain about import model ?
Ans. 
Import model is a Power BI feature that allows you to import data from various sources and create a data model.
• Import model is used to create a data model in Power BI.

• It allows you to import data from various sources such as Excel, CSV, SQL Server, etc.

• You can create relationships between tables, add calculated columns, and measures.

• Import model is useful when you have large amounts of data that need to be transformed ...read more
Answered by AI
Add your answer

Q1. What is the current Organisation
Ans. 
ABC Corporation is a multinational technology company specializing in software development and data analytics.
• ABC Corporation is known for its expertise in Power BI development.

• The company has a global presence with offices in multiple countries.

• ABC Corporation offers a wide range of software solutions for various industries.

• They have a strong focus on data analytics and provide advanced reporting and visualization too...read more
Answered by AI
View 2 more answers
Q2. What is the current CTC and Expected CTC
Ans. 
The current CTC and expected CTC are personal financial details and should not be disclosed in an interview.
• It is not appropriate to discuss personal financial details in an interview.

• Salary negotiations should be done after receiving a job offer.

• Focus on discussing your skills, experience, and qualifications for the Power BI Developer role.
Answered by AI
View 1 more answer

Q1. What is Row Level Security ?
Ans. 
Row Level Security is a feature in Power BI that allows you to restrict data access at the row level based on user roles and filters.
• Row Level Security (RLS) is used to control data access in Power BI based on user roles and filters.

• It allows you to define rules that determine which rows of data a user can see.

• RLS can be applied to tables or views in the data model.

• It is commonly used to restrict access to sensitive or...read more
Answered by AI
View 2 more answers
Q2. What is difference between SUM and SUMX?
Ans. 
SUM calculates the sum of a column or expression, while SUMX calculates the sum of an expression over a table.
• SUM is used to calculate the sum of a column or expression in Power BI.

• SUMX is used to calculate the sum of an expression over a table in Power BI.

• SUM is typically used with a column reference, while SUMX is used with an expression.

• SUMX can be used to perform calculations on filtered or modified data.

• Example: S...read more
Answered by AI
View 2 more answers
Q3. What is difference between calculate column and measures?
Ans. 
Calculated columns are computed during data loading, while measures are computed on the fly during data visualization.
• Calculated columns are created in the data model and stored in the underlying table.

• Measures are created using DAX expressions and are calculated dynamically based on the context of the visualization.

• Calculated columns consume memory and can impact performance, while measures are more efficient.

• Calculat...read more
Answered by AI
View 2 more answers

Q1. Present company last working day
Ans. 
The last working day of the company is the day on which an employee's employment ends.
• The last working day is typically determined by the company's policies and the employee's contract.

• It may be different for each employee depending on their notice period or reason for leaving.

• The last working day is usually communicated to the employee through an official letter or email.

• On the last working day, the employee may be re...read more
Answered by AI
Add your answer

Q1. Difference Between direct query mode and import mode
Ans. 
Direct query mode connects to data source in real-time, while import mode loads data into Power BI for faster analysis.
• Direct query mode connects to data source in real-time, providing up-to-date data

• Import mode loads data into Power BI for faster analysis, but may not always reflect real-time changes

• Direct query mode is suitable for large datasets that require real-time updates

• Import mode is suitable for smaller datas...read more
Answered by AI
Add your answer
Q2. Define powerBI in layman poin of view
Ans. 
PowerBI is a data visualization tool that helps users analyze and visualize data to make informed business decisions.
• PowerBI helps in creating interactive reports and dashboards

• It allows users to connect to various data sources like Excel, SQL databases, and cloud services

• Users can create custom visualizations and share insights with others

• PowerBI can be used for data exploration, data modeling, and data storytelling
Answered by AI
Add your answer

Q1. How the end user access the report
Ans. 
End users can access the report through Power BI Service, Power BI Mobile App, or embedded in other applications.
• End users can access the report through Power BI Service by logging in with their credentials

• End users can also access the report through Power BI Mobile App on their smartphones or tablets

• Reports can be embedded in other applications using Power BI Embedded feature
Answered by AI
Add your answer

Power BI and SQL Coding

Q1. Salary discussion ........ TCS offer very low salary as per market standards
Add your answer
Q2. Normal Question like your family background
Add your answer
Q3. SQL and PLSQL Question
Add your answer
Q4. BI Question for RLS
Add your answer
Q5. MS Azure automation Question
Add your answer

Q1. Without RLS how can you implement the security to data?
Ans. 
Implement security to data using row-level security (RLS)
• Use user roles and permissions to restrict access to specific data

• Leverage Power BI's built-in security features such as dataset security and data categorization

• Implement dynamic security based on user context or attributes

• Utilize Power BI's security features like Azure Active Directory integration for authentication and authorization
Answered by AI
Add your answer