Table of Contents

Findings…………………………………………………………… 2
Issues………………………………………………………………. 2
Opportunities………………………………………………….. 3
Recommendations………………………………………….. 3
Next Steps………………………………………………………. 3
Project Schedule…………………………………………….. 4
Database Design…………………………………………….. 4
Data Modeling & Data Marts…………………………. 4
Database Selection…………………………………………. 5
ETL Selection………………………………………………….. 5
Data Mining…………………………………………………… 6
Conclusions………….………………………………………… 8
References…………………………………………………….. 10

Findings:

ABC University has several departmental databases that perform specific functions for each department. Within these databases are several items that can be considered cross functional data among …show more content…

Microsoft Visio is the easiest of any of the tools for an end user or database design to read, interpret and modify.
Database Selection In my experience of BI, the mainstream database tool that is used in most companies is Microsoft SQL Server. Microsoft SQL Server BI Tools has the ability to build the database structure and have BI Tools on top of the database to directly analyze data through cubes using Microsoft SQL Server Analysis Services and can also serve up custom reports straight from SharePoint or another service using SQL Server Reporting Services. The users can connect to the cubes using Microsoft Excel Pivot tables, or one of the of the Microsoft tools like Microsoft Power Query or Microsoft Power Pivot.

ETL Selection
For the ETL process design and development at ABC University, we will be sticking with the Microsoft tools for the ease of integration and the use of one vendor for this project. We will be utilizing Microsoft SQL Server Integration Services (SSIS) to finish the ETL Process. Again as explained in earlier documentation, the Microsoft Business Intelligence tools are the most commonly used suite of tools among businesses and have the most people versed in using them. They are not as complex as some of the other tools on the market such as Oracle. I do not have personal experience with the other tools such as Informatica, Ab Initio, Business Objects, or IBM Infosphere,