What is an executive dashboard? What will be an ideal ...

[kwoodring]

What is an executive dashboard?
 
  What will be an ideal response?

Question 2

Write an SQL query for the HAPPY INSURANCE database that will, for each agent, retrieve the name of the agent and the name of his or her supervisor. (The name of the agent will be retrieved even if he or she has no supervisor.)
 
  What will be an ideal response?

[Ahernandez18]

Answer to Question 1

Executive dashboard is a particular form of data warehouse front-end application. The executive dashboard, as the term suggests, is intended for use by higher-level decision makers within an organization. It contains an organized, easy-to-read display of a number of critically important queries describing the performance of the organization. In general, the use of executive dashboards requires little or no effort or training. As is the case with other front-end data warehouse applications, executive dashboards can also be Web based.

Answer to Question 2

SELECT a.agentname, s.agentname
FROM agent a LEFT OUTER JOIN agent s
ON a.supervisedby = s.agentid;

[kwoodring]

Gracias!

[diana chang]

Excellent