Persistent Systems Power BI Developer Interview Questions and Answers

Q1. Tell us about your latest project
Add your answer

Q1. Tell me about Yourself
Add your answer

Q1. What is the difference between star schema and snowflake schema?
Ans. 
Star schema has a single fact table connected to multiple dimension tables, while snowflake schema has normalized dimension tables.
• Star schema denormalizes dimension tables, making it easier to query but potentially less efficient for storage.

• Snowflake schema normalizes dimension tables, reducing redundancy but potentially making queries more complex.

• Star schema is commonly used for data warehouses with denormalized da...read more
Answered by AI
Add your answer

Q1. What is the use of GROUP BY clause?
Ans. 
The GROUP BY clause is used in SQL to group rows that have the same values into summary rows.
• It is used with aggregate functions like COUNT, SUM, AVG, etc.

• It helps in summarizing data and generating reports.

• It is often used in conjunction with the HAVING clause to filter grouped data.

• Example: SELECT department, COUNT(employee_id) FROM employees GROUP BY department;
Answered by AI
Add your answer

Q1. Dax query method question
Add your answer
Q2. Direct query method and formulas
Add your answer

Brief information about Business Intelligence (BI) tools.

Q1. What is the role of Power BI in today's market?
Ans. 
Power BI plays a crucial role in today's market by enabling organizations to visualize and analyze their data for better decision-making.
• Power BI allows businesses to create interactive reports and dashboards for data visualization.

• It helps in analyzing data trends, identifying patterns, and making informed decisions.

• Power BI integrates with various data sources, making it easier to consolidate and analyze data from mu...read more
Answered by AI
Add your answer
Q2. What are the differences between Power BI and Tableau?
Ans. 
Power BI is a Microsoft business analytics tool while Tableau is a data visualization tool.
• Power BI is a Microsoft product while Tableau is developed by Tableau Software.

• Power BI is more user-friendly for users familiar with Microsoft products.

• Tableau has more advanced visualization capabilities compared to Power BI.

• Power BI integrates well with other Microsoft products like Excel and Azure, while Tableau has more flex...read more
Answered by AI
Add your answer
Q3. What are some case studies that demonstrate the use of Power BI?
Ans. 
Power BI has been used in various industries for data visualization and analysis.
• Retail industry: analyzing sales data to identify trends and optimize inventory

• Finance sector: creating interactive dashboards for financial reporting and analysis

• Healthcare sector: tracking patient outcomes and hospital performance metrics

• Manufacturing industry: monitoring production efficiency and supply chain management
Answered by AI
Add your answer

Q1. What are your salary expectations?
Ans. 
My salary expectations are in line with industry standards for a Power BI Developer with my level of experience.
• I have researched the average salary range for Power BI Developers in this location

• I am looking for a competitive salary that reflects my skills and experience

• I am open to negotiation based on the overall compensation package offered
Answered by AI
Add your answer

Q1. Difference between measure and count
Ans. 
Measure is a calculated value based on data in a model, while count is a simple count of records.
• Measure is a calculated value based on aggregation functions like sum, average, etc.

• Count is a simple count of records in a dataset.

• Measures are used in Power BI to perform calculations on data, while count is used to simply count the number of records.
Answered by AI
Add your answer
Q2. What is Row level security
Ans. 
Row level security is a feature in Power BI that restricts data access at the row level based on user roles or criteria.
• Allows users to only see data that is relevant to them

• Can be implemented using DAX expressions

• Helps in maintaining data privacy and security

• Useful for organizations with sensitive data
Answered by AI
Add your answer
Q3. What are relationships in power BI
Ans. 
Relationships in Power BI define how different tables are connected to each other.
• Relationships define how tables are related to each other based on common fields

• They are used to create connections between tables for data analysis

• Relationships can be one-to-one, one-to-many, or many-to-many

• They are essential for creating accurate and meaningful visualizations in Power BI
Answered by AI
Add your answer
Q4. In previous project what type of data source we used
Ans. 
We used a variety of data sources including SQL databases, Excel files, and web APIs.
• SQL databases

• Excel files

• Web APIs
Answered by AI
Add your answer

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