What is a cross-product dashboard?
A cross-product dashboard is a database dashboard that shows the link between two different SQL database tables. The name comes from the term 'cross product' in relational algebra, which is the basis for relational databases. A cross-product dashboard graphically represents a cross-product product, including lines, bar charts, and pie charts designed for executives.
A cross-product dashboard shows the results of a cross-product product, also known as a cross join or cartesian join, in an SQL database such as Microsoft SQL Server or MySQL. A cross-product product combines two different tables in a database into one larger table. A cross-product product could contain a combination of a list of orders and a list of customers.
The dashboard shows a graphic image of a database. It could be a line chart or a pie chart. The advantage of using a dashboard is that a user does not need to know SQL or type commands into a database. This makes cross-product dashboards very useful for executives who need to see information about their business at a glance.