Data Analytics: Certification

There are three major components of a CRM system to be implemented a well-defined overall business strategy, a business intelligence system for monitoring customer journeys and interactions, and which of the following?

A robust technology infrastructure.

Which of the following is a definition of a dashboard as it pertains to data analysis?

A tool that identifies key information related to an individual's or business's operation.

As a data analyst, you want to identify the high-value customers who make up a large portion of the revenues, so that you can find ways to expand the customer base. Which of the following will help you identify this information?

Demographic data.

Which type of customer data is psychographic in nature?

Descriptive data.

Which of the following will be the most effective way for a company to get customers to complete surveys?

Distribute a link with a receipt.

As a data analyst, your responsibility to the company is to identify areas for improvement, mitigate risks, and better engagement with buyers. For this, you need to have a proper understanding of the organization's customers. Which aspect of a CRM system will help you accomplish this objective?

Gathering customer insights.

While performing analysis on data that you have collected, you find the need to combine Hadoop analytics and Tableau extensions in one easy to use site. You find which of the following meets your needs?

Rapid Miner.

How do you calculate click-throughs of a Website?

Number of visitors who click on an ad/Total number of visitors who visited the page.

In the Hadoop Environment, MapReduce is

a programming model for the parallel processing of large datasets.

Hadoop YARN can be described as

a resource management platform responsible for managing the other Hadoop resources.

Prominent examples of big data's relevance in business include Amazon, Netflix, Facebook, Pandora, etc. These companies are redefining their industries and the consumer's experience by

analyzing the purchases and preferences of millions of users.

In which vendor lock-in type will the proprietary software only work in a particular vendor's cloud environment?

Tools lock-in.

Which of the following operations does OpenRefine perform with General Refine Expression Language?

Advanced data operations.

The Web department asks you how they can help you in your role as Data Analyst. Your best answer would be

Allow users to make purchases from their mobile phones as well as from Facebook.

Before building your own in-house data center, it's important for you to evaluate the overall budget and organizational needs to make sure it's an affordable option for your firm. Which of the following factors do not need to be included in your analysis?

Asset management.

You request the company's marketing department place an advertisement for your company and one of its products at the corner of First and Main in Hometown, USA. Sales skyrocket and the president of the company wants to know how you ascertained this would be a good location for an advertisement. You reply

By capitalizing on the location data provided by millions of mobile users!

You want to display the average distribution of an item, and how several variables can affect it. Which of the following would you use for this analysis?

Bell curve.

Which of the following correctly defines enterprise resource planning (ERP)?

Business management software that is used to collect and store data from various departments within a company.

Which of the following statements is true of B2C CRM software?

Consistency of long-term sales through marketing is a primary objective.

This data is largely unstructured, and, as the name suggests, may be context-specific in nature. Examples include impulse purchases, and purchases driven by environmental or market conditions, complaint details, and customer query details.

Contextual Data.

In order to improve sales at your company you schedule a meeting with the marketing, sales, and customer service. The other teams do not understand why customer service has been invited. You explain

Customer service speak with the customers and can provide valuable data.

As a data analyst, you review some prominent companies that deal with big data such as Amazon, Netflix, Pandora, etc. From this, you extrapolate that these companies analyze not only the customer's purchases but what other important piece of data?

Customers' preferences.

Which of the following is an essential part of the B2B framework?

Data handling.

Which feature of OpenRefine helps to get an overview of the bigdata as well as to maintain consistency between data?

Facet.

Sales data can be used to serve different purposes. Which of the following can be determined from analyzing sales data?

Estimates of how sensitive the quantity sold is to changes in the pricing of the product.

After you give a presentation, your manager tells you that your presentation was good but it could have been better, if you would have added which of the following?

FAQ slides to invite discussion and questions.

As a data analyst, you are very interested in analyzing network traffic by examining Web logs. Which of the following tools can provide you with this information?

Google Analytics.

How does Google Fusion Tables share data with other collaborators across the globe?

Google Drive.

Which of the following works on the same concept as centralized database?

Google Fusion Tables.

Martha as a data analyst asks you how she could incorporate information from Google Transparency Reports into their data but, since Google is an online entity, she do not know how. You inform her that

Google's reports are also downloadable.

When asked how IT data management relates to customer relationship management, you reply

IT data management supports the CRM by providing many channels to communicate with the customer.

Which of the following provides access across a public connection in a virtualized environment?

IaaS.

A customer service representative takes a call from a customer with an idea on how to improve a product. After the call, the rep calls the marketing department and passes along the idea. This is called?

Inter-departmental support.

As a data analyst, how do you define network traffic to a new intern?

It is a commerce or communication between a sender and a receiver of that communication.

Which of the following data analysis tools provides tool blending?

KNIME.

Your organization wants to advertise its products. As a data analyst, what kind of data will you analyze to make the advertisement most effective?

Marketing data.

Which of the following is a characteristic of B2B CRM Software?

Predicting customer behavior based on past buying patterns and business profitability.

As a data analyst, you want to measure the amount of interaction between your company and your customers. What source of data is likely to provide the best metrics to achieve this?

Social media platforms.

Which of the following is one of the three variations of cloud-based systems which is also a popular delivery model for a range of business applications?

Software as a Service (SaaS).

As a data analyst at a company, your boss instructs you to collect data and combine it with Google Analytics for further analysis. Which tool would most likely be your first choice to do so?

Tableau Public.

As a data analyst, you are frustrated, as the data you have to analyze is unstructured and not easy to decode. The data you are analyzing is stored in which type of format?

Text or video format

IT departments must take the lead in developing workplace privacy policies and implementing regular training programs for employees. Which government agency has provided two sources of guidance in this area?

The Federal Trade Commission.

What does "modeling" mean?

The development of a visual representation of something being created.

As a newly hired data analyst, you sit down with the head of the Sales Department and ask, "What is the objective of sales data?"

The objective of sales data is to make projections of revenue.

Which factors are associated with successful dashboards?

They are updated frequently and contains the most appropriate information for the user.

Your manager has asked you to suggest a way for hosting the company Website that can benefit from the on-demand scalability and redundancy provided by a network of physical servers. You recommend

Websites can be hosted on virtual servers using pooled resources from underlying physical servers.

You are required to create a project development schedule using the Gantt chart to determine how long a project will take. You have outlined all the necessary tasks included in the project. The senior manager has provided a timeframe to complete the project. What will be your next step before creating the chart in Excel?

You will discuss the plan with the team members about how long you want each task to take.

The increased churn rate in a company will

harm the company.

The first thing you ask for as a newly hired data analyst is a Twitter page. When upper management asks you why you want a Twitter page, you reply

having a Twitter page allows us to publicize information about new products, styles and discounts.

Google Transparency Reports provide data in a statistical and visual form. To preview that data you may

view or download the report.