Societe Generale Global Solution Centre MSBI and Power BI Developer Interview Questions and Answers

Q1. What you do as a MSBI developer in your organisation
Ans. Gathering data and load into the SQL server db with the help of SSIS, create stored procedures, user defined functions, performance tuning of SSIS packages, creating interactive, user friendly dashboards and reports in PowerBI as per the requirement.
Answered Anonymously
Add your answer

Power bi desktop in power bi service

Q1. What is power bi
Ans. 
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
• Power BI allows users to connect to various data sources and create interactive reports and dashboards.

• Users can easily share and collaborate on reports with others within the organization.

• It offers features like data modeling, data visualization, and data transformation.

• Power BI can be use...read more
Answered by AI
View 1 more answer
Q2. How creative a dashboard in power query
Ans. 
A creative dashboard in Power Query involves using unique visuals and interactive elements to present data in an engaging way.
• Utilize custom visuals to display data in a visually appealing manner

• Incorporate interactive elements such as slicers and filters for user-friendly navigation

• Use color coding and formatting to highlight important insights

• Include dynamic elements like tooltips and drill-down capabilities

• Experimen...read more
Answered by AI
View 1 more answer

Q1. Power bi desktop
Add your answer
Q2. Write the Dax query in data modeling
Ans. 
Write a DAX query in data modeling
• Use CALCULATE function to apply filters and context to calculations

• Use SUMX function to iterate over a table and perform calculations

• Use RELATED function to retrieve related values from other tables
Answered by AI
View 1 more answer

Q1. What is power pivot
Ans. 
Power Pivot is a data modeling tool in Excel that allows users to create relationships, calculations, and measures for analyzing large datasets.
• Power Pivot is an add-in for Excel that enables users to create data models and perform advanced data analysis.

• It allows users to import and combine data from multiple sources, create relationships between tables, and define calculations and measures.

• Users can create complex ca...read more
Answered by AI
Add your answer
Q2. Creation in dax
Ans. 
Creation in DAX refers to the process of generating new calculated columns or measures in Power BI using Data Analysis Expressions.
• Use DAX functions like CALCULATE, SUMX, AVERAGE, etc. to create new columns or measures

• Understand the data model and relationships to create accurate calculations

• Test the newly created calculations to ensure they are working correctly
Answered by AI
Add your answer

Q1. What are the components of Power bi
Ans. 
Power BI components include Power Query, Power Pivot, Power View, Power Map, and Power Q&A.
• Power Query: Used for data extraction and transformation.

• Power Pivot: Used for data modeling and analysis.

• Power View: Used for interactive data visualization.

• Power Map: Used for geographical data visualization.

• Power Q&A: Allows users to ask questions in natural language and get answers from data.
Answered by AI
Add your answer
Q2. What is mean by DAX
Ans. 
DAX stands for Data Analysis Expressions and is a formula language used in Power BI for creating custom calculations.
• DAX is used to create custom calculations in Power BI, similar to Excel formulas.

• It can be used to create calculated columns, measures, and calculated tables.

• DAX functions can be used to manipulate data, perform calculations, and create complex expressions.

• Examples of DAX functions include SUM, AVERAGE,
Answered by AI
Add your answer
Q3. What is mean by M language
Ans. 
M language is a powerful data transformation language used in Power Query in Power BI.
• M language is used to transform and clean data in Power BI.

• It is a functional language with a wide range of functions and operators.

• M language is case-sensitive and uses a step-by-step approach to data transformation.

• Examples of M language functions include Table.TransformColumns and List.Transform.
Answered by AI
Add your answer

It was a real-time scenario that they asked about.

Scenario based with power BI UI creation

Q1. Structure way of Power BI
Ans. 
Power BI is a business intelligence tool used for data visualization and analysis.
• Power BI allows users to connect to various data sources such as databases, Excel files, and online services.

• Users can create interactive reports and dashboards using Power BI's drag-and-drop interface.

• Power BI offers a wide range of visualization options like charts, graphs, and maps to present data effectively.

• Users can share their repo...read more
Answered by AI
Add your answer
Q2. Reports of Power BI
Ans. 
Power BI reports are visual representations of data insights, created using Power BI Desktop or Power BI Service.
• Power BI reports are interactive and customizable

• They can include various visualizations like charts, graphs, tables, and maps

• Reports can be shared and accessed online through Power BI Service

• Data can be refreshed in real-time or scheduled updates
Answered by AI
Add your answer

Q1. Scenario based question on Power BI summarized table view concept
Add your answer
Q2. How to achieve dynamic chart based on selection button
Ans. 
Use Power BI bookmarks and buttons to dynamically change chart visuals based on user selection.
• Create multiple chart visuals for different data sets

• Use bookmarks to save different chart configurations

• Link selection buttons to bookmarks to dynamically switch between charts
Answered by AI
Add your answer

Q1. Tell us about your latest project
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. What is your family background?
Add your answer
Q3. Share details of your previous job.
Add your answer
Q4. Why should we hire you?
Add your answer
Q5. Why are you looking for a change?
Add your answer
Q6. Where do you see yourself in 5 years?
Add your answer
Q7. What are your strengths and weaknesses?
Add your answer
Q8. Tell me about yourself.
Add your answer