A manufacturing company, specializing in turf maintenance equipment, has recently seen a decline in their lawn mower sales. As a result, the analytics team is asked to review the latest customer satisfaction survey results. An analyst on this team creates a report for senior management with attractive visuals, supported by the KPI results. Upon reviewing the report, the analyst's manager

mentions that the report is missing the narrative. What does this mean?

A Data Dictionary is being developed for an employee database. When reviewing the data dictionary, the analyst recommends adding another primitive data element. Which element would be suggested?

With the recent departure of two of its employees, an IT helpdesk team is now understaffed and finding it difficult to keep up with the current workload. The number of tickets being received has increased as well as the number of days to resolve the tickets. The IT manager has set up a meeting with the IT director to request funding for two new helpdesk agents. To prepare for the

meeting, the manager is interested in showing the tickets processed against ticket volume over the past year. What type of chart should the manager use to effectively show the change in processing rate over time?

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:

Interested in experimenting with analytics, a manufacturing company hires an analyst to see how the capability can be developed within its organization. The analyst is getting started and recognizes the need to show value from the onset of their work to gain upper management's trust and future funding. What action will accomplish these objectives?

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:

A financial software company has growth and expansion as one of their top strategic priorities for the year. The senior executive team would like to assess their sales performance over the last 3 years to help set sales objectives. In discussion with the business analytics manager, for a comprehensive sales report, the sales lead recommends looking into the number of contracts signed over the past 3 years and the dollar value for the signed contracts. Which other question is important to consider when evaluating sales performance?

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:

An analyst is looking at a particular dataset that includes the scores across all 8th grade students, across three schools. The analyst is trying to determine which type of statistics average to use to best represent the results. On looking through the dataset, the analyst has identified a few extreme outliers. As a result, the analyst was led to use the following type of average:

An analyst is using a Data Flow Diagram (DFD) to depict the flow of data across a data security company. Which of the following is true about DFDs?

The analytics team is assessing the results of their analysis. They are surprised to find that their data indicates two events seem to

be strongly related even though the general belief in the organization is that they are independent of each other. Knowing that

this information will be used for decision making, they are concerned about presenting this data. At an impasse, the business

analysis professional reminds them that the data can be presented as long as the team has:

Insights based on the data collected indicate that a multi-national company could increase its sales of a mature product by reducing its price by 20% which would result in increased revenues of 2% over a 6-month period. The team recommends this as an appropriate goal for its organization. This is considered a good goal because:

An online retailer has been successful utilizing analytics to guide decisions on product placement and marketing spend.

Management has requested a task force be assembled to make recommendations on how to further develop their analytics capabilities. To begin this work, the task force builds a model to develop a shared understanding about customer segments, customer relationships, key partnerships, and the company's value proposition. The team has leveraged the following model to facilitate this discussion?

The results for a certification exam were revealed in percentage and percentile. The results for one of the attendees was: 75%, 90th percentile. What is the value in sharing the percentile score?

The research question prompting the use of analytics is well-defined. The team obtains the results and determines that the source data did not provide reliable results. As a result of this finding, the team modifies the original question to one that can be answered by the data. What is a risk that could impact the value of this analysis?

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?

A research marketer is interested in collecting information about the spending habits of families in North America. Concerned about the volume of data required to conduct the research, they choose to use sampling. The dataset is sourced using all credit card transactions from a leading North American credit card company for Quarter 1 of the prior year. The sample used is:

A government agency is conducting a study on the performance of 12th grade students' in mathematics across the country. In particular, they want to understand if there is a relationship between intelligence and scores, as well as the difference in performance between various locations. Which combination of inferential statistics procedures should be used?

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 consumer goods manufacturer has recently completed an analytics study to understand how to improve its operational excellence. From the top highlights, online sales outperformed other channels in sales growth and there was a direct relationship between positive customer reviews and increased internet sales. Which strategic business decision may be logically derived from

these results?

An analyst at a bank is trying to identify research questions for an analytical study on top customer issues across branches. During an interview with a branch manager, the analyst asks the manager what their top customer concerns are relating to this branch?

After the manager's reply, the analyst asks a follow up question on how their top customer concerns compare against the top customer concerns across all branches? Was the analyst's follow-up question valid?

A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?