What is the relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity only if they have made an order?
Based on the financial analysis that's been completed by the analytics team, the business analysis professional reminds the team that the most financially feasible option is the one with the:
A data scientist is performing statistical analysis and is interested in graphically depicting the data set according to the associated quartiles Minimum, First Quartile, Median, Second Quartile, Third Quartile. Which technique would allow for the display of this statistical five number summary?
Interested in building out the analytics capability based on the positive results obtained by past analytics efforts, the Chief Marketing Officer (CMO) pitches the idea of using analytics to guide future decision making across the enterprise. Before allocating budget to build up an enterprise analytics practice, the decision makers should:
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:
Which attributes from the Order entity will need to be normalized to avoid redundancies?
. Orderld
. OrderDate
. Itemld
. ItemName
. Quantity
. ItemPrice
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:
A business analyst constructs a model they would like to review with key business stakeholders but decides to review the model first with the data scientist who has performed the data analysis. The data scientist provides some suggestions on how to reduce the complexity in the model. One suggestion is to use color to group objects needing to be associated. The data scientist is
encouraging using which Gestalt Principle of Perception with regards to data visualization?
The architecture team puts forth a solution architecture that integrates multiple data sources from within and outside the organization. The architecture provides the foundation to source a new analytics program. If one of the objectives of the analytics team was to provide 'one source of the truth', this objective would be referring to which of the following?
The interplay between enterprise systems and data analytics can be envisioned at various layers. The layer that connects the business processes to data analytics is the:
An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad. What outcome would lead the team to have this concern?
The analytics team is struggling with which recommendation to make. Their challenge is that they have five good options and this indecision is stopping them from moving forward. To help the team finalize their recommendation, the BA professional on the team recommends they complete:
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?
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?
An analytics team is interested in reviewing the results of a public opinion poll that is going to be conducted at the end of the month. One of the factors the team is interested in, is ensuring the result set is statistically significant. Why would this factor be important to the team?
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?
A Human Resource manager recently learned that their competitor reduced employee attrition rates by 20% after implementing personality tests as part of their screening process. Intrigued by the idea, the manager suggests collecting data on personality tests and attrition rates over the next year. The data from this year is then analyzed to explore possible relationships. What type of analytics has the team been asked to perform?
An insurance company has seen an upward trend in winter-related accidents over the past three years. The company has just completed an analytics study to better understand the primary reasons for these accidents and assess how many of the drivers were using winter tires. This analysis will help the company decide how to move forward with drivers not taking precautionary measures during winter. What type of analysis will help in determining the primary reasons and percentage of those drivers with winter tires?
After analyzing sales data, the analytics team finds that the older the customer, the more expensive the neckties purchased. The team felt this was a breakthrough insight but on closer analysis realized that other factors could account for this relationship. This is a clear indication that: