FPBA1014 Chapter 10 Quiz

Which of the following are NOT reasons for a business to use Business Analytics Tools?

• To improve profits

• To improve decision-making
• To increase efficiency and productivity
• Personal reasons

What role does Business Analytics play in decision-making?

• It provides insights based on data analysis

• It provides insights based on astrology

• It provides insights based on guesswork

• It provides insights based on dreams

What is a main feature of Microsoft Power BI?

• Cooking recipes database
• Ability to play video games
• Interactive visualisations and integrating data from various sources

• Social media platform that can share pictures

What is a main feature of Microsoft Excel?

• Organizing and calculating structured data with formulas

• Playing music from a playlist

• Editing and manipulating photos

• Sending emails with attachments

What can Tableau do that is better than Microsoft Excel?

• Tableau is simpler to use.

• Tableau can send out emails directly from the app.

• Tableau can input data faster.

• Tableau can handle larger datasets and create more complex visualisations.

Which of the following are NOT the benefits of using Python?

• Python has simple drag and drop tools.

• Python can be integrated with other tools.

• Python is open-source and anyone has access to use it.

• Python is versatile and general purpose.

What are the features of R?

• Video game creation

• Astronomy research
• Historical events
• Data analysis, visualisation, and statistical modeling

What can SQL be used for?

• Managing and manipulating relational databases
• Creating apps and programs

• Creating 3D animations
• Creating visualisations from structured data

A business has collected a large volume of video, audio, and text data on their customers. It needs to process the data in a timely manner, which tool should it use?

• Apache Spark

• Microsoft Excel

• Power BI

• Tableau

Which of the following are NOT challenges that Business Analytics (BA) face?

• Unskilled employees that do not know how to use BA tools.

• BA tools can be an expensive investment.

• BA tools require high level artificial intelligence to run.

• There is a variety of data formats, structures and access methods that make integrating data difficult.