NEW
Font size
WorksheetsData Analyst
Total questions: 48
Worksheet time: 24mins
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
Sarah opened a candy business a month ago. After looking at her first month’s sales, she decides to stock twice as many gummy candies as chocolate candies this month. This is an example of:
Using data
Reading data
Organizing data
Capturing data
As the Data Analyst, you have been named in a lawsuit against the company. Other employees of the company are upset over findings from a recent company network traffic usage report. Which of the following best describes the reason for this situation?
Capturing video of employees working using a hidden camera
Failure to publish positive comments along with employee complaints
Publishing an incomplete list of employee suggestions for network improvements
Failure to keep personal information collected private
When observing network traffic, which of the following will be a factor in determining and creating trend reports?
Sales logs
Time frame
Speed
Google analytics
A company has been analyzing the monthly sales revenue of the 10 member sales team against stated goals. The sales team is consistently reaching targets of phone calls, emails, scheduled web conferences and demonstrations. However, monthly sales is always less than the stated goal. Which of the following recommendations would be the best for this situation?
Use a bell curve to identify lower performing sales team members
Invest in a marketing campaign to generate additional leads
The sales manager needs to increase the monthly targets for customer demonstrations
Adjust monthly sales goals inline with the average sales
As the data analyst for a large company you have been asked to distribute information including long-term trends of key areas of the company’s services and products to the members of the executive board. Which of the following would be a method to complete the task?
Provide access to the server log files to each of the executive board members.
Compile individual indicators from the information and distribute the results to board members
Plot the information on a single bell curve and display on a wall poster to be discussed at a board meeting
Create a dashboard containing the information, accessible through the company’s web portal
You are working for a company that manufacturers plumbing supplies and equipment. Your customers frequently request product information from their sales representatives. How can you get the most consistent data on product preferences from these e-mails?
Implement an artificial intelligence-based system of semantic language understanding
Ask sales team members to tag all e-mails with keywords and segmentation classifications
Implement an application programming interface (API) to facilitate communication between the email and the company CRM.
Implement a structured keyword and rule-based system to identify content based on established criteria
One of the tools used in analyzing Big Data is Hadoop. Which best describes the benefits of this tool?
This tool allows for the distributed processing of large data sets across clusters of computers using simple programming models
This tool helps to ensure data integrity across all remote computing clusters using simples commands
This tool helps to reduce concerns about data security by distributing data processing between remote clusters
The tool provides analytical reports of data processing efficiency, showing problem areas of remote computing performance
As a data analyst, you must make decisions about the location of your company’s important data. What is your single most important criteria for choosing to keep data in-house?
The company has better control of data when using an in-house solution as opposed to a cloud-based data storage solution.
In-house data is slower to access than cloud-based data
In-house date is more accessible to staff than cloud-based data
The company will benefit from reduced costs when keeping data in-house, as opposed to a cloud-based data storage solution.
Which three words commonly describe the term Big Data?
Volume, velocity, and variety
Large, structured, and accurate
Volume, infinite, and predictable
Large, unstructured, and timeless
What term defines the sum of the models, rules, and processes for managing data within a problem domain?
Data architecture
Data planning
Data normalization
Data processing
You are looking at a report that lists ticket numbers, building categories, physical addresses, and descriptions of items that need repairs. What kind of data storage system is producing this data?
Facilities Management System
Inventory Management System
Supply Chain Management System
Enterprise Resource Planning System
Mike works for an e-commerce business and is looking to capture good data that the company will use to make future business decisions. What is the most important thing he should look for when deciding on data capturing methods?
Methods that take a small sampling of the larger population
Methods that are slow and methodical
Methods that are fast and accurate
Methods that can create the most meaningful visualizations
You have an active following of customers on your company's social media site. Which technology will help integrate the information posted in this forum, with your company's sales and marketing data?
Application programming interface
Customer relationship management
Enterprise resource management
Inventory management system
Environmental Solutions LLC develops software for complying with governmental regulations regarding management of hazardous companies. They are trying to decide if they should develop and release a new software line for complying with safety regulations. What kinds of internal data would contribute information to help make this decision?
Surveys on the customer’s demographics, needs, and preferences
Transaction data on sales of the current products
Sales leads from tradeshows and magazine advertising
Company overhead costs and planned marketing expenses
Which scenario would call for the use of OpenRefine?
The need to be able to merge and share sets of data with other users.
The need to transform disorganized data from one format to another format.
The need to see a visual representation of data drawn from multiple sources.
The need to be able to write scripts that are customizable, replicable, and updateable.
What is important information that can be found using customer data?
Which types of customers buy certain products
Options to minimize operating costs
A method to reach the right set of customers
Projected revenue for the next year
The company reached a decision to add additional shifts of the existing hours of customer support personnel. They will be available during non-traditional business hours, based on trends reported by the Data Analyst. Which of the following will this information come from?
Performance estimates
Outcome reports
Web site traffic reports
Sales revenue estimates
What is the primary purpose for implementing a customer relationship management system?
It is a business strategy aimed at managing customers to optimize long-term value
It is a business process to help a company develop products designed specifically for its customers
It is a database for storing and planning marketing events such as tradeshows and conferences
It maximizes profit margins by tracking current inventory and ordering new products
Your friend who knows you are a professional data analyst asks for your advice. She rents several retail spaces at local swap meets in her area and she wants to determine the best inventory to stock by location. She adds that she has no budget. Which database would you recommend?
MS-SQL
Filemaker Pro
Oracle
MySQL
A company is considering increasing the network bandwidth for better internet connection speed. They need to know how much additional bandwidth is needed. A summer intern is tasked with tracking internet usage among employees in his department. What is the possible problem with the report he provides?
Types of internet sites that need to be accessed have not been considered
The intern has not properly protected his co-workers privacy
The cost of the expansion has not been factored in
The survey is biased because it does not include all employees
A company has been analyzing the monthly sales outcomes of the 10 member sales team against stated goals. The sales team is consistently reaching targets of phone calls, emails, scheduled web conferences and demonstrations, however monthly sales are always short. The sales manager has initiated a training program that has shown progress in monthly sales outcomes. Now the sales manager needs to analyze the correct amount of training needed to produce the desired sales results. Which of the following indicators would be the best for this situation?
Bell curve measuring hours of training to monthly sales
Team member satisfaction surveys about the training provided
Ratio of sales revenue to training scores
Customer satisfaction surveys of team members performance after training
Profits at your consulting company have been stagnant for the last three years. Your company is expanding its services. You will be representing your company’s new business plan at the investor's meeting. What information should you use to justify the new business plan?
Analysis of marketing focus groups indicates that a significant change in messaging will attract additional customers
You have interviewed some competitors already in the market, and determined that new services will be profitable
After meeting with finance and personnel departments, you concluded staffing new services from existing resources makes the most sense
Analysis of historical sales demonstrates a long-term life cycle for existing service programs.
Which of the following describes a tool that identifies key information that summarizes business operations?
Dashboard
Log file
Data map
Bell curve
You are building a multimedia presentation to share an analysis of data collected from peak website visitor activity. Which of the following would you include in your slides?
Include a brief history or background about the project
Text documents about marketing products to a target audience
A list of factors that lead to sales of products in different regions of the world
YouTube videos of product demonstrations included on the web site
Which of the following is a strength of the R Project?
Analysts can write R Project scripts that are customizable, replicable, and updateable.
The R project is proprietary software with a dynamic and engaged online community
Users of the R project are able to design predictive analytics with streamlined usability
R Project scripts supports code in Java, allowing programmers to use pre-existing skills
What area of the Hadoop framework is a programming model for the parallel processing of large data sets?
Hadoop Yam
Hadoop Distributed File System
Hadoop Common
Hadoop MapReduce
As the Data analyst for a children’s audio book club, your market data analysis has shown a growing trend in the market for delivery of books via internet streaming rather than by mail. The organization currently has highly structured data including clustered session and shared file systems in a vertical architecture. You are considering moving to a cloud-based solution. What attributes about your current structured data might require more caution?
They scale well in cloud-based systems but are offset by license fees
They do not scale well in cloud-based systems
Highly structured data solves latency issues in cloud-based systems
Highly structured data in the cloud will significantly improve the customer streaming experience
Allan is reading the comments on his company social media pages to see if there are any discernable changes in the quality of customer service his company has provided in the last six months. What kind of data are these comments?
Structured data
Centralized data
Institutional data
Unstructured data
The company CEO was unavailable. As a data analyst, you were asked to give a speech to the local chamber of commerce as they welcome your new company plant to their town. After the meeting, one of the commerce members asks what led to the decision to build the new plant in their town instead of the neighboring town. Which of the following is likely to be the strongest reason?
The decision was based on the Production Managers analysis of the need for additional capacity for demand spikes
The decision was made by the company Finance department based on analysis of geographical access to employees
The decision to build was driven by the company CEO since he has always been fond of the town where he went to college
The decision was based on rigorous data analysis of a training workforce, access to shipping and tax incentives
As a data analyst for an organization, which of the following is necessary to ensure your results are valid and ethical?
Compare data collected to that of competitors to ensure findings are similar
Repeat the collection of data several times to ensure consistent results each time
Verify and follow the process outlined for data collection as approved by a committee or oversight body
Do not publish any procedures about data collection methods to ensure confidentiality
An art supply retail store is trying to determine how many brands of high-quality paintbrushes to stock in the store. Management is aware that the profit margin on paintbrushes is very low, due to high shipping costs. What other factor can affect supply chain efficiency?
Frequency of sales transaction of paintbrushes
Number and location of paintbrush manufactures
Video tutorials on special effects that various brush types can produce.
Demographic profile of customers who purchased paintbrushes
Your supervisor forwards you instructions to download a rental mail list of potential customer leads. The license and download instruction indicate the list is for one promotional mailing event only. Your supervisor instructs you to upload the data to your CRM so marketing can send additional promotional e-mail messages to it. Why is this unethical?
The license applies only to printed mailings, and does not need to be considered, when planning email campaigns
The rental list has not been qualified for valid sales leads yet
A rental list can only be used according to the agreed upon terms, and may not be stored in a persistent database
Marketing sends its promotional messages from a different database, not the CRM
A competitor has recently updated their sales tactics, which now mirror your company’s tactics. These changes appear to have come from guidelines used within your Sales Department. Which of the following is a possible ethical violation?
The company CEO sold sensitive sales plans to the competitor
A data analyst attended the same sales trends seminar as the competitor
The competitor hired a former employee from the production team who had not signed an NDA
A data analyst published the guidelines on sales tactics in a public forum
You have created a presentation about your analysis of network traffic and your suggestions to improve operations based on your findings. You have asked to present your information to the executive team members that are located in various cities internationally. Which of the following would be the appropriate tool for presenting this information?
Set up a webcast meeting for everyone to connect and share your presentation.
E-mail the handouts to the individual members and request a message receipt
Present the information at the annual board meeting when all of the members will be present to participate
Set up a conference call with the members and discuss the information with all of the team members
You have collected data on revenues and determined that there is a trend in revenue based on various sales cycles throughout the year. What would be the best approach to present this information to administration and the sales team?
Create a chart that shows revenue compared to sales cycle so the trend will stand out
Create a presentation that has a revenue table listing all revenue for a particular time frame for each sales person
Create a word processing document outline detailed tips to improve sales revenue
Create an e-mail message to each team member specifying his or her top and low revenue values for the quarter
Kim works for a clothing boutique that has several locations across the country. They are looking to be able to share up-to-date data between managers at multiple stores. What would be the best tool for this?
Tableau public
OpenRefine
The R Project
Google BigQuery
A company just completed a major update project creating an HTML5, CSS3 and JavaScript interactive, dynamic web site. Now they want to measure the effectiveness of the new site along with customer expectations for the site.
Provide incentives to customers to complete a short usability survey after visiting the site
Use a customer satisfaction survey on Facebook.
Have customer service representatives contact individual customers who have visited the site and interview them.
Analyze click-through rates from web logs
You want to determine the best-selling product in your company's catalog. How would you obtain the data necessary?
Customer order transactions from a CRM
User surveys on customer satisfaction
Key performance indicators
Google analytics on specific keywords
