Data Tools

Question 1

A spreadsheet program that is a powerful tool for data analysis and documentation.

Answer 1

Excel

Question 2

An online, collaborative spreadsheet tool used for data analysis and documentation that is compatible with Microsoft Excel file formats.

Answer 2

Google Sheets

Question 3

Microsoft’s programming language for Excel. It allows users to automate tasks and perform several other functions.

Answer 3

VBA

Question 4

Microsoft’s interactive data visualisation and analytics tool for business intelligence.

Answer 4

Power BI

Question 5

An Interactive data visualisation software tool focused on business intelligence that can be used on both Macs and Windows operating systems.

Answer 5

Tableau

Question 6

A programming language used throughout Power BI for creating calculated columns, measures, and custom tables.

Answer 6

DAX

Question 7

Allows users to query and retrieve information from a structured database.

Answer 7

SQL

Question 8

A programming language that can be used for developing web and desktop applications that is widely used in data analysis.

Answer 8

Python