Introduction to Business Analytics Questions and Answers (100% Correct Answers) Already Graded A+

Why is interactivity advantageous when creating dashboards? A. They allow users to decide which visuals are displayed on the dashboard. B. They allow users to drill down to see more details regarding the data C. They allow users to determine which KPI's they would like on their data D. They allow users to send real-time messages to the dashboard's creator [ Ans: ] B. They allow users to drill down to see more details regarding the data What is the primary purpose of the SUM function in Excel? A. Converting percentages to decimals B. Aggregating C. Totaling D. Averaging [ Ans: ] B. Aggregating How can you most effectively work though all your organization's data without becoming overwhelmed by the amount of data? A. Focus on key performance indicators (KPI) B. Focus on high-level numbers C. Focus on the tools you are using D. Focus on the data points most relevant to your organization. [ Ans: ] A. Focus on key performance indicators (KPI) In which phase of analytics will you create an optimization model? A. Descriptive Phase B. Data Gathering Phase C. Predictive Phase D. Prescriptive Phase [ Ans: ] D. Prescriptive Phase How do you most effectively gather psychographic data? A. With Sales Data B. With Surveys C. With Marketing Data D. With Feedback Forms [ Ans: ] B. With Surveys How can you best describe a data silo? A. A data silo is considered a data hierarchy, with the most important data at the top. B. A data silo consists of data sources that are not shared between departments C. A data silo is a sto