Database Design and Visualizations

The following presentation is our final project for our database design and modeling class. We were tasked with creating a fictional data warehouse and business intelligence system for IBM based upon IT ticket data.

The following presentation was based off of sample IT ticket data, that we used to create some of table schemas. After understanding the data warehouse, we created our visualizations for our “IT department”. Since our company would have different roles, we needed to create separate views based on their role within the company.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: