Arctern Power BI Developer Interview Questions and Answers

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. ROW LEVEL SECURITY
Add your answer
Q2. SUM, SUMIF SUMIFS AND DELETE TRUNCATE
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
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

Q1. How many filters in power bi
Ans. 
There are multiple types of filters in Power BI including visual, page, report, and drill-through filters.
• Visual filters apply to a specific visual or group of visuals.

• Page filters apply to all visuals on a specific page.

• Report filters apply to all visuals on all pages of a report.

• Drill-through filters allow users to navigate to a different report page based on a selected data point.
Answered by AI
Add your answer
Q2. There are three filters
Ans. 
The three filters can be applied to the data in Power BI to narrow down the results.
• Filters can be applied to specific columns or measures in the data

• Filters can be used to show only certain values or ranges of values

• Filters can be combined to create more complex filtering logic
Answered by AI
Add your answer

Q1. How many connectivity modes
Ans. 
There are three connectivity modes in Power BI: Import, DirectQuery, and Live Connection.
• Import mode: Data is imported into Power BI and stored in a dataset.

• DirectQuery mode: Data stays in the data source and queries are sent directly to the source.

• Live Connection mode: Power BI connects directly to the data source for real-time data access.
Answered by AI
View 1 more answer

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

Q1. Explain your overall experience.
Ans. 
I have 5 years of experience as a Power BI Developer.
• Developed interactive dashboards and reports using Power BI

• Created data models and performed data analysis

• Worked with various data sources such as SQL Server, Excel, and SharePoint

• Implemented data transformations and data cleansing

• Collaborated with business stakeholders to gather requirements and provide insights

• Optimized performance and improved data visualization

• Tr...read more
Answered by AI
View 1 more answer
Q2. Explain your recent experience.
Ans. 
I have recently worked as a Power BI Developer, creating interactive dashboards and reports.
• Developed interactive dashboards and reports using Power BI

• Gathered requirements from stakeholders and translated them into data visualizations

• Created data models and implemented data transformations

• Collaborated with cross-functional teams to ensure data accuracy and consistency

• Provided training and support to end-users for effe
Answered by AI
Add your answer