Exploring Business Intelligence Concepts

What is the primary purpose of data visualization tools?

• To create complex algorithms for data processing.

• To store data in a database for future use.

• To represent data graphically for easier understanding and analysis.

• To ensure data security and privacy compliance.

Name two popular data visualization tools used in business intelligence.

• Excel, Google Sheets

• Tableau, Power BI

• QlikView, D3.js

• Looker, SAP Analytics

What is a Database Management System (DBMS)?

• A Database Management System (DBMS) is software that manages databases.

• A DBMS is a type of hardware used for data storage.

• A DBMS is a programming language for data analysis.

• A DBMS is a cloud service for file sharing.

List three functions of a Database Management System.

• Data visualization

• Data encryption

• Data archiving

• 1. Data storage 2. Data retrieval 3. Data manipulation

What is the difference between structured and unstructured data?

• Unstructured data is organized in a database, while structured data is not.

• Structured data is organized and easily searchable, while unstructured data is unorganized and harder to analyze.

• Structured data is always in text format, while unstructured data is in binary format.

• Structured data is less reliable than unstructured data.

Define big data analytics in your own words.

• Big data analytics is the process of creating data without any analysis.

• Big data analytics is the process of analyzing vast amounts of data to extract meaningful insights and support decision-making.

• Big data analytics refers to the use of small data sets for quick insights.

• Big data analytics is only about storing large datasets without analysis.

What are the three Vs of big data?

• Volume, Variety, Validation

• Volume, Velocity, Value

• Velocity, Variety, Visualization

• Volume, Velocity, Variety

How does data visualization enhance decision-making?

• Data visualization eliminates the need for data analysis entirely.

• Data visualization is only useful for aesthetic purposes, not decision-making.

• Data visualization improves clarity and understanding, enabling faster and more informed decision-making.

• Data visualization complicates data interpretation, leading to slower decisions.

What is SQL and how is it used in database management?

• SQL is a type of spreadsheet software.

• SQL is used for creating graphic designs.

• SQL is a programming language used for managing and manipulating relational databases.

• SQL is a markup language for web development.

Explain the concept of data warehousing.

• Data warehousing is primarily used for data entry tasks.

• Data warehousing is a technique for data encryption.

• Data warehousing is a method for real-time data processing.

• Data warehousing is a centralized repository for storing and analyzing data from multiple sources to support business intelligence and decision-making.