Data+ BI Tool Basics: Tableau and Power BI

1. In Power BI, what does 'Power Query Editor' allow you to do?

Design interactive dashboards

Clean, transform, and combine data

Write Python scripts

Manage user access

2. What is the main advantage of using Power BI's 'Power Pivot' feature?

Creating simple bar charts

Building advanced data models with relationships

Deleting unwanted rows

Converting images to data

3. In Tableau, what does 'shelving' data mean?

Storing data in archives

Dragging fields to rows, columns, or other areas

Removing data from the dataset

Backing up visualizations

4. True or False: Power BI Desktop requires an internet connection to create and edit reports.

True

False

5. Which tool is known for its strength in exploratory data analysis and ad-hoc visualization?

Excel only

Tableau

SQL databases

Text editors

6. In Power BI, what is a 'relationship' between tables used for?

To delete duplicate rows

To join tables for combined analysis

To compress file size

To hide sensitive columns

7. What is the purpose of a 'filter' in Tableau or Power BI?

To permanently delete data

To restrict displayed data based on criteria

To change data types

To create new columns

8. True or False: Tableau Public allows you to publish interactive visualizations online for free.

True

False

9. What is the primary purpose of a business intelligence tool like Tableau or Power BI?

To store raw data in databases

To transform raw data into visual insights for decision-making

To replace all spreadsheet software

To create only static reports

10. True or False: Power BI Premium is required to publish dashboards to Power BI Service.

True

False

11. Which visualization type is best for showing trends over time?

Pie chart

Line chart

Scatter plot

Heat map

12. In Power BI, what is DAX used for?

Creating visualizations only

Writing formulas and custom calculations

Connecting to Excel files

Managing user permissions

13. True or False: Tableau and Power BI can both connect to real-time data sources.

True

False

14. In Power BI, what component is used to import and model data?

Power Query

Power BI Service

Power Pivot

Power Apps

15. Which of the following is a key difference between Tableau Desktop and Tableau Server?

Desktop is for analysis; Server is for sharing dashboards

Server has more visualization types

Desktop cannot connect to live data

Server is only for small datasets

16. What is a 'calculated field' in Tableau?

A field created from existing fields using formulas

A field imported from an external database

A field used only for filtering

A field that cannot be modified

17. In Tableau, what is a 'dimension' used for?

A numerical measurement or metric

A categorical variable that describes data

A type of chart visualization

A database connection method

Submit

19. What is a 'measure' in Tableau?

A categorical field used for filtering

A numerical field that can be aggregated

A type of dashboard filter

A saved visualization

Submit

Data+ BI Tool Basics Tableau and Power BI Quiz

1. In Power BI, what does 'Power Query Editor' allow you to do?

2.

What first name or nickname would you like us to use?

2. What is the main advantage of using Power BI's 'Power Pivot' feature?

3. In Tableau, what does 'shelving' data mean?

4. True or False: Power BI Desktop requires an internet connection to create and edit reports.

5. Which tool is known for its strength in exploratory data analysis and ad-hoc visualization?

6. In Power BI, what is a 'relationship' between tables used for?

7. What is the purpose of a 'filter' in Tableau or Power BI?

8. True or False: Tableau Public allows you to publish interactive visualizations online for free.

9. What is the primary purpose of a business intelligence tool like Tableau or Power BI?

10. True or False: Power BI Premium is required to publish dashboards to Power BI Service.

11. Which visualization type is best for showing trends over time?

12. In Power BI, what is DAX used for?

13. True or False: Tableau and Power BI can both connect to real-time data sources.

14. In Power BI, what component is used to import and model data?

15. Which of the following is a key difference between Tableau Desktop and Tableau Server?

16. What is a 'calculated field' in Tableau?

17. In Tableau, what is a 'dimension' used for?

18. A 'dashboard' in both Tableau and Power BI serves primarily to ____.

19. What is a 'measure' in Tableau?

20. A 'worksheet' in Tableau is best described as a ____.