PowerBI

Which of the following is a primary function of a Tableau Dashboard?

• To visually display and combine multiple data visualizations.
• To perform statistical analysis on data.
• To store large datasets efficiently.
• To create complex data models.

What does 'Drill Down analytics' primarily enable users to do?

• Generate automated reports without user input.
• Visualize data trends over time.
• Summarize data in a high-level overview.
• Explore data at a granular level.

Which of the following is a core component of Power BI that allows users to create reports and dashboards?

• Power BI Desktop
• Power BI Gateway
• Power BI Mobile
• Power BI Service

Which of these is a common type of data source that Power BI can connect to?

• Excel spreadsheet
• CSV file
• XML document
• SQL Server database

When importing data into Power BI, what is a crucial step before creating visualizations?

• Ignoring data types
• Creating reports immediately
• Skipping data validation
• Data cleaning and transformation.

Which type of Power BI Data Visualization is best suited for showing trends over time?

• Bar Chart
• Line Chart
• Scatter Plot
• Pie Chart

What is a key benefit of using 'Interactive and dynamic charts' in a dashboard?

• They enhance user engagement and facilitate real-time data exploration.
• They limit data visualization to pre-set formats.
• They require extensive coding knowledge.
• They provide static data representation.

In Power BI, what is the primary purpose of a 'Slicer'?

• To connect to external data sources.
• To sort data in ascending order.
• To create visualizations in Power BI.
• The primary purpose of a 'Slicer' is to filter data in reports.

What is the significance of the 'Extract' option when connecting to data in Tableau?

• The 'Extract' option is primarily for visual formatting of data.
• The 'Extract' option allows for real-time data updates only.
• The 'Extract' option is significant for improving performance and enabling offline analysis in Tableau.
• The 'Extract' option is used to delete data from Tableau.

Which of the following is NOT a common way to import data into Power BI Desktop?

• Using web APIs to fetch data
• Connecting to SQL databases
• Importing data from a proprietary file format without a connector
• Importing data from Excel files