This is my portfolio for IT444: Data Analytics that I took in Spring semester 2018. In this course we were taught data analytics through an Agile software development model. There was a total of six sprints and each sprint had four scrums. I was the project manager for the Red Team. At the end of each sprint, teams were tasked with creating a video which summarized the sprint. Trello was used for the facilitation of communication between teams and team members in the course. Each individual team was given free reign over any other communication tools to be used. We decided to use Google Hangouts, group texting, and email as the complementary communication tools. For each sprint, I had to create the sprint planning which included a PERT chart, Gantt Chart, and team assignment spreadsheet. Then, I had to create tasks for individual team members in Trello based upon the team assignment spreadsheet. After each meeting I posted meeting minutes on Trello.
There were five teams in the course that collaborated to deliver an "end-product" to a fictional real estate company. Each team was assigned with a specific task that required database implementation. The team I was on was tasked with implementing "property inquiry." After each team finalized their local database models, the project managers (myself included) merged the local database models into one master database model. Each team implemented their local databases with Oracle and MS SQL Server. Then, the local databases were merged into one master database. After the master database was finalized, each team performed data analytics on the master database using SSAS, SSRS, QlikView, and Pivot. Below is our local data model and the master data model that we contributed to. I've also provided download links for our local data dictionary, the global data dictionary, our local Oracle database script, the Oracle master database script, and the database models.
Download global data dictionary Download local data dictionary Download local database script Download master database script for Oracle Download Red Team local database model
