CTS Consulting & Technical Support Power BI Developer Interview Questions and Answers

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

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;

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

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

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