Data Analyst

A company wants to determine the efficiency of their newly updated web site by tracking what customers did on the site and how much time the customers spent on each page. Which of the following would be the best approach?

• Analyze click through rates from web logs.

• Use a customer satisfaction survey on Facebook

• Have customer service representatives contact individual customers who have visited the site and interview them.

• Provide incentives to customers to complete a short survey after visiting each page of the site.

For most businesses, using cloud-based computing offers many benefits, except?

• Latency

• Reliability

• Ubiquity

• Economy

You are assigned a project to determine the effectiveness of a recent post card campaign. The post card was mailed to a rented list of businesses similar to your current customers. The postcard offered a 10% discount on the first purchase of your company’s flagship product. Which internal company department would you contact first to obtain data?

• Marketing

• Product development

• Sales

• Shipping and receiving

You work in the registrar’s department for a major university. You need to report on expected enrollments for the next school year’s cycle of freshman class registration. You must work with several different departments in the university. Which internal organization will provide the least important data for your report?

• Finance department, for financial aid applications

• Athletics department, for ticket sales for sporting events

• IT department, for new student technical support requests

• Admissions department, for accepted applicants

Chris works for a large e-commerce company and is looking to use the R Project to create 3D contour charts that will represent the last five years’ sales data. What element of the R Project could help him create these charts?

• R-Visualizer

• Tableau Public

• Knime

• Graph-R

As the Data Analyst, you need to review the format of printed bills going out to customers. You notice that bills previously paid by credit card, show the full card number and other information. You recommend that this information be masked or truncated. Why?

• To simplify the display for customers

• To remind customers that they used a credit card

• To prevent theft of the information

• To prevent customers from paying the bill twice

Digitax develops and sells a boxed, locally installed tax preparation software application. They handle all the shipping and fulfillment internally. Some customers have requested an online application instead. Besides software development costs, what additional information should be considered?

• Warehouse costs to store boxed product (cds, manuals) versus cloud hosting services

• Total annual revenue and customer demographics

• Sales leads from tradeshows and magazine advertising, and promotional mailing lists

• Company overhead costs and physical location security

What is an advantage of using centralized data?

• Using multiple data redundancies at a single location creates robust centralized data

• The use of “shadow” databases helps to create one version of the data

• Small changes to the database do not affect centralized data, making it more stable over time

• A single location holding the main record of the data ensures consistency and accuracy

A retail art supply store is trying to determine the optimal quantity of paintbrushes to store in the warehouse. What kind of data should they be looking for?

• Number and location of paintbrush manufacturers

• Profit margin on the sale of each paintbrush

• Demographic profile of customers who purchased paintbrushes

• Frequency of sales transactions of paintbrushes

As the data analyst for a large company, you are preparing a visual tool for project managers to use with their team members to show tasks and completion dates. Which of the following would be the appropriate tool for managing this information?

• A. A calendar time line created in a word processing application

• B. A calendar table created in graphics editing application

• C. A Gantt chart created in a spreadsheet

• D. A Gantt chart created in a presentation application