BI QUIZ

Which of the following is NOT a visualization option in Power BI?

• Pie Chart

• Line Graph

• Bar Chart

• Pivot Table

Which language is used in Power BI to create calculated columns and measures?

• Python

• DAX

• R

• PHP

In Power BI, what is the primary purpose of a relationship between tables?

• To merge tables into one

• To create a direct connection between tables for analysis

• To remove duplicate data

• To increase data redundancy

What is the function of "Filters" in Power BI?

• To change the appearance of a report

• To speed up report processing

• To modify database schemas

• To limit data displayed in visualizations

Which Excel feature allows users to summarize and analyze data using a drag-and-drop interface?

• Pivot Tables

• Macros

• Data Validation

• Conditional Formatting

What does the "IF" function in Excel do?

• Formats data automatically

• Applies a condition to return different results

• Sorts data in a table

• Removes duplicates

What is the main objective of Exploratory Data Analysis (EDA)?

• To build predictive models

• To clean and preprocess data

• To summarize, visualize, and detect patterns in data

• To store data efficiently

12. Which of the following is NOT a common technique in EDA?
    

• 12. Data visualization

• 12. Descriptive statistics

• 12. Feature engineering

• 12. Writing SQL queries

Which type of plot is best for showing the distribution of a numerical variable?

• Scatter Plot

• Histogram

• Line Chart

• Pie chart

Which chart type is most appropriate for displaying trends over continuous time periods?

• Bar Chart

• Pie Chart

• Line Chart

• Map