BMIS 311 Data Analytics Smbk

Curiosity, understanding context, having a technical mindset, data design, and data strategy are the 5 essential aspects of __ thinking and skills

Analytical

What are the main types of visuals that Power BI supports?

Comparison, correlation, distribution, data over time, part-to-whole representations, and rankings

The 3-step data visualization process is comprised of which of the following?

Create your visualsExplore data sets for patternsPlanning for visuals

What functionalities does Tableau provide for data analysis?

Data Preparation and cleansing Connection and exploring data Creating what-if analyses User interactivity Calculations and functions

Analytical skills necessary for a data analyst include the characteristics and capabilities that allow for the observation, research, and interpretation of a problem or change in a desired state. According to Google, there are five essential aspects of analytical skills including which 3 of the following?

Data strategy- Understanding context- Curiosity

DDDM refers to Data Driven____ Marketing

Decision

How do IoT data analytics benefit organizations? Restricts data access to senior management Provides data that is only relevant to IT departments Offers insights that assist in proactive decision-making Enables real-time monitoring and alerts

Enables real-time monitoring and alerts Offers insights that assist in proactive decision-making

According to Tableau, data-driven decision making (DDDM) is the use of the following to guide strategic business decisions that align with organizational goals, objectives, and initiatives.

Facts, Metric, Data

Which of the following statements correctly address how Power BI supports the needs of different users within an organization?

Offers enhanced security with Power BI Report Server in its Premium version Department managers can track data specific to their departments

What features make Python popular for data analytics?

Open-source nature Active developer community supports graphics and visualization tools

Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called Microsoft

Power

SQL, usually pronounced "sequel", is quite useful when working with large data sets. The Q in SQL stands for

Query

Collections of related fields in a database are referred to as

Records

In order to be considered open data, databases must provide access rights so that they can be ___.

Redistributed

Which of the following are challenges associated with using Tableau?

Requires separate dashboards for mobile and desktop due to display issues Limited to 16-column table displays High cost when scaling for large organizations

When working in Tableau, users can assume which 3 roles?

Viewers, Explorers. Creators

Data that offers free access, distribution, and usage is known as______data.

open

When data is anonymized, the PII is eliminated or encrypted. PII includes names, social security numbers, addresses, and more and stands for ___ identifiable information.

personally

The graphical and structured representation of data is known as data

visualization

The process of data analytics includes which of the following?

Descriptive Analytics, Predictive Analytics, Prescriptive Analytics

Which program is typically limited to one user at a time?

Spreadsheet

In computer programming, a set of rules and guidelines that define a specific computer language is referred to as the language's

Syntax

When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered ___ data

Third-party

Which of the following are uses of IoT analytics in business?

To personalize products and services based on customer usage To optimize business processes by identifying inefficiencies To reduce downtime by predicting equipment failures

Which of the following best describes the focus of predictive analysis?

Understanding, predicting, and planning for the future

What is a key benefit of integrating Python with Excel for data analysis?

Users can access Python directly from the Excel ribbon without needing installation

When working in Microsoft Power BI, which 3 tiers are available?

Desktop, Pro, Premium

Which of the following is a popular data analytics program that offers business intelligence as well as data visualization

Tableau

Most databases are composed of multiple_______which are groups of assigned records and fields organized in rows and columns.

Tables

Protecting private or sensitive information by eliminating or encrypting information is the goal of data

anonymization

A SQL statement is used to ask a question or communicate a request of the__________ management system

database

SQL is quite useful when working with large data sets and is widely used in today's business environment. It allows the user to query the data contained in a

database

In a database, data is organized in complex and meaningful collections specified by the database administrator. These collections are referred to as

fields

Data that has been collected internally by the organization is known as -party data

first