IX. Database Dashboard and Analytics (2-4 pages)

Database Dashboard

The executives at Flix2You would like to see a dashboard created that management can log into securely and view weekly reports that contain specific information regarding the sales and demographics of the users of Flix2You. The dashboard should be informative, easy to understand, easy to use, and provide the ability to export data to MS Excel and print to a .pdf. The dashboard should provide the ability to drill down thru various levels of detail. Additionally, the dashboard should be able to run on a tablet device (eg. iPad, Android, etc.).

The dashboard should contain a graphical representation of the data. You will need to do some research on various dashboards. The purpose of this section is to have you demonstrate your ability to provide the SQL Queries needed to generate a web based report that details various corporate data owned by Flix2You. An example dashboard can contain the following information but is not limited to:

Movie Information

• Movie name
• Rating
• When it was rented (day of the week)
• How often it was rented
• Revenue related information Company Information
• Monthly, Quarterly revenues
• Number of downloads, sales, etc.
• Number of new members

The query should group the data accordingly for ease of reading and the user information associated with each product should be sorted in ascending order by Last Name.