The analytics team has been asked to determine if the organization should launch their highest revenue generating product into the North American market. To date, this has only been available in Eastern Europe. To answer this, the team formulates several research questions, including:
The marketing department for a major restaurant chain is interested in testing a Kids Eat Free campaign to determine if it will help to increase sales. They are interested in piloting the campaign to determine which day of the week will improve sales the most.
The campaign is launched across 7 cities with each city promoting a different day of the week. The sales data is collected and provided to a team for analysis. What concern might the analytics team have regarding data quality across cities?
An analyst at a supermarket chain has been asked to extract data from multiple data sources to complete a study on customer
spending habits. The analyst is going to query data from various databases. Which statement is true about database querying?
The analytics team has been asked to assess sales data from their company's website with the hopes of providing insights to help increase online sales. It's the first time the team is looking at this specific data and they are concerned about the quality of data that has been captured. They decide to use the following approach as the next step:
While sourcing data, an analyst runs into a situation where different business units are usingdifferent names to refer to the same data element. This lack of standardization is resulting in confusion and additional time required to properly prepare data for analysis. Which practice, if implemented would address this situation and mature the organization's business analytics practice?
A business analyst manager is planning budgets for the new year, and training opportunities for his team of business analysts. The manager sends out a survey to the team to obtain their top interests within the seven areas of training opportunities. The team results were compared against the manager's personal rating. What can be deduced from the following chart with regards to the
survey results?
The team has completed their analysis on a vast amount of collected data and agree on their recommendations for action.
However, they are having difficulty in developing the appropriate messages to support their recommendations. The business analysis professional suggests which technique to assist the team?
An analyst at a phone manufacturing company is preparing a dashboard for Senior Executives that will cover past year's performance. It will be used in the upcoming senior leadership team meeting to make strategic decisions for the new year. While analyzing the data, the analyst found a lot of interesting revelations related to performance. What should the analyst keep in mind when preparing the Executive dashboard?
The analytics team has been asked to provide an estimate of the number of customers they expect to have in 12 months. They debated how accurate that figure needs to be and determined that based on the availability of good data, they could predict within + or - 10%. This is an example of a:
Collaborative games are used by a business analyst to identify the research questions to be explored within an analytics system.
Participants are asked to write down a research question on a sticky note, put the notes on the wall,and move them towards related research questions. What type of Collaborative game is being played?
A large telecommunications company wants to increase their Average Revenue Per User per month by 5%, by end of year, to increase revenue in a highly competitive market. From a SMART target perspective, what is missing?
Which attributes from the Order entity will need to be normalized to avoid redundancies?
. Orderld
. OrderDate
. Itemld
. ItemName
. Quantity
. ItemPrice
A real estate broker is tracking monthly sales between two of its teams. The results have been visualized. What insights can be drawn from the chart?
There were 7 students enrolled in the Introduction to Artificial Intelligence course. These were the student's scores from the final exam: 64, 70, 80, 80, 90, 98, 100
What is the mean and mode for the outlined scores?
The results of the data analytics work led to some clear and strongly supported outcomes and the analytics team is very confident in their recommendations; particularly given that the payback on the required changes are a short 3 months. However, there is concern because the organization operates in a highly regulated environment and some new regulatory changes are being considered with announcements and implementation in the next 6 months. Under these conditions the team decides to:
A call center has requested to review their sales conversion data for the month. The analyst working on this request is trying to identify the chart that will effectively present the data, which includes: the number of leads, the number of calls made, the number of calls completed, the number of customers interested and the number of sales. What chart should the analyst use to show the values across each stage of the pipeline?
A lab is conducting a study on protein interactions. They have used the data to create a graph visualization. In graph visualization, what would a layout be?
An analytics system is being developed by relying entirely on research questions that are framed using the results from benchmarking. Which research question is being asked?
A large car manufacturer is interested in comparing the number of sales for a specific model of electric car across all 50 US states.
The data analytics team sourced and acquired the data, and the business analyst created the model to compare sales across states.
In a meeting to review the results, the feedback received included several complaints concerning an inability to distinguish the number of sales per state. What model would result in such confusion?
A dataset contains 10 measures of workplace sustainability. The analytics team is in need of producing a single score of sustainability. Which of the following techniques if used would achieve this objective?
A marketing department has established an analytics team. The analytics practice is stand-alone and analysts have limited insights into corporate strategy. Which is an expected result for analytics practices operating at the business unit level?
DIAGRAM TAKEN
An analyst at an organization has just learnt about bullet charts. For the latest dashboard, the analyst has decided to display the customer satisfaction rate from the latest 2018 customer survey results through a bullet chart while comparing it to the 2017 customer satisfaction rate.What can be gleaned from this chart?
Customer Satisfaction
120%
100%
80%
Allegra Consulting is planning on establishing an analytics system to track career progression of their consultants. Elicitation will be used to identify the required features. How would brainstorming be used to prepare for elicitation?
A brainstorming session is conducted to identify the research questions to be explored within an analytics project. During the brainstorming activity which of the following should happen?
Which attribute in the Customerissues entity would be categorized as unstructured data?
•CustomerlD
•ConcernCategory
•ConcernSubCategory
•AgentID
•ComplaintNotes
•lssueResolved(Y/N)
An analytics team is sourcing data for a new analytics initiative and is deciding between two comparable data sources. One source being considered is a very large dataset and another consists of three smaller sources. What advantage will the larger dataset provide over the three smaller sources?
An analyst is doing a clinical study on the value of analyte among a large population of healthy people. The analyst is going to use a Gaussian Distribution to share the results. Which of the following represents a Gaussian Distribution? (IMAGE TAKEN)
The finance manager has reported that customers are taking much longer to remit payments this year than last. They would like help in finding a solution to address the situation. One suggestion was to offer a 10% discount to entice customers to pay their invoices in full within the first 30 days. Before offering the discount, the finance manager would like the analytics team to do some research to determine if there is value in addressing the accounts receivable problem. Which of the following is a valid question to ask in this situation?
An analyst supporting the Marketing department for a specialty retailer has been asked to look through past sales data to help guide product decisions. The business sponsor for this initiative would first like to know 'What is the most profitable product line?'. What type of analytics is the analyst going to perform to address this question?
An HR manager attended a conference where the topic of HR analytics was presented. The manager returned to the office feeling strongly that analytics could be used to guide hiring decisions in the future. Which of the following results would assist the HR team in making such decisions?
The results for a certification exam were revealed in percentage and percentile. How would you infer the results for an attendee at: 75%, 90th percentile?
A consumer products company gained popularity with increased growth and brand recognition with one of its products. Although they have a loyal customer base and past year’s performance results have shown steady growth, the Senior Leadership team wants to keep product leadership as their primary strategic priority.What would be their primary goal?
An analytics team completed their research to determine why customers are abandoning items in their online shopping cart. The team suggests improvements to the website to address the problem. The Director of Sales proclaims that the current website is fine and indicates that the problem materialized when the company increased its shipping rates. The solution proposed by the team seems misaligned. What has gone wrong?
To support their recommendation, the analytics team has identified investment and resources required to implement. The team has also identified key activities and events that are required to transition the organization through various stages to the future state.This information is clearly articulated in the:
A fifty-year-old brick and mortar business is interested in determining the potential for selling their current products online. The sales director has asked the analytics team to predict future sales for their most popular product. A simple question is formed "Would you buy this product online?" The sales director would like to survey students from local colleges and universities within a 50km radius.As a result, the team will conclude:
A data scientist is working with a team of upper level managers to develop a strategy for creating an enterprise analytics program. What critical success factor would help ensure the organization obtains the most value from its data?
A private school has decided to include bullet charts in students' end of year performance report. It will depict the student's score against the highest score achieved in that grade, and the qualitative category that the student's score falls under.Should a column chart be used instead?
An analyst is interested in providing a visual diagram to compare and contrast the characteristics of four different solution options. Each option should be represented by their cost, value, and risk level. What type of chart would accomplish this task?
A lab is conducting a study on protein interactions. They have used the data to create a graph visualization.In graph visualization, what would an edge represent?
A financial institution is interested in leveraging analytics to address a recent surge in credit card fraud. The company has decided to invest in streaming analytics to obtain instant access to real-time data to stop fraudulent behavior before it occurs. Which practice will help the financial institution integrate the data as it is collected?
A consumer product company has recently seen decline in sales in their athletic wear over the last 3 quarters. Along with a customer satisfaction survey on their athletic wear products, a study on the competitive market has been initiated. The analyst working has created a dashboard, integrating the results from the market study with customer feedback. On reviewing with the analytics manager, the feedback received was that the visuals were powerful, but the dashboard lacked narrative.What does the manager mean by this?
An analyst is interested in determining whether their company is charging the right prices for their products. Before creating a research question to frame their data analysis, they review a research study provided by the sales department and review several competitor websites.Which statement is true about document analysis?